calculation of EMA

C

Charles Williams

Hi Garima,

assume that alpha (smoothing constant) is in A1, your time series is in row
2 then put this formula in b3 and copy across to the right
=B1*(1-$A$1)+$A$1*B2

Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com
 
Top