I have taken data from Dow Jones from 1928 to 2009 and added the 200 day moving averages with buy and sell signals in the excel spread sheet trading system that you can download for free below .
If you want to analyze other data, just remove the data below the close value, and put your data below that row. Historically( 1928-2009) this system will give you profit. But the down side with moving averages is that you will not profit in sideways markets. The advantage of using moving averages is that you will profit from any big trend.
This system is really simple. Buy if the 200 day moving average is below the close, Sell if the 200 day moving average is above the close price.
( I have used excel 2007, so you probably need that to run it, if you don`t have office excel you can get a free trial at Microsoft.com. (You can also use the free alternative OpenOffice) ( Below is a screen shot from the spreadsheet)
Download Now ( 1.26MB )
Price : Free
Operating system : Microsoft Office Excel 2007 /OpenOffice
Publisher : american-dollar.com
