Jorge Martínez López
unread,Oct 18, 2022, 4:00:17 PM10/18/22Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to bean...@googlegroups.com
Hi all,
I'm trying to troubleshoot an issue with updating old prices using
bean-price. The main problem is that from 2019-05-03 onwards
bean-price does not fetch the USD/GBP currency.
I can't really explain why because the only transactions I see on
those days are in GBP and one of the Asset accounts has funds in USD.
This is the bean-price output for both days (omitted some non-relevant
currencies).
bean-price --date 2019-05-03 --dry-run --clear-cache -vv main.beancount
INFO : Using price cache at "/tmp/bean-price.cache" (with
indefinite expiration)
INFO : Clearing cache /tmp/bean-price.cache*
INFO : Processing at date: 2019-05-03
INFO : Loading "main.beancount"
DEBUG : -------- Currencies in primary list:
DEBUG : USD /GBP
DEBUG : EUR /GBP
DEBUG : HOOLI /USD
DEBUG : -------- Currencies held in assets:
DEBUG : EUR /GBP
DEBUG : GBP /USD
DEBUG : GBP /EUR
DEBUG : HOOLI /USD
DEBUG : EUR /USD
DEBUG : USD /GBP
DEBUG : -------- Currencies to fetch:
DEBUG : USD /GBP
DEBUG : EUR /GBP
DEBUG : HOOLI /USD
HOOLI /USD @ 2019-05-03 [
beanprice.sources.yahoo(HOOLI) ]
EUR /GBP @ 2019-05-03 [
beanprice.sources.yahoo(EURGBP=X) ]
USD /GBP @ 2019-05-03 [ beanprice.sources.yahoo(GBP=X) ]
bean-price --date 2019-05-02 --dry-run --clear-cache -vv main.beancount
INFO : Using price cache at "/tmp/bean-price.cache" (with
indefinite expiration)
INFO : Clearing cache /tmp/bean-price.cache*
INFO : Processing at date: 2019-05-02
INFO : Loading "main.beancount"
DEBUG : -------- Currencies in primary list:
DEBUG : USD /GBP
DEBUG : HOOLI /USD
DEBUG : EUR /GBP
DEBUG : -------- Currencies held in assets:
DEBUG : GBP /EUR
DEBUG : GBP /USD
DEBUG : HOOLI /USD
DEBUG : EUR /GBP
DEBUG : EUR /USD
DEBUG : -------- Currencies to fetch:
DEBUG : HOOLI /USD
DEBUG : EUR /GBP
HOOLI /USD @ 2019-05-02 [
beanprice.sources.yahoo(HOOLI) ]
EUR /GBP @ 2019-05-02 [
beanprice.sources.yahoo(EURGBP=X) ]
This is how my commodities are defined:
2002-01-01 commodity EUR
export: "CASH"
name: "Euro"
price: "GBP:yahoo/EURGBP=X"
asset-class: "cash"
1792-04-02 commodity USD
export: "CASH"
name: "US Dollar"
price: "GBP:yahoo/GBP=X"
asset-class: "cash"
My main operating currency is GBP, I hold accounts in EUR and USD, so
my main goal is to be able to "convert to GBP" using Fava. Do I need
to define a GBP commodity as well?
How do I troubleshoot this further?
Thanks in advance!
Kind regards,
Jorge