Update Specific Mutual Fund Balance in Cell

Google Sheets
, ,
1

Is it possible to create a sheet that tracks the balance of specific mutual funds within an investment account?

For example,

Account # CashBalance MutualFund1Balance MutualFund2Balance Etc.
Account 1 $5,000 $7,000 $8,000 Etc.
Account 2 $6,000 $8,000 $9,000 Etc.

2

The only data available via Tiller are account balances and transactions, both in dollars. To generate the report you want, Tiller would also have to report share quantities and ticker symbols.

You could create it by manually tracking your shares and using the GOOGLEFINANCE function:

There are some previous discussions that might point you in helpful directions, and you can add your vote to the request thread to report the necessary data.