Spreadsheet Formulas for Personal Finance

1

Plaid

#Personal Finance #Mobile Banking #Other Fin Tech 78 social mentions

2

ProjectiFi

Wow this is like a flashback to my own experiments in Excel, prior to going full mad-scientist for the past 6 months and creating a web app for FI/FIRE planning called ProjectiFi: https://projectifi.io/ I had been using similar functions in parts of my spreadsheet, but as I kept adding more and more nuance and flexibility to the life planning and projection aspects, eventually the formulas just reached such a critical mass that the whole spreadsheet got really painful to maintain. If you feel like kicking the tires on ProjectiFi, I'd be curious to hear your thoughts -- I've been working hard to make everything that had become unwieldy and difficult in Excel for FI planning and experimentation feel more intuitive and straightforward.

#Productivity #Fintech #Personal Finance 12 social mentions

3

GnuCash

For a non-startup personal open source project, you can consolidate all that data in the desktop program https://gnucash.org/ . Offhand, I suspect you could layer all those features you mention, using a mix of GnuCash customizable existing reports, and their (poorly documented) extension in Guile. The UX might not be what you want with just reports and scripting, but you can definitely analyze data and generate arbitrary noninteractive HTML reports, and there's some limited facility for dialogs that way. (For example, the features to help keep an ITOT & AGG ETF portfolio balanced for risk tolerance seems trivial, and it could even have a sense of calendar schedule for periodic rebalancing. But instead of it doing it for you, the UX would probably just be a generated report that shows the balance, and tells you the exact two transactions to rebalance.) Or, alternatively, get into the code of GnuCash itself, and do whatever interactive GUI and maybe even (if very brave/foolish) making your code talk to your brokerage, etc.

#Personal Finance #Accounting #Small Business 38 social mentions

I have been using Lunch Money[0] after it was mentioned here and am pretty happy with it. It took a while for the API[1] to launch but it's in beta at the moment and they're pretty responsive to user feedback. [0] https://lunchmoney.app.

#Personal Finance #Financial Planner #Finance 43 social mentions