Hi everyone
I'm new to betangel. I'm looking to develop fully automated bot for my strategies. I would appreciate advice which way to achieve this with betangel.
For my strategies to work I need download or create database with statistics. I have been searching forum and have seen some of you are using excell to download statistic from websites. Next I need somehow know what matches are playing on current day and calculate suitable strategy for the current matches using my instructions. After all allocate the strategy in betangel automation and let it run automatically. Every strategy got different input values for different match as well to be more complicated,but without that strategy is useless. This is just general describe of my target. There will be need filters as well etc.
I have no background with any programming language,but I will not hesitate to learn one need.
What the best approach to develop the bot in your opinion? It's excell and VBA script enough for this?
I'm apologies for my English as well. If you don't understand clearly please ask.
Thank you for reading my post and helping.
Automatic strategy allocation
-
ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Hi.
Yes Excel/VBA and BA would be flexible enough to do what you want. It's a significant project though so I hope it's something that works rather than being speculative. The first step would be to see if the stats sites you already use have a csv download option, of at least find one. Then get your Excel model to identify the bets and prices you'd like arranged into a list. If you get that far then the BA integration will be straightforward.
But given your tech experience that's a little like saying you want to build a V12 engine but you've never held a spanner. It might be best to approach the end goal via a series of more simple tasks. Perhaps doing the bet selection the way you currently do it and set it up manually in Guardian, then move further back in the process.
Yes Excel/VBA and BA would be flexible enough to do what you want. It's a significant project though so I hope it's something that works rather than being speculative. The first step would be to see if the stats sites you already use have a csv download option, of at least find one. Then get your Excel model to identify the bets and prices you'd like arranged into a list. If you get that far then the BA integration will be straightforward.
But given your tech experience that's a little like saying you want to build a V12 engine but you've never held a spanner. It might be best to approach the end goal via a series of more simple tasks. Perhaps doing the bet selection the way you currently do it and set it up manually in Guardian, then move further back in the process.
Thank you very much Shaun. It is big project and not even close what I do in manual trading. Some of the tasks I do live are impossible implement. My main concern is, if VBA or even excell can handle all the requested calculation tasks. I know phyton language can be used in excell as well. I have no idea what can be achieved with excell. It will need calculate time for entry the market for example. Betangel will need fire that bet ,but need to check the score as well in some strategies. I would prefer having life stats implemented to it as well ( shots ,attacks ,cards etc),but that information is very expensive through API. At least to my knowledge. My goal is to fully automate all this.
Thank you very much for great advice. I appreciate it.
Thank you very much for great advice. I appreciate it.
-
ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Excel/Vba will be up to the task of the calculations which I suspect won't be too onerous. Calculations are pretty much all Excel does so it's hardly a slouch. What it might struggle will is anything that needs to reference large datasets or involved iterative formulas in real-time. It might come down to how quick you need to be, are you looking to place bets in a second or two or within a few milliseconds. If it comes down to sheer speed then you might need to consider using Excel, Python (or my chouce C#) to place the bets too rather than sending them to BA.
But before getting too deep into a 6 month project I suggest you collect your stats, and collect Betfair price data and see if you can find an edge first, then think about automating the bets later. If you need price data to kick start the analysis before you start collecting your own you can find some here. https://historicdata.betfair.com/#/home.
Automation is very much about the data and that needs to be complete and of a high enough time resolution. As mutulple football matches occur at the same time BA won't be able to do it and you'll need to look at collecting price and volume data yourself via the Betfair Api.
But before getting too deep into a 6 month project I suggest you collect your stats, and collect Betfair price data and see if you can find an edge first, then think about automating the bets later. If you need price data to kick start the analysis before you start collecting your own you can find some here. https://historicdata.betfair.com/#/home.
Automation is very much about the data and that needs to be complete and of a high enough time resolution. As mutulple football matches occur at the same time BA won't be able to do it and you'll need to look at collecting price and volume data yourself via the Betfair Api.
Thank you Shaun again. Your inputs are very valuable to me. I didn't know that I can directlly placing bet on Betfair through excell .I'm lucky enough, that my son knows phyton language and my brother in law knows vba plus phyton and Java and he is specialised in databases.
I know they do something with computers,but didn't know what exactly until now. Regarding historic data's I don't need testing. I'm full time trader. All this strategies got edge . It was first successful strategies I started using before many of them fails.I created them . I don't use them lot now because I do different type of trading harvesting more money.Now I can see potential with this data's and automation available to be able trade lots matches in high quality .The live stats now available to get are perfectly fitting my strategy and I'm able add more strategies. It's all about quality data's and informations. My strategies don't need quick execution. 30 sec - 1 min is good. My main task will be obtain information about VAR. When VAR in progress everything need to stop even when Betfair keep the market open to be able steal our
. I hope I will be able post results in less than 6 months,
I know they do something with computers,but didn't know what exactly until now. Regarding historic data's I don't need testing. I'm full time trader. All this strategies got edge . It was first successful strategies I started using before many of them fails.I created them . I don't use them lot now because I do different type of trading harvesting more money.Now I can see potential with this data's and automation available to be able trade lots matches in high quality .The live stats now available to get are perfectly fitting my strategy and I'm able add more strategies. It's all about quality data's and informations. My strategies don't need quick execution. 30 sec - 1 min is good. My main task will be obtain information about VAR. When VAR in progress everything need to stop even when Betfair keep the market open to be able steal our
. I hope I will be able post results in less than 6 months,
-
ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
I think it's time your lad earned his keep 
...give him this for a little light bedtime reading.
https://developer.betfair.com/en/exchange-api/
...give him this for a little light bedtime reading.https://developer.betfair.com/en/exchange-api/
-
ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
That's odd, and who said the internet isn't listening to you......when I loaded the link to the doco I got a Spanish language loading screen. Duolingo is a snitch !! At least I now know "Creato da Utente Sconosciuto" means "created by an unknown user" which probably won't come up much in conversation. 
You do not have the required permissions to view the files attached to this post.