Are your values limited to a particular
range? If so, you could work around it by substituting some value outside the
possible range (e.g. -1 or some big number) for values of Null.
eg
z = iif(z == Null, -1, z);
AddToComposite(…..)
Then, after calling Foreign, use:
x = iif(x == -1, Null, x);
Cheers,
Nathan
From:
amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of treliff
Sent: Monday, 23 January 2006
11:59 AM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: How can
AddToComposite generate Null values?
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
SPONSORED LINKS
YAHOO! GROUPS LINKS