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

Post Reply
rolandimone
Posts: 4
Joined: Mon Nov 06, 2017 4:47 pm

Dallas wrote:
Thu Nov 23, 2017 12:06 pm
rolandimone wrote:
Thu Nov 23, 2017 12:02 pm

Link not working.
I've just tried it and its still active and working
Thanks problem was with my IP provider. It works when I turned VPN on.
luckycharms365
Posts: 1
Joined: Sat Dec 30, 2017 6:09 am

Hi guys, noob post here. How can I see goal times using the data that welshboy has scraped? HHT,AHT,HFT, and AFT I have no idea what they mean. Thanks in advance for any help as it would be greatly appreciated.
User avatar
Dallas
Posts: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

luckycharms365 wrote:
Sun Dec 31, 2017 10:12 pm
Hi guys, noob post here. How can I see goal times using the data that welshboy has scraped? HHT,AHT,HFT, and AFT I have no idea what they mean. Thanks in advance for any help as it would be greatly appreciated.
It will be the number of goals
Home Half Time
Away Half Time
Home Full Time
Away Full Time
Dendy
Posts: 1
Joined: Thu Jan 18, 2018 3:24 pm

Hi guys

I'm very interested in this topic (one of the reasons why i entered on BetAngel Forum :D). I think would be interesting to have data from the initial odds from Over/Under Markets (0.5; 1.5; 2.5; etc.) and "Cards markets" (i don't know exactly the name for it, sorry) to try to find some correlation. At least to find a possible strategy based on this data. Do you think it's possible to scrap this data? I think oddsportal have some historical data but i don't know if it's possible or not to scrap data from there. At least it's possible to find some Over/Under odds.

Cheers guys ;)
User avatar
gstar1975
Posts: 615
Joined: Thu Nov 24, 2011 11:59 am

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 do not have the required permissions to view the files attached to this post.
LinusP
Posts: 1871
Joined: Mon Jul 02, 2012 10:45 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: 615
Joined: Thu Nov 24, 2011 11:59 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: 615
Joined: Thu Nov 24, 2011 11:59 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: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

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: 3140
Joined: Sun Jan 31, 2010 8:06 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

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!
nicksim80
Posts: 2
Joined: Mon Aug 19, 2019 1:29 am

Hi,
Does anyone have updated data they are willing to share as per Welshboy's oiginal post?
The original data is now 2 seasons old.
Or is anybody aware of an alternative source?

Thanks in advance!

Nick
CallumPerry
Posts: 575
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

This looks like it will be VERY useful in the near future, thank you very much for sharing!
Speculator_3
Posts: 61
Joined: Wed Feb 20, 2019 10:01 pm

Hi all, this is a copy of my separate new thread I just wrote, but I wanted to post here anyway - since that this subforum doesn't seem to very lively.

What I I want is to analyse betfair historical data when a certain specified GOAL DIFFERENCE is achieved in a match.

For example: say I want to study matches where EITHER team was leading by 3 goals at any point - i.e. I want to look at matches where the scoreline was either 3-0, 0-3, 4-1, 1-4, 5-2, etc at some time in the match. Note: I don't care what the scoreline was specifically - just that there was a 3 goal difference. What I want to know is the time of match when this occurred, the match back/lay odds immediately after this scoreline was achieved, the names of teams involved, and also how the scoreline progressed with the relevant time/odds info (so if the scoreline changed from 3-0 to 3-1, I want to know the time and match odds at that new point).

I want this data on EVERY SINGLE MATCH that went live on betfair 24/7, say in the last several months. Essentially I want at least several thousands' games of data.

How can I find this info?
Post Reply

Return to “Betfair Data”