Times of Goals Scored

[Kanga]

Hi Everybody,

Does anybody know of a site that lists stats on when goals are scored ?
A breakdown onto bands would be ok 0-10 mins, 11-20 mins etc etc.
Preferably with each of our Leagues & the major Euro Leagues.

TIA

[jackhulk]

Hello

Did you ever find such a site? I'm looking for the same thing

[Kanga]

No sadly and after considerable looking. There seems to be everything else available but not the actual timings.

There is a poster on here that runs a footy stats website and was looing for ideas to add - I never got round to asking.

[jackhulk]

Thats a pity.

Here's the site I use......

http://www.rsssf.com/

....its a bit manual with regards to finding times for first, second, third goal etc but all the data is there for a large number of leagues - hope it helps.

[Nikola]

jackhulk

Thanks, this site helps!

Although it would take a lot less time if there was a list of the times of goals. Anyone found this yet? I've been looking for this for a while now (again) and my head is starting to hurt. I dont think I'll find it in the end.

[jackhulk]

yeah would be good if there was a site as you say that "breakdown onto bands would be ok 0-10 mins, 11-20 mins etc etc"

Let us know if you ever find such a site please.

[F.]

Hi,

I just found this thread. I don't know of any website like that, but I might be able to provide you with a txt or csv file for the info you want.

Please let me know:
- league AND season you want these stats from
- preferred format (be as specific as possible)

I don't promiss anything but I'll try


F.

[muppet77]

hi webusermxc, i would be interested in as many premiership seasons as you have!

as for format, how about csv so i can put it straight into excel.

date, team a, min, min, min, team b, min, min, min

does that sound ok?

i have pmailed you my email address.

[Nikola]

Me too!

I need the Premiership mostly, although I would like to see Spanish Primera and Italian Serie A also, for the last let's say 5 years. csv and text both if your connections isn't slow, they're small files uploaded quickly. If you have a slow connection then just csv.

Thanks

Sent you a private messege with mail adress also.

[muppet77]

ok, it may take 2/3 weeks to do.

surely there must be goal times that can easily be dumped into excel, without text editing??????

help!!!

[Morris]

I have found something like this, but it only breaks down the time when the first goal was scored.

I dunno if that would help, but you are probably looking for all goals?

Well, if you need it, Its on the Ladbrokes website and all you have to do is click on the underlined teams for there data or go to the stats centre on the Football section.

Hope that helps.

[muppet77]

good spot mate, but you are right, i would like all the goals for each game in a user friendly format.

[georgej]

Found this http://www.soccerbot.com/fa/results/...ester%20United

May be able to go through the links for each team and get the data into seperate sheets. Not sure what you intend to use if for so no idea if you need it split into teams, game order etc.

Let me know and i'll see if i can come up with something. It even has past seasons and looks like all the leagues you may want. Not going to do anything until i hear back though. Looks like it could be a bit tricky and don't want to waste time if this isn't what's required.

[muppet77]

i would like the premiership 2005/6 not last season.
i really need the clubs, score and goal mins.

eg liverpool draw with manu 1-1 with a goal by saha in the 23rd and a goal from kuyt in the 33rd min:

the output would be:

liverpool, 1, 33, manu, 1, 23.

can anyone help??

[muppet77]

NB i have manually inputted last seasons goal times, so i need 05/06 season and previous.

ta.

[georgej]

Look at the bottom of this page
http://www.soccerbot.com/frames.htm

looks like you can get the whole of the premiership from 2001/2002
click one of the dates from now to then (at the bottom)
click on any team in the league table
The last option is ALL TEAMS

Seems to have the entire season with all the data you're looking for.
Should be able to get excel to parse the data from the site for that table.

Does this look about right?
I'll try if i have time tonight - and if someone else hasn't already done it.

[muppet77]

looks good, but i would like it in the row format in excel.
is this possible? is this 'parsing'?
i can easily cut and past it to excel, but i need all the info in one row.

[georgej]

Hi muppet - hit a few snags, but just about there now.

What i have so far:
you enter the url of the page required into cell A1 on Sheet1 (can be amended so that you can list the URLs in A1, A2 etc)
This wil pull the data to Sheet2
Sheet3 will then have the data in the layout you want (i think)
This will be saved to another sheet renamed as a date, readt for the next page to be split and sorted.

I was having a bit of trouble when a player scored more than one goal or it was a penalty or own goal - sorted that now.

If a player scores more than one goal, the times will not be in order (lowest to highest) - The way i have the code looking at the data, that should be pretty easy to fix. Is this something you need?

Layout

Arsenal	7	20	29	68	23	45	59	84		Everton	3	9	41	59
Blackburn Rovers	0									West Bromwich Albion	1	76
Charlton Athletic	2	29	90							Birmingham	2	20	33
Fulham	1	75								Fulham	2	43	61
Manchester City	0									West Ham United	1	46
Arsenal	0									Bolton Wanderers	2	10	71

I'll make the code check that the away side has not scored too many goals and the away team name doesn't overwrite anything.
I thought this looked better than having the data squashed up - but not sure if this matters for your purposes.

Should finish it tomorrow ok.

[georgej]

It looks a bit messy as i've left the screenupdating on so that you can see it is doing something. I think i've got it working, but can tweak it if something is wrong. Not extensively tested this - cos i'm knackered.

[muppet77]

wow! mate that is awesome.

is it possible to easily tweak it so it works with 24 championship teams?
that'll be 24 x 23 = 552 matches instead of the premiership's 20 x 19 = 380 matches?

thanks a million!