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

Re: [amibroker] Standard Deviation calculation question



PureBytes Links

Trading Reference Links

Hello,

StDev function in AmiBroker works as STDEVP in Excel (not STDEV).
Read the Excel help file to learn about difference between STDEVP  and STDEV.

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "the_chairmann" <jhart_1972@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Sunday, December 14, 2003 3:07 PM
Subject: [amibroker] Standard Deviation calculation question


> I'm experimenting with a standard deviation exploration but I'm 
> getting discrepencies in the resulting answer.  Take Alcoa for 
> example.  I get a 5 day Sd of 67 in Amibroker but a SD of 65 in 
> Excel.  I tried this over 5 & 10 day periods for other stocks and 
> got conflicting answers as well.  Is it because AB is a "moving" 
> standard deviation?  
> 
> >From the AB help file:  Calculates moving standard deviation of the 
> ARRAY over periods bars  
> 
> 
> 
> Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 
> 
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 
> 
> 
> 

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->

Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

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