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

Re: [amibroker] Strange Numbers



PureBytes Links

Trading Reference Links

That did it.
They all stop calculating on Dec 26, 2003.
The data has OHLC all the same and 0 volume.
When I delete this day's data - the problem is fixed.

Question,- how do I delete data for this day for all
stocks in my Canadian Database using AFL?  One at a
time would be a pain
Rick


--- Graham <kavemanperth@xxxxxxxxx> wrote:

> do an exploration for each part of the calculation
> to see what is
> happening. Then you should know what part is
> screwing the calculation
> ie columns for C-L,H-C,H-L,V,sum(V,21)
> 
> -- 
> Cheers
> Graham
> AB-Write >< Professional AFL Writing Service
> Yes, I write AFL code to your requirements
> http://www.aflwriting.com
> 
> 
> On 14/03/07, ricko8294_98 <ricko@xxxxxxxxxx> wrote:
> > What does this mean?
> > I am working with the Chaiken Money Flow (CMF)
> indicator from the AB
> > Library.  The code is
> >
> > CMF = sum(((( C-L )-( H-C )) / ( H-L ))*V, 21 ) /
> sum(V,21);
> >
> > For some stocks CMF gives an {EMPTY} value even
> though there are
> > datapoints for each array.
> >
> > Also the numerator gives {NAN} (not a number
> right) across the whole
> > range of the data.
> >
> > If I change the denominator to (NZ(H-L)))*V,21 - I
> get all zeros.
> > Same thing if I change the numerator to
> >  Nz(sum(((( C-L )-( H-C )) / ( H-L ))*V, 21 )).
> >
> > What is more confusing, if I compare a stock
> listed both on the
> > Canadian and US exchanges, I get CMF values for
> the US, but not the
> > Canadian exchange (TD vs TD.TO).
> >
> > If anybody can shed a light here it would be
> appreciated
> > Thanks
> > Rik
> >
> >
> >
> >
> >
> > Please note that this group is for discussion
> between users only.
> >
> > To get support from AmiBroker please send an
> e-mail directly to
> > SUPPORT {at} amibroker.com
> >
> > For NEW RELEASE ANNOUNCEMENTS and other news
> always check DEVLOG:
> > http://www.amibroker.com/devlog/
> >
> > For other support material please check also:
> > http://www.amibroker.com/support.html
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> 


Rick Osborn & Associates
885 Sorrento Ave.
Oshawa, Ontario L1J 6V6
(905) 728-8543  fax 728-0815



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Transfer from your equities account.  
Receive up to $1,000 from GFT. Click here to learn more.
http://us.click.yahoo.com/aZttyC/X_xQAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
 
Yahoo! Groups Links

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

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

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

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