NSE India Dashboard

Author: Alan Trébuquet
Published: June 7, 2023

Fetch option Chain (Equity Derivatives) and quotes from NSE India in a simple Google Sheets template.

How does it work?

It uses the ImportJSON add-on that we built.

ImportJSON provides a simple function to import JSON formatted data from different sources and turn it into a two-dimensional table you can easily manipulate.

Copy the template

To properly set yourself up to extract thousands of data points from NSE India, the first thing you need to do is copy the template:

Generate a nseappid parameter

To scrape easily data from NSEindia, you need to generate a nseappid parameter. How can you do that?

  • Install the EditThisCookie plugin. It is only available for Chrome but you can easily find equivalents if you use another browser.
  • Go to NSEindia
  • Open the EditThisCookie extension menu and copy the value of the nseappid parameter

Install ImportJSON add-on in the copied spreadsheet

Then, simply install the tool into your Google Sheets from the Google Workspace Marketplace following the step-by-step instructions indicated by the add-on.

From there, you can access the tool by clicking “Add-ons” and activating ImportJSON within the spreadsheet, you are ready to go!

See how the info displays in the ‘Tool’ tab

Did you find this tool useful?

We’d love to hear all of your feedback so that we can keep providing the best information on web scraping!