Building Automated Excel Models Linked to Live Market Data

An advanced build course for investors and active traders who already live in Excel and are tired of copy-pasting prices. You will design models in three layers (raw data, calculation engine, output), then feed them from real sources: Excel Stock Data Types and STOCKHISTORY, Power Query pulls of NSE bhavcopy, AMFI NAVs and RBI rates, and real-time broker feeds from Zerodha Kite Connect through Python. On top of that data you will build five working models: a live peer valuation sheet, a reverse DCF that recalculates implied growth as the price moves, a Nifty options chain with Black-Scholes Greeks, a rolling portfolio risk dashboard, and a position sizing calculator. Finally you will automate refreshes, snapshots and alerts with VBA, Office Scripts and Python, and harden the whole thing with audit checks, performance tuning and a maintenance playbook for corporate actions and index changes.