How to NSE & BSE Live Data in Google Sheets

Reading Time: 5 minutes

GOOGLEFINANCE function can be used to track stock prices, including tracking NSE & BSE live data in Google Sheets.

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

ticker – The ticker symbol for the company/index to consider.

Keep in mind to use both the exchange symbol and ticker symbol. For Eg, if you want to find the stock price of Infosys (NSE: INFY), use NSE(exchange symbol) and INFY(ticker symbol).

attribute – This specifies the type of data to fetch about the ticker from Google Finance.

Compulsory to mention if the date is specified. By default, the function returns the “price” parameter. If you set the parameter as “high”, it will return the day high price of that particular stock.

start_date – [ OPTIONAL ] – The start date when fetching historical data.

end_date|num_days – [ OPTIONAL ] – The end date when fetching historical data or the number of days from start_date for which to return data.

interval – [ OPTIONAL ] – The frequency of returned data; either “DAILY” or “WEEKLY”.
Interval can alternatively be specified as 1 or 7. Other numeric values are disallowed.

Sample Usage
=GOOGLEFINANCE("NASDAQ:NVDA","price", DATE(2020,1,15),DATE(2021,1,15),7)

//This fetches the weekly stock price of Nvidia for the period specified.

=GOOGLEFINANCE(B2,"High",DATE(2022,1,1), DATE(2022,1,31),7)

//Retrieves the weekly high price between the dates specified for the ticker in cell B2.

What is NSE & BSE Live Data in Google Sheets?

The National Stock Exchange (NSE) and Bombay Stock Exchange (BSE) are two stock exchanges active in India. They deal with the stock transactions of the entire country. We can easily track NSE & BSE live data in Google Sheets using inbuilt functions.

Why Track Live Data in NSE & BSE?

People invest money in the stock market through NSE or BSE. Investors want to check the live prices of the stocks they have invested in or are on their waitlist. Having a Google Sheets containing live stock prices helps keep track of their investment portfolios. Or they may have created a watchlist of stocks, and they want to track their prices looking for an opportune moment to strike.

If you are one of these people, then you are in luck. For Google Sheets makes that fairly easy. You can track NSE & BSE Live data in Google Sheets using the GOOGLEFINANCE function.

Example of how to track NSE & BSE Live Data in Google Sheets
Example of how to track NSE & BSE Live Data in Google Sheets

How to Track NSE & BSE Live Data in Google Sheets

What is Google Finance Function?

To track stock prices in Google Sheets, you have to use the Google Finance function. The GOOGLEFINANCE function in Google Sheets helps you fetch real-time financial data and historical securities data from Google Finance. Google Finance is a web service by Google focused on business news and financial information.

Sample Examples of NSE & BSE Live Data in Google Sheets

Given below are some examples of GOOGLEFINANCE formulas to get NSE and BSE stock prices in Google Sheets.

  1. =GOOGLEFINANCE(“NSE:INFY”, “price”, DATE(2014,1,1), DATE(2014,12,31), “DAILY”)
  2. =GOOGLEFINANCE(“NSE:TCS”,”price”,TODAY()-30,TODAY())
  3. =GOOGLEFINANCE(A2,A3)

Let us now learn in more detail how to track NSE and BSE stock prices in Google Sheets using an example.

Get the weekly high prices for a stock listing

Step 1: Open Google Sheets

  • Open Google Sheets.
  • Select the cell where you want stock data to be displayed.

Step 2: Use the GOOGLEFINANCE formula 

Let us use the above image as a reference to extract stock data from NSE.

To fetch the weekly high price for a given stock, say Hindustan Unilever (placed in cell B2 in the example), use the following formula.

=TRANSPOSE(GOOGLEFINANCE(B2,"High",DATE(2014,1,1), DATE(2014,1,31),7)

Let us analyse the formula by breaking up the parameters.

  • The TRANSPOSE function transposes the results from rows to columns.
  • The GOOGLEFINANCE function is fetches the stock data.
  • The first parameter (B2) selects the ticker symbol for the stock of choice.
  • The second parameter (High) returns the highest prices for a particular day for the specified stock.
  • The third parameter, DATE(2014,1,1), is the beginning date of the data to fetch. Here the date used is the 1st of January, 2014.
  • The fourth parameter, DATE(2014,1,31), is the ending date of data to retrieve. The date used is the 31st of January, 2014.
  • ilter Data by Color in Google Sheets: In this article, we would have a look at how to Filter Data by Color in Google Sheets.
  • Using GOOGLEFINANCE to Convert Currency in Google Sheets | 2 min easy guide: In this article we would see how to convert currency in Google Sheets on a real-time basis using Google Finance. 
  • Complete Guide on the REGEXEXTRACT Function in Google Sheets for 2022: Learn how to use the REGEXEXTRACT function in Google Sheets and its variations.
  • The last parameter (7) is used to fetch weekly data, as the interval is seven days.

On entering the formula, the requested stock data will be retrieved and displayed in Google Sheets, as shown below.

Track weekly high prices of a stock in Google Sheets
Track weekly high prices of a stock | NSE & BSE Live data in Google Sheets

Visualise the data using the SPARKLINE function in Google Sheets

Let us consider one more example to get NSE data in Google Sheets and then visulalise the stock data so that we can track them better.

Let us extract stock data for Asian Paints from NSE. The ticker symbol for Asian Paints is placed in cell B10.

The GOOGLEFINANCE formula to get stock prices data from NSE is as under.

=GOOGLEFINANCE(B10,"price",DATE(2020,1,15),DATE(2021,1,15),7)
  • The Google Finance function is used to extract stock prices.
  • The first parameter (B10) selects the ticker symbol for the stock of choice.
  • The second parameter (price) is used to select prices for a particular day for the specified stock at the closing price.
  • The third parameter, DATE(2020,1,15), is the beginning date of fetching data. Here the date used is the 15th of January, 2020.
  • The fourth parameter, DATE(2021,1,15), is the ending date of fetching data. Here the date used is the 15th of January, 2021.
  • The last parameter (7) is used to fetch weekly data, as the interval is seven days.

After we’ve pulled the stock data from NSE to Google Sheets, we can visualise the high and the lows and the trends of the stock price using the SPARKLINE function.

For the data we’ve pulled to Google Sheets, the formula is as under.

=SPARKLINE(D11:D62)

This will create a line chart representing the data within the range of the sparkline function.

The output looks like this:

Line chart of the stock price created with the SPARKLINE function
Line chart to track NSE & BSE live data in Google Sheets

Conclusion

The GOOGLEFINANCE function in Google Sheets is used to import NSE & BSE Live Data in Google Sheets. You can also create sparkline graphs to visualise the trend of that particular stock. 

See Also

Want to know more formulas and functions in Google Sheets? Look at our definitive guide on Google Sheets which covers hundreds of such topics here. Enjoy reading!

Some related aricles you may be interested.

Import Yahoo Finance Data Into Google Sheets: Import stock data from Yahoo Finance from stock exchanges around the world.

How To Import CoinGecko Data To Google Sheets: Track crypto prices from Google Sheets.

Import Data From Nasdaq To Google Sheets: Retrieve Nasdaq data and export them to Google Sheets.

shalinamigo

←
→

Leave a Reply