Thursday, April 16, 2009

Calculate Dow Jones Moving Average in excel

Someone asked me how does one calculate a moving average of any stock or index. So here's an illustration of how to calculate moving averages in excel using dow jones data. Simply open the spreadsheet and follow the calculations, they are very simple to understand. This is the simple moving average.

You can download the excel spreadsheet from here.

I have also included charts in another sheet in the same file. It has a couple of all time historical chart for the dow in both log scale and normal scale. There's another chart of the 2007-09 recession and stock market crash along with a comparison with the Great Depression of 1929-32. The same charts also have the 200 day moving average plotted to show how the 200 dma is a key technical level.

No comments:

Post a Comment