New issue 351: Allow a balance column by referencing another column, sum up position converted at original rate https://bitbucket.org/blais/beancount/issues/351/allow-a-balance-column-by-referencing
Martin Michlmayr: I [posted this to the beancount list](https://groups.google.com/forum/#!topic/beancount/SGDBejEtd0I) and Martin said this isn't supported at the moment. Opening a ticket. I have expenses in one currency (EUR) and want to convert all of them to another (USD) **on the day** of the transaction. This gives the correct result because I pass "date" to CONVERT(): ``` beancount> SELECT sum(convert(position, "USD", date)) WHERE account ~ '^Assets:A'; sum_conver ---------- 107.50 USD ``` But I'd like to see a "register" type view with each individual transaction and the total. Test case: ``` plugin "beancount.plugins.implicit_prices" 2000-01-01 open Assets:A 2000-01-01 open Assets:B 2018-12-05 * "Test 1" Assets:A 20 EUR @ 1.10 USD Assets:B 2018-12-06 * "Test 2" Assets:A 45 EUR {1.14 USD} @ 1.14 USD Assets:B 2018-12-07 * "Test 3" Assets:A 30 EUR {1.14 USD} Assets:B ``` -- 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 post to this group, send email to beancount@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/20181219112211.2146.96465%40celery-worker-110.ash1.bb-inf.net. For more options, visit https://groups.google.com/d/optout.