Hello, Nulls are ignored only if they appear at the START of the array. Nulls are used by AMiBroker to start the INITIAL period of data where data are "unavailable". For example output of SIMPLE moving average from 15 periods will have the very first 15 array elements set to null.
If your data series contains Nulls INSIDE non-null series (in the middle of array), you need to use Nz() function (null-to-zero) to convert nulls to some other values. If you are going to use LLV the safe bet is to convert nulls to some high values, like this: LLV( Nz( XYZ, 1e9 ), 20 ) 1e9 is 1000000000 Best regards, Tomasz Janeczko amibroker.com ----- Original Message ----- From: "sidhartha70" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, June 27, 2008 11:40 AM Subject: [amibroker] Re: Definition of a 'tick' > Thanks Tomasz. > > While I've got you another quickie... if I'm using LLV() or HHV() with > arrays that also contain 'Nulls' as well as values, do the LLV & HHV > functions simply ignore the Null's...? > > i.e. if I have 5 Null's over the past 20 values of array XYZ, then > LLV(XYZ,20) will return the lowest value over the past 20 values of > XYZ ignorning the Null's...? > > Many Thanks > > --- In [email protected], "Tomasz Janeczko" <[EMAIL PROTECTED]> wrote: >> >> It is ANY new trade. >> >> Best regards, >> Tomasz Janeczko >> amibroker.com >> ----- Original Message ----- >> From: "sidhartha70" <[EMAIL PROTECTED]> >> To: <[email protected]> >> Sent: Friday, June 27, 2008 9:47 AM >> Subject: [amibroker] Definition of a 'tick' >> >> >> > Can someone define a 'tick' for me (as AmiBroker see them)... Is it a >> > new trade at a new price...? Or any new trade including at the same >> > price as the trade before...? >> > >> > >> > ------------------------------------ >> > >> > 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 >> > >> > >> > >> > > > > ------------------------------------ > > 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 > > >
