how to fetch option chain data to excel on a desktop computer

ADS
option chain data
  • ADS
    is there a readymade programme available to fetch option chain into excel
  • nagavenij
    There is no direct API endpoint or stream available to fetch the option chain. You will need to build it on your end by filtering the instruments and retrieving OI, LTP, and volume using either the WebSocket stream or the Quote APIs, based on your requirement.

    Additionally, we do not have an official Excel library. However, you can stream live market data into Excel using the Kite Connect API by integrating it with third-party tools or by writing custom code in Python or VBA that connects to Kite’s WebSocket API. You can refer to this forum discussion.
Sign In or Register to comment.