Comparison of current interest rates data of various countries/regions along with recent rate trend

Below is a table showing a comparison of current interest rates data of various Countries/regions along with recent interest rate trend. The current interest rate is the rate at which banks can borrow money from the central bank. The interest rates are used by central banks to shape monetary policy.


With respect to Indian Interest rate, tomorrow Reserve Bank of India (RBI) will review the interest rate. October Index of Industrial Production (IIP) figures released on Monday showed a 5.1 percent negative growth in output. Monthly Wholesale Price Index (WPI) inflation for the month of November has come in at 9.11%. The dilemma that the RBI is facing is that there are two battles to fight - inflation and growth. It is a really hard balancing act that the RBI has to do.

Download - Stock screener using Microsoft Excel based on comparative relative strength indicator method

Comparative Relative Strength study compares two stocks to show how the stocks are performing relative to each other. Comparative Relative Strength Study should not be confused with the Relative Strength Index of J. Welles Wilder Jr. It is one of the most simplest and powerful way to analyse the stock markets.

I have created a simple Excel file where I have taken four different “base dates” and compared it with current market price of stocks.  Just for ease of calculation, I have taken previous 3, 6, 9, 12 month’s prices as “base date”, to see the rate of change (momentum) during these timeframes. Therefore we can easily compare stocks across the market, to find an outperforming or underperforming stock.

You can download the relative performance rank calculation file, free from here.

Screenshot of screener below


How to update the data?
You need to follow the steps given under to update the data, to reach the desired results.

1) Update the data in "Grey cells" only, which you will find in all the sheets except the first sheet “Screener”

2) Download the end of day (EOD) data from National Stock Exchange site, for this sheet I have downloaded 3, 6, 9, 12 month’s data. Alternatively one can choose specific day’s data as base date for example a significant high (05-11-2010) or an important low (26-08-2011). It’s up to you to select different time frames. The minimum timeframe to compare,  that I have used is 3 month’s data, some people use 1 week and 1 month’s data as well to gauge short term performance.

3) Copy the data in the same sequence as I have done in different worksheets i.e. “Latest” “3 month” “6 month” “9 month” “12 month”. In case you choose different data set, keep the latest data first and oldest in the last sheet otherwise “Gain %” in first worksheet will be calculated erroneously.

4) That’s all about updating data. Once all the data is copied everything will be updated automatically in the first sheet “Screener”. Now you can apply excel filter by selecting top row. You can check the performance of stocks across different timeframes by using “Sort largest to smallest” feature. On top you will get the outperforming stocks (part of “buy only” watch list) and the bottom of the table will give you the list of underperforming stocks (part of “sell only” watch list). To further arrange the data for your convenience you can uncheck the "#N/A" when you sort the data.


A Few things to take care of:
1) Updating this stock screener is a little tricky, at least for someone who is new to Microsoft Excel. People familiar with Microsoft Excel will find it very easy. It’s just a simple copy paste task in the appropriate sheets.

2) The data that we download from NSE is not reliable at times. Old data is not split adjusted so you will get erroneous result with this screener, especially with the stock that had a split, bonus or rights issue in the past one year. If you can import data from a reliable software or a website, it will work like a charm.

3) Always verify the results of the screener with a chart. That’s what I do to verify the results of any kind of screener.

4) You need to copy the formulas in the “Screener” worksheet if new data is added in second work sheet “Latest”. This can be done easily by selecting the last row in the first worksheet “Screener” and dragging it down.


Screening and trading
This excel file will just help you to find an outperforming or underperforming stock. It tells you, where you should allocate your money. It doesn’t ensures that you will be profitable trading a particular stock. Profitability will depend on your trading system and trading discipline.

This screener essentially helps you in finding a momentum stock. Momentum trading is not easy for everyone.  It is based on “buy high, sell higher” (greater fool theory) way of trading in other words breakout trading.  One can always wait for some kind of a retracement to enter a momentum trade. But the stock chart will always give an impression that the stock has moved “significantly” from a base. Most of the stocks that you will find using this screener will be “fundamentally over valued”.

If you face any problems using this screener you can send me a mail or put your query below in the comments section (I prefer comments as it helps everyone). Hope that you find the screener useful in your trading. Good luck :)