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 webs