# Exchange Rates
Historical exchange rates data is essential for being able to interpret historical financial data published in different currencies.
There are a number of publicly available sources for exchange rates data. You can retrieve a full extract of exchange rates data from the OECD and the Federal Reserve from a single dataset published on Morph.io (opens new window), a free site for running scrapers to retrieve this kind of data. The data is available in CSV, as a full database, or via a queryable API in JSON, CSV or ATOM. The scraper also records when particular data was first seen, so that you can occasionally query for any updates since the last time you retrieved data.
To download the data, or use the API:
- Visit the scraper: https://morph.io/markbrough/exchangerates-scraper (opens new window)
- Sign in with Github (if you don't have an account, you can create one for free)
- Download the data, or access via the API (opens new window)
|Date||The date of the exchange rate (equivalent to |
|Rate||The rate of this currency to USD|
|Currency||The currency code for this currency (according to |
|Frequency||Whether this currency is a daily date (|
|Source||The source of this data, currently OECD (|
|RateFirstSeen||The date/time when the rate was first seen by the scraper API|
# Selecting the best date
Because multiple sources are used, you may wish to use a formula to prefer certain sources over others. For example, you may significantly prefer the daily rates from FRED to the monthly rates from the OECD, but still have the OECD rates as a fallback option if there's nothing else available (e.g. for very old rates).