Stocks To Keep A Close Eye On - Chapter II
- Thread starter SavantGarde
- Start date
- Tags bse buy medium term investing nse sell shares short term investing
- Status
Hello friends,
I am Anant. I am posting in this forum for the first time. Most of my posts are in Karthik Marar's threads "Experiments in Technical Analysis" and "System Implementation Excercise". For long time I have not posted in Traderji though I am regularly going through the messages in the forum.
I had asked Uma to post the updater AFL. But Uma insisted that I should do it and explain the AFL and its usage. So, Iam doing it now. The AFL itself is very simple and short.
Coming to the working of the AFL, I will explain it line by line. Experts can directly start using it as they will understand the functioning of the AFL.
Take the first two lines of the AFL:
The first line is for selecting the Date on which the stocks were purchased. The default date is 28-05-2009 as this was the date from which Uma is tracking the stock list. You can select any date you want. I will explain later how to select the date when describe how to use the AFL later. The second line is just to get the dates of the quotes in your database and convert them to a number. Ami Broker converts dates to number as follows:
Date Number = (Year - 1900) * 10000 + (Month number) * 100 + Date.
Therefore 28-05-2009 becomes 109 * 10000 + 5 * 100 + 28 = 1090528.
Now take the next 8 lines:
This portion finds out where in the databse is the data pertaining to the buying date. For this what it does is start counting from the latest data point and count backwards. For each data point it examines the date of that point and compares with the selected buying date (selected in line 1 above). If the dates match it takes that point and stops counting and goes to next part of the code. Ami broker stores the data for each stock for each day as a bar and its position in database is referred to as BarIndex. The bar numbers start with zero for the oldest data point and continue further towards the latest by increasing the number by 1 for each subsequent bar. Total number of data points available for a stock is called the BarCount.
Now the next portion of the code:
Here we are determining the buying price for the stock. As we have located the data point for the date of purchase and saved the position as BarNum, we now use the data for this BarNum to determine the price. As Savantji has explained the buying price is the previuos day's high. Therefore the program selects the high of previous day (the day before buying) as the buying price. But if on the actual day of buying the High is lower than the previous day's high then it selcts High of buying day as purchase price. If the low of buying day is higher than previous day's High then the low of buying day is taken as purchase price.
Using this purchase price the program determines the Profit/loss by subtracting the purchase price from the day's close. This is stored as PL
Now the remainder of the program code simply prepares the report:
The statement Filter = 1 defines the criterion based on which the report should be prepared. Filter = 1 selects all stocks.
the 'SetOption' statement declares that there are no default columns in the report and only the column defined in the program are reported.
The remaining 'AddColumn' statements define the column we want to see in the report, the order in which the columns are presented and the format of the column contents.
That's all about the logic of the AFL and its working internals.
The instructions for its usage are in the next post.
Regards
-Anant
P.S. : This was originally posted in the main thread http://www.traderji.com/equities/10035-stocks-keep-close-eye-341.html#post316932. As per Savantji's suggestion I am posting it here. As the attachment is already in the original post I am not allowed to attach it here again. You may please download it from the original post.
I am Anant. I am posting in this forum for the first time. Most of my posts are in Karthik Marar's threads "Experiments in Technical Analysis" and "System Implementation Excercise". For long time I have not posted in Traderji though I am regularly going through the messages in the forum.
I had asked Uma to post the updater AFL. But Uma insisted that I should do it and explain the AFL and its usage. So, Iam doing it now. The AFL itself is very simple and short.
Coming to the working of the AFL, I will explain it line by line. Experts can directly start using it as they will understand the functioning of the AFL.
Take the first two lines of the AFL:
Code:
[COLOR="Blue"]BuyDate = ParamDate("Buy Date", "28-05-2009");
Dt = DateNum();[/COLOR]Date Number = (Year - 1900) * 10000 + (Month number) * 100 + Date.
Therefore 28-05-2009 becomes 109 * 10000 + 5 * 100 + 28 = 1090528.
Now take the next 8 lines:
Code:
[COLOR="blue"]
for(i = BarCount - 1; i > 0; i--)
{
if(Dt[i] == BuyDate)
{
BarNum = i;
break;
}
else
{
BarNum = 1;
}
}[/COLOR]Now the next portion of the code:
Code:
[COLOR="blue"]BuyingPrice = IIf(H[BarNum - 1] > H[BarNum], H[BarNum], IIf(H[BarNum - 1] < L[BarNum], L[BarNum], H[BarNum - 1]));
PL = C - BuyingPrice;[/COLOR]Using this purchase price the program determines the Profit/loss by subtracting the purchase price from the day's close. This is stored as PL
Now the remainder of the program code simply prepares the report:
Code:
[COLOR="blue"]Filter = 1;
SetOption("NoDefaultColumns", True);
AddColumn(DateTime(), "Date", formatDateTime, colorDefault, colorDefault, 120);
AddTextColumn(Name(), "Symbol", 12, colorDefault, colorDefault, 120 );
AddColumn(BuyingPrice, "Buy Price", 6.2);
AddColumn(C, "Today's Close", 6.2);
AddColumn(PL, "P / L per share", 6.2, IIf(PL < 0, colorRed, IIf(PL > 0, colorGreen, colorDefault)), colorDefault, 72);
AddColumn(PL * 100 / BuyingPrice, "P / L %", 6.2, IIf(PL < 0, colorRed, IIf(PL > 0, colorGreen, colorDefault)), colorDefault, 72);[/COLOR]the 'SetOption' statement declares that there are no default columns in the report and only the column defined in the program are reported.
The remaining 'AddColumn' statements define the column we want to see in the report, the order in which the columns are presented and the format of the column contents.
That's all about the logic of the AFL and its working internals.
The instructions for its usage are in the next post.
Regards
-Anant
P.S. : This was originally posted in the main thread http://www.traderji.com/equities/10035-stocks-keep-close-eye-341.html#post316932. As per Savantji's suggestion I am posting it here. As the attachment is already in the original post I am not allowed to attach it here again. You may please download it from the original post.
Last edited:
The following message was originally posted in the main thread "Stoks to Keep a Close Eye On, page 340, post No. 3398. I am posting it here as per the suggestion of Savantji.
HOW TO USE THE UPDATER AFL
To use the updater you have to do a bit of manual job in Ami Broker. First, download the 'updater.afl' file from my previous post and save it in 'AmiBroker\Formulas\Custom' directory.
Now you need to create a watchlist to contain all the stocks which have given a trigger on a particular day. To easily identify the date of buying the stocks in the watchlist I rename the default watchlist name such that the buying date is in the name itself. Thus, for example, for the stocks bought on 28-5-2009 I name the watchlist as 'Buy20090528'. For June 1, 2009 I name the watchlist as 'Buy20090601' and so on. You can use your own convention of naming so that you have distinct watchlist for each buying day. This is necessary for the AFL to work properly.
After creating the watchlist add all the relevant symbols in it. For this Click on 'Symbol' in the main menu bar and select 'watchlist-Add selected symbol' and add the symbol to your watchlist.
Once you add all the symbols to the watchlist Click on 'Analysis' menu item on main menubar and select 'Automatic Analysis'. The Automatic Analysis Window opens. In this window you have to set some parameters.
First, click on the 'Pick' button which is on the right side top line. A file selection dialog opens. Select the 'Custom' folder (in which you have saved the 'updater.afl' file). Select the 'updater.afl' file from the file list and click 'Open'. Back in the Analysis window. Then, under 'Apply to' column select 'use filter' and click 'Define' button. In the window that opens click on 'Clear' button. Then click on dropdownlist against the 'Watchlist' label. From the list of watchlist names select the watchlist which you have created. Do nothing else and click OK.
You are now back to the "Analysis window". Under the middle column labelled 'Range' select the 'from' radio button. The circle should be clicked to mark a dot in it. Against this item there are two dates 'from' is upper and 'to' is lower. Select the same date for both. This date is the date for which you want to generate the update report. For example, if you want to get the update for June 2, 2009 select this date for both 'from' and 'to'.
Now we have to set the date of purchase. Do you remember the Buy Date parameter in the first line of the code which I explained in the previous post? It is this date parameter which the program is going to use. The default buying date is 28-05-09. If you don't select buying date then 28-05-09 will be used as buying date. To select a different buying date Click on 'Parameters' button in the Analysis window. This button is located at the bottom of the buttons just by the side of 'Close'. When you click this a dialog box appears and you can select the desired buying date. After selecting the date close the dialog box by clicking OK. You are back in the Analysis window.
You are now ready to generate the update report. Just click on the 'Explore' button. This is located on the right side just below 'edit' button. The bottom table gets filled with the updated report. That's all.
I have a word document with screen-shots of each step described above and detailed explanation. But the size is larger than permitted to post it here. I will see an alternate way so that those who are new to AmiBroker can go through it and understand. I will keep you informed about this.
For the time being, "Its time to move on. Aur Bolo."
Post your comments, queries, suggestions, crticisms etc. without hesitation.
Regards
-Anant
HOW TO USE THE UPDATER AFL
To use the updater you have to do a bit of manual job in Ami Broker. First, download the 'updater.afl' file from my previous post and save it in 'AmiBroker\Formulas\Custom' directory.
Now you need to create a watchlist to contain all the stocks which have given a trigger on a particular day. To easily identify the date of buying the stocks in the watchlist I rename the default watchlist name such that the buying date is in the name itself. Thus, for example, for the stocks bought on 28-5-2009 I name the watchlist as 'Buy20090528'. For June 1, 2009 I name the watchlist as 'Buy20090601' and so on. You can use your own convention of naming so that you have distinct watchlist for each buying day. This is necessary for the AFL to work properly.
After creating the watchlist add all the relevant symbols in it. For this Click on 'Symbol' in the main menu bar and select 'watchlist-Add selected symbol' and add the symbol to your watchlist.
Once you add all the symbols to the watchlist Click on 'Analysis' menu item on main menubar and select 'Automatic Analysis'. The Automatic Analysis Window opens. In this window you have to set some parameters.
First, click on the 'Pick' button which is on the right side top line. A file selection dialog opens. Select the 'Custom' folder (in which you have saved the 'updater.afl' file). Select the 'updater.afl' file from the file list and click 'Open'. Back in the Analysis window. Then, under 'Apply to' column select 'use filter' and click 'Define' button. In the window that opens click on 'Clear' button. Then click on dropdownlist against the 'Watchlist' label. From the list of watchlist names select the watchlist which you have created. Do nothing else and click OK.
You are now back to the "Analysis window". Under the middle column labelled 'Range' select the 'from' radio button. The circle should be clicked to mark a dot in it. Against this item there are two dates 'from' is upper and 'to' is lower. Select the same date for both. This date is the date for which you want to generate the update report. For example, if you want to get the update for June 2, 2009 select this date for both 'from' and 'to'.
Now we have to set the date of purchase. Do you remember the Buy Date parameter in the first line of the code which I explained in the previous post? It is this date parameter which the program is going to use. The default buying date is 28-05-09. If you don't select buying date then 28-05-09 will be used as buying date. To select a different buying date Click on 'Parameters' button in the Analysis window. This button is located at the bottom of the buttons just by the side of 'Close'. When you click this a dialog box appears and you can select the desired buying date. After selecting the date close the dialog box by clicking OK. You are back in the Analysis window.
You are now ready to generate the update report. Just click on the 'Explore' button. This is located on the right side just below 'edit' button. The bottom table gets filled with the updated report. That's all.
I have a word document with screen-shots of each step described above and detailed explanation. But the size is larger than permitted to post it here. I will see an alternate way so that those who are new to AmiBroker can go through it and understand. I will keep you informed about this.
For the time being, "Its time to move on. Aur Bolo."
Post your comments, queries, suggestions, crticisms etc. without hesitation.
Regards
-Anant
Last edited:
Hi friends, here is the update on triggers of 28-05-09 for today. The Excel sheet is attached.
The Excel sheet for update of triggers of 02-06-09 for today is also attached (Only one stock in it).
Today two stocks have hit and crossed the target. They are:
ABAN
GVKPIL
AXISBANK which hit SL yesterday is removed from the list.
Savantji, next targets and SL for the above two stocks awaited.
_____
In the last five trading days (28-5-09 to 03-06-09):
17 out of 54 triggers recommended by Savantji have gone up by more than 10%. Out of these nine have gone up by more than 20%. The Highest gainer is WELGUJ which is over 38% up.
______
Regards
*** Uma ***
The Excel sheet for update of triggers of 02-06-09 for today is also attached (Only one stock in it).
Today two stocks have hit and crossed the target. They are:
ABAN
GVKPIL
AXISBANK which hit SL yesterday is removed from the list.
Savantji, next targets and SL for the above two stocks awaited.
_____
In the last five trading days (28-5-09 to 03-06-09):
17 out of 54 triggers recommended by Savantji have gone up by more than 10%. Out of these nine have gone up by more than 20%. The Highest gainer is WELGUJ which is over 38% up.
______
Regards
*** Uma ***
Last edited:
Hi friends,
The update for today w.r.t. the triggers of 28-05-09 is attached as an excel sheet. Today seven stocks have hit Targets. They are:
1. BAJAJHIND (Target 2 hit)
2. CHAMBLFERT
3. IFCI
4. IVRCLINFRA
5. RELCAPITAL
6.RNRL
7. TTML
The update for second list (triggers of 2-6-09) is also attached.
Fresh targets for the above 7 stocks awaited.
Regards
*** Uma ***
The update for today w.r.t. the triggers of 28-05-09 is attached as an excel sheet. Today seven stocks have hit Targets. They are:
1. BAJAJHIND (Target 2 hit)
2. CHAMBLFERT
3. IFCI
4. IVRCLINFRA
5. RELCAPITAL
6.RNRL
7. TTML
The update for second list (triggers of 2-6-09) is also attached.
Fresh targets for the above 7 stocks awaited.
Regards
*** Uma ***
Last edited:
- Status
Similar threads
-
to keep record of stocks i will be following- Started by Gandhar.
- Replies: 5
-
-
-
-
Is it ok to buy Stocks keeping the current market scenarios in mind or should I wait
- Started by greg4u
- Replies: 10