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 plus an error. So I presume it's not that. Except that if I first do a single quote from the commandline, gnucash then fails on two of the four instead of three of the four. So it's looking like rate limit. Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 11/08/2019 19:53, John Ralls wrote: > 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 <[email protected]> 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 <[email protected]> >>>>> 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 >>>>> >>>>> [email protected] >>>>> >>>>> 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/ -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ _______________________________________________ gnucash-user mailing list [email protected] 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.
