Option data importing from google finance (open interest & implied volatility)

F&O
62

Sir…I’m try in mobile is it possible

63

Hello sir…I will try ,in mobile is it possible…sir

64

@raju_pentakota, Can’t understand in Mobile EXCEL???
:thinking:

65

Sir,
Unable fetch the option chain data in google sheets due to non technical knowledge of python. Kindly share the updated file.

66

Dear @subhajitbardhan,
Don’t use GOOGLE SHEET just download above niftyExcel.xlsx

and it will update auto/by press F5.

:slight_smile:

1 Like
67

Sir
Unable fetch the nse nifty option chain data in my google sheets . Help me pl…

68

By any chance you know where can i get live data? NSE data is delayed… I know the platforms to watch the live options chain. but don’t know how to export it to excel.

69

I tried with above url i got the below error. Could you please guide me why i got the below errror.

Error Could not fetch url: http://www.niftyindices.com/IndexConstituent/ind_nifty200list.csv
Thanks

70

The new NSE website doesn’t allow the web scraping. We have to find another method. I am sure Lotus is already working on it.

1 Like
71

@lotus, Could you help that NiftyExcel to make it dynamic for Nift or BankNifty plz. also will this work even after old website being closed by NSE

72

Hi Brother

A thanks for sharing this sheet. Useful

2 quick followup help -

a) I want similiar option chaing for bank nifty . how do i change this in the excel? (right now its for nifty)

b) i want to have comparative data of 15 mins. how do i actually make sure excel refreshes it every 15 mins and new data retrieved doesnt overwrite older data and some form of time stamp is available - so that i can compare oi change etc

thanks

1 Like
73

Thanks for the sheet, I stumbled upon it while I was trying to import option chain data to Excel on Mac.
It isn’t straight forward when it comes to Excel on Mac and your sheet works perfectly fine.

A question.
Will the difference between Calls & Puts give me a direction ( Buy/sell)

Thank you

74

Thanks for sharing such a helpful link.
Keep rocking and keep helping.

75

Dear Lotus,

First of all, thanks a ton for your efforts.

can you please provide option chain in excel using data from nse new website. I have coded data from old website to my excel sheet but it do not IV which is very useful for sellers. I have office 2013 & am not able to fetch data from new website.

76

Thank you. it is working correctly.

77

Why its not showing latest data? Showing feb 11 and today feb12

78

sandeep ji i think you this sheet has been removed by you. will be obliged if you could post it again. actually i was trying to webscrap nse options chain on google spread sheets without any sucess… i did tried the link also = importhtml and with the link provided by you… but unfortunately no sucess dear

79

How to create option chain data or change in option change data on 15 min interval in google sheet?

80

Hey Lotus,
I am searching for a google sheet which have data of future stock like which includes open interest, change in open interest of that stock ,can you guide me to some sheets as i see you are quite active on the topic so if you can share any sheets with me ,it will be helpful.

Regards,
Ashish patel
([email protected])

81

Hello Saurav sir loved the interface of your sheet ,can you share the google sheet link with me ,please .

Thanking you ,
Ashish Patel.
Email: [email protected]