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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Split form 0
Cell data entering slow! 0
Help Needed ! 0
Amending meeting cancels all future meetings 0
Calculation Based on Dynamic Variables (What-if Scenario) 0
calculate average values for 100 records in the shortest way? 5
calculating volatility 0

Top