If you want to aggregate your stocks, bonds or other investments in one place, you might have come across my Stock Portfolio Tracker. Go on and give it a try. It’s FREE and won’t cost you money and you can tweak it to your hearts content. Its embedding my current portfolio updating the price in real time.
Around sometime last year, Google decide to do one round of upgrade for their Google Sheets, Document and Presentation. What happens is that it doesn’t affect your old documents but that, if you create your documents on new platform they have the new functionalities, if you have them on an old platform they still have the old functionalities.
The portfolio tracker is still based off the old Google Sheets, but I have been experimenting with the new one.
As we get to the tail end of 2014, Google have indicated that they will be updating the old workbooks to the new one.
The reason I did not swing over was that some of the functionalities was still not done up yet. However, since Google won’t be going back, I decide to update the links to the new Google Sheet.
For those of you on older Stock Portfolio Tracker, I am not sure how Google will upgrade the sheets. I believe there should be little hiccups so you don’t have to do much.
You can read more here, what is supported and what they are removing:
Upgrading older spreadsheets to new Google sheets
A great performance improvement
What can we look forward to?
For one thing, the performance improvement is immense. In the old stock portfolio tracker, there are some advance formulas. The stock portfolio tracker calculates everything on the fly.
You won’t notice much of a difference but, if you have a 600 row transactions sheet like mine, you will realize it is crawling.
I am happy to say that the new one is much much better. It very much feels more like how Excel will feel. If there needs to be some calculation in the background, you will see a progress bar.
I am sure you will enjoy it.
There are some good improvements listed out:
- New sheets are designed with performance of huge sheets in mind
- Supports 2 million cells data
- Limits removed and no more restricted to 256 columns per sheet
- Filtered Views
- Condition Formatting using custom formula
- Add a color to each of your sheet tabs
- Offline Editing with Google Chrome
So go on give it a try if you have not. I am sure you will enjoy having a portfolio that you can check here and there, and not have to update prices. If you are new to online spreadsheets or are on Microsoft give it a try. I seldom use Office nowadays.
To get started with dividend investing, start by bookmarking my Dividend Stock Tracker which shows the prevailing yields of blue chip dividend stocks, utilities, REITs updated nightly.
- $50,000 Portfolio to Supplement Lifetime Critical Illness Coverage. - June 5, 2023
- The Beauty of Having Low Essential & Basic Expenses - June 3, 2023
- Singapore Savings Bonds SSB July 2023 Yield at2.82% (SBJUL23 GX23070H) - June 1, 2023
Saturday 7th of January 2017
Greetings; Thanks for the sheet; I was wondering if there was a way for the transaction section to auto update the company name when it changes?
Saturday 7th of January 2017
Hi CS, unfortunately i havent found a method to do that. It will be great!
Friday 22nd of May 2015
HELP! How can I fix the function CONTINUE (used on the "Yahoo data ref" page) that is discontinued in the new Google Sheets...?!
Saturday 23rd of May 2015
I took a look at my sheet and although its on the old Google Sheets format it looks ok. Perhaps you can share with me your sheet at [email protected] so that i see what is wrong.
Thursday 6th of November 2014
Thank you very much for putting in so much effort in this Portfolio Tracker. I use it to track my investment portfolio as well.
Friday 7th of November 2014
Thanks. It really makes me happy folks are having good fun with it.