How to get stock price in google sheets

How do you use Google Sheets to pull stock prices automatically?

You can use the GOOGLEFINANCE function in Google Sheets. For example, =GOOGLEFINANCE(“NSE:INFY”) will fetch the current price of Infosys from the NSE. Replace the symbol as needed for other stocks.