Evaluating stocks with TCI Rapid X-Ray

So many stocks…So little time

Investing is largely a process of elimination, and the more efficiently you can eliminate investments that do not check the boxes on your investing checklist, the more time you can spend diving deep into the ones that do.

For equity investors in the Indian Stock Market, there are about 1,500 listed stocks on the NSE and nearly 5,000 on the BSE, to choose from when making investment decisions. Sure, there are ways to whittle that list down using filters of market capitalisation and sectors, but you’re still left with a few hundred potential investments to sift through.

Some investment-related sites / blogs offer Microsoft excel templates in which one can download and manually input relevant information from sources like annual reports or moneycontrol.com. These sheets have formulae that, based on the information manually copy-pasted, show indicators that aid in judging the investment-worthiness of the stock. One such Indian investment site offers such a stock evaluation template for a fee, the accompanying instruction video shows it takes two hours to fill in all the information. That’s for one stock!

Even if you do manage to stay focused to do the copy-pasting without errors, best of luck trying to resist the temptation to go ahead and buy a stock simply because of the time that’s gone into getting the numbers in one place.

So, I was excited when I came across screener.in and it’s ‘export to excel’ functionality with ten years of financial statement information. I used it to make the first version of the TCI Rapid X-Ray. I received a lot of emails asking for the template plus I noticed some tweaks that were needed in the template, which needed a revision. This post provides easy download access to the new TCI Rapid X-Ray to save your time when evaluating stocks.

Using the new TCI Rapid X-Ray Premium Template

Step 1: Download the TCI Rapid X-Ray

Step 2: Using the template and what’s new

The point of the TCI Rapid Stock XRay is to automate the task of pulling 10 years of financial information and to be able to quickly scan what the numbers say.

Getting up and running

Navigate to screener.in

The Calm Investor | How to use screener

Click ‘Login’ on the upper right corner

The Calm Investor | Using screener India

Register or Login (if you have previously registered). Login in. You see a screen similar to the one below.

The Calm Investor | Using TCI Rapid XRay to evaluate Indian Stocks

Navigate to https://www.screener.in/excel/

The Calm Investor | TCI Rapid XRay

Click ‘Browse’, navigate to the folder where you downloaded the TCI Rapid XRay Premium file and select. Click Upload. If successful, the browser navigates to the main page. You are all set.

Enter the name of a company you would like to examine in the search bar, select from the options presented.The Calm Investor

screener shows the main page for the selected company. In this case, for Bajaj Auto Ltd

The Calm Investor

Click the blue ‘Export to Excel’ button on the top right of the page. Save and open the excel file downloaded as a result.

In addition to the default screener.in tabs, you will see an additional ‘TCI Rapid XRay’ tab. This tab summarises key metrics to quickly decide whether the company matches your investment strategy (high sales growth / high profitability / high ROCE / declining Debt-Equity…) with colour coded cells and in-cell graphs to represent trends.

The Calm Investor | Rapid XRay Premium Features

Other Metrics summarised:

  • Three Basic valuation sanity checks: Basic CFO-derived valuation, Average Free-Cash-Flow in perpetuity model and Discounted Cash Flow valuation range
  • Earnings per Share growth and Price Growth over the last 10 years
  • Cash Flow from Operations (CFO), Free-Cash-Flow (FCF) and Net Profit compared over the last 10 years

Note that this is the just the jump-off point in evaluating a stock. If the basic financial metrics look healthy and the stock doesn’t look like it’s already priced assuming it’s the next Apple, then the real work of investment evaluation follows. Whether you think the company will prosper and grow profitably over the next 5-10 years.


Click here to download the TCI Rapid XRay Premium

[download id=”7623″]

Note: This template is available on an as-is basis and is not meant to recommend any stocks to buy or sell. Please do your own diligence before making any investment decisions.

14 thoughts on “Evaluating stocks with TCI Rapid X-Ray

  • August 28, 2017 at 11:36 pm

    Great thing going here. I had to calculate this about any company I was serious in – and not in this detail with graphs and all.

  • August 31, 2017 at 5:59 pm

    Thanks for the template…It is really narrowing down the options to choose the stock

  • September 2, 2017 at 11:41 am

    Thanks! Glad you’re finding it useful.

  • September 12, 2017 at 3:03 pm

    This is really a great tool. It speeds up the stock analysis process. Thanks for sharing.

  • September 13, 2017 at 7:23 am

    You’re welcome Kamlesh

  • November 5, 2017 at 3:09 pm

    Thanks a lot for the template.. and I receive 500 error when I try the export to excel feature.. Here are the steps followed.

    1. Upload excel file
    2. open a company and click export to excel.

    now I’m receiving 500 server error.

    Error 500: Whoops! Something has broken down.

    I tried with custom excel and it worked fine. Kindly advice.

  • November 5, 2017 at 5:40 pm

    Will check this out and get back to you.

  • November 10, 2017 at 5:12 pm

    Thanks for the template. Though couple of formula errors grabbed my attention. For eg: the inventory and receivable days formula has linking error. Should have been linked to the Annual sales instead of the Quarterly sales figure. Profitability ratios wherein the Change in inventory has been considered as a part of expenses hence reducing the Profitability ratios than what it should be. But overall quite impressive in helping us find such a solution to save hell lot of time. Thanks once again

  • November 10, 2017 at 7:37 pm

    Thanks Manan for pointing out the error. Easy to miss these. Will fix quickly.

  • Pingback: Fundamental Analysis Tools for Investors in India | The Calm Investor

  • July 1, 2020 at 10:28 am

    How can I download the free live sample of TCI Rapid X-Ray Premium Template?

  • August 1, 2021 at 8:15 pm

    how to get free version of tci-rapid-xray-premium as i am not able to download this as there is no link given to download the same.

  • August 3, 2021 at 8:01 pm

    i want to download this sheet can u share the link

Leave a Reply

Your email address will not be published. Required fields are marked *