bhavana said:
Namaste Traderji and all forum members,
How to calculate Absolute strength index or relative strength ranking?
Is there any specific formula?
Please help me.
Here is an explanation of how I do it. I should warn you that this type of relative strength ranking is very simplistic but still finds excellent performers. To begin with you will need historical prices of all stocks. Basically what I am trying to do here is to rank each stock on a 1-100 scale based on performance vs all the stocks (100 being the top performer, meaning it has out performed all other stocks in the list)
Here are the steps:
1. I first generate a spreadsheet from the database with the following info:
SYMBOL, CLOSE 60 DAYS AGO, LATEST CLOSE, % CHANGE
NOTE: The close 60 days ago is variable, if you want you can have "Close 1 yr ago".
2. I then create another column where I generate the rank for each stock using Excel or OpenOffice's PERCENTRANK function. The exact formula I use is this (in OpenOffice): FLOOR(PERCENTRANK($D$2:$D$813;D2) * 100;1). Where $D$2:$D$813 is the range for % changes.
That is it. The above procedure will rank all the stocks based on 60 days performance. I am not sure if this is clear. If anyone wants the OpenOffice spreadsheet I can email it to them. I am attaching the CSV file I generated (I have removed some data from the end of the file because I could not upload it - file size limit). The data & symbols in the file are from NSE's website that I have collected & stored in a database.
More sophisticated relative strength ranking takes into account performance over various periods (last month's perf, last 60 days, last 6 months, last 1 yr) and gives weighting to recent data etc. The combinations are many, the idea in this case is to find consistent performers.
--SwingTrader