6 ms·
A Python-Powered Budget Spreadsheet
- conductr 13y ago"Now to get Excel to talk to eBay…" Should just use python for that too.
- estebank 13y agoYou 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, LibreOffice has support for Python macros. [1]: http://www.resolversystems.com/products/resolver-one/ http://www.resolversystems.com/products/resolver-one/ [2]: http://www.resolversystems.com/eol.php http://www.resolversystems.com/eol.php
- mwexler 13y agoNot sure why estebank's comment was downvoted; Resolver One was truly awesome. DataNitro's stuff is also interesting, but it's a different approach, and Resolver One's model and work shouldn't be forgotten.
- nonchalance 13y ago> Not sure why estebank's comment was downvoted I gave an upvote. I suspect others downvoted the comment because it spoke well of Resolver One, which is competing in the same space as DataNitro (a YC company).
- rufugee 13y agoAre there docs on python macros for LibreOffice? I'm having trouble tracking them down if there are...
- nonchalance 13y agohttps://help.libreoffice.org/Common/Scripting https://help.libreoffice.org/Common/Scripting
- rufugee 13y agoThanks, 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.
- nonchalance 13y agohttp://wiki.openoffice.org/wiki/Python_as_a_macro_language#Script_coding 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 :)
- rufugee 13y agoGreat...thank you!
- wffurr 13y agoAlso the PySpread project which is still active: http://manns.github.io/pyspread/ http://manns.github.io/pyspread/
- pudquick 13y agoLove seeing your posts, but would appreciate when I see 'em here, especially when posted by a founder, some mention of your YCombinator Summer 2012 status and backing.
- fredsanford 13y agoYup. Let us know when you're slashvertising...
- padobson 13y agoPersonal 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?
- willis77 13y agoIt 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?
- padobson 13y agoBut 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.
- cdcarter 13y agoYNAB is the best option I have found.
- chc 13y agoBecause 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.
- mbucc 13y agoActually, 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).
- jessaustin 13y agoThere 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.
- ris 13y agoWhen will people learn that gaussian blur is not a secure redaction method?
- hadem 13y agoEvery screenshot is blurred. Could fake data not have been used for demonstration purposes?
- cormac70 13y agoYeah, but blurring the screenshots was quicker ;-)
- richardlblair 13y agoThe string concatenation in this make me want to cry...
- cormac70 13y agoOh dear! Sorry to hear that... looking it up I find my method described as 'naive appending', oops! Still, efficiency is of absolutely no importance in this application, and as I said in the post, I'm new to Python...
- OMGWTF 13y agoWhat does "Share scripts with up to 4 users" (Enterprice License) mean?
- karamazov 13y agoIn 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.