> On Sep 6, 2018, at 12:15 AM, Manfred Usselmann <manf...@usselmann.de> wrote: > > > > Hi, > > I'm using GnuCash 3.2 with Finance::Quote 1.47 on Ubuntu 18.04. > > When trying to download currency exchange rates this fails with "Unknown > error". > > I've registered an ALPHAVANTAGE_API_KEY and entered it on the settings > screen. > > Some tests from the command line: > > $ GNC-FQ-DUMP -V ALPHAVANTAGE CHFEUR=X > Finance::Quote fields Gnucash uses: > symbol: CHFEUR=X <=== required > date: 09/06/2018 <=== recommended > currency: USD <=== required > last: 0.8842 <=\ > nav: <=== one of these > price: <=/ > timezone: <=== optional > > All fields returned by Finance::Quote for stock CHFEUR=X > > stock field value > ----- ----- ----- > CHFEUR=X close: 0.8842 > CHFEUR=X currency: USD > CHFEUR=X currency_set_by_fq: 1 > CHFEUR=X date: 09/06/2018 > CHFEUR=X high: 0.8847 > CHFEUR=X isodate: 2018-09-06 > CHFEUR=X last: 0.8842 > CHFEUR=X low: 0.8840 > CHFEUR=X method: alphavantage > CHFEUR=X open: 0.8845 > CHFEUR=X success: 1 > CHFEUR=X symbol: CHFEUR=X > CHFEUR=X volume: 0 > > $ ECHO '(ALPHAVANTAGE "CSCO")' | GNC-FQ-HELPER > (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2018-09-05 12:00:00") > (last . 47.2700) (currency . "USD")))
Does the CSCO price retrieval work in GnuCash? I created a CHFEUR=X security, set it to retrieve quotes from Alphavantage, and successfully retrieved the price in GnuCash. Note, however, that it’s not a meaningful value: CHFEUR=X retrieves the price in EUR of 1CHF, but Finance::Quote treats it as USD because Alphavantage doesn’t tell it otherwise. Regards, John Ralls _______________________________________________ gnucash-user mailing list gnucash-user@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.