[GNC] FX fetching strangeness

[Jeff Abrahamson]

Somewhat related, the Alphavantage docs as well as gnucash itself
suggest that Yen is JPY.  And yet

    jeff at 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 at 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 <jeff at 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 at birdsong:~ $ gnc-fq-dump currency USD EUR
>>>    1 USD = <unknown> EUR
>>>    jeff at 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 at 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 at 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/