Live data from Hacker News

A Python-Powered Budget Spreadsheet

datanitro.com

11–20 of 37 posts

Re: A Python-Powered Budget Spreadsheet

#11
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?

Re: A Python-Powered Budget Spreadsheet

#12
post #10
post #5

You could also use Resolver One[1], which sadly is no longer in development[2]. It is a commercial spreadsheet written in IronPython that uses (almost?) vanilla python files as documents. Needless to say it is extremely scriptable. I'd love to take a stab at making a lite version in QT or wxPython running in CPython... Sadly, I've gotten too used to Google Spreadsheets to really need a desktop version Also, of course…

Are there docs on python macros for LibreOffice? I'm having trouble tracking them down if there are...

https://help.libreoffice.org/Common/Scripting

Re: A Python-Powered Budget Spreadsheet

#13

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?

Re: A Python-Powered Budget Spreadsheet

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

Re: A Python-Powered Budget Spreadsheet

#15
post #10

Earlier quoted context omitted.

Are there docs on python macros for LibreOffice? I'm having trouble tracking them down if there are...

https://help.libreoffice.org/Common/Scripting

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.

Re: A Python-Powered Budget Spreadsheet

#18
post #15

Earlier quoted context omitted.

https://help.libreoffice.org/Common/Scripting

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

Re: A Python-Powered Budget Spreadsheet

#19

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?

I've discussed this at length elsewhere, so here's my abridged opinion.

The main issue is that a "mainstream" personal finance app must have the following two features:

- Automatic download of financial transactions

- Intelligent categorization from "STBCKS3134" to "Starbucks [Dining]"

Any tool that doesn't have those two features is doomed to be "niche"... used only by people who actually enjoy and/or are disciplined enough to enter their own data regularly.

In short, we need a "Twilio for personal finance" so that people can build creative solutions and not have to reinvent the wheel. There are startups out there that are trying to solve this.

Re: A Python-Powered Budget Spreadsheet

#20
post #5

You could also use Resolver One[1], which sadly is no longer in development[2]. It is a commercial spreadsheet written in IronPython that uses (almost?) vanilla python files as documents. Needless to say it is extremely scriptable. I'd love to take a stab at making a lite version in QT or wxPython running in CPython... Sadly, I've gotten too used to Google Spreadsheets to really need a desktop version Also, of course…

Also the PySpread project which is still active: http://manns.github.io/pyspread/
Post reply on HN