Now here is a simple question. You have the NSE EOD database for amibroker.( If not you can download the NSE EOD database – updated upto 28 July 2010) and the stocks in nse is more than 1300 symbols.
Now all you need to do is you have to find the list of stocks that had recently made 5/20 EMA crossover from the bunch of NSE Stock pack and also you have to scan the stocks with price value greater than Rs50. And also print the values of 5EMA and 20 EMA values for those corresponding stocks.
An exploration makes it easy to filter stocks or get data in a specified format. And now inorder to filter the stocks based on 5/20 EMA crossover from database and also to filter the stocks only above Rs 50 use the filter function as shown below
Filter=Cross(EMA(C,5),EMA(C,20)) AND C>50;
cross function is used to identify the crossovers and C in the above notation denotes the Close price.
And inorder to print the values of 5EMA and 20 EMA values for those corresponding stocks use the funtion AddColumn as shown below
Now save the simple 5-20 EMA scanner as a .afl file under the directory c:program filesamibrokerformulascustomSimple 5-20 EMA scanner.afl
Goto->Amibroker->Analysis->Automatic Analysis and select All Symbols and n=1. The value of n is choose as one just to find out the recent 5/20 EMA crossover among the list of nse stocks as shown below .Also select the Simple 5-20 EMA scanner formula afl file from the c:program filesamibrokerformulascustom path
Select Explore button to start filtering the stock database and the results of EMA 5/20 crossover will be published along with the technical data 5EMA and 20 EMA values.
Now the list of Stocks the meets the criteria i.e EMA(5,13) bullish crossover and also the stocks should also be above Rs 50 simply arrives as shown above
And we will work out some of the famous stock scanning methods in upcoming sessions step by step.