You can download historical foreign exchange data into a Microsoft Excel spreadsheet using the following XLS.
The spreadsheet provided above is an improvement over the excellent VBA code provided by the website investexcel.net. The following two features are added:
- Combo boxes for the currency pair to make finding currencies simple and easy.
- Date pickers for the to and from date ranges.
If you think either the combo boxes or the date pickers are a hassle to deal with and only want one of them, you can go to the developer tab, enable design mode, and delete them. The VBA code will work just fine without them.