Balance in EUR when asset price is only available in USD

77 views
Skip to first unread message

Timothée GROS

unread,
Jan 3, 2022, 8:23:51 AM1/3/22
to Beancount
Hi!

I am not really sure if my question is related to beancount or Fava only.

I am european, and my main currency is EUR.
When display my balance sheet in Fava, i usually select "converted to EUR" in order to display the equivalent value in Euro rather than the number of assets (stocks.... funds, etc...) or the foreign currencies.
I have an issue, with some commodity for which i don't have price information in euros (typically some Cryptoassets, for which my price fetcher only provide price in USD).
Of course, i have also price directives in my beancount file to convert USD to EUR, so i would expect beancount to be able to compute the equivalent value from ASSET to USD and then from USD to EUR.

Apparently this is not the case and these assets are not converted in the balance sheet.
Is there a workaround ?

Patrick Ruckstuhl

unread,
Jan 3, 2022, 9:12:39 AM1/3/22
to bean...@googlegroups.com

Hi,

there are no automated cross currencies calculated. I created a plugin that you can use which will take care of it. It will calculate "virtual" price entries based on commodity price and fx rates.


https://github.com/tarioch/beancounttools

https://tariochbctools.readthedocs.io/en/latest/plugins.html#generate-base-ccy-prices


Regards,

Patrick

--
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 view this discussion on the web visit https://groups.google.com/d/msgid/beancount/a3d3faa3-75df-40eb-938d-d6036c100e87n%40googlegroups.com.

Timothée GROS

unread,
Jan 3, 2022, 2:33:14 PM1/3/22
to Beancount
Wow. Very cool.
I have tested your plugin . *it just works* 
Thanks !
Reply all
Reply to author
Forward
0 new messages