Re: bean-query CONVERT() at a historical rate

2020-06-11 Thread Chary Chary
Martin, thanks! I actually found the solution, the query is like that: select SUM(CONVERT(COST(position),"USD",*date*)) WHERE account ~ "Income" With such query the conversion happens with the exchange rate of the transaction date. I think the bean-query is really amazing thing! On

Re: bean-query CONVERT() at a historical rate

2020-06-09 Thread Martin Michlmayr
* Chary Chary [2020-06-09 01:58]: > is this correct, that beancount does not have possibility to convert > to commodity (currency) at a historical rate (at a rate, which > commodity had at a date of transaction)? Someone might have a bette answer but... if you do a simple conversion (@@),

bean-query CONVERT() at a historical rate

2020-06-09 Thread Chary Chary
Hi, is this correct, that beancount does not have possibility to convert to commodity (currency) at a historical rate (at a rate, which commodity had at a date of transaction)? I see only options to convert at a current exchange rate or at an exchange rate at a particular date