This Excel spreadsheet downloads historical Forex data from the Internet, specifically the daily bid rates.
You simply enter two three-letter currency symbols, two dates, and click a button.
The spreadsheet will then connect to a remote website, and download daily bid rates (using some clever VBA). The Forex data is imported into a sheet called “Data”.
Now you can analyze and plot the forex data using all of Excel’s functionality. As an example, the spreadsheet plots the exchange rate data. If you wanted, you could easily add Bollinger Bands to the plot.
I’ve password-protected the VBA module in the spreadsheet (I’m heavily modifying it for a future post), but if you want the password then let me know.
This is free Forex data that we’re downloading, and in no way shape or form compares with paid services. Using the VBA programming principles used in the spreadsheet, you can easily use other tools, like Access databases, instead of Excel.
You may also be interested in this spreadsheet which downloads historical stock prices from Yahoo straight into Excel.
The spreadsheet is in Excel 97-2003 format, although I’ve only tested it in Excel 2010.
Update 29th July 2011: I’ve removed the password. Enjoy, and please come back and let me know what cool Forex applications you’ve made with it.