Thank you Dan for the insights, I will continue using single queries
without any issues. Thanks for the help!
Andrea
Il giorno martedì 5 marzo 2024 alle 00:22:14 UTC+1 dan...@grinta.net ha
scritto:
> On 03/03/24 23:16, Andrea Vidali wrote:
>
> > Which outputs multiple balances for each line
On 03/03/24 23:16, Andrea Vidali wrote:
Which outputs multiple balances for each line
You have one balance per row, as expected. However, each balance
contains amounts in different commodities, presented separated by a comma.
The `balance` column in beanquery is just the cumulative sums of
Thanks Martin for the response. You are right, I didn't detailed enough.
Now I made a specific beancount file to show what I meant. I defined three
Assets and two commodities to make it more comprehensive:
2022-11-01 commodity EUR 2022-11-01 commodity AAPL 2022-11-01 open
Assets:Bank:Checking
I think the query you issued should work.
Can you be more specific about "it mixes together the balances"?
Maybe isolate just a few transactions and run on that, to isolate what you
believe is the problem and reply here.
On Sat, Mar 2, 2024 at 9:58 AM Andrea Vidali wrote:
> Hi everyone,
Hi everyone, first of all thank you for this amazing piece of software that
is Beancount.
The issue: I need to extract the balance of multiple accounts *separately*
on the last day of each month, over a period (suppose a year + the latest
day of the previous year).
I researched this in this