eTrader Zone       

This page contains the formula for EMA and you can download the formula in Excel spreadsheet.

Exponential Moving Average applies weighting factor which decrease exponentially, and reacts faster to recent price changes than a simple moving average. The 12-days and 26-days EMAs are the most popular short-term average, for long term, the most popular EMAs are 50-days and 200-days.

Exponential Moving Average (EMA)

Formula:

EMA = (CP * SC) + (PE * (1 - SC))
SC = Smoothing Constant
CP = Current closing price
PE = Previous EMA
First EMA is the average for past n days

Login or Register to download this Excel Spreadsheet