Manual Account for Cyptocurrency

Google Sheets
1

Hi folks! New to Tiller but really liking it so far.

I’m using three manual accounts to track a small amount of three different cryptocurrencies we hold. I’d ideally like to use the GOOGLEFINANCE() function to automatically update the balance for each manual account. However, when I try to add that formula on the Balances page, it breaks the sheet. Wondering if anyone has any suggestions on the best way to update a balance via a formula?

Thanks in advance :slight_smile:

2

A quick and dirty hack until someone suggests a better way: try putting your formula in the hidden Balance History sheet, in the Balance column of the most recent row for the account you’re trying to update.

1 Like
3

That worked great, thanks so much :slight_smile:

4

I did not know I needed this. Thank you!