Tracking your investments with Google Sheets Google Sheets has a nifty little function called GOOGLEFINANCE, which allows you to monitor a stock’s status and historic movements in real-time.