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 balances of all Assets and
Liabilities
Note, that following standard accounting principles, for Net Worth the
conversion to the target currency is done using the exchange rate (price),
dated with the date the report is generated for.
On Monday, March 10, 2025 at 6:25:20 PM UTC+1 [email protected] wrote:
> Hi all
> What would be the BQL query to get the balances at the end of each month
> for (a) given acclunt(s), converted to the base currency?
>
> thanks for any help.
> Thank you very much
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/beancount/672d1b4b-e690-4ee4-a9fa-975b741c6683n%40googlegroups.com.
