Live data from NSE website to Excel

General
1

please is it possible that we can get live stock data in excel from only NSE website without use of google finance.

2

Quick google of the title gave me this as top result.

To make it short just go to vba editor put this function in a module and pass the scriID to the function and parse the json response.

Public Function getNSEData(scripID As String)  
    URL = "http://www.nseindia.com/live_market/dynaContent/live_watch/get_quote/ajaxGetQuoteJSON.jsp?symbol=" & scripID
    Set xmlHttp = CreateObject("MSXML2.ServerXMLHTTP.6.0")
    xmlHttp.Open "GET", URL, False
    xmlHttp.setRequestHeader "Content-Type", "text/JSON"
    xmlHttp.send
    getNSEData = xmlHttp.responseText    
End Function
2 Likes
3

@newguy_Do you have any video for this…it is very difficult to understand

4

No I don’t have any video for this.

5

open excel sheet > go to data >choose from web, which is 2nd from left top> enter there the link of page to want to import to excel

6

Hello L,

This method was working earlier. Now the exchange has blocked the access for this link “https://www.nseindia.com/live_market/dynaContent/live_watch/get_quote/ajaxGetQuoteJSON.jsp?symbol=INFY”

So you cant get live quotes from NSE website to excel.

The better way is, Just create a market watch list in Pi. Then link the market watchlist to excel. That’s it. You get live quotes only if pi is running.

8

Is it working in google spread sheet?

1 Like
9

As you may know, Yahoo Finance discontinued their free api service that delivered live market data quotes on Nov 1st, 2017 after it was purchased by Verizon. Nevertheless I have managed to upgrade my Deriscope Excel AddIn to let users get real time market quotes into the spreadsheet directly from YF in addition to time series of historical data.
This 5 min youtube video demonstrates how all this works in practice.

10

is nse json working as on 29.8.2018
it seems it is blocked. plz update if not.

1 Like