yes, this works for stocks, how can I get data for NIFTY AND BANKNIFTY for all columns and send excel output to output folder?
What should I write stock on fno
api_req=req.get('https://www.nseindia.com/api/quote-derivative?symbol=NIFTY',headers = headers).json()
for item in api_req['**stocks**']:
data.append([
item['metadata']['instrumentType'],
item['metadata']['openPrice']])