After a long time, I am updating the blog. Regret for not able to replying to comments (many are still pending for approvals for publish, apologies).
NSE website has changed the access of public JSON URL that we have been using to get the quotes from NSE website into the tool. So this post updates the NSE Share Price tool with the following –
- Update the NSE Website URL to be used for data fetching
- Encoding the ticker symbols with “&” (like M&M, COX&KINGS, L&TFH …etc.)
The updated URL is directly linked to the website URL of NSE Quote page instead of the JSON URL used for fetching previously. Though the NSE might have changed the access of direct JSON URL for their web security / access privilege purposes, data-wise access should be open for the public information.
The updated product file can be downloaded from the link – NSE Live Stock Prices in Excel Ver 3 – Portfolio Mangement Through Excel <not working for all the users>
The updated futures file can be downloaded from the link – NSE Futures Live Prices in Excel with Autoupdate ver2 <not working for all the users>
Update : Some of the users are not getting the relevant data as the direct access of the URL is blocked. So again we have to update to a new URL and also improved the speed of the excel. Just click on the calculate all after you insert the script id.
The updated product file can be downloaded from the link – NSE Live Stock Prices in Excel Ver 4 – Portfolio Mangement Through Excel <updated on 28th May 2017>
Also, users can download the tool of BSE data from BSE Live Stock Prices in Excel Ver 1 – Portfolio Mangement Through Excel