How to get Historical and Real-Time Stock Data for the NSE Exchange

Wisesheets VTL.NS Income Statement

We all have favorites. Are you looking how to get historical and real-time stock data for NSE Exchange your favorite stocks? 

If so, then you have come to the right place! You can get historical and real-time stock data from NSE Exchange. 

We will provide you with a step-by-step guide to getting this data from the National Stock Exchange of India right on your Excel or Google Sheets spreadsheet without any coding.

Identify your Stocks

The first step to get stock data from NSE is to find the NSE stocks you're interested in. Use this link to download a list of NSE stocks that you require. Keep in mind that to get data of these stocks on Wisesheets you need to enter the ticker followed by .NS.

For example, if you'd like to get data from ACC Ltd., you need to enter ACC.NS as mentioned here.

How to get Real-Time NSE Stock Data

After you've decided which stocks to track real-time data for, the simplest approach to get this information into Excel or Google Sheets is to use Wisesheets.

Simply enter in your spreadsheet =WISEPRICE("ticker", "parameter")

For example, if you want to get Year High value for ACC.NS, you need to simply enter =WISEPRICE("ACC.NS", "YearHigh")

Wisesheets ACC.NS Revenue

The list of parameters includes:

  • Symbol
  • Name
  • Price
  • Changes Percentage
  • Change
  • Day Low
  • Day High
  • Year High
  • Year Low
  • Market Cap
  • Price Avg 50
  • Price Avg 200
  • Volume
  • Avg Volume
  • Exchange
  • Open
  • Previous Close
  • EPS
  • PE
  • Shares Outstanding
  • Earnings announcement
  • Timestamp

For example, to get ACC Ltd stock data, you need to enter =WISEPRICCE("ACC.NS", "price")

For investigating multiple tickers, you can easily lock in your cells like this and then drag it to cover all of them.

Wisesheets multiple NS tickers or companies

The best part about the WISEPRICE function is that whenever you’d like to update the data you just need to press the refresh button.

Wisesheets Price function for AAPL

You can create a free account by following link : https://www.wisesheets.io/

After you get your account, download the Excel or Google Sheets add-in and login with your account.

Once you login, you will have access to the WISEPRICE function to get real-time stock data and your list of stocks!

Thats it! You can now get real-time data for all your NSE stocks in Excel or Google Sheets.

How to get Historical NSE Stock Data

Getting historical NSE stock data in Excel or Google Sheets is a cumbersome task. However, with the right tool, you can get all the historical data you need on your spreadsheet immediately.

The best way to do this is to use Wisesheets. You can get your free account here.

Once you have an account from here, you can get NSE historical stock data by entering the ticker of the company you'd like to get data for followed by the extension ".NS". Then select whether you'd like annual or quarterly data. 

For example, if you'd like to get annual data from the company Tilaknagar Industries Ltd., you need to enter the ticker TI.NS, and then click on get data. This will return all the financial statements, key metrics, and growth metrics for that company going back up to 19 years.

Wisesheets Income statement for VTL.NS

Getting all the stock data at once from NSE companies is often tedious. So, if you are looking for specific data to build a screener or DCF model, you can use the =WISE function.

You can check out how to get historical NSE data from the video below.

Getting Data for a Particular Parameter

The function accepts the following arguments:

=WISE(ticker, parameter, year/period, [quarter])

For the tickers available be sure to use this list. Keep in mind you need to enter the ticker followed by ".NS"

Wisesheets TIL.NS Revenue for 2023

The list of parameters includes everything in the financial statements; key metrics and growth metrics which you can see here.

As for the period you can select either a specific year, such as, 2021, “TTM” (which returns the results from the sum of the last 4 quarters), “LY” (Last Fiscal Year) or “LQ” (Last Fiscal Quarter).

Once you have a model set up using the function you can simply change the ticker and get all of the financial data you need at once without wasting any time copy-pasting financials from multiple websites.

Wisesheets Discounted cashflows

Conclusion

Now you know how to get historical and real-time data from NSE Exchange for NSE stocks on Excel and Google Sheets. You can use historical data to build a valuation model or create historical comparisons for your investment thesis.

We hope this guide was helpful. Happy investing!

Hello! I'm a finance enthusiast who fell in love with the world of finance at 15, devouring Warren Buffet's books and streaming Berkshire Hathaway meetings like a true fan.

I started my career in the industry at one of Canada's largest REITs, where I honed my skills analyzing and facilitating over a billion dollars in commercial real estate deals.

My passion led me to the stock market, but I quickly found myself spending more time gathering data than analyzing companies.

That's when my team and I created Wisesheets, a tool designed to automate the stock data gathering process, with the ultimate goal of helping anyone quickly find good investment opportunities.

Today, I juggle improving Wisesheets and tending to my stock portfolio, which I like to think of as a garden of assets and dividends. My journey from a finance-loving teenager to a tech entrepreneur has been a thrilling ride, full of surprises and lessons.

I'm excited for what's next and look forward to sharing my passion for finance and investing with others!

Related Posts