I’m building an Excel workbook that must stay in sync with Zerodha’s Kite API, streaming both the full option chain and live market quotes in real time. Within the option chain I need every strike price for the selected symbol, its corresponding expiry dates, and the latest Open Interest and Volume figures to flow straight into the sheet the moment Zerodha publishes them. Here’s the workflow I have in mind: • The workbook opens, prompts for API key / secret, generates the request token and stores the access token securely. • A user-friendly input cell lets me type or pick the underlying (e.g., NIFTY, BANKNIFTY, any NSE stock). • Behind the scenes your code (Python with KiteConnect, xlwings or VBA—whichever you prefer) connects to Zerodha’s WebSocket for tick-by-tick prices while polling or parsing the option chain endpoint. • Excel refreshes each row automatically, no manual click needed, preserving formulas and conditional formatting I’ll add later. • If the API session expires, the workbook should refresh the token without losing data. • A lightweight latency indicator or timestamp cell will confirm the feed is still live. Deliverables 1. Unlocked Excel file with all live feeds wired up 2. Source code (Python/VBA) well commented 3. Step-by-step setup guide so I can re-generate API keys and deploy on another PC 4. Quick demo (video or screen-share) proving real-time streaming of option chain + price data for at least two symbols Acceptance criteria • Strike prices, expiry dates, OI and volume columns populate fully on first load and update continuously thereafter. • Live last-traded price, bid/ask and volume for the underlying refresh with no noticeable lag. • Workbook keeps running for a full market session without manual intervention or crashes. If any additional Zerodha compliance steps are required, mention them in the guide. Looking forward to getting this running before the next expiry week.