Betfair Data : Betfair Price Files Download Manager

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

Sun Jun 18, 2017 12:35 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
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
You do not have the required permissions to view the files attached to this post.

User avatar
Dallas
Posts: 7688
Joined: Sun Aug 09, 2015 10:57 pm

Sun Jun 18, 2017 1:17 pm

Fantastic work Nigel

rostov
Posts: 9
Joined: Mon Jul 02, 2012 3:45 pm

Mon Jun 19, 2017 6:26 am

Many thanks Nigel. Top class.

User avatar
rinconpaul
Posts: 112
Joined: Wed Dec 03, 2014 10:39 pm

Fri Jul 07, 2017 9:48 pm

Brilliant work champion! :idea:

Goose_86
Posts: 2
Joined: Fri Jun 16, 2017 10:42 pm

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,

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

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.

Goose_86
Posts: 2
Joined: Fri Jun 16, 2017 10:42 pm

Fri Jul 14, 2017 9:07 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: 3
Joined: Wed Sep 13, 2017 11:27 pm

Tue Oct 17, 2017 3:27 am

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: 3
Joined: Wed Sep 13, 2017 11:27 pm

Thu Oct 19, 2017 12:42 am

Thank you!!!

Post Reply

Return to “Betfair Data”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest