calculation of EMA

  • Thread starter Thread starter garima
  • Start date Start date
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
 
Back
Top