Home Page Exclusions

New Premier League Players Analysis

The arrival of new players to the Premier League can cause headaches for Fantasy managers. Although good form in other leagues does not dictate they will be an instant Premier League success, it can be a useful indicator of whether they are worth investing in. To help you analyse their form elsewhere I have come up with this handy spreadsheet.

Method

The spreadsheet works out the points per appearance that each player would have earned using the Premier League points system last season. Some users may remember that I did the same last year. There is a sheet for the new transfers into the league (e.g. Alexis Sanchez and Cesc Fabregas) and also one for the newly promoted clubs. Goalkeepers are left out as, in most cases, this is unnecessary information.

The sheet for the new transfers is split into forwards, midfielders and defenders. It includes simple information such as the transfer price and the old club as well as statistics. The clean sheets statistics for each player relate to the number their new Premier League club kept last season. For instance, Ander Herrera does not have the number of clean sheets his old club, Athletic Bilbao, managed but the number Manchester United did last season. United kept 13 clean sheets in the 38 matches last season which works out as 11 in relation to Herrera’s 32 apps.

The newly promoted clubs sheet is split into three tables, one for each club. It is similar to the previous section. This time the clean sheets stats are for the promoted club’s championship season.

But there are limitations. Some leagues are easier than the Premier League so the player may have a higher points per appearance than he would manage in England.

Updates

I will be refreshing the sheet each week and there will be a new link so watch out in the comments section for it. Eventually, the price and ownership columns will be filled in once the fantasy game is launched. This will allow me to calculate the value for each player. This is worked out by multiplying the points per appearance by 100 and dividing by the price. This figure, when available, is useful when comparing players of similar price only.

thepuntmaster Twitter - @thepuntmaster Freelance journo and FPL addict. Everton fan.

20 Comments Post a Comment
  1. J0E
    • Fantasy Football Scout Member
    • Has Moderation Rights
    • 14 Years
    9 years, 8 months ago

    Great work....look forward to further updates over the summer

    Open Controls
  2. Fifa las vegas
    • 11 Years
    9 years, 8 months ago

    After FPL, which is the best Fantasy game?

    I'm thinking of playing more than FPL this year, but don't want to do them all, and lose interest after a few Gameweeks. Telegraph? Sky?

    Sky looks good to me, a nice amount of prizes.

    Open Controls
  3. coriswrasse
    • Fantasy Football Scout Member
    • 13 Years
    9 years, 8 months ago

    nice read. thanks for the tables etc...

    Open Controls
  4. BigManBakar
    • Fantasy Football Scout Member
    • 10 Years
    9 years, 8 months ago

    Absolutely brilliant. Thanks a ton 😀

    Open Controls
  5. Agnipurush
    • 11 Years
    9 years, 8 months ago

    Thanks a lot

    Open Controls
  6. Konig Luther
    • 11 Years
    9 years, 8 months ago

    Great Work

    Open Controls
  7. pppppppp88
    • 9 Years
    9 years, 8 months ago

    when does fantasy.premierleague.com star again?

    Open Controls
    1. htfcbrad
      • 9 Years
      9 years, 8 months ago

      Does anybody have a good idea of when all of the currently missing transferred players will be in the game? Such as Filipe Luis, Remy Cabella, Lazar Markovic etc... Thanks.

      Open Controls
      1. Jairzinho
        • Fantasy Football Scout Member
        • 13 Years
        9 years, 8 months ago

        Should be within the next week.

        Open Controls
  8. Twelve years a slave
    • Fantasy Football Scout Member
    • 13 Years
    9 years, 8 months ago

    Thankyou, very interesting

    Wonder if it would be possible to add some kind of weighting to take i to account the quality of league the players were playing in. Would be very difficultt to do i guess

    Open Controls
    1. thepuntmaster
      • Fantasy Football Scout Member
      • 10 Years
      9 years, 8 months ago

      Maybe - I'll have a look this week and see if I can get it out for the next version

      Open Controls
    2. thepuntmaster
      • Fantasy Football Scout Member
      • 10 Years
      9 years, 8 months ago

      yep have managed to do this, will be up by friday 🙂

      Open Controls
      1. Twelve years a slave
        • Fantasy Football Scout Member
        • 13 Years
        9 years, 8 months ago

        Very good, look forward to it

        Open Controls
  9. Harlem Globeslotters
    • Fantasy Football Scout Member
    • 11 Years
    9 years, 8 months ago

    Amazeballs spreadsheet - thanks. Certainly helped me make a few calls on the first draft.

    Open Controls
  10. swok
    • 9 Years
    9 years, 8 months ago

    Hi Puntmaster,

    I play in a fantasy draft league, so any deep numerical analysis like this is really helpful in getting an edge over my competition.

    I am creating my own spreadsheet / model, and would really like a spreadsheet of points per game for each player in the EPL.
    Do you have anything like that?

    Open Controls
    1. thepuntmaster
      • Fantasy Football Scout Member
      • 10 Years
      9 years, 8 months ago

      Sorry only the new players and the ones on the VS. It's pretty easy to do tho mate just look on transfermarkt for the apps and divide their total score by that number. That included BAPS etc 🙂

      Open Controls
    2. WHY ALWAYS MESUT?
      • 10 Years
      9 years, 8 months ago

      I play a draft myself, would love to discuss strategies/picks if you're up for it! Might be able to come up with something interesting!

      Open Controls
  11. Redhulkster
    • 10 Years
    9 years, 8 months ago

    Well done..cheers 🙂

    Open Controls
  12. thepuntmaster
    • Fantasy Football Scout Member
    • 10 Years
    9 years, 8 months ago

    I have written a community article about the VS update but it is either taking a while to go up or not going up so I thought I'd post a bit about it here.

    Many of you will have seen my New Players Analysis on the community article section. This new update has more players including Enner Valencia and Filipe Luis.

    I have also added more players to the promoted clubs section so there is more information for you to have a look at.

    The biggest update is the VS section. I asked the community which players they were struggling to choose between and have compared them.

    With prices released I have also calculated each player's ''value.

    Anyway, all the info is on the document. I hope the article is published soon so you can all see it or this is HTpiced instead.

    https://drive.google.com/file/d/0B6W3Px_oyV6-d0pWcHRBd0xCNEU/edit?usp=sharing

    Open Controls