NSE Option Chain in Xls

Respected Members,

I’m not able to extract NSE Option chain into google spread sheet. Please help me.

I have used importhtml function.

@ Respected Lotus,

Please help

Regards

You can download FNO Bhavcopy from -

https://www1.nseindia.com/products/content/derivatives/equities/archieve_fo.htm

It has the option chain inside, filter with “OPTIDX”

1 Like

Thank you for reply, I have put the query regarding automation as I don’t want to download it manually.

Just download in python and shoot back with Gspread module.

I am doing the same.

Check -


There is NO other way to import into Gsheet from NSE because NSE blocked Gservers.

great thanks for your response.

how can we connect