On Saturday, June 22, 2024 at 5:37:23 AM UTC+2 fin wrote:
Alejandro López wrote:
if i could come up with one for networth that would be very
helpful, but i've not had much time lately to poke at that one.
This one works for me. This is net worth at a certain date
query = f"""
SELECT SUM(position)
where date <= {date_iso} AND account ~ 'Assets|Liabilities'
"""
But I usually make it per account and convert to a single currency
query = f"""
SELECT account, convert(SUM(position),'{currency}',{date_iso}) as amount
where date <= {date_iso} AND account ~ 'Assets|Liabilities'
"""
--
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/d52958e0-f23f-4dfb-b568-7dafc1199a24n%40googlegroups.com.
