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

Re: [amibroker] Re: How can AddToComposite generate Null values?



PureBytes Links

Trading Reference Links

Perthaps a negative value instead of the zero, of course depends if
you get -ve normally
Or an extrordinary large negative number, like -10000000
Then substitute when you are reading te composite


--
Cheers
Graham
AB-Write >< Professional AFL Writing Service
Yes, I write AFL code to your requirements
http://e-wire.net.au/~eb_kavan/ab_write.htm


On 1/23/06, treliff <treliff@xxxxxxxxx> wrote:
> Good call Nathan, but nope that won't do it for me. Point is that
> there are "genuine" zero values in the resulting ATC ticker that I
> would NOT want converted to Null (the example I gave was just a dummy
> to illustrate the challenge).
>
> --- In amibroker@xxxxxxxxxxxxxxx, "WALTON, Nathan"
> <nathan.walton@xxxx> wrote:
> >
> > After calling Foreign:
> >
> > eg
> >
> >
> >
> > x = Foreign("~nulltest", "O");
> >
> >
> >
> > Can you simply use:
> >
> >
> >
> > x = iif(x == 0, Null, x);
> >
> >
> >
> > This will substitute Null values for '0's
> >
> > ________________________________
> >
> > From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx]
> On
> > Behalf Of treliff
> > Sent: Monday, 23 January 2006 11:32 AM
> > To: amibroker@xxxxxxxxxxxxxxx
> > Subject: [amibroker] Re: How can AddToComposite generate Null
> values?
> >
> >
> >
> > Thanks Graham, but that doesn't work. When I use 0 (zero) then ATC
> > creates zero value as expected, but I need it to create empty
> (Null)
> > value.
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, Graham <kavemanperth@xxxx> wrote:
> > >
> > > use 0 instead of null
> > >
> > >
> > > --
> > > Cheers
> > > Graham
> > > AB-Write >< Professional AFL Writing Service
> > > Yes, I write AFL code to your requirements
> > > http://e-wire.net.au/~eb_kavan/ab_write.htm
> > >
> > >
> > > On 1/23/06, treliff <treliff@xxxx> wrote:
> > > > When I run a dummy-scan like
> > > >
> > > > AddToComposite( IIf( DayOfWeek() == 5, Null,
> > 1) , "~nulltest" , "X");
> > > >
> > > > this results in Friday's values zero (instead of Null or
> > {empty} ).
> > > >
> > > > Point is I need my ATC to generate values that will be
> recognized
> > by
> > > > Foreign function as "fixup candidates".
> > > >
> > > > I have tried instead
> > > >
> > > > AddToComposite( IIf( DayOfWeek() == 5, 1/0,
> > 1) , "~nulltest" , "X");
> > > >
> > > > and this generates Infiniti values:
> > > >
> > > > 1.#INF
> > > >
> > > > however it seems these are not considered for Foreign fixup.
> > > >
> > > > Any advice will be gratefully received. TIA.
> > > >
> > > > -treliff
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > 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 other support material please check also:
> > > > http://www.amibroker.com/support.html
> > > >
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> >
> >
> >
> >
> > 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 other support material please check also:
> > http://www.amibroker.com/support.html
> >
> >
> >
> >
> >
> >
> > ________________________________
> >
> > YAHOO! GROUPS LINKS
> >
> >
> >
> > *      Visit your group "amibroker
> > <http://groups.yahoo.com/group/amibroker> " on the web.
> >
> > *      To unsubscribe from this group, send an email to:
> >        amibroker-unsubscribe@xxxxxxxxxxxxxxx
> > <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
> >
> > *      Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service <http://docs.yahoo.com/info/terms/> .
> >
> >
> >
> > ________________________________
> >
>
>
>
>
>
>
>
>
> 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 other support material please check also:
> http://www.amibroker.com/support.html
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


------------------------ Yahoo! Groups Sponsor --------------------~--> 
Try Online Currency Trading with GFT. Free 50K Demo. Trade 
24 Hours. Commission-Free. 
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/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 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/

<*> 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/