Skip to content
Exports fantasy premier league season history to excel workbook
Python
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.gitignore Initial commit May 7, 2018
Changelog.txt
FPLDataFetcher.py
FPL_logo.gif
README.md Added Warning regarding change of FPL api Sep 3, 2019

README.md

Fantasy Premier League Data Fetcher

Code was written in Python 3. I chose python since I just started learning it a couple of months ago and the openpyxl module is a way to export data to excel sheets.

Executing the script prompts a GUI interface asking the user to enter their fantasy team ID. This can be found easily on the wesite. Clicking the submit button then proceeds to import all json data from the website and exporting it to excel.

Youtube tutorial: https://youtu.be/DM9-e84iDZ8

Screenshots: https://imgur.com/a/lp27xAn

FPL have changed their API, I will update the app soon to reflect this change. Thank you

Requirements

Whatever is required by the openpyxl and tkinter modules, ie,

  • Windows device
  • Microsoft Excel 2010 or newer

Modules Used

  • tkinter - for GUI
  • requests - to fetch json data from FPL website
  • openpyxl - to write the imported data to excel workbook
  • os - to show the path of the created excel file
  • I've also used urlopen and base64 to read the FPL logo off of an imgur link to place it in the GUI

List of data imported

  • Gameweek Score
  • Gameweek Average Score
  • Points Benched
  • Transfers Made for GW
  • Transfer Cost
  • Gameweek Rank
  • Overall Points
  • Overall Rank
  • Percentile Overall Rank (v2.0)
  • Percentile Gameweek Rank (v2.0)
  • Position in overall leaderboard
  • Team Value
  • Weekly Squad
  • Chips Used and when
  • Complete Transfer history with values
  • Final Dream Team
  • FPL Cup history
  • Classic League Ranks
  • H2H Ranks
  • Individual player scores for each GW
  • Weekly Dream Team

Json links


www.fezfiles.com

You can’t perform that action at this time.