Title: Re: [amibroker] Re: Find symbols with no bars
You need to decide how many/few bars you want to accept. To get an idea what you are dealing with Explore your database with an exploration like this:
DT = DateTime();
DN = DateNum();
NumBars = Cum(V>0);
NewDay = DN != Ref(DN,-1);
FillBars = Cum(V==0 AND Status("BarInRange"));
SN = Status("StockNum");
NumDays = Cum(Newday);
Filter = Status("LastBarInTest");
SetOption("NoDefaultColumns",False);
AddTextColumn(MarketID(1),"Market",1.0);
AddTextColumn(SectorID(1),"Sector",1.0);
AddTextColumn(IndustryID(1),"Industry",1.0);
AddTextColumn(FullName(),"FullName",1.0);
AddColumn(C,"$Close",1.2,1,2,60);
AddColumn(MA(V,60),"MA(V,60)",1.0,1,2,60);
AddColumn(FillBars,"NoData",1.0,1,2,60);
AddColumn(SN,"#",1.0,1,2,50);
AddColumn(NumBars,"#B",1.0,1,2,50);
AddColumn(Numdays,"#D",1.0,1,2,50);
AddColumn(DT[0],"From",formatDateTime,1,2,150);
AddColumn(DT[BarCount-1],"To",formatDateTime,1,2,150);
Wednesday, February 4, 2009, 7:39:20 PM, you wrote:
> hmmm... neither of those gave anything different then Filter =1, which
> is all stocks with bars, not the ones without.
> ------------------------------------
> **** IMPORTANT ****
> This group is for the discussion between users only.
> This is *NOT* technical support channel.
> *********************
> TO GET TECHNICAL 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
> <*> To visit your group on the web, go to:
> http://groups.yahoo.com/group/amibroker/
> <*> Your email settings:
> Individual Email | Traditional
> <*> To change settings online go to:
> http://groups.yahoo.com/group/amibroker/join
> (Yahoo! ID required)
> <*> To change settings via email:
> mailto:amibroker-digest@xxxxxxxxxxxxxxx
> mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
> <*> 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/
__._,_.___
**** IMPORTANT ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
*********************
TO GET TECHNICAL 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
*********************************
__,_._,___
|