|
PureBytes Links
Trading Reference Links
|
try this
Var = whatever:
Var = iif( Var==0,null,Var);
--
Cheers
Graham
AB-Write >< Professional AFL Writing Service
Yes, I write AFL code to your requirements
http://www.aflwriting.com
On 16/11/06, dchang813 <dchang813@xxxxxxxxx> wrote:
>
> Hi--
>
> I'm looking for the converse of the NZ() function--in other words, I'd
> like to turn all zeroes in an array to Null.
>
> For instance, given an array of:
>
> 1 0 0 1 1 0 1
>
> I'd like to turn it into:
>
> 1 Null Null 1 1 Null 1
>
> Why? I'd like to be able to create a "mask" array that can be used to
> cut holes in an otherwise continuous indicator.
>
> So, say the indicator's array is:
>
> 33.54 33.51 33.50 33.53 33.49 33.40 33.30
>
> Doing a bitwise & on this array and the mask I gave above would produce:
>
> 33.54 Null Null 33.53 33.49 Null 33.30
>
> The plot would then show line segments connecting these points (or so
> I hope).
>
> Can this be done without looping through the mask array to replace the
> zeros with Nulls?
>
> Thanks,
> Dennis.
>
>
>
>
>
>
>
> 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
>
>
>
>
>
Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.11/542 - Release Date: 11/20/2006
|