If you are using a mobile device, just tap the spreadsheet and swipe left to see the Trigger prices and forex trading spreadsheet free. Get The Top Daily Stock Picks Sent To Your Email Free! This system has been consistently delivering results over the years and we take the slow and steady approach to making money by taking one good trade at a time. You can also inspect and verify the calculations used to generate the results.
However, it is one of the more significant tools in the forex trader’s arsenal. This spreadsheet is simple to use. Once you’ve entered this date and clicked a button, some clever VBA fetches daily historical foreign exchange rates from the internet, and plots the Relative Strength Index and the historical volatility. USD from 1 January 2011 to 8 February 2013. As you can see, most of the movement is between an RSI of 30 and 70. Occasionally, the RSI of GBP-USD dips below 30 or peaks over 70, but quickly pulls back to the normal trading range.
Click the picture below for example calculations. You may also be interested in this spreadsheet, which plots RSI, ATR and volatility of stock quotes downloaded from Yahoo Finance. This site takes time to develop. We’ll assume you’re ok with this, but you can opt-out if you wish. This Excel spreadsheet downloads historical Forex data 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. I’ve just tried the spreadsheet in Excel 2010 and it works perfectly for me. When you loaded the spreadsheet in Excel, did you give the macro permission to run?