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 then can be downloaded “ECB exchange rates_YYYYMMDD_HHMM.xlsx”. An Instructions sheet (shown first) documents the data source, your input parameters, and explains how every figure is derived. Usability touches—yellow‑highlighting the functional currency row and collapsing currencies that have no data to keep the view clean.
