Announcement

Collapse
No announcement yet.

Betfair Historical SP

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Betfair Historical SP

    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.

  • #2
    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.
    Ali
    BetamicroSolutions - my IT business
    Twitter Me - Finally! I'm on Twitter.

    Comment


    • #3
      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?

      Comment


      • #4
        Yep, that's probably the thing he used Leon.
        Ali
        BetamicroSolutions - my IT business
        Twitter Me - Finally! I'm on Twitter.

        Comment


        • #5
          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

          Comment


          • #6
            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...
            Last edited by Cran; 8 September 2010, 11:15 PM. Reason: files finished uploading and links updated
            If you want more luck... Take more chances!

            Comment


            • #7
              Originally posted by Cran View Post
              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

              Comment


              • #8
                all separate

                might have a look at combining them tomorrow if I get time
                If you want more luck... Take more chances!

                Comment


                • #9
                  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

                  Comment


                  • #10
                    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

                    Comment


                    • #11
                      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...
                      If you want more luck... Take more chances!

                      Comment


                      • #12
                        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

                        Comment


                        • #13
                          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.

                          Comment


                          • #14
                            try MS SQL Server Express is also free and a bit easier to use (not much)
                            If you want more luck... Take more chances!

                            Comment


                            • #15
                              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.
                              Ali
                              BetamicroSolutions - my IT business
                              Twitter Me - Finally! I'm on Twitter.

                              Comment

                              Working...
                              X