[GNC] [GNC} Cannot get online quotes

[Chris Good]

Message: 2
Date: Fri, 25 Sep 2020 09:49:55 +0200
From: Emilio Dorigatti <emilio.dorigatti at gmail.com>
To: gnucash-user at gnucash.org
Subject: [GNC] Cannot get online quotes
Message-ID: <06fa361c-71b1-8c1c-da32-d7170830b0ec at gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi all,

I am trying to setup online quotes as per the guide [1]. I am at the latest
version

# gnc-fq-update
Reading '/root/.cpan/Metadata'
 ? Database was generated on Fri, 25 Sep 2020 01:29:03 GMT Date::Manip is up
to date (6.82).
Finance::Quote is up to date (1.49).

And no errors are returned from check:

$ gnc-fq-check
("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx"
"aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse"
"bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
"dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
"fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
"ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
"greece" "hex" "hu" "hufund" "hungary" "hustock" "iexcloud" "indiamutual"
"known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau"
"morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx"
"platinum" "romania" "seb_funds" "sixfunds" "sixshares"
"stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk"
"troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts"
"ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo_json"
"yahoo_yql" "za" "za_unittrusts")

However, dumping fails with all sources:

$ gnc-fq-dump -v europe AMZN

Parsing of undecoded UTF-8 will give garbage when decoding entities at
/usr/share/perl5/site_perl/HTML/TreeBuilder.pm line 108.

Finance::Quote fields Gnucash uses:

 ??? symbol: AMZN (deduced)?????? <=== required

 ????? date: ** missing **??????? <=== recommended

 ? currency: ** missing **??????? <=== required

 ????? last: **missing**????????? <=\

 ?????? nav: **missing**????????? <=== one of these

 ???? price: **missing**????????? <=/

 ? timezone:????????????????????? <=== optional

** This stock quote cannot be used by GnuCash!

All fields returned by Finance::Quote for stock AMZN

stock?????????? field? value

-----?????????? -----? -----

AMZN???????? errormsg: HTTP session failed

AMZN???????????? last: **missing**

AMZN????????????? nav: **missing**

AMZN??????????? price: **missing**

AMZN????????? success: 0

And obviously fails within GnuCash, too. I don't know how I am supposed to
specify the currency? Or perhaps there are connection issues to the servers?

Thank you for working on GnuCash, it's an amazing piece of software!
Emilio.

[1]: https://wiki.gnucash.org/wiki/Online_Quotes


Hi Emilio,

Source europe also fails with AMZN for me but source alphavantage works.
You have to set your  ALPHAVANTAGE_API_KEY in the environment for
gnc-fq-dump and in the Online Quotes tab of GnuCash Preferences for GnuCash.

Does that work for you?

Regards,
Chris Good