bean-query /tmp/example.beancount "select account, convert(sum(position), 'CAD') group by 1 order by 1"
It'll be able to convert as long as you have at least some price directives in your file to provide the exchange rate (Beancount does not access the network on purpose - deterministic, repeatable, no unexpected things - so it won't pull rates form anywhere; you have to have rates inserted in your file).
--
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+unsubscribe@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/b1d52a31-67d5-4043-bf57-01c8e0ff03ff%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Fava has a drop-down that will convert all tree charts (income statement and balance sheets) to any currency. It uses the same convert functions as sql.
You can use the SQL shell's conversion function to do this.Something like this:bean-query /tmp/example.beancount "select account, convert(sum(position), 'CAD') group by 1 order by 1"
It'll be able to convert as long as you have at least some price directives in your file to provide the exchange rate (Beancount does not access the network on purpose - deterministic, repeatable, no unexpected things - so it won't pull rates form anywhere; you have to have rates inserted in your file).
On Sat, Aug 5, 2017 at 8:00 AM, <gksrn...@gmail.com> wrote:
Hi. I'm trying Beancount instead of Ledger.Sometimes I use another currency in business trips.I want to check my balances in temrs of the our currency.Ledger can do this by using -X option.How to do this in Beancount?Thanks in advance,Hankook Lee
--
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+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/b1d52a31-67d5-4043-bf57-01c8e0ff03ff%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
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+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhN4pErx%2Bx4_-LeRYUrp3o-KK7S0SomcuCbP44sd_f9k7w%40mail.gmail.com.
Hi,I am trying to use Fava and have an issue with the FX rate used.In my beancount file I have different rates for different dates. I expect the income statement to convert based on the FX rate of the date of the transaction -bean-query> SELECT date, narration, account, position, getprice(currency,"IDR", date), convert(position, "IDR", date)but instead it just takes the latest FX rate in the file which is wrongbean-query> SELECT date, narration, account, position, getprice(currency,"IDR", date), convert(position, "IDR")How do I get bean-report or fava to switch to the first query instead of the second for the income report?Thanks!
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/72f3ac63-b4db-49b0-b4a1-2cd0f9dd6844%40googlegroups.com.