Excel Indian Stock Updater

My trading sheet already holds each NSE/BSE symbol, the recommended buy price, the actual buy price and its stop-loss. The only piece missing is a quick way to fill the Current Market Price column and have Excel immediately show the unrealised profit or loss for every position.

Here is what I need built:

• A macro, add-in or small script that I can trigger on demand (one click or a shortcut key).
• On execution it should fetch the latest CMP for every symbol in the sheet from a reliable source that covers Indian equities. I am open to your guidance on whether that is a free financial API, a paid endpoint, or a lightweight scrape of NSE/BSE data—whichever is stable and within fair usage limits.
• Once prices are pulled, the tool writes them into the designated column, updates the P/L calculation for each row (₹ value and percentage), and optionally flags any position whose CMP is at or below the stop-loss.

You are free to use VBA, Power Query, Python, or another method that works inside Excel 2016 on Windows. Please keep the code well commented and include a short read-me so I can adjust symbols or expand the spreadsheet later.

Deliver the working file and the source code, along with brief setup instructions. After that I will test it with my live portfolio to confirm the CMPs and calculations update correctly.

Sample XL. https://docs.google.com/spreadsheets/d/1Se6QmoC2qEF3t4i7GpGfky69NbFqzYu6MWjbhIFc4oQ/edit?usp=sharing