RE: More help: Exponential Moving Averages
- Posted by rforno at tutopia.com
Jan 20, 2003
I don't know if your formula is correct. The one I know for Exponential
Moving Average is:
TODAYS_EMA = TODAYS_DATA * alpha + YESTERDAYS_EMA * (1 - alpha)
where alpha is a coefficient between 0 and 1. To get an equivalent of normal
moving average for 10 days, for example, you should use alpha = 0.1
approximately, although there is no exact equivalence.
Regards.
----- Original Message -----
From: <noranross at optusnet.com.au>
Subject: More help: Exponential Moving Averages
>
> In my analysis of the stock market EMA's are used. I have been given the
> formula
> ema = close*period%+yesterday's ema*(100-period)% and it doesn't work in
my
> Excel. I have tried everything.
> Can anyone help please
> Ross Elliott Darwin Australia
>
>
>
> TOPICA - Start your own email discussion group. FREE!
>
|
Not Categorized, Please Help
|
|
