Dear all,
I just want to double check, that the beanquery I am using to get my net
wort at certain date is an optimal one
I use the following:
query = f"""
SELECT account, convert(SUM(position),'{currency}',{date_iso}) as amount
where date <= {date_iso} AND account ~ 'Assets|Liabilities'
"""
As you can see, I convert everything to one currency with the exchange rate
at the date of the report.
it works fine, but I am just wondering whether there is more conical way?
E.g. using
BALANCES [AT <function>] [FROM …]
--
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 on the web visit
https://groups.google.com/d/msgid/beancount/a2c38db0-f814-4541-9f3e-cd05c025398dn%40googlegroups.com.