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

Re: [Metastockusers] Re: How to duplicate Exponential Moving Averagein Excel



PureBytes Links

Trading Reference Links

lseldin wrote:

>>>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 Links
>
>
>
> 
>
>
>  
>



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
 

Attachment:
EMA.xls

Attachment: Description: "Description: MS-Excel spreadsheet"