Betfair Historical SP

[Leonthefixer]

Evening everyone,

I am looking at researching info with regards to the Betfair SP and therefore I am looking at the historical Betfair SP's.

Betfair have them here in one handy Zip file for up to and including the 27/05/2008:

http://promo.betfair.com/betfairsp/SP_history.html

However, after this date they seem to be here but in individual files for each and every day, nearly 1,500 days/files:

http://promo.betfair.com/betfairsp/prices/

I can't say I fancy going through each and every file and downloading it as I will be doing it forever.

So does anyone know of a place that has them all in the one place or similar or do you really have to click on each file?

Cheers.

[AlistairH]

Leon, one of the guys in my chat room was downloading this data and I'm sure he said he used some addon for Firefox just for the reasons you mention above. He was able to set it and walk away I think.

I'll ask him tomorrow when he's in.

[Leonthefixer]

Hope things are good with you Alistair!

If I download it I will try and break it down into years or something and then hopefully other people won't have the hassle in the future and can just download the info.

Anyone at a loose end and who is a bit better at Excel than me, fancy doing it?

[AlistairH]

Yep, that's probably the thing he used Leon.

[1/4 of a millionaire fund]

I had a program to automatically download them into a MYSQL database a few years ago when I was looking at optimum lay the field prices. I've still got the database which goes til aug 2009 when i stopped collecting the data. Probably still got the scraper script around somewhere

[Cran]

Here's the files

Haven't done anything with them, it's just all the .csv files zipped up into 4 separate .zip files

ukwin.zip 20Mb
ukplace.zip 18Mb
irewin.zip 6Mb
ireplace.zip 5Mb

right click... save link as... or whatever...

[1/4 of a millionaire fund]

I've got all the files, It will take a while to upload to my server, but when it's done I'll stick a download link here.

Haven't done anything with them, it's just all the .csv files zipped up into 4 separate .zip files

ukwin.zip 20Mb
ukplace.zip 18Mb
irewin.zip 6Mb
ireplace.zip 5Mb

... links to follow shortly (maybe tomorrow morning as the upload is going quite slow)

are the csv files joined into one for UKwin etc or just all the separate files cran?

No need to reply just saw they're all separate

[Cran]

all separate

might have a look at combining them tomorrow if I get time

[Leonthefixer]

Cheers for that guys - been off doing some other stuff so not had chance to look at the files, or your email MF. Will have a look tomorrow morning hopefully. Could prove to be a handy resource for the community as I am sure I am not the only person who has/will want(ed) these

[Quaint]

Ta-dah

I confess to not actually having read this whole thread, so ignore me if this is completely irrelevant!

I have all the files up to April in one sheet. It's over 100k rows, so you might need Office 2007 and above to actually view all the cells. Hope it helps

[Cran]

Have now combined the data into just 4 .csv files (ukwin, ukplace, irewin, ireplace)

You'll need a later version of Excel or a Database (MySQL and MS SQLServer Express are both free) to use them as there are a lot of records

242100 + 229502 + 81763 + 79829 = 633191 rows

Here's the links

spdata_ukwin.zip 17Mb
spdata_ukplace.zip 15Mb
spdata_irewin.zip 5Mb
spdata_ireplace.zip 4Mb

Have fun...

[1/4 of a millionaire fund]

Thanks for that guys, you've saved alot of people a lot of hassle downloading those files, myself included and and mine was automated to put them all into a database at a click of a button, but they soon mount up and I was missing maybe 2000 of them so saved me a lot of download time

I'd echo Cran's recommendation for MYSQL, it's free, fast and makes easy work of drilling down the data to whatever you want in seconds. Plenty of help on the net if you get stuck as it's free and the query commands are usually nothing more than a line of code

[brumbie]

Well I thought I was reasonably smart so I downloaded my sql and php something and after reading it all I had to take a long hot shower to recover.Thanks Cran for the download,its something i've been wanting for a long time but me thinks i'll have to find another way of perusing it.......


BTW..I lost again today.

[Cran]

try MS SQL Server Express is also free and a bit easier to use (not much)

[AlistairH]

With all due respect to those advocating mySQL and SQL Express, and with my MCSE hat on (if there was a spitting emoticon, I'd use it), I'd say, given the nature of the data being imported, i.e. a flat file database, combined with the fact that not all members here are technojocks, folks would be better off using OpenOffice Database (free) or MS Access (not free).

These are much simpler to install/use than the aforementioned SQL suggestions for the simple, albeit, large table of data that is being downloaded. Both applications can easily handle the amount of records contained therein.