[GNC] FX fetching strangeness

[Jeff Abrahamson]

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 <jeff at p27.eu> wrote:
>>
>> 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/

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/
http://transport-nantes.com/