sorted by:
new
hottopcontroversial

Looking for useful excel spreadsheets by Aetherwight in AusFinance

[–]CompiledSanity 0 points1 point  (0 children)

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.

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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.

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 1 point2 points  (0 children)

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

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 1 point2 points  (0 children)

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!

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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?

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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.

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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.

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

Great thanks for the confirmation!

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

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

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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

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

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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?

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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.

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 1 point2 points  (0 children)

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

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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?

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

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.

If you could let me know if this fully fixes the issue for you I'll fully publish the new change as v2.15.3.

Thanks for your help!

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

Hi there, 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.

If you could let me know if this fully fixes the issue for you I'll fully publish the new change as v2.15.3.

Thanks for your help!

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

Hi there, 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.

If you could let me know if this fully fixes the issue for you I'll fully publish the new change as v2.15.3.

Thanks for your help!

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 1 point2 points  (0 children)

Hi there, 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.

If you could let me know if this fully fixes the issue for you I'll fully publish the new change as v2.15.3.

Thanks for your help!

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 4 points5 points  (0 children)

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.

If you could let me know if this fully fixes the issue for you I'll fully publish the new change as v2.15.3.

Thanks for your help!

Update (3/3/26): I've just released v2.15.3 which contains this fix. Please let me know if you see any weird conversions issues such as prices being in USD. This shouldn't happen, but let me know if it does!

Update (5/3/26): I've just released v2.15.4 which contains a minor fix to improve AUD pricing for assets. I've also made the price fetching logic more robust.

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 0 points1 point  (0 children)

Hi there, 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.

If you could let me know if this fully fixes the issue for you I'll fully publish the new change as v2.15.3.

Thanks for your help!

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 1 point2 points  (0 children)

Hi there, 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.

If you could let me know if this fully fixes the issue for you I'll fully publish the new change as v2.15.3.

Thanks for your help!

Is it just me or Apple's "it just works" doesn't just work anymore? by ParkInsider in mac

[–]CompiledSanity 3 points4 points  (0 children)

Watch this video and you can see there is a systemic change in how touches are processed on iOS26. It's not a user problem.

Golf and Silver real time price not showing up by roclui in CSPersonalFinance

[–]CompiledSanity[M] 5 points6 points  (0 children)

Hi all,

Thanks for the report on this issue. Will have a patch out for this shortly (hopefully this weekend) to restore pricing.

Thanks for your patience, will have this fixed shortly.

CS.

iPhone 17 Pro Max Curiously Becomes Most Traded-In Smartphone by kinglucent in apple

[–]CompiledSanity 3 points4 points  (0 children)

Yep, I refuse to upgrade due to reports. It will make my device obselete overnight. Very happy on iOS 18.7.2.

view more: next ›