r/FantasyPL•
Con45

FPL API

Does anyone know of an API for the official game? I'm looking to automate scoring for an offline draft league, and we use standard scoring for the most part.

Posted Dec 6, 2015, 7:40 PM UTC

158
danhatcher•

This thread contains some information but it's not entirely helpful. I'd like to know if there's an open API floating around so I could make an automated draft league too.

6
hi-i-am-new-hereCrystal Palace•

What are the rules and how are they different? I have spent a season or two trying to get this working. I'm using a combination of extensions for anti fantasy football and excel macros. I will send it over if I think either could help.

2
Con45OPLiverpool•

We don't use captains or bonus points from the official game. Also squads are a lot bigger, and you only get one automatic sub.

2
hi-i-am-new-hereCrystal Palace•

For the one player mini game I have a macro which pulls all the player stats from that week. What's the set up at the moment? A list of players on a spreadsheet (a bit how the differential mini game is run)?

Or would you like to look at someone's fpl team and see each of their player stats?

2
Con45OPLiverpool•

Currently, we run the league through a Google spreadsheet. Player scores used to be manually input by my friend but, shockingly, he got tired of that haha.

Really, we only need total score of each player per week.

2
hi-i-am-new-hereCrystal Palace•

Ah OK. Would this be enough then?

https://docs.google.com/spreadsheets/d/1WtTMrwCsEg7XEZJgi9Z-8SFTcTkAyj5eiXGGouQuYts/edit#gid=0&vpid=A1

The GW_Player stats sheet.

If so I can send over the macro formula I use which pulls the info from the site. I then just copy paste from excel to google sheets

3