Nifty 50 option chain on excel

UG7128
Nifty 50 option chain on Excel. I dont know pull data to google excel. Help me
  • salim_chisty
    We don't have an official Excel library. You can get live market data in Excel using the Kite Connect API by integrating it through third-party tools by writing custom code in Python or VBA that connects to Kite's WebSocket API.
    You may refer to the similar discussion in this thread.
  • ADS
    is it possible to download option chain with columns showing changes in OI, LTP and VOLUME etc. in excel
  • salim_chisty
    There is no direct API endpoint/stream to fetch the option chain. You need to build it at your end by filtering instruments and fetching OI/LTP/volume​using Websocket streaming or Quote APIs, depending on your usability. This thread explains a basic flow to create an option chain.
Sign In or Register to comment.