Zerodha Option Chain Excel Feed

I trade on Zerodha every day and would like my option-chain view to live inside Excel instead of the browser. Using the Kite API, I need a solution that streams real-time strike prices, bid/ask quotes, and volume + open-interest LTp call and put figures directly into a worksheet. The feed should refresh continuously without manual clicks so I can sort, filter, and run my own formulas while the market is open.

You may use Python, VBA, Power Query, or any other stack that talks to the Kite API—whichever keeps the sheet light and the data flowing with minimal latency. Please handle API authentication, throttling limits, and reconnections so the sheet stays populated even if the network drops for a moment.

Deliverables
• Ready-to-use Excel file wired to the Kite API
• Any external script or add-in (with clear path and instructions) that the workbook relies on
• Quick setup guide: where to paste my API key/secret, how to start/stop the stream, and what to do if Zerodha rotates tokens

Acceptance criteria
The worksheet must display the four data points in separate columns, auto-update in real time, and stay within Kite’s rate limits for a full trading session without freezing or logging me out.