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.
(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
Betfair Price Files Download Manager
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 dimSovereign wrote: ↑Fri Jul 14, 2017 8:40 pm7z 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.
Thanks for that
-
- 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.
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.