Stocks/Bonds Mix

Over the years I have accumulated a few stocks here and a few bonds there, across various accounts.

Is there a Google Sheet to aggregate my total mix of stocks & bonds? I 'm envisioning a sheet where I can enter the percentage of stocks or bonds for each account, then the sheet will sum up the total, e.g. “Portfolio is 65% stocks, 35% bonds.”

I like this idea. I’ve seen it on other tools or for specific Financial Institution interfaces but I would also love something like this in a template.