Downloading Betfair Price Files

Example spreadsheets and comments on example spreadsheets.
Post Reply
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

I've seen a few posts relating to the price files found here:

http://data.betfair.com/

I made up a sheet last year that sorts out the data once you've downloaded a file (UK win only files).
It gradually builds up into a database that you can analyse by year/month/day/week/racetype/course/runners, betting position of winner etc.

Once you've downloaded a file you can navigate to it and load it into the programe.

There are 2 sheet with pivot tables on them showing the traded volume by course and racetype and the favourite win rate by course and racetype. The info for these no longer exists, (original database deleted), but what you can see is still valid

I haven't put a button on any sheet so you'll have to run it manually. Before you do so however, make sure to delete any info in the unique values sheet,and the database sheet (everything else should take care of itself, but haven't used it for a while myself). If you try to download the same file twice, you will be told that it already exists and will not be added.

Cheers,Nigel

PS Had to delete a couple of pivots as the file size was to big.
You do not have the required permissions to view the files attached to this post.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

see here for some Betfair 2014/2015 files

https://onedrive.live.com/redir?resid=2 ... lder%2czip
herbie
Posts: 342
Joined: Mon May 11, 2009 8:56 pm

thanks nigel :D
sarkec
Posts: 54
Joined: Thu Sep 29, 2016 12:38 pm

Hello,

Where or how I can load that CSV files into the excel?


Thanks
Post Reply

Return to “Bet Angel - Example spreadsheets”