Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Spreadsheet formulas for personal finance

bou.ke

Post reply on HN
Print view View original

31–40 of 123 posts

Re: Spreadsheet formulas for personal finance

#31

Post by basseq »

bouk wrote: post #21
basseq wrote: post #20

Earlier quoted context omitted.

Because I like a challenge: =SUMPRODUCT( (bracket_min bracket_max)*(bracket_max-bracket_min)) ) *bracket_rate ) Where income is your income, bracket_min is the range of bracket minimums, bracket_max is the range of bracket maximums, and bracket_rate is the range of bracket tax rates. Demo on Google Sheets: https://docs.google.com/spreadsheets/d/1z0vx8TJeWr-hbJ3q6E7r...

Really cool! Unfortunately Numbers doesn't support more complicated SUMPRODUCT formulas...

You could do it with a bunch of INDEX-MATCH formulas and pre-calculating base tax per bracket:

  =(income-INDEX(bracket_min,match(income,bracket_min,1)))*
    INDEX(bracket_tax,match(income,bracket_min,1))+
    INDEX(bracket_base_tax,match(income,bracket_min,1))

Re: Spreadsheet formulas for personal finance

#33

Post by jonshariat »

asdff wrote: post #28

I wish it was easier to actually pull information from various banks and accounts. For all of mine, I have to log in to the website and click around some 2006 era website to set a range or dates or something before I can generate a CSV file. It's a ton of friction just to get a look at my financials. I wish I could always have access to updated CSV files without having to spend all this time for each and every accoun…

You can do this with Tiller (https://www.tillerhq.com/), it pulls it down for you.

Also when trying to remember the tiller app, I found that Excel now has this as part of office 365 https://www.theverge.com/2020/6/16/21292642/microsoft-money-...

Re: Spreadsheet formulas for personal finance

#34

Post by dv_dt »

basseq wrote: post #10

I like XIRR to get an actual sense of what my annualized portfolio performance looks like. Pretty much every bank, brokerage, or financial software I've used is "dumb" and will a) count deposits as growth , b) show total lifetime growth, and/or c) ignore deposits. XIRR allows me to better benchmark portfolio performance by accounting for when I deposit (or withdraw) money so I can clearly say, "I'm earning X% per yea…

Also annoying, most stock trackers in brokerages and elsewhere really don’t track dividend payments as performance either.

Re: Spreadsheet formulas for personal finance

#36

Post by shepherdjerred »

asdff wrote: post #28

I wish it was easier to actually pull information from various banks and accounts. For all of mine, I have to log in to the website and click around some 2006 era website to set a range or dates or something before I can generate a CSV file. It's a ton of friction just to get a look at my financials. I wish I could always have access to updated CSV files without having to spend all this time for each and every accoun…

Excel[0] has this functionality built in via Plaid[1]. There are other solutions like YNAB[2] or Wealthfront[3]. I agree with you though. I have a nice python program for understanding my finances, but I still have to manually update bank/credit card/loan balances.

[0] https://plaid.com/blog/microsoft-announcement/

[1] https://plaid.com/

[2] https://www.youneedabudget.com/

[3] https://www.wealthfront.com/

Re: Spreadsheet formulas for personal finance

#37

Post by jplr8922 »

I have an MSC in quant finance, and i'm seriously considering learning Django (in top of my backend skills) to build an complete app for personal finance management.

Key features ; - Budget (aka cashflow management, what am I doing with my paycheck next month?) - Project planning (aka balance sheet, what is the purpose of my inflows and outflows over time?) - End of year results(aka do my projected budget match my projects, and if you want to travel so much why are you spending X amount on alchool?) - Taxes (how do I pay less of them) - Insurance (how do I mitigate common risks, and when should I purchase insurance to protect my projects)

I myself need one app for financial transaction, another for rebalancing my portfolio of ETF, one for doing my taxes, a spreadsheet for my budget, etc. My bank credit card and debit card are managed by two different units which refuse to talk to each other and share information. This is ridiculous.

Re: Spreadsheet formulas for personal finance

#38

Post by edem »

jplr8922 wrote: post #37

I have an MSC in quant finance, and i'm seriously considering learning Django (in top of my backend skills) to build an complete app for personal finance management. Key features ; - Budget (aka cashflow management, what am I doing with my paycheck next month?) - Project planning (aka balance sheet, what is the purpose of my inflows and outflows over time?) - End of year results(aka do my projected budget match my pr…

I want to do the same, but I don't have the math knowledge. I have the programming knowledge though. Do you want to collaborate? Feel free to send a DM if you do.

Re: Spreadsheet formulas for personal finance

#39

Post by et1337 »

jonshariat wrote: post #33
asdff wrote: post #28

I wish it was easier to actually pull information from various banks and accounts. For all of mine, I have to log in to the website and click around some 2006 era website to set a range or dates or something before I can generate a CSV file. It's a ton of friction just to get a look at my financials. I wish I could always have access to updated CSV files without having to spend all this time for each and every accoun…

You can do this with Tiller ( https://www.tillerhq.com/ ), it pulls it down for you. Also when trying to remember the tiller app, I found that Excel now has this as part of office 365 https://www.theverge.com/2020/6/16/21292642/microsoft-money-...

Tiller user here. It’s a brilliant product. They have many different templates that allow you to manage money at the level of detail you want. I tried a ton of different apps and none of them were flexible enough.

My only complaint is that their Google Sheets sidebar UI can be abysmally slow at times, and you have to open it and hit “sync” to load transactions from your financial institutions.

Re: Spreadsheet formulas for personal finance

#40

Post by kachnuv_ocasek »

jplr8922 wrote: post #37

I have an MSC in quant finance, and i'm seriously considering learning Django (in top of my backend skills) to build an complete app for personal finance management. Key features ; - Budget (aka cashflow management, what am I doing with my paycheck next month?) - Project planning (aka balance sheet, what is the purpose of my inflows and outflows over time?) - End of year results(aka do my projected budget match my pr…

Why do you want to pay less taxes?
Post reply on HN