[amibroker] Re: Exploration to find "Empty" values

["Jim" <bankedout@xxxxxxxxxxxxx>]

Jayson,

Thank you, that works too.  I used this:

Filter = BarIndex()<102;

AddColumn( C, "Close", 1.3);
AddColumn( BarCount, "BarCount", 1.0);
AddColumn (ROC(C,104),"2yr%chg");
AddColumn (BarIndex(),"BarIndex", 1.0); 

Curiously (to me) BarIndex and BarCount give different values.  
BarIndex is always one less than BarCount.  I'll try to figure out 
which one I like better.  I plan to add this filter criteria to 
another exploration I am working on.  Previously that one excluded 
IPOs etc. from the results, but I want them in if certain conditions 
exist.  These ideas for indentifying "IPO" type stocks will help me 
to accomplish my goals.

Thanks again,

Jim
---------------------------------------------------------------------
--- In amibroker@xxxxxxxxxxxxxxx, "Jayson" <jcasavant@xxxx> wrote:
> How about barindex()   simple search for stocks whose barindex() 
is greater
> than what ever time frame you want...
> 
> x=barindex()>200;
> 
> gives only stocks with 200 or more bars of data....
> 
> Regards,
> Jayson
> -----Original Message-----
> From: Jim [mailto:bankedout@x...]
> Sent: Friday, January 16, 2004 3:22 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re: Exploration to find "Empty" values
> 
> 
> "> If they haven't been trading you should be able to filter on
> Close.
> > Either way, check out the IsNull function."
> 
> I want them to be trading.  I'm looking for stocks with less than 2
> years of price history.  Initial Public Offerings etc.
> 
> I tried this:
> 
> Filter= ROC(C,102)=IsNull;
> AddColumn (ROC(C,104),"2yr%chg");
> 
> And then tried pushing Explore.  Amibroker does not like this.  It
> points to right before the = sign and tells me I have a syntax
> error.  I'm trying to "tell" Amibroker that I want those stocks
> which have ROC(C,102) value of "nothing" (not ZERO).
> 
> Any ideas?
> 
> Jim
> -------------------------------------------------------------------
--
> --- In amibroker@xxxxxxxxxxxxxxx, "sloughbridge" 
<sloughbridge@xxxx>
> wrote:
> > --- In amibroker@xxxxxxxxxxxxxxx, "Jim" <bankedout@xxxx> wrote:
> > > Hello,
> > >
> > > I am wondering how to do something with an exploration.
> > >
> > > If I Filter my database for Close > Zero, it will return all of
> my
> > > stocks.
> > >
> > > If I then Add a Column which displays the Rate of Change for 
the
> > > Close,102 weeks  This displays mostly stocks with a number
> value.
> > > Either positive or negative, depending on how their price has
> > > changed over the past 2 years.
> > >
> > > But, if I sort by this ROC 2 years column, there are quite a 
few
> > > results where there is no value.  I'm guessing these are issues
> > > which haven't been trading for 2 years.
> > >
> > > How do I screen specifically for ROC(C,120)="No Value"
> > >
> > > What do I put in place of "No Value"?
> >
> > If they haven't been trading you should be able to filter on
> Close.
> > Either way, check out the IsNull function.
> 
> 
> 
> Send BUG REPORTS to bugs@xxxx
> Send SUGGESTIONS to suggest@xxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at:
> http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> 
> 
> 
> -------------------------------------------------------------------
---------
> ----
> Yahoo! Groups Links
> 
>   a.. To visit your group on the web, go to:
>   http://groups.yahoo.com/group/amibroker/
> 
>   b.. To unsubscribe from this group, send an email to:
>   amibroker-unsubscribe@xxxxxxxxxxxxxxx
> 
>   c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of 
Service.


Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html 

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->

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/