1. More help: Exponential Moving Averages
- Posted by noranross at optusnet.com.au Jan 17, 2003
- 434 views
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
2. Re: More help: Exponential Moving Averages
- Posted by Lucius Hilley <l3euphoria at bellsouth.net> Jan 17, 2003
- 428 views
You did not give us any data to work with. Lucius L. Hilley III ----- Original Message ----- From: <noranross at optusnet.com.au> To: "EUforum" <EUforum at topica.com> 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! > >
3. Re: More help: Exponential Moving Averages
- Posted by noranross at optusnet.com.au Jan 19, 2003
- 434 views
Thanks for Query The period is 5. The actual EMA is as follows. My calculations do not get these figures or anything close. Date EMA Close 2/1/02 3419 3440 3/1/02 3418 3414 4/1/02 3425.5 3443 7/1/02 3429 3463 8/1/02 3436 3430 9/1/02 3431 3420 Ross Elliott Darwin
4. Re: More help: Exponential Moving Averages
- Posted by Euler German <efgerman at myrealbox.com> Jan 19, 2003
- 416 views
On 16 Jan 2003, at 14:23, noranross at optusnet.com.au wrote: > > 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 > I'm afraid you have a wrong (sort of) formula. There's a good example in (beware of wrapping): http://www.stockcharts.com/education/What/IndicatorAnalysis/indic_moving Avg.html#exponential Kind regards, -- Euler
5. Re: More help: Exponential Moving Averages
- Posted by Pete Lomax <petelomax at blueyonder.co.uk> Jan 19, 2003
- 414 views
On Sat, 18 Jan 2003 21:37:52 +0930, noranross at optusnet.com.au wrote: >Thanks for Query The period is 5. The actual EMA is as follows. My >calculations do not get these figures or anything close. >Date EMA Close >2/1/02 3419 3440 >3/1/02 3418 3414 >4/1/02 3425.5 3443 >7/1/02 3429 3463 >8/1/02 3436 3430 >9/1/02 3431 3420 > >Ross Elliott Darwin The following code does not always get the right results either, actually, it only gets one answer right.... Maybe Yahoo Finance (or where ever you got those figures from) does not use a textbook formula, at the very least it looks to be rounding to nearest 0.5. I tried three variations, see what you think. constant ema=3D{ {"2/1/02", 3419, 3440}, {"3/1/02", 3418, 3414}, {"4/1/02", 3425.5, 3443}, {"7/1/02", 3429, 3463}, {"8/1/02", 3436, 3430}, {"9/1/02", 3431, 3420}} atom pma,csp for i =3D 2 to 6 do pma=3Dema[i-1][2] csp=3Dema[i][3] -- print ema from above table and three attempts at calculating it printf(1,"%f:%f:%f:%f\n",{ema[i][2], (1/5)*csp+(1-1/5)*pma, (2/5)*(csp-pma)+pma, (2/6)*csp+(1-2/6)*pma}) -- a failed attempt at reverse engineering the weighting: -- printf(1," %f/%f=3D%f\n",{(ema[i][2]-csp),(pma-csp), -- (ema[i][2]-csp)/(pma-csp)}) =09 end for if getc(0) then end if Pete
6. Re: More help: Exponential Moving Averages
- Posted by noranross at optusnet.com.au Jan 20, 2003
- 436 views
Thanks Euler thats seems to be the answer I wanted Ross Darwin