NSE Option Chain in Xls

Omveer_Singh · February 18, 2020, 5:25pm

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

Newbie420 · February 18, 2020, 5:29pm

You can download FNO Bhavcopy from -

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

Omveer_Singh · February 19, 2020, 5:08am

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

unofficed · February 19, 2020, 8:20pm

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.

Omveer_Singh · February 23, 2020, 5:49pm

great thanks for your response.

how can we connect