Excel-Kite Real-Time Trading

I want a single Excel workbook that talks directly to the Zerodha Kite Connect API. From inside the sheet I should be able to log in with my own API key, watch live prices tick by tick, and press a button (or trigger a cell formula) to send market or limit orders straight to the exchange. The same file also needs to pull historical OHLC data so I can run quick back-tests or visualise past performance without leaving Excel.

All three trading modes matter to me: algorithmic rules that run automatically, classic technical-indicator set-ups, and the occasional manual signal when I change a cell value. I am fine starting with solid, pre-built strategies—think moving-average cross, RSI breakouts, simple mean-reversion—so long as the logic is clearly laid out and I can toggle them on or off from the sheet.

Deliverables
• An unlocked Excel workbook (VBA, Office Script, or an external helper in Python that pipes data into Excel—whatever is leanest and most reliable) already wired to Kite Connect for login, live feed, historical pull and order placement.
• Clear instructions on how to enter my API credentials and map contract symbols.
• A short demo showing a live price update and an executed test trade.

If the core flow proves stable, we can look at adding more custom strategy slots later, but right now the focus is a plug-and-play sheet that fetches data, analyses it, and places trades without leaving Excel.