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, Jeff Abrahamson <j...@p27.eu> wrote: > > 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 ** <=== recommended > currency: ** missing ** <=== required > last: <=\ > nav: <=== one of these > price: <=/ > timezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > ===== > > Finance::Quote fields Gnucash uses: > symbol: JPY (deduced) <=== required > date: ** missing ** <=== recommended > currency: ** missing ** <=== required > last: <=\ > nav: <=== one of these > price: <=/ > timezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > jeff@birdsong:~ $ > > I'm I confused or is there a different way of fetching JPY FX? > > Thanks. > > Jeff > > > > On 11/08/2019 19:20, Jeff Abrahamson wrote: >> 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 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 <j...@p27.eu> >>>> wrote: >>>> >>>> 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" and three other currencies. >>>> >>>> I have precisely those four currencies in use, though I'm a bit confused >>>> why FQ would have tried to fetch all four at once when I only needed >>>> one. I'm also confused why it found none. >>>> >>>> Based on a conversation on this list in 2018, I tried this: >>>> >>>> jeff@birdsong:~ $ gnc-fq-dump currency USD EUR >>>> 1 USD = <unknown> EUR >>>> jeff@birdsong:~ $ gnc-fq-dump alphavantage USD EUR >>>> Finance::Quote fields Gnucash uses: >>>> symbol: USD (deduced) <=== required >>>> date: ** missing ** <=== recommended >>>> currency: ** missing ** <=== required >>>> last: <=\ >>>> nav: <=== one of these >>>> price: <=/ >>>> timezone: <=== optional >>>> >>>> ** This stock quote cannot be used by GnuCash! >>>> >>>> ===== >>>> >>>> Finance::Quote fields Gnucash uses: >>>> symbol: EUR (deduced) <=== required >>>> date: ** missing ** <=== recommended >>>> currency: ** missing ** <=== required >>>> last: <=\ >>>> nav: <=== one of these >>>> price: <=/ >>>> timezone: <=== optional >>>> >>>> ** This stock quote cannot be used by GnuCash! >>>> >>>> jeff@birdsong:~ $ >>>> >>>> Any suggestions on what to do or what to test? >>>> >>>> -- >>>> >>>> Jeff Abrahamson >>>> +33 6 24 40 01 57 >>>> +44 7920 594 255 >>>> >>>> >>>> http://p27.eu/jeff/ >>>> http://transport-nantes.com/ >>>> >>>> >>>> _______________________________________________ >>>> gnucash-user mailing list >>>> >>>> gnucash-user@gnucash.org >>>> >>>> To update your subscription preferences or to unsubscribe: >>>> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>> >>>> If you are using Nabble or Gmane, please see >>>> https://wiki.gnucash.org/wiki/Mailing_Lists >>>> for more information. >>>> ----- >>>> Please remember to CC this list on all your replies. >>>> You can do this by using Reply-To-List or Reply-All. >>>> >> -- >> >> Jeff Abrahamson >> +33 6 24 40 01 57 >> +44 7920 594 255 >> >> >> http://p27.eu/jeff/ >> http://transport-nantes.com/ > -- > > Jeff Abrahamson > +33 6 24 40 01 57 > +44 7920 594 255 > > > http://p27.eu/jeff/ > http://transport-nantes.com/ _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.