This is a major update to the Excel Stock Analyzer. Company financial data is now automatically downloaded from Morning Star. and stock price history from Money control. Jignesh Acharya pointed out that there are issues with the Yahoo finance stock price downloader. Here are the main features of the analyzer This is a screenshot of…

Use this Excel tool to compare risk vs. reward in Indian stock investments. The index component of the stock price analyzer published yesterday has been removed to enable comparison between two stocks. The way I see it, this comparison tool can be used for any stocks irrespective of the sector they belong (unlike financial statements).  Such…

Use this Excel sheet to analyze the risk vs. reward of investing in a stock in comparison with an index. The analysis is based on price history (adjusted for dividends, splits and bonuses) and is a spin-off the popular Mutual Fund Risk-return analyzer Two versions of the sheet are available: The ‘annual’ version in which risk…

The Excel stock analyzer now has two spreadsheets based on Warren Buffett’s approach to stock valuation. The valuation sheets have been built from the ground up  based on this article: Valuing Stocks the Warren Buffett Way The article mentions that more details can be found at: “Buffettology: The Previously Unexplained Techniques That Have Made Warren…

Use this Excel spreadsheet to analyze Indian stocks.  I am trying to build a stock analyzer with which one can comprehensively analyze a stock, obtain fair value with different methods, obtain growth rates of different metrics and visualize them graphically. This is the first version of such an attempt. The sheet calculates ‘fair value’ of…