Ah, that works, thanks. Although within gnucash I'm now able to update
USD, CHF, and GBP against EUR but JPY gives an error (Get Quote ->
"Unable to retrieve quotes for these items: ... Continue using only the
good quotes?").
I read that I am limited to 5 quote per minute, this would be three
The "alphavantage" source is for stock quotes. To retrieve currency exchange
rates use "currency":
gnc-fq-dump currency EUR JPY
1 EUR = 118.31 JPY
That's hard-coded inside of Finance::Quote to use alphavantage and so requires
an API key.
Regards,
John Ralls
> On Aug 11, 2019, at 10:35 AM,
Somewhat related, the Alphavantage docs as well as gnucash itself
suggest that Yen is JPY. And yet
jeff@birdsong:~ $ gnc-fq-dump alphavantage EUR JPY
Finance::Quote fields Gnucash uses:
symbol: EUR (deduced) <=== required
date: ** missing ** <===
That was it. Thanks.
I've also filed this:
https://bugs.gnucash.org/show_bug.cgi?id=797343
Jeff Abrahamson
http://p27.eu/jeff/
http://transport-nantes.com/
On 04/08/2019 21:39, John Ralls wrote:
> Do you have an Alphavantage key set in $ALPHAVANTAGE_API_KEY (for command
> line tools
Do you have an Alphavantage key set in $ALPHAVANTAGE_API_KEY (for command line
tools like gnc-fq-dump) and in Preferences>Online Quotes (for GnuCash's
internal use)?
Regards,
John Ralls
> On Aug 4, 2019, at 11:45 AM, Jeff Abrahamson wrote:
>
> I'm using gnucash 3.4 and Finance::Quote 1.47
I'm using gnucash 3.4 and Finance::Quote 1.47 on linux (ubuntu 19.04).
I'm trying to get FQ to work for me.
When I enter a dual-currency transaction, the quote editor pops up. If
I touch the "fetch rate" button, I see a dialog that says "unable to
retrieve quotes for these items: CURRENCY:CHF"