1. RE: More help: Exponential Moving Averages
- Posted by rforno at tutopia.com Jan 20, 2003
- 477 views
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! >