View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Alojz Alojz is offline
external usenet poster
 
Posts: 161
Default exponential moving average

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


"j" wrote:

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