Hello, So Im new to this API world & have a very basic requirement of getting live data in excel for Nifty & Banknifty Futures (3months) in Excel file. (Using Query function or anything else) Im currently using NSE website API for getting this data but its not consistent & need something more reliable. TIA.
Subscribe to them using pi software
Use link to excel feature to import the data in excel