Here is an Excel stock screener to scan & filter Indian stocks with multiple criteria. Cap-wise screening & sector-wise screening possible. It gets data from Value Research and allows the user to screen capitalization-wise and sector-wise.

I have always wanted to build a stock screener and hence this sheet. I am well aware that they are pretty good online screeners available. What is being offered is a choice, and I am confident that the Excel screener will evolve into something at least useful to a small group of users, if not as a unique tool. I seek your help in evaluating this sheet and in making it better.

read more


Here is a free stock analysis spreadsheet that can automatically process balance sheet data from screener.in. This is the 12th edition of the freefincal automated stock analyzer.

The previous versions used MorningStar.in financial data.  However, since I received requests to make a spreadsheet that can process screener.in data, I thought I will give it a try. I would say that about 80% of the features of past versions can be found here.

read more


The 11th version of the freefincal automated stock analyzer now has an easy-to-understand graphical analysis of the factors that are used to calculate the Altman Z-score.  The Z-score is a measure of financial health and in particular, how close the business is to bankruptcy.

If this is your first encounter with the freefincal stock analyzer, you can scroll down to have a look at its full features.

read more


The 10th version of the freefincal automated stock analyzer includes an easy-to-understand graphical analysis of the factors that drive return on equity (ROE) using the five-step Dupont Analysis.

Return on equity is defined as

ROE = Net income/shareholders equity.

It is the profit for each unit of shareholders equity or the earning power of the company. If there is a gradual increase or decrease in ROE, it is beneficial to dig deeper and find out the reasons behind the trend.

read more


Dear reader, I write this to make two requests: (a) help beta test an Excel sheet that automatically downloads standalone or consolidated financials data (in new format or old) from MoneyControl, and (b) provide your feedback on how to improve the freefincal stock analysis spreadsheet.

MoneyControl Financials Downloader

The aim behind making this sheet is to integrate it with the stock analyzer and derive valuation inputs from it. However, before doing that it would be great if a few users can test the sheet with your fav. stocks and check if it is working fine.

read more