Hello,
You should not have zero as closing price when you use regular import
funciton
because they don't allow that.
Maybe you simply don't have 200 bars of data for certain symbols.
Or value passed to log function is equal to 1 (no change in price).
Log( 1 ) is equal zero.
Best regards,
Tomasz Janeczko
amibroker.com
On 2010-03-26 15:36, i cs wrote:
That was quick - thanks herman.
The problem was a divide by zero!
Why this got past me was that the zeroes in the closing price seemed
to occur well before number of bars required for the actual calculation .
I will look up stdev in the group anyway, sometimes it gets a bit
frustrating looking through a couple of hundred posts and not findind
the answer!
Live and learn!
Thanks again
RZ
------------------------------------------------------------------------
*From:* Herman <[email protected]>
*To:* ics4mer <[email protected]>
*Sent:* Sat, 27 March, 2010 1:31:17 AM
*Subject:* Re: [amibroker] problems with stdev?
This was discussed some time back and has a logical explanation. Do a
search for StDev(
herman
> Hi,
> Getting a 0.0000 during explorations with stdev.
> Not all stocks, just some.
> However, using the same code, I get successful plots.
> Can't find anything in the manual to indicate why this is
> happening, and there seems to be no odd data in the symbol which
might cause it to go astray.
> Here is the code, with some debug statements:
> VSPR = (C/Ref(C,-1) ); //works OK
> VSLog = log(C/Ref(C, -1)); // works OK
> VolStd = StDev(log(C/ Ref(C,-1) ),200); // Fails, gives 0.000000
> Anyone have similar probs?
> TIA
> RZ
> ------------ --------- --------- ------
> **** IMPORTANT PLEASE READ ****
> This group is for the discussion between users only.
> This is *NOT* technical support channel.
> TO GET TECHNICAL SUPPORT send an e-mail directly to
> SUPPORT {at} amibroker.com
> TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
> http://www.amibroke r.com/feedback/ <http://www.amibroker.com/feedback/>
> (submissions sent via other channels won't be considered)
> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> http://www.amibroke r.com/devlog/ <http://www.amibroker.com/devlog/>
> Yahoo! Groups Links