Re: Is it possible to show number of transactions in register report
Martin Blais: As an FYI, in the Beancount query language, you express this using COUNT(): beancount select year(date), month(date), account, count(position) where account ~ 'Expenses:Piano' group by 1, 2, 3 order by 1, 2, 3; I haven't merged it into the default branch yet, but I'm working on documenting it right now in order to merge it and make it available. It would be fantastic to combine the power of SQL and flexibility of ledger files. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Is it possible to show number of transactions in register report
On Tue, Jan 6, 2015 at 5:21 AM, Ivanov Dmitry usr...@gmail.com wrote: Martin Blais: As an FYI, in the Beancount query language, you express this using COUNT(): beancount select year(date), month(date), account, count(position) where account ~ 'Expenses:Piano' group by 1, 2, 3 order by 1, 2, 3; I haven't merged it into the default branch yet, but I'm working on documenting it right now in order to merge it and make it available. It would be fantastic to combine the power of SQL and flexibility of ledger files. I've merged the SQL client two days ago on the 'default' branch of Beancount. Doc is here: http://furius.ca/beancount/doc/query An approach I would recommend is to convert your input file to Beancount, which provides the benefit of inventory booking checks (it's more strict) and dated balance assertions (you don't have to worry about file ordering). From there, you can then automatically convert that file into Ledger format equivalent and use the reports you've become accustomed to. This way you get both set of tools and a much tighter input file with less errors. I'm seeing a few users take this road now. Or... you could port my SQL client to use Ledger's Python interface. I don't think it would be very difficult. It might even be possible to support both backends without forking it. Cheers, -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Further Ledger Development
Nice to have you aboard Alexis! I have no suggestions on bug fixes as my workflow doesn't expose any. On Tue, Jan 6, 2015 at 5:15 AM, Alexis surryh...@gmail.com wrote: Hello everyone, lately I have been providing some patches to Ledger and John was kind enough to help out with valuable feedback, insightful conversations, and allow me access to the official Ledger repository. Thanks John! I am committed to do what I can to move Ledger forward, my main focus is getting rid of the segmentation faults, adding more tests, improving the documentation by covering all available options, and expanding the Python module. John and I have been talking about various aspects and which need more work and I am currently planning what issues should be addressed for the next release (3.1.1). I am uncertain who has a say (apart from John ;) in deciding what bugs should be fixed and which features implemented, so make yourself heard and let's talk about important issues to plan a roadmap. John and I agreed to keep all P1 bugs (8 in total) and moved all P2 bugs to P3, so I can move bugs I feel should be addressed for Ledger 3.1.1 back to P2 and start working on it. Since I'm not yet too familiar with all aspects of Ledger I will also address minor bugs that I think will help me in digging deeper into Ledger's code. I found 23 segmentation fault related bugs in Bugzilla and I would like to set their Status to UNCONFIRMED, then go through them one by one and schedule the ones that can be reproduced with a master build for 3.1.1 and set their Status to CONFIRMED. John and I agreed to follow the git-flowน model for development, which means the master branch will only see updates when a new version is released as of now and development will happen on the next branch, so please make pull request against next from now on. You're more than welcome to help out if you can by contributing patches, going through Bugzilla verifying that bugs are still reproducible, sharing your knowledge so you or someone else can document it, add tests, tell your story with Ledger, share ideas or cool things you've done with Ledger, the community and Ledger will benefit from you contribution. It would be great if we can coordinate our work to gain the most from our joint effort and I invite you to talk to me; I'm afh in #ledger. Thanks, Alexis น http://nvie.com/posts/a-successful-git-branching-model/ https://github.com/nvie/gitflow -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Craig, Corona De Tucson, AZ enderw88.wordpress.com -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Further Ledger Development
Alexis surryh...@gmail.com writes: John and I agreed to follow the git-flowน model for development, which means the master branch will only see updates when a new version is released as of now and development will happen on the next branch, so please make pull request against next from now on. Thanks for all your hard work, Alexis! The only thing I wanted to mention about git-flow, and the reason it was abandoned previously: is that releases were far and few between, and so master was stagnating and everyone was starting to use the next branch directly anyway (thus next became the new master). So I think that if we want git-flow to be successful for us, we should be committed to fairly frequent releases on the master branch, which may likely mean we move to a four-point version number and do point releases on a weekly or semiweekly basis. How does that sound? Essentially, any time you have a build which passes all tests and you think is sane, it's a candidate for a mini-release to master. John -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Balance statement with multiple currencies/commodities
I go about it like this: 2015/01/01 Balance Assets::Stock = 3 AAPL 2015/01/01 Balance Assets::Stock = 5 GOOGL 2015/01/01 Balance Assets::Stock = 3 MSFT And so on for Assets::Cash. It works for me, without complaints from Ledger. I might be running my reports with different options, though. On Tue, Jan 6, 2015 at 6:00 PM, Pascal Fleury fle...@users.sourceforge.net wrote: Hello, I love the multiple currency/commodity that one can have in the accounts. It let's me manage e.g. cash in USD, CHF and EUR, or my stock portfolio with different stock tickers. When reconciling, though, I face an issues when I want to write a balance assertion. Either I'd like to only assert the amount for one currency/commodity, or all of them. I did not find a way to express multiple currencies in a balance statement, and specifying only a single one will let ledger complain that there is more in that account (which is correct). Ideally, something like 2015/01/01 Balance Assets::Stock = (3 AAPL + 5 GOOGL + 3 MSFT) Assets::Cash= (50.00 USD + 25.00 CHF + 15.00 EUR) Alas, this is no valid syntax. Is there a way to assert such balance amounts ? thanks, --paf -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Balance statement with multiple currencies/commodities
Hello, I love the multiple currency/commodity that one can have in the accounts. It let's me manage e.g. cash in USD, CHF and EUR, or my stock portfolio with different stock tickers. When reconciling, though, I face an issues when I want to write a balance assertion. Either I'd like to only assert the amount for one currency/commodity, or all of them. I did not find a way to express multiple currencies in a balance statement, and specifying only a single one will let ledger complain that there is more in that account (which is correct). Ideally, something like 2015/01/01 Balance Assets::Stock = (3 AAPL + 5 GOOGL + 3 MSFT) Assets::Cash= (50.00 USD + 25.00 CHF + 15.00 EUR) Alas, this is no valid syntax. Is there a way to assert such balance amounts ? thanks, --paf -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Balance statement with multiple currencies/commodities
I did this: 2015/01/01 Balance Assets::Stock 0 = 3 AAPL Assets::Stock 0 = 5 GOOGL Assets::Stock 0 = 3 MSFT Assets::Cash0 = 50.00 USD Assets::Cash0 = 25.00 CHF Assets::Cash0 = 15.00 EUR - Harpreet Eli Sangha On Tue, Jan 6, 2015 at 3:13 PM, John West jwes...@gmail.com wrote: I go about it like this: 2015/01/01 Balance Assets::Stock = 3 AAPL 2015/01/01 Balance Assets::Stock = 5 GOOGL 2015/01/01 Balance Assets::Stock = 3 MSFT And so on for Assets::Cash. It works for me, without complaints from Ledger. I might be running my reports with different options, though. On Tue, Jan 6, 2015 at 6:00 PM, Pascal Fleury fle...@users.sourceforge.net wrote: Hello, I love the multiple currency/commodity that one can have in the accounts. It let's me manage e.g. cash in USD, CHF and EUR, or my stock portfolio with different stock tickers. When reconciling, though, I face an issues when I want to write a balance assertion. Either I'd like to only assert the amount for one currency/commodity, or all of them. I did not find a way to express multiple currencies in a balance statement, and specifying only a single one will let ledger complain that there is more in that account (which is correct). Ideally, something like 2015/01/01 Balance Assets::Stock = (3 AAPL + 5 GOOGL + 3 MSFT) Assets::Cash= (50.00 USD + 25.00 CHF + 15.00 EUR) Alas, this is no valid syntax. Is there a way to assert such balance amounts ? thanks, --paf -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Getting Python bindings working when installing ledger from source
Could someone tell me why homebrew boost refuses to build with python? I have tried every incantation I can find and it always builds --without-python. On Tue, Jan 6, 2015 at 3:01 AM, Alexis surryh...@gmail.com wrote: Hello Tim Swanson on Tue, Jan 06, 2015 at 04:38:14AM CET, you wrote: That did it! Thank you. Glad I could help. Enjoy Ledger and its Python module! Both have been very useful to me and are fun to work with. Cheers, Alexis -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Craig, Corona De Tucson, AZ enderw88.wordpress.com -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Further Ledger Development
Alexis surryh...@gmail.com writes: Hello everyone, lately I have been providing some patches to Ledger and John was kind enough to help out with valuable feedback, insightful conversations, and allow me access to the official Ledger repository. Thanks John! I am committed to do what I can to move Ledger forward, my main focus is getting rid of the segmentation faults, adding more tests, improving the documentation by covering all available options, and expanding the Python module. Not very sexy but... more docs! More reporting syntax examples, and real-world scenarios. The docs are a little bit wrong in a few places, but mostly they just need more examples. Larger tutorials (keeping track of stock, working in multiple currencies, etc) would be great, as many of the questions on this list are about that stuff. And thanks for working on it! Coincidentally, my ledger-git Arch package is updating as I type this... Eric John and I have been talking about various aspects and which need more work and I am currently planning what issues should be addressed for the next release (3.1.1). I am uncertain who has a say (apart from John ;) in deciding what bugs should be fixed and which features implemented, so make yourself heard and let's talk about important issues to plan a roadmap. John and I agreed to keep all P1 bugs (8 in total) and moved all P2 bugs to P3, so I can move bugs I feel should be addressed for Ledger 3.1.1 back to P2 and start working on it. Since I'm not yet too familiar with all aspects of Ledger I will also address minor bugs that I think will help me in digging deeper into Ledger's code. I found 23 segmentation fault related bugs in Bugzilla and I would like to set their Status to UNCONFIRMED, then go through them one by one and schedule the ones that can be reproduced with a master build for 3.1.1 and set their Status to CONFIRMED. John and I agreed to follow the git-flowน model for development, which means the master branch will only see updates when a new version is released as of now and development will happen on the next branch, so please make pull request against next from now on. You're more than welcome to help out if you can by contributing patches, going through Bugzilla verifying that bugs are still reproducible, sharing your knowledge so you or someone else can document it, add tests, tell your story with Ledger, share ideas or cool things you've done with Ledger, the community and Ledger will benefit from you contribution. It would be great if we can coordinate our work to gain the most from our joint effort and I invite you to talk to me; I'm afh in #ledger. Thanks, Alexis น http://nvie.com/posts/a-successful-git-branching-model/ https://github.com/nvie/gitflow -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Balance statement with multiple currencies/commodities
Does this also verify that there aren't any other gremlins lying in that account? I think that was the desire for the complete balance check. On Tue, Jan 6, 2015 at 10:13 PM, ELI elip...@gmail.com wrote: I did this: 2015/01/01 Balance Assets::Stock 0 = 3 AAPL Assets::Stock 0 = 5 GOOGL Assets::Stock 0 = 3 MSFT Assets::Cash0 = 50.00 USD Assets::Cash0 = 25.00 CHF Assets::Cash0 = 15.00 EUR - Harpreet Eli Sangha On Tue, Jan 6, 2015 at 3:13 PM, John West jwes...@gmail.com wrote: I go about it like this: 2015/01/01 Balance Assets::Stock = 3 AAPL 2015/01/01 Balance Assets::Stock = 5 GOOGL 2015/01/01 Balance Assets::Stock = 3 MSFT And so on for Assets::Cash. It works for me, without complaints from Ledger. I might be running my reports with different options, though. On Tue, Jan 6, 2015 at 6:00 PM, Pascal Fleury fle...@users.sourceforge.net wrote: Hello, I love the multiple currency/commodity that one can have in the accounts. It let's me manage e.g. cash in USD, CHF and EUR, or my stock portfolio with different stock tickers. When reconciling, though, I face an issues when I want to write a balance assertion. Either I'd like to only assert the amount for one currency/commodity, or all of them. I did not find a way to express multiple currencies in a balance statement, and specifying only a single one will let ledger complain that there is more in that account (which is correct). Ideally, something like 2015/01/01 Balance Assets::Stock = (3 AAPL + 5 GOOGL + 3 MSFT) Assets::Cash= (50.00 USD + 25.00 CHF + 15.00 EUR) Alas, this is no valid syntax. Is there a way to assert such balance amounts ? thanks, --paf -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Balance statement with multiple currencies/commodities
No, this achieves expressing multiple currencies in a single balance statement, but does not achieve verification that only these currencies are present. - Harpreet Eli Sangha On Tue, Jan 6, 2015 at 7:58 PM, Martin Blais bl...@furius.ca wrote: Does this also verify that there aren't any other gremlins lying in that account? I think that was the desire for the complete balance check. On Tue, Jan 6, 2015 at 10:13 PM, ELI elip...@gmail.com wrote: I did this: 2015/01/01 Balance Assets::Stock 0 = 3 AAPL Assets::Stock 0 = 5 GOOGL Assets::Stock 0 = 3 MSFT Assets::Cash0 = 50.00 USD Assets::Cash0 = 25.00 CHF Assets::Cash0 = 15.00 EUR - Harpreet Eli Sangha On Tue, Jan 6, 2015 at 3:13 PM, John West jwes...@gmail.com wrote: I go about it like this: 2015/01/01 Balance Assets::Stock = 3 AAPL 2015/01/01 Balance Assets::Stock = 5 GOOGL 2015/01/01 Balance Assets::Stock = 3 MSFT And so on for Assets::Cash. It works for me, without complaints from Ledger. I might be running my reports with different options, though. On Tue, Jan 6, 2015 at 6:00 PM, Pascal Fleury fle...@users.sourceforge.net wrote: Hello, I love the multiple currency/commodity that one can have in the accounts. It let's me manage e.g. cash in USD, CHF and EUR, or my stock portfolio with different stock tickers. When reconciling, though, I face an issues when I want to write a balance assertion. Either I'd like to only assert the amount for one currency/commodity, or all of them. I did not find a way to express multiple currencies in a balance statement, and specifying only a single one will let ledger complain that there is more in that account (which is correct). Ideally, something like 2015/01/01 Balance Assets::Stock = (3 AAPL + 5 GOOGL + 3 MSFT) Assets::Cash= (50.00 USD + 25.00 CHF + 15.00 EUR) Alas, this is no valid syntax. Is there a way to assert such balance amounts ? thanks, --paf -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Getting Python bindings working when installing ledger from source
Hi Craig, Homebrew features a separate package for boost python, which needs to be installed in addition to boost. % brew install boost boost-python I'm uncertain for what reasons this was done, I think because many people want boost, few boost python and supporting both system Python 2.7.x and Homebrew Python 3.x.x is somewhat of a hassle. Alexis -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: Further Ledger Development
That's exciting news, great work Alexis. -- --- You received this message because you are subscribed to the Google Groups Ledger group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.