Skip to content

Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield

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:

  1. V Ramesh, CEO of MF Utility will be joining Ashal and me at the Pune Investor Meet on Feb 26th. You can register via here. Only a few seats left.
  2. My book with PV Subramanyam, You Can Be Rich Too With Goal Based Investing is now available at a 30% discount of Rs. 279/- from amazon.

When Pranav first showed me the sheet, I was blown away by its features. Here are a few screenshots:

The inputs sheet

The index ratios: PE, PB and Div Yiled

The index data

Nifty 50 Total Returns Data

The India Volatility Index. Read more: India VIX: The Stock Market Volatility Index.

The download status is exhibited at the bottom of the sheet.

A one-minute video (no audio, except for mouse-clicks) showing the features of the Nifty one-stop shop.

This sheet is Pranav's intellectual property. To safeguard it, I have password protected the VBA code. Please contact Pranav (email in the sheet) to unlock it for a fee. The sheet is meant for personal use only and can be used without any passwords. 

Download the Nifty One Stop Shop V 1.2

Tomorrow, I will integrate this sheet with the Nifty Valuation Analyzer: PE, PE, Div Yield, ROE, EPS Growth Rate

Please join me in congratulating Pranav. Freefincal cannot grow without such support from friends, readers and DIY investing community.

Pune Investor Workshop (personal finance) Feb 26th, 2017

The second Pune workshop will be held on Feb 26th, 2017. You can register for this via this link

You Can Be Rich Too With Goal-Based Investing

Gift it to your Friends and Relatives whom you care more. Already follower of Pattu and Subra's forum. Ordered 4 more copies to give gift to my friends and eagerly waiting to read

The best book ever on Financial Freedom Planning. Go get it now!

Your first investment should be buying this book

The (nine online) calculators are really awesome and will give you all possible insights

Thank you, readers, for your generous support and patronage.

Amazon Hardcover Rs. 279 30% OFF

Kindle at Amazon.in (Rs. 244.30)

Google Play Store (Rs. 244.30)

Infibeam Now just Rs. 307 use love10 to get additional 10% OFF.  

If you use a mobikwik wallet, and purchase via infibeam, you can get up to 100% cashback!!

  • Ask the right questions about money
  • get simple solutions
  • Define your goals clearly with worksheets
  • Calculate the correct asset allocation for each goal.
  • Find out how much insurance cover you need, and how much you need to invest with nine online calculator modules
  • Learn to choose mutual funds qualitatively and quantitatively.

More information is available here: A Beginner's Guide To Make Your Money Dreams Come True!

What Readers Say

Also Available At

Bookadda Rs. 371. Flipkart Rs. 359

Amazon.com ($ 3.70 or Rs. 267)

Google Play Store (Rs. 244.30)

Free Apps for your Android Phone

Install Financial Freedom App! (Google Play Store)


Install Freefincal Retirement Planner App! (Google Play Store)


Find out if you have enough to say "FU" to your employer (Google Play Store)


About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.

2 thoughts on “Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield

  1. P. R. RAVINDRAN

    Thank you Mr. Pranav for your excellent effort to provide valuable information on NIFTY.
    Thanks to Pattu Sir for attracting great brains to contribute.

    Reply

Do let us know what you think about the article

%d bloggers like this: