//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js(adsbygoogle = window.adsbygoogle || []).push({});

Use this Excel sheet to automatically determine the valuation of 21 NSE indices with long-term averages of PE, PB and Div Yield ratios along with ROE and rolling one-year EPS growth rate and dual moving averages. This is a major update to the Nifty PE Valuation Analysis spreadsheet where I have integrated Pranav Date's NSE historical price and ratios downloader.

Before we look at the features of the sheet, two quick announcements:

read more

2

Pranav Date, who played a key role in the development of monthly returns, consistency and capture ratios, has now developed a fantastic one stop shop solution for downloading Nifty historical data: the price data from 59 NSE indices, the total returns (dividends reinvested) Nifty 50 index, PE, PB and dividend yield ratios  for 51 indices and the volatility index: India VIX.

Before we look at the features of the sheet, two quick announcements:

read more

1

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 included any valuation methods. Only a few key graphs from the balance sheet data are available. The sheet is free for personal use only and can be modified at will for this purpose. 

read more

2

Here are the latest Nifty Valuation charts created with the Nifty Valuation Analyzer: PE, PE, Div Yield, ROE, EPS Growth. These charts are provided for information only. No investment suggestions are provided. I only use them sparingly for education and not for investments. Goal-based systematic investment continues regardless of current developments.

Simple Moving Averages: 150 and 363 days

Dual moving average analyser for hurricane warnings shows a bearish trend. But the index can move either way. Don't take these charts too seriously. Details here:  Moving Average Market Level Indicator

read more

30

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