Stock Portfolio Tracker in Google Docs Spreadsheet

One of the best ways to manage your money is to use a spreadsheet program such as Excel or Google Docs to create a personal portfolio tracker.

For people who are used to Excel, there was a great plugin called MSN MoneyCentral Stock Quotes Add-in which worked great for many people. However over the past few weeks the plugin doesn’t work. There is a new Stock Quotes in Excel Plugin that is working well for people. This plugin comes at a small cost but is worth purchasing. There is a 25% discount exclusively for FinanceTrain users. Get the Stock Quotes in Excel Add-in.

However, if you don’t want to spend and are open to moving from Excel to Google Spreadsheets, then you’re in luck. Google Spreadsheets come with in-built functions to help you get stock quotes and build a reliable stock portfolio. The spreadsheet gets updated automatically and can be downloaded on a need basis.

One of our readers, Roger, was kind enough to share a copy of his stock portfolio tracking spreadsheet that he built using Google Spreadsheets.

You can access the spreadsheet from the below link:

https://docs.google.com/spreadsheet/ccc?key=0AvwJ4YKNr03kdG9FbkpVY3JacEd3dnJOZXhHSU81SFE#gid=3

You need to have a Google account to use it. To save a copy into your own account, follow the following steps.

Once saved, you can modify the spreadsheet as you wish to suite your requirements.

You can also read this interesting blog post about Alternative Stock Quotes Solutions.

Membership
Learn the skills required to excel in data science and data analytics covering R, Python, machine learning, and AI.
I WANT TO JOIN
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Saylient AI Logo

Take the Next Step in Your Data Career

Join our membership for lifetime unlimited access to all our data analytics and data science learning content and resources.