Dow Jones Moving Average Calculation

Its often very confusing as to exactly how we calculate moving average etc. Most sites just say that this is the way, but when it actually comes to doing it, it turns out to be quite confusing, especially the Exponential Moving Average. Simple Moving Average on the other hand is not all that difficult.

To make your life easy I have illustrated how to calculate moving average etc using real data of Dow jones in an excel spreadsheet. Download and see how these are calculated. Pretty simple to understand then.