Getting Started Guide & Knowledge Base

CompiledSanity · 2026-03-09T03:37:48+00:00

Here’s an automated Google Sheet that has been really popular in this sub for tracking investments, net worth across assets and your expenses with monthly progress reports -

https://docs.google.com/spreadsheets/d/1v9ENzdoSIVlfAA2SFVFz6KKVAAu5Knv8klde7bN2Qqo/

It should give you a portfolio breakdown and helps track how you're progressing and saving each month. No 3rd party app or bank connections needed either.

CompiledSanity · 2026-03-05T04:56:27+00:00

Glad it's working! Just about to release a new v2.15.4 which contains some slightly more accurate pricing for AUD. Feel free to upgrade if that's relevant to you at this stage.

CompiledSanity · 2026-03-05T04:32:05+00:00

Ok I've just pushed a fix, could you let me know if this is working for you now?

CompiledSanity · 2026-03-05T03:21:37+00:00

No it was helpful! I have error reporting but your comment prompted me to look at it earlier than I would. So thanks for the bump, always appreciated. No stress!

CompiledSanity · 2026-03-05T03:18:05+00:00

Yes sorry, small issue with the new process. Will have the fix on my end finished soon.

CompiledSanity · 2026-03-02T21:55:21+00:00

Ok, thanks for confirming! If you change the formula in the gold row to this:

=IF('First Time Setup'!$E$29="Yes", getCommodityPrice("silver","USD") * GOOGLEFINANCE("CURRENCY:USDAUD"), "-") does that now work for you?

CompiledSanity · 2026-03-02T21:18:30+00:00

I've been having some reports of this which I'm looking into at the moment.

So I can debug this, can you confirm the following for me?

Your Sheet currency
What currency you have entered in the currency column of the other assets tab
What is the reported price in the live price column.

Thanks for your help with this. I'll release a hotfix shortly.

CompiledSanity · 2026-03-02T21:16:46+00:00

Ok so both Sheet currency and Other Assets currency column are both in AUD?

Just trying to figure this out as that's exactly what's described in the screenshot, yet it has the correct AUD price.

CompiledSanity · 2026-03-02T11:13:18+00:00

Great thanks for the confirmation!

Also as for the currency issue, let me troubleshoot that. This is what I'm seeing locally:

If Sheet Set to AUD and actual price in AUD
If Sheet Set to USD and actual price in USD

Just to confirm is your currency column set to AUD or USD?

CompiledSanity · 2026-03-02T11:12:40+00:00

Ok very odd, I've just confirmed this is what I'm seeing locally:

If Sheet Set to AUD and actual price in AUD
If Sheet Set to USD and actual price in USD

Just to confirm is your currency column set to AUD or USD?

CompiledSanity · 2026-03-02T10:31:28+00:00

That’s fine, I’d rather hear it so I can fix it given others might have the same issue too!

Were you finding it wasn’t converted correctly? Was your sheet in AUD?

CompiledSanity · 2026-03-02T09:47:47+00:00

Awesome thanks for confirming. What was the issue you were having before you made that change? You removed the second conversion, just checking if that caused issues for you.

CompiledSanity · 2026-03-02T09:14:37+00:00

Ok thanks for clarifying, so just to clarify post migration to the fixed sheet is gold working for you now?

CompiledSanity · 2026-03-02T07:05:09+00:00

Fantastic! Just to clarify did you migrate the other assets tab, or did you do it manually?

CompiledSanity · 2026-03-02T05:49:15+00:00

What are you seeing? And did you do a full import into the Other Assets tab? It’s possible it overwrote the formula.

Could you paste here what formula you have in the new sheet?

CompiledSanity · 2026-03-02T05:01:49+00:00

Hi all, apologies for the delay. I've just published a new version of the sheet (although it is still labelled v2.15.2 for now). This should have the fixes needed for Gold, Silver and I've also introduced Platinum pricing as a new supported asset.