Betfair Price Files Download Manager

Post Reply
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

Lovin your work nigelk, many thanks.
weemac
Posts: 1216
Joined: Mon Sep 16, 2013 8:16 pm

Betfair seem to have killed off that page today. It's gone.
THEBOO
Posts: 1
Joined: Thu Sep 29, 2016 11:10 am

Been trying to access the Betfair Price files since yesterday - the normal link now just takes you to the main Betfair home page. Can't find any announcements about stopping the service or moving the location of the files. Anyone know why?
User avatar
Dallas
Posts: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

THEBOO wrote:
Tue Mar 20, 2018 8:43 am
Been trying to access the Betfair Price files since yesterday - the normal link now just takes you to the main Betfair home page. Can't find any announcements about stopping the service or moving the location of the files. Anyone know why?
Being phased out for there new data page
https://historicdata.betfair.com/#/home
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

Anyone have the price files for the last few months? Would be great if someone made them available
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

THEBOO wrote:
Tue Mar 20, 2018 8:43 am
Been trying to access the Betfair Price files since yesterday - the normal link now just takes you to the main Betfair home page. Can't find any announcements about stopping the service or moving the location of the files. Anyone know why?
I think the site has been a bit dodgy for a while but working fine at the moment with all files up to date.
ocze0107
Posts: 12
Joined: Mon Mar 26, 2018 2:13 pm

This Excelsheet didnt work with 64 Bit System, i get errors when i open it
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

ocze0107 wrote:
Wed Mar 28, 2018 1:23 pm
This Excelsheet didnt work with 64 Bit System, i get errors when i open it
It's nothing to do with being 64bit. It works fine on my system. 64bit Win7Pro, Excel2016.

You say you 'got errors', saying what the errors actualy were might have helped in finding a solution, similarly with 'didn't work'. It doesn't give much to work with.
ocze0107
Posts: 12
Joined: Mon Mar 26, 2018 2:13 pm

ShaunWhite wrote:
Wed Mar 28, 2018 1:35 pm
ocze0107 wrote:
Wed Mar 28, 2018 1:23 pm
This Excelsheet didnt work with 64 Bit System, i get errors when i open it
It's nothing to do with being 64bit. It works fine on my system. 64bit Win7Pro, Excel2016.

You say you 'got errors', saying what the errors actualy were might have helped in finding a solution, similarly with 'didn't work'. It doesn't give much to work with.
Its for me in German but i try it, " Error to compile. The Code in this Project must be refresh for 64 Bit Systems.Change Declare and mark it with PtrDafe-Attribut...
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

If only i,d found this on tuesday. took me 10 hours getting the info i wanted. This way took less than an hour
Hugo219
Posts: 1
Joined: Sun Jun 10, 2018 5:50 pm

You're amazing DUDE!!/DUDe/Dud-ette ; Surprised at how few youtube views on there though, but your stuff is gold, good work and keep it up sensei !! Many thanks ;) :)

Also worth mentioning that WHEN running the files on a 64-bit machine, like mine, you'd have to mark declare statements with 'PtrSafe' ...... i.e. Using a very generic example below to demonstrate :
"Declare Function GetActiveWindow Lib "user32" () As Long"
becomes :
"Declare PtrSafe Function GetActiveWindow Lib "user32" () As Long"

If running on 32 bit machines, no changes to code required. ----Just my lil contribution
User avatar
gstar1975
Posts: 615
Joined: Thu Nov 24, 2011 11:59 am

nigelk wrote:
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
Where can I find the Betfair SP matched Volume. Not Total Volume but just the matched money that was matched at Betfair SP. In these SP data files on the Promo site only have the columns for Morning Volume, Pre Off volume and In Play volume but no BSP volume matched for example:
280718 Gabrials King BSP matched Volumes.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
gstar1975
Posts: 615
Joined: Thu Nov 24, 2011 11:59 am

Can anyone also explain the discrepancies on the Picture below?

The BSP volume matched does not work out correctly or am I missing something...
280718 Gabrials King BSP matched Volumes.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
Euler
Posts: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

That does look a bit anomalous because one should be related to the other.
dougkpga
Posts: 11
Joined: Wed Aug 22, 2018 4:12 pm

Hi Nigel,
That is an awesome help.
Far be it from me to complain as I am very grateful for the work you have saved me so this is not a complaint but when I downloaded, say 2015 (UK Win) and it said 365 files were available but it downloaded 163 files.
The other years 2016 (152 days) and 2017 (156) were a bit short too.
I'm not sure if I am doing anything wrong and still very happy with the results.
Cheers Doug
Post Reply

Return to “Betfair Data”