I need an Excel-based workspace that talks directly to Zerodha’s Kite Connect API, pulls both FnO and cash market streams in real time or on-demand, and lays everything out clearly inside the workbook. Data handling • The workbook should automatically fetch price, volume, and open-interest fields for any symbol I enter. • Please structure the queries so I can easily extend them to new instruments without touching the VBA or Python again. Visuals A line-chart dashboard is the immediate goal—one sheet that redraws the selected symbol’s price, volume, and OI as soon as fresh data lands. If you can wire the code so bar or candlestick views could be added later that would be a plus, but for now only line charts are required. Custom scans & alerts I want to define formula-based scans (for example moving-average crossovers, volume spikes, OI divergence) and run them at user-selectable intervals—say 1, 5, 15 minutes or end of day. The scan engine should accept any Excel formula I type into a control sheet, evaluate it against the live data range, and flag matches. Pop-up alerts inside Excel are fine for v1; please leave the hooks open for email or webhook alerts later. Future collaboration Once the framework is stable, I’ll be adding new strategies regularly, so clean, well-commented code is critical. Think of this as phase one of a longer partnership; if we click, you’ll have ongoing work refining formulas, alerts, and visual tweaks. Deliverables • An unlocked Excel file with working API connection, refresh controls, and query templates • VBA/Python (or hybrid) source code with clear comments • One dashboard sheet showing live line charts for price, volume, and OI • Scan engine that reads formulas from a config sheet and highlights hits on schedule • Quick start guide so I can add instruments and scans myself If this sounds like the kind of structured yet flexible build you enjoy, let’s get started.