How to export option chain data to excel in sensibull kite

Fundamental Analysis
1

how to export option chain data to excel in sensibull kite

2

Not sure if Sensibull has that option. but you can import the Option chain into Excel from the NSE website.

Go to Excel → Data → Get external data

image
image1365×697 53.6 KB

Click on ‘get data from web’

image
image734×540 23.7 KB

Enter this URL in the address bar -

https://nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbol=NIFTY&instrument=-&date=-

Click on the yellow right arrow marks wherever you see it on the webpage & click on Import -

image
image1258×593 84.2 KB

If you want it to as real time as possible - you click on properties in the data page and select refresh every minute

image
image1177×654 45.5 KB

image
image642×517 25.8 KB

And thats it… ! You’ll have the option chain data on excel…But personally i think Sensibull option chain is just easier on the eyes…

3 Likes
3

Microsoft Excel gives an error (An unexpected error has occurred)
How o deal with it?

4

Share the screenshot of the error here

5

how to get it live