AngelOne Live Data Excel Integration

I want my market-tracking spreadsheet to pull live quotes from AngelOne SmartAPI, update automatically, and display everything in clear, interactive line charts. To get this running smoothly, please start with your own Angel Broking account while you build, test, and refine; once everything works, I’ll use my client ID, MPIN, and TOTP later on switch the connection over. (Angel api is free), you can use an api of your choice also but result needs to be same.

Here’s what I expect:

• SmartAPI connection wired into Excel, refreshing tick data in real time.
• A simple drop-down or slicer that lets me choose among Nifty50, Nifty500, and the full universe of FNO stock futures. I need the flexibility to jump between single symbols or whole indices.
• Live line charts that can overlay multiple selected fields on the same plot for quick visual comparison.
• Data formatted so standard Excel formulas run instantly—especially statistical and trend analysis functions (Long OI ,short OI ,shortcovering , long unwinding, money flow, etc. Will give the required formula ideas once we have a working live FnO data to plot charts).
• Clear, reusable VBA or Power Query code (or another approach you recommend) with comments so I can expand the workbook later.
• Hand-off session showing me how to change API keys, add symbols, and troubleshoot common issues.

Deliver a working workbook, the underlying code, and short setup notes. Once everything refreshes reliably and the charts respond to new selections without lag, the job is done.

If successful , multiple future works in pipeline.
* there will only be one milestone, work completion, nothing in between , no time pass, Either you deliver and get paid or nothing happens.