beanquery
beanquery copied to clipboard
beancount
A customizable light-weight SQL query tool that works on tabular data, including Beancount.
Add `last_day()` function to retrieve the last day of a given month. Useful for generating monthly reports, when showing e.g. the market value at the end of each month: ```...
I am using cyrillic account names in ledger.beancount: 2020-01-01 open Активы:Bank Account name in terminal ouput looks differently: ...>bean-query ledger.beancount Input file: "..." Ready with ... beancount> balances from year...
it would be super cool to be able to run: ``` bean-query --format=markdown ``` and then continue to convert that to whatever format you need (using pandoc or whatnot). Formatting...
The one argument form of the `parse_date()` BQL function that tries to guess the date format does not seem a great idea as the format used for the conversion depends...
When performing queries, it is often useful to express one of the columns as a percentage of the total. An example I see commonly is reporting on Assets allocation -...
**[Original report](https://bitbucket.org/blais/beancount/issue/237) by Martin Michlmayr (Bitbucket: [tbm13](https://bitbucket.org/tbm13), GitHub: [tbm](https://github.com/tbm)).** ---------------------------------------- Sometimes I want to convert one currency to another at a fixed rate that does not necessarily reflect any actual...
In a mailing list thread https://groups.google.com/g/beancount/c/4EkTUWoLXwI and in beancount/beancount#688 it was proposed to add the possibility of performing arithmetic operations on Amounts. The only operations that make sense are multiplication...