How to get current stock price and previous close of a stock from National Stock Exchange

Hi everyone,

Can anyone please help me in creating a macro which will retrieve only the current close and previous close price of a stock from National stock exchange.

I have some hundreds of stocks for which i need current stock price and previous day's closing price.

I have attached the spreadsheet in which column A contains stock symbols, column B contains company name and column C has the link to the National stock exchange for each of the stock and the data has to be retrieved from the same link. An example of the stock price and previous close is attached in the image that i have attached.

I am attaching the spreadsheet as well. Any help is Greatly appreciated. Thank you