Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old Yesterday, 08:45 AM
thorns thorns is offline
Member
 
Join Date: Aug 2007
Posts: 492
Default Betfair API data

Asking a bit of a favour or guidance. I have just downloaded this years horse racing historical data via betfair and it comes as a *.tar file.

Is there a simple way to convert this to open in excel?
Reply With Quote
  #2  
Old Yesterday, 11:48 AM
walkermac walkermac is offline
Member
 
Join Date: Nov 2013
Posts: 694
Default

A .tar file is a compressed archive of multiple individual files. You can use something like the free program 7Zip to extract it. The Betfair .tar file is composed of .bz2 files, which are themselves compressed, so they'll have to be extracted once again to get the base JSON file. *phew*!

There's a bit more info here: https://betfair-datascientists.gith...storicDataSite/.

There are JSON to CSV converters to subsequently get the data into Excel.

Another option that may suit your purposes is this tool from Betfair, which seems to automate the process: https://github.com/betfair/historic-data-workbook

*NB - this is theory from me, haven't done it myself.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 09:43 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655