[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Metastockusers] Re: How to duplicate Exponential Moving Average in Excel



PureBytes Links

Trading Reference Links

>>Example: For a 5 day EMA:
exponent = 2/(5+1) = .33
1 - exponent = .67
EMA = .33 * Close .67 * Previous EMA<<

So if the 10 days data is 11, 22,33,44,55,66,77,88,99,111

Then how do calculate the "Previous EMA". I don't see the calulation 
you start with.

I am trying for the example to calculate a 5 day MA.

Could you walk me through the 5 days of calculations. Sorry,
buy I don't understand.

Much appreciated.

larryTAKEOUT@xxxxxxxxxx




------------------------ Yahoo! Groups Sponsor ---------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/zMEolB/TM
---------------------------------------------------------------------~->

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
     http://groups.yahoo.com/group/Metastockusers/

<*> To unsubscribe from this group, send an email to:
     Metastockusers-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/