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 beancount+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/a2c38db0-f814-4541-9f3e-cd05c025398dn%40googlegroups.com.