Downloading Betfair SPs

[Ted Brogan]

Is there a way to download all the histoircal BF SP's all at once rather than by clicking hundreds of files individually? Maybe some sort of VBA code? (I'm a complete newbie at that sort of thing though). I basically just want all available GB win data (There are about 280 files I think looking at the site).

Thanks
Ted.

[throwmeadisc]

Hi Ted,

Use Firefox and install this addon.

https://addons.mozilla.org/en-US/firefox/addon/201

Then navigate to the Betfair SP site and goto the page with all the 280 files etc. Then use the DownLoadThemAll addon to download the files.

If you only want GB then you can use the filter function to filter out only the files you want.

Hope this helps.

Al

[Ted Brogan]

Brilliant piece of kit, thanks very much.

[knot]

Anyone using Betfair SP's to form a systems builder please beaware that there alot of race's missing from the csv files. Just from January alone using my own system the following races/selections are missing from the place GB csv files. There also seems to be alot of selections missing from the win csv files.

GB / Kemp 10th Jan / 17:15 1m3f Hcap
GB / GLghs 11th Jan / 14:30 6f Hcap
GB / GLghs 15th Jan / 18:50 6f Hcap
GB / GLghs 15th Jan / 19:20 1m6f Hcap
GB / GLghs 15th Jan / 21:20 1m2f Hcap
GB / Ascot 17th Jan / 13:05 2m3f Hcap Hrd
GB / Ascot 17th Jan / 14:50 3m Grd2 Hrd
GB / Sedge 20th Jan / 13:50 2m4f Hcap Hrd
GB / Sedge 20th Jan / 14:20 2m Hcap Chs
GB / Sedge 20th Jan / 14:50 3m3f Hcap Hrd
GB / Sedge 20th Jan / 15:20 3m3f Mdn Chs
GB / Chelt 24th Jan / 14:05 2m5f Hcap Chs
GB / Uttox 24th Jan / 15:30 2m6f Hcap Chs
GB / Chelt 24th Jan / 16:20 2m1f Hcap Hrd

[Steve Voltage]

Hi Ted,

Use Firefox and install this addon.

https://addons.mozilla.org/en-US/firefox/addon/201

Then navigate to the Betfair SP site and goto the page with all the 280 files etc. Then use the DownLoadThemAll addon to download the files.

If you only want GB then you can use the filter function to filter out only the files you want.

Hope this helps.

Al

is there anyway of downloading more than one cssv file to one spreadsheet?

[KevinTHFC]

On excel 2007 you can click on data and then import a text file to the same sheet. I am sure you can do the same thing on older versions as well

[Steve Voltage]

On excel 2007 you can click on data and then import a text file to the same sheet. I am sure you can do the same thing on older versions as well

I've been playing around with this but no luck any further advice please?

[GaryRussell]

On excel 2007 you can click on data and then import a text file to the same sheet. I am sure you can do the same thing on older versions as well

I've been playing around with this but no luck any further advice please?

You could concatenate the files into one file and import that.

Create a file named concat.bat in the same folder as the csv files (you can use notepad) containing the copy command to concatenate the files. Run this file by double clicking it.

Code: Select all

copy /b file1.csv+file2.csv file3.csv

In the above example file1.csv and file2.csv will be combined to create file3.csv