Thread
Do you want to stop getting red arrows?
You need to make better use of xG data
Here's how you can build an FPL model in 20 minutes:
You need to make better use of xG data
Here's how you can build an FPL model in 20 minutes:
1) Export Fbref Player data
From this link:
fbref.com/en/comps/9/stats/Premier-League-Stats
Export the table to an excel workbook by clicking on 'share & export':
From this link:
fbref.com/en/comps/9/stats/Premier-League-Stats
Export the table to an excel workbook by clicking on 'share & export':
After downloading it and removing unnecessary columns, I ended up with this: 
2) Access Player Poistions
Thanks to @theFPLkiwi you can link fbref data to a player's FPL position
Here's the table which has a player's name in fbref and their FPL position:
github.com/theFPLkiwi/theFPLkiwi/blob/main/ID_Dictionary.csv
Thanks to @theFPLkiwi you can link fbref data to a player's FPL position
Here's the table which has a player's name in fbref and their FPL position:
github.com/theFPLkiwi/theFPLkiwi/blob/main/ID_Dictionary.csv
3) Save Player Positions in Excel
Create a new sheet in the workbook from step 1
In that sheet, copy and paste the data from step 2
Remove unnecessary columns - you only want fbref name and FPL position
Create a new sheet in the workbook from step 1
In that sheet, copy and paste the data from step 2
Remove unnecessary columns - you only want fbref name and FPL position
You'll end up with this: 
4) Use vlookup to join on FPL position to fbref data
Vlookup is an excel function that lets you combine two datasets when they share a common variable
As the data from steps 1 & 2 both have player name, we can use vlookup to join them together
Vlookup is an excel function that lets you combine two datasets when they share a common variable
As the data from steps 1 & 2 both have player name, we can use vlookup to join them together
This is how I used vlookup to join the tables together: 
Here's more details on vlookup:
support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
5) Make a table with points for goals, by position
In a 3rd sheet, make a table which lists how many points players from each position get for scoring a goal:
In a 3rd sheet, make a table which lists how many points players from each position get for scoring a goal:
6) Do a vlookup between FPL position and points for a goal
Similar to step 4, do a vlookup between the main table and the table you just made
Similar to step 4, do a vlookup between the main table and the table you just made
You'll end up with this: 
7) Multiply npxG & xA columns by points for goals and assists
Make a new column which multiplies the npxG/90 by the 'points for goal column'
Make a new column which multiplies xA/90 by 3 - no need for vlookups here as every player gets 3 points for an assist
Make a new column which multiplies the npxG/90 by the 'points for goal column'
Make a new column which multiplies xA/90 by 3 - no need for vlookups here as every player gets 3 points for an assist
8) Create an 'Expected Points' column
Add together the columns made in step 7 to get an estimate of Expected Points
Add together the columns made in step 7 to get an estimate of Expected Points
Your final table should look like this: 
If you don't do this and only sort xG tables online, you're completely ignoring a player's position
This means you're more likely to make bad transfers
This means you're more likely to make bad transfers
If you wanted to update this model each week, it'd take 5 minutes
you could copy in the most recent data from fbref and the xpts column would automatically update
you could copy in the most recent data from fbref and the xpts column would automatically update
You can access the model I built and get better at FPL here:
docs.google.com/spreadsheets/d/12Z5mtYX7mAx93zhff5219cia_STBWGTb/edit?usp=sharing&ouid=11116462794011...
docs.google.com/spreadsheets/d/12Z5mtYX7mAx93zhff5219cia_STBWGTb/edit?usp=sharing&ouid=11116462794011...
If you have any questions please let me know!
If you found this useful, please retweet the first tweet so more people can see it
If you found this useful, please retweet the first tweet so more people can see it
For more details on the best way to use data in FPL
Check out my free ebook covering the 3 most common mistakes people make with data
tremendous-pioneer-21.ck.page/f178882f09
Check out my free ebook covering the 3 most common mistakes people make with data
tremendous-pioneer-21.ck.page/f178882f09
