Power Query - BF Historic Bulk Data Downloader

[paspuggie48]

This is an upgrade to the downloader tool I posted here viewtopic.php?t=28303

BF Data Bulk Downloader.xlsx

BF Downloader.png

I have added a "DateFrom" and "DateTo" field.

Just enter the dates accordingly, right-click "Refresh" on any cell in the Table and the downloader will get the information from those specific files based on the date ranges.

* Not sure anyone uses the original tool anyway as there was an issue with Betfair and the Header Columns and no one responded to say they had an issue. Regardless, I have rectified the problem in this version.

[MemphisFlash]

Anything Power Query of yours i download. Thanks

[paspuggie48]

Anything Power Query of yours i download. Thanks

Ha Ha...bless you my child

[MemphisFlash]

proof it works

Capture.PNG

[paspuggie48]

proof it works

Capture.PNG

I've not tested it fully.

BF usually have some innocuous data lurking somewhere.

If anyone gets an error message then let me know and I'll investigate.

[Fugazi]

Pas,

I think i used either yours old one or a version someone edited to help me build my prediction model, so many thanks.

[paspuggie48]

Pas,

I think i used either yours old one or a version someone edited to help me build my prediction model, so many thanks.

Good on yer !!

[Anbell]

Thanks for this. I ran into an error

image_2024-05-09_144926616.png

[paspuggie48]

Thanks for this. I ran into an error

image_2024-05-09_144926616.png

What date range did you try Anbell?

[Anbell]

I think it was 1/1/24 to present

[Anbell]

I've been going backwards from current, starting with the fist of the month. It was ok back to March1, but Feb1 failed, as did jan1

[paspuggie48]

I've been going backwards from current, starting with the fist of the month. It was ok back to March1, but Feb1 failed, as did jan1

Gotchya. If I recall some BSPs were returned as a text value "Infinity". I'll investigate and hopefully solve it by close of play today

[Anbell]

Feb 10 & 20 failed but Feb 25 worked!

[Anbell]

I've been going backwards from current, starting with the fist of the month. It was ok back to March1, but Feb1 failed, as did jan1

Gotchya. If I recall some BSPs were returned as a text value "Infinity". I'll investigate and hopefully solve it by close of play today

You're a legend

[paspuggie48]

I've been going backwards from current, starting with the fist of the month. It was ok back to March1, but Feb1 failed, as did jan1

Updated version that solves the issue raised by Anbell.

BF Data Bulk Downloader.xlsx

BF Bulk Downloader.png

I was able to get 840,000+ selections from 01/01/2025 to 08/05/2024

It did take just under 10 mins mind you

Again, anymore errors then let me know.