[GNC] FX fetching strangeness

[John Ralls]

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.