Keeping exchange‑rate tables current is a chore that accounting teams repeat every month. This Python tool automates the task and hands you a fully‑formatted Excel workbook in seconds.
At launch the script asks four questions—functional currency, periodicity (month / quarter / half‑year / year), the final period‑end date, and how many periods to look back based on the selected periodicity. It then fetches the daily eurofxref file directly from the European Central Bank, converts the rates into your chosen base currency, and generates three sheets:
- YTD Close – the closing rate on each period‑end day
- YTD Average – the average rate from 1 January to that day
- Period Average – the average rate within the month / quarter / etc.
The workbook lands on your Desktop as “ECB exchange rates_YYYYMMDD_HHMM.xlsx”. An Instructions sheet (shown first) documents the data source, echoes your input parameters, and explains in plain English how every figure is derived. Usability touches—yellow‑highlighting the functional‑currency row and collapsing currencies that have no data—keep the view clean.
Why care? Because once you schedule this script (Windows Task Scheduler, cron, CI pipeline) your FX packs update themselves: no manual downloads, no copy‑paste mistakes, no forgotten refreshes or calculations.
Code download:
