Calculate Dow Jones Exponential Moving Average

My post below contains the link to an excel spreadsheet which has the calculation for simple moving average for dow jones. Many people asked me for a similar sheet for calculating exponential moving average too. So here it is - the excel sheet with formula to calculate ema for dow jones or for that matter any index or stock.

Download and play with the data, have a look at the formulas and understand how they work.