LATEST SPREADSHEET CORNER ARTICLE:
How to Track Mutual Funds in Google Sheets
March 19, 2016
Google Sheets is an online cloud-based service that allows users to create, edit and collaborate on spreadsheets online and offline.
I covered Google Sheets in a previous Spreadsheet Corner article, Alternatives to Excel. I also created a stock portfolio tracker using Google Sheets. In this article, I illustrate how to use the Google Finance capabilities within Google Sheets to access mutual fund data.
You’ll need to upgrade to a newer browser version to access all your files in Drive. In terms of operating systems, Google Drive currently works with Windows XP and above, Lion 10.7 (for Mac) and above. It doesn’t work with Linux operating systems, but Google suggests that Linux users can use Google Drive on the Web at drive.google.com or through the Google Drive application. For an updated list of accepted browsers and operating systems, go to Google’s help page on System Requirements and Browsers.
An overview of Google Sheets spreadsheet app as well as a portfolio tracker created with Google Sheets that automatically retrieves financial information for portfolio tracking and watchlist construction.