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

Post Reply
rostov
Posts: 9
Joined: Mon Jul 02, 2012 3:45 pm

Wed Aug 23, 2017 2:38 pm

.
Many thanks to Adam (welshboy 06). Fantastic work, much appreciated.

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

Wed Aug 23, 2017 10:18 pm

I stuck welshboy's data up on a simple website, I'll try and make it a big more searchable when I figure out php7 :(

https://goaltimes.000webhostapp.com/index.php

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

Wed Aug 23, 2017 10:24 pm

spreadbetting wrote:
Wed Aug 23, 2017 10:18 pm
I stuck welshboy's data up on a simple website, I'll try and make it a big more searchable when I figure out php7 :(

https://goaltimes.000webhostapp.com/index.php
Nice work Spreadbetting :)

welshboy06
Posts: 165
Joined: Wed Mar 01, 2017 2:06 pm

Thu Aug 24, 2017 12:47 pm

Nice one spreadbetting!

I've done something similar myself, but using an ipython notebook. Was considering making a simple webpage, but you're already on the case :P

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

Thu Aug 24, 2017 1:59 pm

Unfortunately putting it up made me realise why I haven't done any html for ages, just about everythings changed, I've only php 5 something on my pc and everythings moved over to php 7 so most of the code I use on y own snippets are now redundant :) I'll be interested to see if the firstgoal times do have any drastic bearing on the outcome come Saturday.


.000webhost seem to be a decent free source if you want to trial a website especially as you have the scrapping code already in place , welshboy06, mysql , php etc all free as far as I can see for now.

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

Sat Aug 26, 2017 3:45 pm

Here the database scrape for the Newcastle game , goal scord at 36mins

Results from 1-0 first goal between 30 and 45 minutes

Newcastle 1 - 0 Away Team
30 games. 70% won. 23% drawn 7% lost.

Home Team 1 - 0 West Ham

24 games. 8% won. 12% drawn 79% lost.

Odds are pretty much in line 1.4, 4.8 ,12.5


Palace vs Swansea, Swansea score 44

Results from 0-1 first goal between 30 and 45 minutes, first goal time in brackets

Crystal Palace 0 - 1 Away Team
13 games. 0% won. 15% drawn 85% lost.

Home Team 0 - 1 Swansea
8 games. 38% won. 38% drawn 25% lost.

odds 7.4, 3.45 , 1.73


If we look at data from 4o minutes onwards it seems Palace don't have a good record of coming back to win and Swansea haven't lost either

Results from 0-1 first goal between 40 and 90 minutes, first goal time in brackets

Crystal Palace 0 - 1 Away Team

Crystal Palace 1 - 1 Newcastle (42)
Crystal Palace 1 - 2 Swansea (42)
Crystal Palace 0 - 1 Chelsea (43)
Crystal Palace 1 - 2 Manchester Utd (45)
Crystal Palace 0 - 2 Arsenal (47)
Crystal Palace 2 - 1 Tottenham (49)
Crystal Palace 0 - 1 Tottenham (50)
Crystal Palace 0 - 2 Hull City (51)
Crystal Palace 1 - 2 Manchester City (55)
Crystal Palace 0 - 2 Manchester Utd (62)
Crystal Palace 1 - 1 Arsenal (63)
Crystal Palace 0 - 1 Portsmouth (69)
Crystal Palace 0 - 1 West Bromwich (74)
Crystal Palace 0 - 1 Tottenham (78)
Crystal Palace 0 - 2 Newcastle (79)
Crystal Palace 0 - 1 Sunderland (80)
Crystal Palace 0 - 1 Everton (87)
Crystal Palace 0 - 1 Manchester City (90)
Crystal Palace 0 - 1 Charlton (90)

19 games. 5% won. 11% drawn 84% lost.

Home Team 0 - 1 Swansea

Everton 1 - 1 Swansea (41)
Crystal Palace 1 - 2 Swansea (42)
Wigan 0 - 2 Swansea (45)
Sunderland 1 - 1 Swansea (45)
Liverpool 2 - 3 Swansea (48)
Fulham 1 - 2 Swansea (56)
Newcastle 1 - 2 Swansea (58)
Burnley 0 - 1 Swansea (64)
West Bromwich 1 - 1 Swansea (64)
Burnley 0 - 1 Swansea (82)
Southampton 0 - 1 Swansea (83)
Arsenal 0 - 1 Swansea (85)
Aston Villa 0 - 1 Swansea (87)
Arsenal 0 - 2 Swansea (88)

14 games. 79% won. 21% drawn 0% lost.
Last edited by spreadbetting on Sat Aug 26, 2017 4:02 pm, edited 3 times in total.

User avatar
Naffman
Posts: 2559
Joined: Sun Aug 11, 2013 5:46 am

Sat Aug 26, 2017 3:49 pm

C'mon JonnyG tell us what to do ;)

User avatar
Westerner
Posts: 126
Joined: Fri Apr 17, 2009 10:03 am

Sun Aug 27, 2017 8:44 am

Shame to see this thread revert to Jonny talking to himself.

User avatar
Euler
Posts: 16199
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ
Contact:

Sun Aug 27, 2017 8:48 am

Not going to allow it to happen, as it's a decent thread. The mods will move or delete the posts.

User avatar
Naffman
Posts: 2559
Joined: Sun Aug 11, 2013 5:46 am

Sun Aug 27, 2017 8:52 am

Think he just needs deleting.

Kind of feel he just wants to be annoying.

Post Reply

Return to “Betfair Data”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 0 guests