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

Re: [amibroker] Re: Find symbols with no bars



PureBytes Links

Trading Reference Links

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

*********************************




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___