Top-League Fixture Projection Automation

I have a step-by-step tutorial that shows how to pull match data from both WhoScored and Understat, calculate projected outcomes/odds, and export everything into a tidy Excel workbook. I need you to run with that guide, automate the workflow, and hand back a repeatable script plus a finished file containing every fixture scheduled for the coming weekend across the Premier League, La Liga, Serie A, Bundesliga, and Ligue 1, that automatically update himself after each gameweek

You’ll scrape the raw match and team statistics, process them exactly as the tutorial outlines, then populate an Excel sheet that lists: kick-off time, home/away sides, modelled probabilities for home win, draw, away win, and the implied decimal odds. Because the file will be refreshed weekly, the code must be fully commented and easy for me to rerun with nothing more than a new date range.

Ideal background
If you already understand betting markets and basic probability models, you’ll recognise why accuracy in transforming xG and shot data matters. A genuine interest in football will also help you spot any anomalies before they slip through.

Deliverables
• Python (or equivalent) script that scrapes WhoScored and Understat, cleans the data, and outputs the projections
• One ready-to-use Excel workbook covering next weekend’s fixtures for all five leagues
• Brief readme showing how to set environment variables (proxies, API keys if needed) and trigger the weekly refresh

Acceptance criteria
1. Script completes without manual intervention and produces the Excel file in under 10 minutes on a standard laptop.
2. Projected odds align with tutorial formulae to within 0.5 %.
3. Workbook passes spot checks against live fixture lists (no missing or duplicated matches).

If that sounds straightforward, let me know your timeline and any past examples of sports-data scraping you’ve tackled.