Want to track your portfolio with the list amount of effort?
Setup a Google Sheet with the information you want (here’s the landing page for the template we use for the Elephant’s Paycheck, you can save a copy and edit it for your own needs).
The reason I use Google Sheets is because it makes it easy to incorporate live market data through a formula.
What is live market data?
I want to choose my words carefully. It’s not ‘real time’ market data. The information is delayed about 15–20 minutes. This has to do with data licensing, and goes beyond the scope of this post. If you’re tracking how you’re doing, but not trading, the small delay is not a concern.
What I mean by ‘live market data’ is that it updates automatically without having to constantly update the price of the companies you own.
What’s the formula?
Here’s the formula to enter the price of a stock into the cell on a Google Sheet:
Just copy that as is into a cell and change AAPL to your ticker symbol.
There’s a lot more you can do with this formula beyond fetching the current price. Head over to the Google help page if you want more.