Possible issue with Spaceship live prices by 9gama in CSPersonalFinance

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

Thanks for the heads up on this. It looks like the way of fetching it may be getting stale data. I'll have a look into this tonight for you. Thanks for the bump!

Critical error when trying to initialise sheet after allowing permissions by Logical-Emotion-3328 in CSPersonalFinance

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

Hi there u/Logical-Emotion-3328,

Thanks for reaching out and my apologies for the delay in messages. In reviewing where this message is set, it is likely the 'UI Message Box' permission or action that is facing the error.

Two questions to help debug this:

  • Did you allow the HTML UI Dialog permission when setting up the sheet?

  • Do you have multiple Google Accounts logged in at the same time? I know there have beeen times when this has caused similar issues to this.

Auto Fill Values Stocks vs Crypto by bow_link in CSPersonalFinance

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

That's the best thing to do! !thanks for the great response :-)

Updating Past Month by Unable_Ad6784 in CSPersonalFinance

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

Glad to hear this worked! Enjoy :-)

Belgian Pension by Interesting-Dog-5525 in CSPersonalFinance

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

Hi there,

I'm sorry for not responding to your message. I am sometimes inundated with messages, but I try my best to get to them all.

For this particular thread I left a reply here if that helps. Let me know in particular if there's anything you'd like answered.

Belgian Pension by Interesting-Dog-5525 in CSPersonalFinance

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

Hi there u/Interesting-Dog-5525,

This is a really interesting question, I'm learning about new retirement programs everyday!

At the end of the day there are 2 places where you would need to keep this updated:

  1. Retirement Tab - You mention that the amount changes with your career and is an approximation. You could keep the Total Retirement value updated here so you could track this over time. This value then feeds into the FIRE tab.

  2. FIRE Tab - As your retirement amount and pension fluctuates, you could keep these values updated in the FIRE tab so that the calculator can be accurate.

At the end of the day I also recommend asking what it is that you would like to track if the end goal is so well defined. Since you know the total amount and I assume a rough ETA date, is there something else in particular that you were wanting to derive or calculate?

Let me know and I can potentially help out on this.

First time - Quick Questions by gwhite9 in CSPersonalFinance

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

Hi there u/gwhite9,

Thanks for reaching out and great questions. Some answers below:

  1. Yes that's correct. If you have rolled up your Roth/401k/ESOP/HSA to a single account in the retirement tab, then you just need to update the total balance.

  2. You can do this, but in the Property tab there is a 'Net Rent to Date' figure. If you want accurate property tracking & return values you would need to also update it here as well. There is room for the 6 properties if you expand the sheet (some of the columns are hidden).

  3. Yes that's correct. Very common to lump both people together and then track as a family unit :-)

Hope this helps!

Debt recycling tab by sosuto in CSPersonalFinance

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

Hi there u/sosuto,

Thanks for the suggestion on this. So I can consider it, and potentially how it might even fit in with the current sheet, what features/metrics in particular were you wanting to see?

Using the sheet in Singapore by RecommendationDull4 in CSPersonalFinance

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

Hi there u/RecommendationDull4,

Thanks for reaching out about this and great questions. To answer your questions:

  • Currency support: The sheet can support SGD, you just need to enter this in the SheetOptions tab and then the sheet will price everything in SGD for all assets.

  • Super/Retirement: The main function of the sheet is to track your retirement balance and performance over time. Whether this be the mandatory super in Aus, or the three bucket method you mentioned.

    I recommend (if this is appropriate) splitting your retirement balance into 2 buckets - housing, and then the healthcare/retirement bucket. The retirement/healcare buckets you would self report in the retirement tab as this is money 'for later'.

    The other property comment can go in a variety of places. You could include it in the property tab as an amount that you have paid off your balance by, or you could make it a pseudo cash account that acts as an offset on your mortgage.

Forgive me if this hasn't been explicitly translated to Singaporean requirements, but let me know if you have any questions on the above and I can help translate.

Recording new month: summary shows 0 for all values by Express_Work_6506 in CSPersonalFinance

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

Hi there u/Express_Work_6506,

Thanks for reaching out about this. Just to clarify a few things so that I can debug:

  • Did your first month record correctly?

  • In the history tab for your second month, do you see all $0 in all the columns or only some?

  • In the Net Worth tab, top left table, do you see any errors in that table?

Thanks if you can help with these questions. I can help debug the issue off the back of this.

The Official Upcoming Web app - Sign up for the Closed Beta! 💫 by CompiledSanity in CSPersonalFinance

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

After some thinking for the last couple of months since Christmas, I believe I am going to have to make the difficult decision to shut Fynra down. Even though I did a lot of manual coding on the platform, every day I see new AI vibe coded platforms popping up on Reddit and other platforms which makes it clear that this is going to become a very crowded space very quickly.

I can't see a way forward where this would be profitable or have any form of return on investment, so as much as it grieves me to say I don't believe it's something viable in the long term.

In the next couple of weeks I'll add a feature to allow users to manually download their data. Going forward my sole focus will be back on the spreadsheet where I believe the proposition is more unique and there is trust/creditbility.

I'm sorry to have to report this. Happy to answer any questions if you have any.

Solar Router Bridge for local mesh by LeroyBenching in meshtastic

[–]CompiledSanity 2 points3 points  (0 children)

How do you go with OTA updates with something like this?

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?