![How to open betfair historical data How to open betfair historical data](http://img.gforum.tv/img/983ea2c468ea8762ec23ef76923703c1b4a9705a.jpg)
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.
But what I do enjoy is data – specifically horse racing data. I’ve always followed horse racing, and have always wanted to ‘crack it’. I think data is the only way to do it. RateThatHorse is unique in that it includes horse ratings, systems and statistics, all built into an algorithm that provides not just data, but selections. Looking for historical betting data on Sports? The Betfair Data Sources Page provides you with all the betting data that you need. Use this page for your sports model or for your own knowledge. Check out more on how best to use these Data Sources on the Betfair Hub.
• 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.
![Only Only](/uploads/1/2/6/2/126298380/702286611.jpg)
• Graphs the data output on a per selection basis, showing last traded price over time.
• Please refer to the Historical Data Work.docx for full instructions relating to the above.
Please note: The Historical Data Workbook isn’t compatible with 64 Bit versions of Excel.
Disclaimer - The Historical Data Workbook is provided ‘as is’. Betfair provides the Historical Data Workbook to demonstrate use of the Betfair Historical Data within Excel. It is intended only as a sample. There are no guarantees as to the functionality of the application