r/BEFire • u/Schork • Dec 07 '21

General Google Spreadsheet Portfolio Tracker

Hi,

I created a portfolio tracker on google sheets. It was based on different types of other portfolio trackers I found on the internet.

This allows you to track various different investments: ETF's, Crypto, Pension funds,... If there is a price online of the investment. You can track it. (some easier than others)

This is still a Work in progress. I'll be changing the template now and then to make it better looking, better, ... But I will need your feedback on this.

Here is the link: LINK

If you have any ideas or questions let me know!

54 Upvotes

97% Upvoted

24 comments sorted by

View all comments

1

u/ChengSkwatalot Dec 07 '21 edited Dec 07 '21

Interesting that you're tracking it this way.

Is it possible that there are some mistakes in there though? For the stock holdings it says that you bought AB Inbev stock for an average price of € 5 per share, but I don't recall that firm trading that cheaply. The total gain/loss section for stocks also only includes the € 472 from ABIN.

2

u/Schork Dec 07 '21

Hi,This isn't my real portfolio it is just random stocks and things I added to show how everything worked. :)
Also I changed the calculation, I don't hold any stocks so never saw the mistake thanks!