Reader Request

-
A quick reader request. For reasons unknown, the powers at Premier League towers have decided to remove the match data from their once reliable website instead opting for an unordered list of random facts including goalscorers, yellow cards etc. To calculate the various data I use on this site I need a listing of player stats each week including minutes played, goals, assists, bonus points and fantasy points and then I need that cross referenced by opponent to establish where (home/away) and against whom (good /bad teams) a particular player is scoring their points.

I can get goal and assist data from ESPN, who provide full match data but they obviously do not include fantasy or bonus points and annoyingly use full names rather than surnames, which requires some excel shenanigans just to get into a readable state.

Does anyone (a) know of any sources which list match data including minutes played or (b) have a reliably maintained spreadsheet with the data included?

Comments

whoracle said…
http://www.football-lineups.com/country/e1/Teams/ ?
August 29, 2011 at 11:38 AM
whoracle said…
http://premiersoccerstats.com/epl.html#
August 29, 2011 at 11:45 AM
whoracle said…
http://www.guardian.co.uk/football/chalkboards/create
August 29, 2011 at 11:47 AM
EddieO said…
Chris, the guys at TotalFPL and Fantasy Scout both have to scratch this information together. Total FPL is run by a guy who's called Frank on his chat page (www.totalfpl.com). Some the guys chatting on the totalfpl site are also knowledgeable so you could just join and ask the question?

The other site is run by a guy called Mark: www.fantasyfootballscout.co.uk

Both seem pretty decent so they may pass on the tip.
August 29, 2011 at 12:46 PM
Matthew said…
http://www.soccerway.com/ has goals (and weather its a pen or not), assists, pens missed, times of goals and subs, players, nationalities times of yellows and reds and some basic stats at the end.
August 29, 2011 at 1:34 PM
Matthew said…
p.s. thanks for the great blog!
August 29, 2011 at 1:35 PM
Gummi said…
I pay 4 pounds a month for stats at EPLIndex.com. They are not in table format, but I just sent a request for an export option to work with in Excel (inspired by you :) ).

Gummi at fantasyformation.com
August 29, 2011 at 6:20 PM
TD Ocho said…
I hate all these changes! Aaarrgh!! Can't see other people's transfers (just that they made them), sort by price rise, this ridiculous listing of stats you mention, "updating", etc. Not to mention I'm not a fan of the new bonus point system. Might need a new game.
August 29, 2011 at 9:34 PM
Steve said…
You could compile this data on a player-by-player basis (if you are using an automated process to do this? I wouldn't recommend trying it manually) by using the player data pages on fantasy.premierleague.com.

For example, http://fantasy.premierleague.com/web/api/elements/180/ has the full match history for Andy Carroll. This has all the data that you mentioned.
August 30, 2011 at 7:54 AM
Chris said…
Thanks for all the suggestions everyone. I am pleased to say I now have a good data set for the first three gameweeks so that the various trends etc can be looked at and posted about. Expect to see some player specific data popping up over the next few weeks (it's still a little too early to suggest Dzeko will score 76 goals or that Szczesny will concede 120 goals).
August 30, 2011 at 9:10 AM
Gummi said…
@Chris: Any chance you could divulge what method worked best for you.

@Steve: Thanks for the API hint. That is excellent. I think I might do a little private programming project to gather this information.

@TD Ocho: Sort by Price Rise has now been added.
August 31, 2011 at 6:54 AM
Post a Comment

Popular posts from this blog

Pushing the Panic Button: Gameweek 15

-
Image
Powered by Tableau The above visualisation is going to form the centrepiece for a new regular post (probably bi-weekly) which is kind of the opposite of the fanning the flames piece. Rather than focus on players who did well this week, we're going to look at players who didn't, and particularly those who haven't for a number of weeks and identify whether, yes you guessed it, the panic button should be pushed. Before we get into specific players, a quick review of what the table above shows: Goals xG - This is the expected goals a player should  have scored in a given week based on the number of shots he took (inside/outside the box), his historic skill level regarding hitting the target and the league average rate of converting shots on target (SoT) to goals. This metric gives an overview of the chances a player is receiving, along with the quality of them and the way he is converting them. Pts - simply the points scored by the player over the last five g...
Read more

A brief update

-
Happy holidays everyone; it's been a while. For those not on Twitter, I was away in Costa Rica over the break without much - if any - internet access hence the lack of posts around these electronic pages. Well, actually, that's only the main reason, not the only one. In truth I've become a bit disillusioned with the fantasy game the past couple of months, partly due to my other commitments which make copying data at 2am somewhat less appealing, partly due to a lack of excitement in this year's game and finally due to the constant frustration I have with today's internet culture. This blog is a labour of love and aside from the small amount of money I made from the pre-season guide many of you graciously purchased, I don't get much out of this beyond the enjoyment of interacting with readers and hopefully helping a few of you to gain a couple of extra fantasy points every now and then. While some of that enjoyment remains, I feel it has waned over time and th...
Read more

Demba Ba and transfer planning

-
Image
I try not to get involved in too much "will-he-won't-he" speculation in these pages with, for example, the weekly statistical rankings being provided regardless of rotation risk. I'm not saying, of course, that this shouldn't be a factor, only that I'm in no position to offer a worthwhile opinion, other than collating other news stories (which are often based on nonsense quotes from managers anyway). There are plenty of other sites who offer opinions on whether Tevez will play or if Vidic has recovered from injury but in almost all cases it's pure guess work and so I try and stay away from such discussions. With that in mind, my initial reaction to Ba's move was negative. I have no idea whether he will play every week at Chelsea, and while you'd think it would extremely odd for a player to leave a good team to go and ride the bench, other players have done the exact same thing before. All I therefore see is a player who has gone from being the e...
Read more