Historical Exchange Rates in Excel
Handy spreadsheet with form to download historical exchange rates for multiple currency pairs straight into Excel.
This nimble spreadsheet can download daily historical exchange rate data for a list of currency pairs within a specified date range. Just click the magic download button, and in less than the time it takes to do another Google search, your pristine exchange rate data will be waiting for you.
How to Use the Spreadsheet
Downloading exchange rate data couldn't be easier. Just enter a list of currency pairs, enter the start and end dates, select a frequency, and click the magical download button. Your data will be downloaded into a new sheet within the same file.
A Note About the Data Source
The historical exchange rate data is downloaded from Quandl.com, a free search engine for numerical data, through its API. As of 1/15/2015, Quandl limits anonymous data downloading to 50 API calls per day, which is equivalent to downloading data for 50 currency pairs per day. If you sign up for a free Quandl account, Quandl provides you with an authentication token under your account settings which lifts your download limits to 2,000 API calls per 10 minutes and 50,000 API calls per day. Limits are subject to change. Please refer to Quandl's API page for the current limits.
Quandl.com only offers daily historical exchange rate data. If you're looking for higher frequency data or additional historical exchange rate information such as the bid and ask spreads, most likely you will need a premium data provider. With access to a premium data provider, a custom-built spreadsheet or add-in can help you streamline the process of moving data from the source straight into Excel.
I really enjoy putting together simple yet practical spreadsheet tools - from coding the core functionalities to designing an intuitive template - that people would actually use regularly. Any feedback or suggestion to help improve this spreadsheet is sincerely appreciated.