I have a system which is quite profitable (around 25% return on staked money)
Only problem is I have to perform it manually or semi-manually trough Guardian automation while I'm sure it could run on auto somehow.
I have a honest question for ya... which way to go?
Excel Spreadsheet within BA or going directly through Betfair API-NG using VBA language.
Any experiences with second option?
Regards
Going auto
-
spreadbetting
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Depends on your knowledge of VBA and excel I'd have thought. I haven't got round to looking at the API-NG yet but as it's all json based it shouldn't be hard to code something if you're proficient in VBA. My current stuff uses API6 and that's relatively simple to use, I'll get round to API-NG nearer the switchover time but as most languages have built in json decoders I'm not expecting many problems.
Obviously using Bet Angel should be quicker short term but I've always found self coded stuff just just you so many more options to either API calls not available via BA, outside sources and saving data into databases.
Obviously using Bet Angel should be quicker short term but I've always found self coded stuff just just you so many more options to either API calls not available via BA, outside sources and saving data into databases.
I would like to see some arguments to support this, why it is best way. I have no intention to cancel BetAngel subscription even if using API-NG for automation, if that's part of argument.6thSense wrote:An Excel spreadsheet via Bet Angel is surely the best way forward.
Hey spreadbetting Kudos for being informative and for being able to code on your own. Nice to hear you get more flexibility through API. What's your background if I may? Because mine is in legislation.spreadbetting wrote:Depends on your knowledge of VBA and excel I'd have thought. I haven't got round to looking at the API-NG yet but as it's all json based it shouldn't be hard to code something if you're proficient in VBA. My current stuff uses API6 and that's relatively simple to use, I'll get round to API-NG nearer the switchover time but as most languages have built in json decoders I'm not expecting many problems.
Obviously using Bet Angel should be quicker short term but I've always found self coded stuff just just you so many more options to either API calls not available via BA, outside sources and saving data into databases.
I just finished one thick book on VBA which I suppose gave me skill to read the code but not really create a new one. For now.
-
spreadbetting
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
I taught myself some basic PHP years ago as it was free and there were snippets all over the net. For me it was perfect to do the basic stuff of connecting to a website and grabbing the info and placing bets, all pre API. Unless you want lots of fancy forms and stuff you don't actually need to know too many coding routines.
If I was starting now I'd go the API-NG route rather than API6 just because you'll eventually have to switch, probably in November. Plus I wish I hadn't been so lazy and spent time learning something like C# just because php can be limiting but as soon as something is working for me I lose interest in trying to make it fancy as bots just need to be efficient and not necessarily seen.
Best place to start is the developers forum as there are snippets of code for all languages and everyone is usually helpful. http://forum.bdp.betfair.com/
If I was starting now I'd go the API-NG route rather than API6 just because you'll eventually have to switch, probably in November. Plus I wish I hadn't been so lazy and spent time learning something like C# just because php can be limiting but as soon as something is working for me I lose interest in trying to make it fancy as bots just need to be efficient and not necessarily seen.
Best place to start is the developers forum as there are snippets of code for all languages and everyone is usually helpful. http://forum.bdp.betfair.com/
This is a Bet Angel forum.Michal wrote:I would like to see some arguments to support this, why it is best way. I have no intention to cancel BetAngel subscription even if using API-NG for automation, if that's part of argument.6thSense wrote:An Excel spreadsheet via Bet Angel is surely the best way forward.
If you go to a BMW forum and ask about running a Lada I'm fairly sure you would get the recommendation to use a BMW instead.
Besides, why re-invent the wheel? Bet Angel has done the development work on this already. The spreadsheet is a lot easier to learn how to use than the Betfair API.
surely running 10 "bots" simultaneously would be quite pointless, you will get stung on data charges unless you limit each "bot" to 1.99 calls per sec, which would seem (to me) pointless.Michal wrote:BetAngel is riding this "Lada" too.
My main concerns are flexibility and lightweight. I want to be able to run about 10 active bots on 10 different markets at the same time.