Use this Excel sheet to automatically download stock financial data from Moneycontrol for analysis. This sheet was prepared many months ago, but I did not come around to complete it. Regular readers may be aware that automated stock analyzers using screener.in and morningstar.in are available with multiple valuation methods. In the current edition, I have not…

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…

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….

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…

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….

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…

Here is a step by step guide on how to use a stock screener and identify financially sound and good businesses.  This is a guest post by Indraneal Balasubramanian, a passionate equity enthusiast who blogs at cognicrafting. Indraneal needs no introduction to Facebook group Asan Ideas for Wealth regulars. The following can be thought as a sequel to Krishna Kishore’s…

Use this free Excel tool to download historical data from 43 indices from the BSE and NSE. List of Indices available:  BSE Sensex, NSE Nifty, BSE Small Cap, BSE Mid cap, BSE 100, BSE 200, BSE 500, BSE Bankex, BSE Capital Goods, BSE Oil and Gas, BSE Metals, BSE IT, BSE Auto, BSE Healthcare, BSE…

Version 9 of the automated stock analysis sheet now  projects expected earnings per share and calculates the forward PE. Some bugs have been corrected and minor improvements made. List of features of the freefincal stock analyzer The automated stock analysis sheet pulls financials from morningstar and analyzes them pulls adjusted stock price history from money control, and…

The  automated stock analysis Excel sheet (version 8)  now calculates thePiotroski Score for the last 9 financial years for Indian stocks. In January 2002, Prof. Joseph Piotroski wrote a paper titled, Value Investing: The Use of Historical Financial Statement Information to Separate Winners from Losers which detailed a method of buying stocks based on 9 balance sheet…

Here is a Stock SIP Calculator for Indian stocks. It can be used to determine returns (XIRR) and monthly variation in returns since January 2000. ‘Can one do a SIP in stocks?” is a question many youngsters often ask. The reason they ask is obvious. The amount of capital at their disposal is small and they…

In the 7th version of the automated stock analyzer, two more valuation metrics have been added: The Graham Formula and the Graham Number. Bugs and suggestions made by users have been corrected/incorporated in this edition. The automated stock analyzer pulls annual (standalone/consolidated) and quarterly financials from Value Research online pulls financials from morningstar and analyzes…

The automated stock analyzer now pulls annual (standalone/consolidated) and quarterly financials from Value Research online. It also pulls financials from morningstar, adjusted stock price from money control and calculates intrinsic value five different ways! Note: If you are not familiar with valuation techniques, I suggest that you download the tool, and read the references provided…

  Automatically analyze stocks and determine their intrinsic value or fair value with this Excel sheet. The analyzer pulls financials from morningstar, adjusted stock price from money control and calculates intrinsic value five different ways! 1) Price Multiple Model 2) Sustainable Growth Rate 3) Book Value Growth Rate (Buffett’s approach to valuation) 4) Discounted Cash Flow (DCF) Thanks…

The automated stock analyzer now includes discounted cash flow valuation. The analyzer now has four methods: 1) Price Multiple Model 2) Sustainable Growth Rate 3) Book Value Growth Rate 4) Discounted Cash Flow First, I would like address a few issues faced by users while downloading stock price from MoneyControl. Let me assure you that…