where can i find historical data of in race horse odds?

The sport of kings.
Post Reply
cyxstudio
Posts: 297
Joined: Sun Mar 23, 2014 11:18 pm

data.betfair.com doesnt give in play odds.

I am trying to formulate an in race trading strategy but first i need the data to test it. Anyone has any information where can i get historial data?
nztrader
Posts: 26
Joined: Tue Feb 16, 2016 8:15 am

Im similar , Im wanting to just get some historical races to look at but cant seem to find anything.
LinusP
Posts: 1918
Joined: Mon Jul 02, 2012 10:45 pm

viewtopic.php?f=5&t=11883

How much data are you after? I don't mind posting yesterdays inplay data (parsed with best offers) if that is helpful?
PeterLe
Posts: 3727
Joined: Wed Apr 15, 2009 3:19 pm

LinusP wrote:viewtopic.php?f=5&t=11883

How much data are you after? I don't mind posting yesterdays inplay data (parsed with best offers) if that is helpful?
Liam, I wouldn't mind seeing this please.
I'm very close in completing my own hand written system and being able to extract my own data should be easy after that.
I'm just keen to see if it's could make use of it going forward
(Probably better in its complete state so I can see what info you grab)
Do you capture every 200ms too?
Thanks
Peter
LinusP
Posts: 1918
Joined: Mon Jul 02, 2012 10:45 pm

PeterLe wrote:
LinusP wrote:viewtopic.php?f=5&t=11883

How much data are you after? I don't mind posting yesterdays inplay data (parsed with best offers) if that is helpful?
Liam, I wouldn't mind seeing this please.
I'm very close in completing my own hand written system and being able to extract my own data should be easy after that.
I'm just keen to see if it's could make use of it going forward
(Probably better in its complete state so I can see what info you grab)
Do you capture every 200ms too?
Thanks
Peter
Sure, I sometimes collect the raw json response and chuck it in a nosql db for processing at a later date but I collect a parsed form which I use for day to day research and model building which is pushed straight into a MySQL db.

Yeh I send a request every 200ms, although trying to get market streaming working with python this morning, struggling :roll:
LinusP
Posts: 1918
Joined: Mon Jul 02, 2012 10:45 pm

Also not sure if you have signed up to AWS Peter, as the free trial offers a MySQL instance for a year / ec2 instance free for a year plus loads more.
LinusP
Posts: 1918
Joined: Mon Jul 02, 2012 10:45 pm

https://www.dropbox.com/s/aaoiuy2p8b8cu ... a.zip?dl=0

Here is a zip that contains some parsed data from yesterday including headers and sql code (mysql) to create a table and load as well as some raw marketbook data for some markets last year.
plus: volume that is likely to be from backing
minus: volume that is likely to be from laying
calc1: cumulative of plus and minus
I say likely because my algo isn't perfect due to xm.
cyxstudio
Posts: 297
Joined: Sun Mar 23, 2014 11:18 pm

LinusP wrote:https://www.dropbox.com/s/aaoiuy2p8b8cu ... a.zip?dl=0

Here is a zip that contains some parsed data from yesterday including headers and sql code (mysql) to create a table and load as well as some raw marketbook data for some markets last year.
plus: volume that is likely to be from backing
minus: volume that is likely to be from laying
calc1: cumulative of plus and minus
I say likely because my algo isn't perfect due to xm.
sorry but..may i know what am i looking at? I saw a lot of size and odds in the txt file. I assume that is the in play odds changes for a horse in a race?
nztrader
Posts: 26
Joined: Tue Feb 16, 2016 8:15 am

Thats awesome... how do you get the data in the first place before parsing it etc?
LinusP
Posts: 1918
Joined: Mon Jul 02, 2012 10:45 pm

All data has been collected from betfairs api.

https://developer.betfair.com/

If you are using excel you will want to look at parsed/IP_2016-06-03.csv this contains the data, parsed/headers.txt are the headers for this csv. Just add the headers to the top of the file to manipulate in excel but I strongly recommend loading to a database as there is a lot of data!
cyxstudio
Posts: 297
Joined: Sun Mar 23, 2014 11:18 pm

LinusP wrote:All data has been collected from betfairs api.

https://developer.betfair.com/

If you are using excel you will want to look at parsed/IP_2016-06-03.csv this contains the data, parsed/headers.txt are the headers for this csv. Just add the headers to the top of the file to manipulate in excel but I strongly recommend loading to a database as there is a lot of data!
i get it now thx
PeterLe
Posts: 3727
Joined: Wed Apr 15, 2009 3:19 pm

Thanks very much Liam,
Going to get today's set up and then Ill have a play with it
Regards
Peter

Edit: I was just looking at this data nd if I took my best earning system circa 2011/2012 (not in use thesedays) and applied it theoretically, the trigger would have fired 604 times on 88 selections.
No point to make as such, but interesting!
Atho55
Posts: 678
Joined: Tue Oct 06, 2015 1:37 pm

Hi Liam, do you have the Betfair .csv files for the last few years assembled into 1 file by any chance. UK & IR win market.
G
Post Reply

Return to “Trading Horse racing”