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:

Download Nifty historical data 1 650x306 - Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield

The inputs sheet

Download Nifty PE PB historical data 650x572 - Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield

The index ratios: PE, PB and Div Yiled

Download Nifty historical data 3 650x574 - Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield

The index data

Download Nifty historical data 4 650x704 - Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield

Nifty 50 Total Returns Data

Download Nifty historical data 5 650x566 - Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield

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

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

download status bar 650x52 - Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield

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.

You can be rich too 225x300 - Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield

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

reviews 650x462 - Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield Reviews 4 650x685 - Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield

Also Available At

Bookadda Rs. 371. Flipkart Rs. 359

Amazon.com ($ 3.70 or Rs. 267)

Google Play Store (Rs. 244.30)

Connect with us on social media


Do check out my books


You Can Be Rich Too with Goal-Based Investing

You can be rich 243x300 - Download Nifty Historical Data: Price, Total Returns, PE, PB and Div Yield My first book is now available at a 35% discount for Rs. 258. It comes with nine online calculators. Get it now.  The kindle edition is only Rs. 199.

Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want

Cover-pink

My second book is now only Rs 199 (Kindle Rs. 99).  Get it or gift it to a young earner

The ultimate guide to travel by Pranav Surya

Travel-Training-Kit-Cover 

This is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step.  Get the pdf for ₹199 (instant download)

Create a "from start to finish" financial plan with this free robo advisory software template


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. Thank you Mr. Pranav for your excellent effort to provide valuable information on NIFTY.
    Thanks to Pattu Sir for attracting great brains to contribute.

Your feedback is valuable. Do let us know what you think about the article and help us improve