Betfair Data : Football Data (CSV, JSON) - UPDATED 16/08/17

Post Reply
LinusP
Posts: 1446
Joined: Mon Jul 02, 2012 10:45 pm

Mon May 14, 2018 1:42 pm

gstar1975 wrote:
Mon May 14, 2018 1:01 pm
Has anyone been able to work out how to use the New Betfair Historical data website, Ive managed to download a .tar file and extracted it but its all gobbledeegoop. All I get is the .bz2 files in text file
You need to extract the bz2 file.

User avatar
gstar1975
Posts: 114
Joined: Thu Nov 24, 2011 11:59 am

Tue Jun 05, 2018 10:09 am

I have extracted the .Bz2 file but they extract as a .txt file

Can you take me through the exact steps please?

User avatar
gstar1975
Posts: 114
Joined: Thu Nov 24, 2011 11:59 am

Tue Jun 05, 2018 10:41 am

gstar1975 wrote:
Tue Jun 05, 2018 10:09 am
I have extracted the .Bz2 file but they extract as a .txt file

Can you take me through the exact steps please?
Can someone please do a video on this please???

User avatar
Dallas
Posts: 9325
Joined: Sun Aug 09, 2015 10:57 pm
Contact:

Tue Jun 05, 2018 4:52 pm

gstar1975 wrote:
Tue Jun 05, 2018 10:09 am
I have extracted the .Bz2 file but they extract as a .txt file

Can you take me through the exact steps please?
I think megarain once wrote a detailed post on how to open Json files in SQL in a betfair data thread.

I use excel myself so never had any need to open Json files

spreadbetting
Posts: 1820
Joined: Sun Jan 31, 2010 8:06 pm

Tue Jun 05, 2018 5:05 pm

You can import json into excel but alot is dependant on your version of excel, just look on youtube they'll be lots of tutorials how to imort json files into your version of excel. There are even plenty of online or standalone convertors for json -> csv files out there too. No idea how big the files are and it may well be that you'd be better off using Access or some SQL database to query them

richolicious
Posts: 1
Joined: Mon Aug 20, 2018 12:45 pm

Mon Aug 20, 2018 12:51 pm

Thanks welshboy06 for scarping the site. By the way, I don't find the event time (goal, red card) in the HKJC site.
http://football.hkjc.com/football/stati ... team_no=-1

Are those info sourced elsewhere, or am I not looking at the right place? Thanks!

Post Reply

Return to “Betfair Data”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 2 guests