This Excel spreadsheet downloads historical Forex google finance usd cad forex from the Internet. You can ask for bid, ask and mid rates for a range of historical currencies. The spreadsheet is easy to use.
You simply enter two three-letter currency symbols, two dates, and specify whether you want the bid, ask or mid price. 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’d appreciate a link to investexcel. 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 2010 format. 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. I’ve added an option to request the bid, ask or mid price.
I am interested in working this code into an existing workbook I have made. This looks like an awesome tool and will do most of what I need it to do. How can I go about getting that password for the VBA code though so I can validate a few things? Let me know what you super cool applications you come up with! It looks like a terrific tool to use with excell.