Betfair Price Files Download Manager

Post Reply
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Finding the files here a pain to sort out exactly what you need? How long does it take to sort out & download 1 years worth of files?

www.betfairpromo.com/betfairsp/prices/

Heres a spreadsheet that does away with all the hard work & eyestrain.
Betfair Price Files v5.7z
(Please see the bottom of this post for a updated file)

Note: Any files created on your C drive must be named the same as shown on the download manager. I've made a you tube video thats gives a quick demonstration:

https://www.youtube.com/watch?v=AMpchy4 ... e=youtu.be

and also shows you what VBA reference libraries I've got ticked.

https://www.youtube.com/watch?v=r6rhQ95 ... e=youtu.be

The update button will process any info that is held in the spreadsheet, then looks for any updates for the current year from then on
For example, if you've download 2017 to date, when you run it tomorrow/next week, it will download any updated files. Some files are not listed such as " bfprices_26072008.csv" where there is no indication of win or place or even which country it is

If you look at the UK Win files from 2007, there are only two that we can be sure contain only the win info

***Betfair have recently changed the location these files were hosted at, there is now an updated version of this file kindly edited and re-shared by the forum user 'Murdok' that retrieves the files from this new location which can be downloaded from the link below***
http://www.mediafire.com/file/6l17qgef8 ... d.rar/file

All the instructions above on how to use the program still apply
You do not have the required permissions to view the files attached to this post.
User avatar
Dallas
Posts: 16070
Joined: Sun Aug 09, 2015 10:57 pm
Contact:

Fantastic work Nigel
rostov
Posts: 31
Joined: Mon Jul 02, 2012 3:45 pm

Many thanks Nigel. Top class.
User avatar
rinconpaul
Posts: 112
Joined: Wed Dec 03, 2014 10:39 pm

Brilliant work champion! :idea:
Goose_86
Posts: 2
Joined: Fri Jun 16, 2017 10:42 pm

Hi there,

This file sounds really useful for some data crunching I want to do however when I download it it says the file extension is .7z and I cant get excel to open it. Is there something I am doing wrong?

Thanks,
Sovereign
Posts: 39
Joined: Wed May 10, 2017 3:12 pm

Goose_86 wrote:
Fri Jul 14, 2017 7:40 pm
Hi there,

This file sounds really useful for some data crunching I want to do however when I download it it says the file extension is .7z and I cant get excel to open it. Is there something I am doing wrong?

Thanks,
7z is a compressed file format. Download 7zip from http://www.7-zip.org/download.html and you should then be able to 'unzip' the file and access the excel file within.
Goose_86
Posts: 2
Joined: Fri Jun 16, 2017 10:42 pm

Sovereign wrote:
Fri Jul 14, 2017 8:40 pm
Goose_86 wrote:
Fri Jul 14, 2017 7:40 pm
Hi there,

This file sounds really useful for some data crunching I want to do however when I download it it says the file extension is .7z and I cant get excel to open it. Is there something I am doing wrong?

Thanks,
7z is a compressed file format. Download 7zip from http://www.7-zip.org/download.html and you should then be able to 'unzip' the file and access the excel file within.
Ah fantastic, it was just me being dim

Thanks for that :)
CarlosGB74
Posts: 7
Joined: Wed Sep 13, 2017 11:27 pm

Phenomenal job my man!

Can anyone please explain the column data please?

I don´t know the meaning of the following:

PPWAP MORNINGWAP PPMAX PPMIN IPMAX IPMIN

Cheers!!

Carlos.
CarlosGB74
Posts: 7
Joined: Wed Sep 13, 2017 11:27 pm

Thank you!!!
Post Reply

Return to “Betfair Data”