I keep hearing people talk about models and this is something i would like to do for Horse racing and greyhounds but my problem is that I haven't the first clue where to start. I have done google searches and the like and I just dont understand SQL and Python etc but my wife does and she will help me but can anyone here please explain where you would get your data from and what process was involved in building a model so that I can explain the process to my wife and hopefully she will be able to get the ball rolling and be able to teach me.
I just feel that if i am to make a successful bot one day that actually can make some type of profit that i need to do this as it seems most people here who are successful in automation has some type of model.
I dont want to know your edge or anything like that, I just need a steer like I can get data from x website and i built a model using y
once i can tell my wife what is needed to start we can get the data and start building something.
Any help appreciated
Data Mining And Building A Model
You can source the data from here:
data.betfair.com
That has minute by minute data for free for historic races, there are data specifications available
I've not used it before but believe it's in JSON format once extracted.
Pretty sure I saw some stuff on github about dealing with it.
You can source general pre-off and in-play data but is aggregated from here
https://promo.betfair.com/betfairsp/prices
It's in CSV format, doesn't take much to just iterate through each file downloading
I have my database for this setup in a relational format to save on space a touch (one table for selections, one table for market info and a final table for the pricing data).
You can also use a guardian bot to store data at specific timeframes which is my preferred method.
Remember to tick 'Export reports on market closure' under advanced settings and I keep my refresh restricted to 900 seconds before and after.
Have attached one I created for creating a model for australian horses (and will be used for the dogs as well).
The file outputs shouldn't take much to work through with python, I don't use it at all as used to work as a VBA developer full-time so I just get it to do all the grunt work for me in excel automatically. There's 2 stored values that get recorded, volume matched on selection and last traded price. Add in anything that suits your purpose.
data.betfair.com
That has minute by minute data for free for historic races, there are data specifications available
I've not used it before but believe it's in JSON format once extracted.
Pretty sure I saw some stuff on github about dealing with it.
You can source general pre-off and in-play data but is aggregated from here
https://promo.betfair.com/betfairsp/prices
It's in CSV format, doesn't take much to just iterate through each file downloading
I have my database for this setup in a relational format to save on space a touch (one table for selections, one table for market info and a final table for the pricing data).
You can also use a guardian bot to store data at specific timeframes which is my preferred method.
Remember to tick 'Export reports on market closure' under advanced settings and I keep my refresh restricted to 900 seconds before and after.
Have attached one I created for creating a model for australian horses (and will be used for the dogs as well).
The file outputs shouldn't take much to work through with python, I don't use it at all as used to work as a VBA developer full-time so I just get it to do all the grunt work for me in excel automatically. There's 2 stored values that get recorded, volume matched on selection and last traded price. Add in anything that suits your purpose.
You do not have the required permissions to view the files attached to this post.
This thread might help
viewtopic.php?f=55&t=13909
viewtopic.php?f=55&t=13909
-
captainbang
- Posts: 88
- Joined: Tue May 01, 2018 1:33 pm
Cheers, thanks very much Paul & Dallas You've been a big help!
ODPaul82 wrote: ↑Sun Dec 22, 2019 4:53 pmYou can source the data from here:
data.betfair.com
That has minute by minute data for free for historic races, there are data specifications available
I've not used it before but believe it's in JSON format once extracted.
Pretty sure I saw some stuff on github about dealing with it.
You can source general pre-off and in-play data but is aggregated from here
https://promo.betfair.com/betfairsp/prices
It's in CSV format, doesn't take much to just iterate through each file downloading
I have my database for this setup in a relational format to save on space a touch (one table for selections, one table for market info and a final table for the pricing data).
You can also use a guardian bot to store data at specific timeframes which is my preferred method.
Remember to tick 'Export reports on market closure' under advanced settings and I keep my refresh restricted to 900 seconds before and after.
Have attached one I created for creating a model for australian horses (and will be used for the dogs as well).
The file outputs shouldn't take much to work through with python, I don't use it at all as used to work as a VBA developer full-time so I just get it to do all the grunt work for me in excel automatically. There's 2 stored values that get recorded, volume matched on selection and last traded price. Add in anything that suits your purpose.