From the previous videos, I went over how to retrieve stock data information in Google Sheets using the GOOGLEFINANCE function. And in this video, I want to follow up on how we can auto-refresh stock data/price every minute/hour by enable one single setting.

Google Sheets has a built-in function called GOOGLEFINANCE which fetches current or historical securities information from Google Finance platform. Instead of paying $15 to $20 for a 3rd party subscription service to access different finance data, Google Sheets’s GOOGLEFINANCE function makes the information available for FREE.

GOOGLEFINANCE function doc: https://support.google.com/docs/answer/3093281?hl=en

Subscribe: https://www.youtube.com/channel/UCvVZ19DRSLIC2-RUOeWx8ug

#google-sheets #googlefinance