Spreadsheet formulas for personal finance • Hacker News Board

Re: Spreadsheet formulas for personal finance

#121

Post by jonshariat » Mon, Aug 09, 2021, 5:04 PM UTC

asdff wrote: post #119

jonshariat wrote: post #33

Earlier quoted context omitted.

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-...

Can I automate with their service? I don't care about their spreadsheet templates, I just want to have a CSV to play with in a local directory that I can update with a cron job.

Its been a while but yes you could at least use the sheet as your db intake, they might also have other, cleaner options, but it does pull it down on a regular basis automatically, you dont need to trigger each time.

Re: Spreadsheet formulas for personal finance

#122

Post by basseq » Tue, Aug 10, 2021, 8:40 PM UTC

taviso wrote: post #78

basseq wrote: post #31

Earlier quoted context omitted.

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))

Clever, but I'm curious why you don't use VLOOKUP? It's simpler, and Lotus 1-2-3 doesn't have MATCH! :-) I think something like this would work... (income-@VLOOKUP(income,table,1))*@VLOOKUP(income,table,3)+@VLOOKUP(income,table,5)

Habit, mostly: I tend to use VLOOKUP for exact matches and MATCH for relative ones.

Re: Spreadsheet formulas for personal finance

#123

Post by FabHK » Wed, Aug 18, 2021, 9:47 AM UTC

scubakid wrote: post #87

zelphirkalt wrote: post #81

Earlier quoted context omitted.

Could you make it so that there is not only a blank page, in case one does not enable JS blindly on every never before visited website?

Good call, I should have thought of that.

Thanks, I also tend to have JS disabled, and saw that you added a note now.