HOW TO view historical data of Sensex & Nifty indices with Google Sheets

The GoogleFinance function can be used to fetch current or historical data for a specified time period. It supports some international exchanges including India's Sensex & Nifty indices, stocks & mutual funds.

Update (6-Sep-2021) - The value for the "ticker" attribute has been changing at different times. Get the ticker symbol for Indian exchanges, stocks & mutual funds from the Google Finance site. The Google Sheets formula has one mandatory & four optional attributes -

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

Not all attributes values work for Indian markets so check the documentation to experiment and find out which attributes work. The following examples return results for the HDFC Index Fund Sensex Plan-Direct Plan mutual fund and SENSEX -

=GoogleFinance("HDFC_INDE_SENS_12V3KIA", "close", "09/06/2021")

=GoogleFinance("INDEXBOM:SENSEX", "close", "08/01/2021" , "09/01/2021", "DAILY")

Update (16-Jan-2019) - The value for the "ticker" attribute of the GoogleFinance formula has changed for Sensex & Nifty. To know the ticker symbol for any stock or mutual fund in India that you wish to find info on, head to finance.google.com and search with actual name. The related code will be shown along with the result.

Try these to get historical data of Sensex & Nifty indices for the first 9 days of September 2013:
=GoogleFinance("BSESN", "close", "09/01/2013" , "09/09/2013", "DAILY")
=GoogleFinance("NSEI", "close", "09/01/2013" , "09/09/2013", "DAILY")
=GoogleFinance("INDEXBOM:SENSEX", "close", "01/01/2019" , "16/01/2019", "DAILY")
=GoogleFinance("NSE:NIFTY", "close", "01/01/2019" , "16/01/2019", "DAILY")




You can even go back in time. The Sensex was at 4031.55 this day in 1997!

Related: A quick way to check latest values of Sensex, Nifty, Gold, Silver, USD-INR currency

Comments

Popular posts from this blog

Maven Crash Course - Learn Power Query, Power Pivot & DAX in 15 Minutes

"Data Prep & Exploratory Data Analysis" course by Maven Analytics

Oracle Cloud Infrastructure 2024 Generative AI Professional Course & Certification Exam (1Z0-1127-24)