Get the live price of NIFTY and Bank NIFTY stocks in Excel sheet
Fetch the last traded price (LTP) as well as Price Change (%) for NIFTY 50 (50 stocks) and Bank NIFTY (12 banking stocks) in Excel sheet.
With this the fetched data can be analyzed to predict the price movements of both NIFTY 50 as well Bank NIFTY in Excel.
With the Refresh Button the price data can be updated.
Since the Excel files are VBA Macro based, enable the contents, and allow to fetch the data.
ERRORS
These works are in beta stage, so there are many unexpected errors.
Due to the lag to fetch the data from the NSE server, Run-Time Error can occurs.
See the screenshot.
Save and close the Excel.
Open after some time and Refresh.
If it takes long time to fetch the data, close.
Open after some time and Refresh.
DISCLAIMER
These Excel files are designed for purely educational purposes only and strictly not for commercial purposes.
Either Dr. M Kanagasabapathy (owner) or the website (www.enote.page) is not responsible for any losses incurred based on this data.
Designed by,
Dr. M Kanagasabapathy
Associate Professor
Coordinator, Incubation Centre
Rajapalayam Rajus' College
Rajapalayam 626117 (TN) India
Screenshots
Possible Errors
Video Tutorial
YouTube Link
Download Link