Real-Time Dhan Options Feed

I want a lightweight solution that streams option Price, Open Interest and the Delta Greek from the Dhan API directly into an Excel workbook in real time.

My preference is for something easy to maintain—Python with xlwings, a small VBA add-in, or another straightforward bridge that keeps the sheet updating without manual refreshes. As long as the Delta field stays in sync alongside price and OI, I’m flexible on the underlying method.

Deliverables
• An Excel file pre-configured with live columns for symbol, price, open interest and delta
• Well-commented source code or macro that calls the official Dhan API endpoints, handles authentication and manages the streaming/refresh logic
• A brief read-me so I can update keys or modify tickers later

Acceptance Criteria
• Data begins flowing within seconds of opening the workbook and continues without forced refresh
• Delta values mirror the same figures visible on Dhan’s platform at any given moment
• No hard-coded credentials; everything pulls from a secure, editable config cell or file

If this sounds clear and achievable, let’s set it up.