Great stuff Paul !
Not sure why but the original tool stopped working for me some time back but for some reason yours works
I've added 'Place' options too, if it helps?
It seemed to test OK for me.
Betfair Price Files Download Manager
- paspuggie48
- Posts: 642
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
You do not have the required permissions to view the files attached to this post.
Bit of a long shot. Does anyone happen to have the Betfair csv file for the U.K. horse racing win market for 18/10/2018 (so for races run on 17/10/2018) please?
The version on the BF website has the RSA results showing. I’ve contacted BF but they haven’t updated yet. Failing this, I can use the place market but don’t have the BSPs, so if anyone has these instead, that would be great.
Thanks in advance.
Btw - this download tool is excellent. Great job.
The version on the BF website has the RSA results showing. I’ve contacted BF but they haven’t updated yet. Failing this, I can use the place market but don’t have the BSPs, so if anyone has these instead, that would be great.
Thanks in advance.
Btw - this download tool is excellent. Great job.
- MemphisFlash
- Posts: 2166
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
i have it but it's on a hard drive i am having trouble with at the min. if i get my drive working i'll post a link to it
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
Hey Paul, I wanted to download a new category of prices but I seemed to remember there had been some changes since I last used the Nigel's file so before doing so I thought I would search the subject and found your file. It's brilliant, well done and thank you. I simplifies and targets the needed downloads in a way I kept telling myself I should do but not being a natural VBAer I have to research each word of code before using it!paspuggie48 wrote: ↑Mon May 31, 2021 11:52 amGreat stuff Paul !
Not sure why but the original tool stopped working for me some time back but for some reason yours works
I've added 'Place' options too, if it helps?
It seemed to test OK for me.
Download BF Files.xls
Just one question if I may. When Bf get round to correcting an error in their download they just change the file with no notification or warning as far as I can see. Does your download just look to see if the file exists in the download folder by name before skipping to the next file or does it check the date of the Bf file with the date of the downloaded file in the folder?
Again, thanks a million for sharing the file ... great work.
Hey, it purely attempts to download the file based on the given date, no check to see whether it exists or not already locally so if you put in a date range that you've loaded in previously then it will just overwrite the original file.firlandsfarm wrote: ↑Fri Apr 29, 2022 9:31 amHey Paul, I wanted to download a new category of prices but I seemed to remember there had been some changes since I last used the Nigel's file so before doing so I thought I would search the subject and found your file. It's brilliant, well done and thank you. I simplifies and targets the needed downloads in a way I kept telling myself I should do but not being a natural VBAer I have to research each word of code before using it!paspuggie48 wrote: ↑Mon May 31, 2021 11:52 amGreat stuff Paul !
Not sure why but the original tool stopped working for me some time back but for some reason yours works
I've added 'Place' options too, if it helps?
It seemed to test OK for me.
Download BF Files.xls
Just one question if I may. When Bf get round to correcting an error in their download they just change the file with no notification or warning as far as I can see. Does your download just look to see if the file exists in the download folder by name before skipping to the next file or does it check the date of the Bf file with the date of the downloaded file in the folder?
Again, thanks a million for sharing the file ... great work.
You can download it from here but its not as easy and straight forward to work with
https://historicdata.betfair.com/#/home
For that data there's a tool you can use to convert it to a csv file (created by Liam): https://www.betfairhistoricdata.co.uk/Dallas wrote: ↑Tue Jul 12, 2022 2:12 pmYou can download it from here but its not as easy and straight forward to work with
https://historicdata.betfair.com/#/home
You have to untar the file yourself first (using something like winzip or 7zip) and then you'll see all the .bz2 files in subdirectories.
Is there a way to bulk convert these csv files? As it will take a long time to convert individual files for a whole year. 10000 races.arch4672 wrote: ↑Tue Jul 12, 2022 2:45 pmFor that data there's a tool you can use to convert it to a csv file (created by Liam): https://www.betfairhistoricdata.co.uk/Dallas wrote: ↑Tue Jul 12, 2022 2:12 pmYou can download it from here but its not as easy and straight forward to work with
https://historicdata.betfair.com/#/home
With the website, I don't think so.gstar1975 wrote: ↑Wed Jul 13, 2022 3:54 pmIs there a way to bulk convert these csv files? As it will take a long time to convert individual files for a whole year. 10000 races.arch4672 wrote: ↑Tue Jul 12, 2022 2:45 pmFor that data there's a tool you can use to convert it to a csv file (created by Liam): https://www.betfairhistoricdata.co.uk/Dallas wrote: ↑Tue Jul 12, 2022 2:12 pm
You can download it from here but its not as easy and straight forward to work with
https://historicdata.betfair.com/#/home
If you want to convert lots of them your best bet is to use python and use the betfairutil library (search for it on github) which has a prices_file_to_csv function.