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.