Excel Based Zerodha Algo Trading Bot with dashboard.

I already keep every trade idea in a simple Excel sheet: scrip name, trigger level, stop-loss and target for both buy and sell sides. What I need is a Python program that sits on my machine, watches that sheet in real time and, the moment a level is touched, fires the appropriate order through Zerodha’s Kite Connect API without any manual action from me. Core flow • Read and refresh the Excel file continuously (I will update it during the day). • Stream live market prices via Zerodha WebSocket and match them against the levels in the sheet. • When a match occurs, automatically place the market/limit order with the correct quantity, stop-loss and target legs. • Update the Excel row (or a log) with order ID, status and fill price so I always see what happened. Dashboard requirements I want a lightweight interface—web or desktop is fine—that shows at a glance: • Order tracking (status of every order you sent) • Trade tracking (fills, quantities still open, average price) • Profit / Loss analysis in real time, plus a running day-total • Previous-day history and the next alert levels still waiting to trigger I have no coding background, so the deliverable must include: • Clean, well-commented Python source that I can run with one command • A brief setup guide covering environment, Zerodha API key placement and how to point the script to my Excel file • Any third-party libraries (pandas, Flask/Tkinter, Kite Connect SDK) declared clearly so I can install them with pip • Basic error handling so the bot keeps running even if the Excel sheet is edited or the WebSocket drops Optional flexibility to integrate another broker such as Upstox later would be appreciated, but Zerodha is the priority. Once everything is working, I should be able to open the dashboard, start the script, update my Excel sheet and watch trades execute and P&L update live—no further clicks needed.

Project ID: 40525485