Re: BQL: monthly balances of account(s)

On 24/03/25 11:51, Floris Kruisselbrink wrote: Op zaterdag 22 maart 2025 om 13:22:52 UTC+1 schreef Vasily M: It relies on a more recent version of https://github.com/beancount/ beanquery that contains the ```date_bin``` function: I can onl

Re: BQL: monthly balances of account(s)

On 24/03/25 21:13, Chary Ev2geny wrote: date_bin is available in the current github directory https://github.com/beancount/beanquery you shall be able to install it like this: git clone https://github.com/beancount/beanquery.git cd beanquery python -m pip install . Or simply: python -m pip

Re: BQL: monthly balances of account(s)

date_bin is available in the current github directory https://github.com/beancount/beanquery you shall be able to install it like this: git clone https://github.com/beancount/beanquery.git cd beanquery python -m pip install . On Monday, March 24, 2025 at 11:51:19 AM UTC+1 Floris Kruisselbrink

Re: BQL: monthly balances of account(s)

Op zaterdag 22 maart 2025 om 13:22:52 UTC+1 schreef Vasily M: It relies on a more recent version of https://github.com/beancount/beanquery that contains the ```date_bin``` function: I can only find one released version of beanquery, version 0.1.0 from november 2024. Looked on pypi and in the

Re: BQL: monthly balances of account(s)

Hi, To add a bit of information on more general case, I recently finally found a way to generate weekly net worth / account balance reports I needed. It relies on a more recent version of https://github.com/beancount/beanquery that contains the ```date_bin``` function: SELECT date_bin(

Re: BQL: monthly balances of account(s)

hello, thank you for this as it gave me a reason to finally get a networth bash alias figured out that i could use in my day-to-day beancounting. :) i really needed a replacement for the bean-report in v2 before i could switch to v3 only. i also need one for the bal bean-report but that isn

Re: BQL: monthly balances of account(s)

Hi, this is a query I use to get a Net Worth at a certain date, grouped by account query = f""" SELECT account, convert(SUM(position),'{currency}',{date_iso}) as amount where date <= {date_iso} AND account ~ 'Assets|Liabilities' """ Net worth is being defined as a sum of balanc