exponential moving average

[j]

Exponential moving slope is the issue. Is there a formula.dropdown table
such as the one available for moving averages

 

[Bernard Liengme]

Have a look here:
http://www.ozgrid.com/forum/showthread.php?t=93282
best wishes

 

[j]

Thank you! I am going to try to apply this to a moving slope!

 

[Alojz]

Hi, u can create formula for EMA. For 12 days EMA, first date MA is simple
MA, in my example in C13, values in colB, dates in colA, row1 is header row:
=SUM(B2:B13)/12 (or use AVERAGE function for first 12 values. From C13 and
13th value u can already start to calculate EMA (in C14):
=+B14*(2/13)+C13*(1-2/13), copy down.
I put sample file with EMA12 and EMA26 to:

http://ash001.sweb.cz/ema.xls

HTH click yes, if so.

Regards
Alojz