Hi All,
I am trying to download historic data using Betfair, the file is running in .tar format and i just cant find anything to open in with. Anybody got a steer on this please?
Betfair Historic data download
-
ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Try 7-zip which is free, or Winzip which isn't
If not just google ".tar decompressor"
If not just google ".tar decompressor"
-
northbound
- Posts: 737
- Joined: Mon Mar 20, 2017 11:22 pm
If you downloaded data from https://historicdata.betfair.com, they can't easily be imported into Excel.
Betfair historical data is typically one .tar file.
When you extract it, it will look like one file per market, usually grouped into folders (for example one folder may contain all the market files for an Ascot meeting).
Each market file contains a number of lines.
Each line contains a JSON object. These objects don't contain a set number of "columns", but they contain info about a specific price/volume change. For one or more runners. Or perhaps a line can contain info about the market's suspension/unsuspension.
Basically, to do something with these files you need software development skills and also know in advance what do you want to extract. It's not as simple as opening these files into Excel.
Betfair historical data is typically one .tar file.
When you extract it, it will look like one file per market, usually grouped into folders (for example one folder may contain all the market files for an Ascot meeting).
Each market file contains a number of lines.
Each line contains a JSON object. These objects don't contain a set number of "columns", but they contain info about a specific price/volume change. For one or more runners. Or perhaps a line can contain info about the market's suspension/unsuspension.
Basically, to do something with these files you need software development skills and also know in advance what do you want to extract. It's not as simple as opening these files into Excel.