Announcement

Collapse
No announcement yet.

Historical Data Excel Workbook

Collapse
This is a sticky topic.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

    Historical Data Excel Workbook

    An Excel workbook is now available via https://github.com/betfair/historic-data-workbook

    The Historical Data Workbook interprets historical data purchased from Betfair by offering a means for download, display and analysis with Excel.

    The prerequisites for using the Historical Data Excel Workbook are:
    • • You must have previously purchased data via https://historicdata.betfair.com using your Betfair account. The BASIC data for use within this spreadsheet is free of charge.
    • • Install 7-Zip before using the spreadsheet, which relies on 7-Zip to manage the compressed data.

    The main functions of the workbook are:

    Extract the following data from the BASIC historical data files displaying the data in the following columns.

    · Date & Time
    · MarketId,
    · Market Status,
    · In-Play (true of false),
    · SelectionId,
    · LastPriceTraded

    Graphs the data output on a per selection basis, showing last traded price over time.

    Betfair Developer Program
    Last edited by BetfairDeveloperProgram; 05-10-2018, 05:11 PM.

    #2
    Hello,

    it seems that the workbook doesn't work. In the first excel sheet I can't login to betfair. Do you know what the problem could be?

    Comment


      #3
      Morning ttt.

      What error do you receive when attempting to login to the workbook? Are you able to login directly to the historical data website via https://historicdata.betfair.com/#/home ?

      Thanks

      Neil

      Comment


        #4
        Good morning all you, can I have some help just to make a vba function works

        Set HTTP_A = CreateObject("MSXML2.serverXMLHTTP")

        HTTP_A.Open "POST", "http://historicdata.betfair.com/api/GetCollectionOptions", False
        HTTP_A.setRequestHeader "Content-type", "application/json"
        HTTP_A.setRequestHeader "ssoid", "GK/PdVw4sAZCiOwN40jbYKXFKPMQUU3+5VZb7k6xU6g="
        HTTP_A.send "&sport=Horse Racing&plan:Basic Plan&fromDay=1&fromMonth=3&fromYear=2017&toDay=31& toMonth=3&toYear=2017&eventId=null&eventName=null& marketTypesCollection=[]&countriesCollection=[]&fileTypeCollection=[]"

        MsgBox (HTTP_A.responseText)

        I can't receive back a valid JSON, it says NgErrorRedirect

        Thanks in advance

        Comment


          #5
          I think the historic API is down at the moment, I haven’t tested but a few others on the BA forum are having issues.

          Comment


            #6
            I m using 64 bit excel, and there is a problem with "ActiveX component can't create object" error code 429 when trying to login. Any instructions?

            Comment


              #7
              Hi mal.

              Unfortunately, the workbook isn't compatible with 64 bit Excel, you'd need to use the 32 bit version.

              Neil

              Comment


                #8
                Hi, I posted in the "Is the Historical API Documentation" Rather than me rewrite it, I was hoping you could take a look and help me out please. Cheers

                Comment


                  #9
                  Hi winnie2402

                  Have you tried using the Historical Data Excel Workbook via https://github.com/betfair/historic-data-workbook

                  This should help you to download the data you require. Please refer to the HistoricalDataWorkbook.docx for details of how to use the spreadsheet.

                  Neil

                  Comment

                  Working...
                  X