Fetch option Chain (Equity Derivatives) and quotes from NSE India in a simple Google Sheets 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:
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
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!
We’d love to hear all of your feedback so that we can keep providing the best information on web scraping!