NSE Indices - P/E, P/B & Div. Yield values

by QuantShare, 4967 days ago

Share |

This object downloads fundamental data/ratios for eleven Indian indices listed on the National Stock Exchange (NSE). The indices are: S&P CNX NIFTY, CNX NIFTY JUNIOR, CNX IT, BANK NIFTY, CNX MIDCAP, CNX 100, CNX PSU BANK, NIFTY MIDCAP 50, S&P CNX 500, S&P CNX NIFTY SHARIAH.

It saves the data in a database named "indices_fund" and in the following fields:
P/E - Price/Earnings: Also called PER, this ratio is the best-known investment valuation indicator. It is simply the stock price divided by the earnings per share or EPS. A high value indicates that either the market is overvalued or stocks that constitute the index have high growth potential.
P/B - Price/Bookvalue: Also called price-equity ratio, the Price-To-Book ratio is calculated by taking the stock price and dividing it by the total assets minus intangible assets and liabilities. A low value indicates that either the market is undervalued or there is something fundamentally wrong with several stocks listed on the index.
Div_Yield - Dividend Yield: This is the DPS - Dividend per share - divided by the current share price of the stock.

The object is very easy to use. You just open the downloader, select a start and end date, start the downloading process and then access the data using the "GetData" function. To get for example Price to Book historical data:
pricetobook = GetData("indices_fund", "p/b", LastData);
This formula retuns data when one of the above indices is selected.

To get the time series when selecting any other ticker symbol, you can use the following formula to display "CNX MIDCAP" Price to Earnings data.
pricetobook = GetDataExtern("indices_fund", "p/e", 0, "^CNX_MIDCAP");

You may use NSE Nifty - S&P CNX Nifty to download historical data for the above NSE indices.