[GNC] FX fetching strangeness

[John Ralls]

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/