Live data from Hacker News

A Python-Powered Budget Spreadsheet

datanitro.com

21–30 of 37 posts

Re: A Python-Powered Budget Spreadsheet

#21

There were times in my life when I would have loved to have had this, but nowadays I rarely see spreadsheets (not just excel, but the concept in general) as much of a solution to anything.

spreadsheets power pretty much everything I see when I turn my head around. Dunno why you think the opposite. You're the first person I see to say something like this.

Re: A Python-Powered Budget Spreadsheet

#22
post #15

Earlier quoted context omitted.

Thanks, but as far as I can tell that just shows you how to launch scripts/macros in various ways (menu item, etc). However, it doesn't document what you can do with the macros...coding conventions...interacting with data...etc.

http://wiki.openoffice.org/wiki/Python_as_a_macro_language#S... has a sample hello world script that can be run as a macro But I agree in general that the documentation is paltry. Good opportunity for an interested person to do some more digging, write a few blog posts and possibly contribute to the documentation :)

Great...thank you!

Re: A Python-Powered Budget Spreadsheet

#25
post #14

Personal finance software is probably one of the most commonly attacked problems in the development world, and yet there are still a ton of people just building custom spreadsheets. I've tried Quicken and Mint and PageOnce (now called Check) and a number of other things, and I've still found that the best solution for me is a mix of GnuCash and Spreadsheets. Why hasn't this problem been solved yet?

Because there isn't one problem with one solution? Case in point: I think most people would not find that the best solution for them is GnuCash and Spreadsheets.

Actually, discovered ledger-cli here last week (thanks HN). It's amazing. Abstracting currency to the concept of commodity + price files makes it trivial to track your shares in 401k, and have the current market value print on the balance report. Handles lots. Recurring transactions support period specifications like "every two weeks starting on 2013/10/01". Maps payee's to accounts, and supports payee aliases. Pretty much anywhere you type a string you can also use a regex. State is a text file and the program does not alter state; just reads it and prints out a report. Finally, it provides a CSV convert which makes it easy to convert an export from your bank to a list of double entry transactions (./convert bk_download.csv >> trx.dat).

Re: A Python-Powered Budget Spreadsheet

#26

Personal finance software is probably one of the most commonly attacked problems in the development world, and yet there are still a ton of people just building custom spreadsheets. I've tried Quicken and Mint and PageOnce (now called Check) and a number of other things, and I've still found that the best solution for me is a mix of GnuCash and Spreadsheets. Why hasn't this problem been solved yet?

It hasn't been solved because it's not one problem. People have different wants and needs and expectations and banks and tax codes and tolerances for entering data, and are lazy when it comes to testing existing options. Why spend hours searching and signing up for trials and learning new UIs when they know how to make a spreadsheet that does what they want?

But isn't the main purpose of personal finance to influence spending decisions? An ideal solution simply just answers the question "Can I afford to X?"

I've not used any software that helps solve that problem in an elegant way, and maybe I'm just minimizing the problem, but it seems like every path to answering that question is simple arithmetic provided you know what other expenses you have in addition to X.

Re: A Python-Powered Budget Spreadsheet

#27

Personal finance software is probably one of the most commonly attacked problems in the development world, and yet there are still a ton of people just building custom spreadsheets. I've tried Quicken and Mint and PageOnce (now called Check) and a number of other things, and I've still found that the best solution for me is a mix of GnuCash and Spreadsheets. Why hasn't this problem been solved yet?

For me - data entry. Form-based software takes too long to fill out. With a spreadsheet, I can import csv files or copy and paste data easily. Developers often talk about Excel being misused as a database, and I think the root cause is the same - spreadsheets provide a very friendly user interface for adding and editing data.

Re: A Python-Powered Budget Spreadsheet

#29

Earlier quoted context omitted.

It hasn't been solved because it's not one problem. People have different wants and needs and expectations and banks and tax codes and tolerances for entering data, and are lazy when it comes to testing existing options. Why spend hours searching and signing up for trials and learning new UIs when they know how to make a spreadsheet that does what they want?

But isn't the main purpose of personal finance to influence spending decisions? An ideal solution simply just answers the question "Can I afford to X?" I've not used any software that helps solve that problem in an elegant way, and maybe I'm just minimizing the problem, but it seems like every path to answering that question is simple arithmetic provided you know what other expenses you have in addition to X.

YNAB is the best option I have found.

Re: A Python-Powered Budget Spreadsheet

#30
post #28

What does "Share scripts with up to 4 users" (Enterprice License) mean?

In addition to our regular license, we have a read-only license that lets people run (but not edit) scripts. An Enterprise license lets you give up to 4 people in your organization read-only licenses.
Post reply on HN