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

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


  • To: <amibroker@xxxxxxxxxxxxxxx>
  • Subject: RE: [amibroker] Re: How can AddToComposite generate Null values?
  • From: "WALTON, Nathan" <nathan.walton@xxxxxxxxxxxxxx>
  • Date: Mon, 23 Jan 2006 11:37:40 +1100
  • Thread-topic: [amibroker] Re: How can AddToComposite generate Null values?

PureBytes Links

Trading Reference Links

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





SPONSORED LINKS
Investment management software Real estate investment software Investment property software
Software support Real estate investment analysis software Investment software


YAHOO! GROUPS LINKS