Re: Monthly balance on the operating currency

2022-10-26 Thread Máté Farkas
On 22/10/2022 19:49, Máté Farkas wrote: > > With a small post-process step I can solve it with this BQL: > > > > SELECT > > year, month, last(balance) as balance, last(getprice("CHF", "USD", > > date)) as price > > WHERE > >

Re: Monthly balance on the operating currency

2022-10-22 Thread Máté Farkas
ar, month ORDER BY year, month Then there will be columns for the actual balances in USD, CHF and the actual price. (It requires that at least one transaction for every month to have every row filled.) Do you have any better idea? Thank you, Máté. On Thursday, October 20, 2022 at 9:37:37 AM UTC+2 M

Monthly balance on the operating currency

2022-10-20 Thread Máté Farkas
How can I get my monthly balance converted to the operating currency? Suppose that my beancount file is: - option "operating_currency" "USD" 2020-01-01 open Assets:USD USD 2020-01-01 open Assets:CHF CHF 2020-01-01 open Income:Payment 2020-01-01 * Assets:CHF 10

Re: Beancount v3

2020-07-08 Thread Máté FARKAS
Hi, that's a good point, I am planning something similar, so it would be good to be able modify/ingest transactions between parsing and booking phase. Could've been done with hooks or plugins as well. Máté. On Wed, Jul 8, 2020, 20:39 wrote: > After reading through the v3 design document, once