Slideshow

Cheap Web Hosting Sites

Social Icons

'

Tuesday, November 13, 2012

How to find similar tickers in Amibroker databases ?

We often need to find tickers having  similar key worlds like 'holding', 'infra' etc in our Amibroker databases.
For this a very simple AFL code can be used.
Write your keyword (keyword INFRA being the default) in the 'Parameters' field  of the Automatic Analysis window strictly in capital letters  else you shall not get any results.


keyword=ParamStr("Keyword in Capitals","INFRA");//use Capital Letters only 
//enter the string/keyword  which you want to search in tickers


if(StrFind(Name(),keyword))

Filter=1;
AddColumn(C,"c",1.2);
AddColumn(Status("StockNum"),"no",1);


AFL displaying tickers with 'OIL' keyword
  

0 Comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...