Looks like you could use an API - there's one that connects to Yahoo for example: Yahoo Finance Stock Market Data API - Alteryx Community
Otherwise if there's an API that you currently use (i.e. it looks like there are URLs in your Excel), then perhaps you can use those. Looks like there is one for your specific site: Developer APIs | 5paisa
your brokerage account probably has an api for stock prices. you should be able to follow the instructions they provide to authenticate and access stock prices.