Using Google Sheets to Track a Stock Portfolio
You can use the GOOGLEFINANCE() function in Google Sheets to fetch current or historical securities information from Google Finance.
In Google Sheets, simply enter the following formula in a spreadsheet cell:
=GOOGLEFINANCE(“symbol”; “attribute”)
More information is available at Google support.
This sample Google Finance Portfolio uses the GOOGLEFINANCE() function to retrieve market data. Check it out and provide us with feedback.