[GNC] Unable to retrieve quotes

Sat May 27 23:37:37 EDT 2023

If you look recently you will find multiple threads to the list about the problems with  retrieving prices from Yahoo - is this same iissue?  Another recent posts suggests that new version 1.56 coming shortly that should fix the issue.

-----Original Message-----
From: gnucash-user <gnucash-user-bounces+dullege=hotmail.com at gnucash.org> On Behalf Of Scott Steimle
Sent: Sunday, 28 May 2023 7:45 AM
To: gnucash-user at gnucash.org
Subject: [GNC] Unable to retrieve quotes

Hello,

For several weeks in a row I could not get quotes for the price database.
The attempt would report back "Unable to retrieve quotes for these items:", followed by a long list of symbols.  Last week (5/20/23) I went through the troubleshooting page <https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting>, where upgrading dependencies with the command "gnc-fq-update" resolved it.  This week, however the problem has resurfaced and although there was an update available, it did not resolve the issue:

$ sudo gnc-fq-update
Reading '/root/.cpan/Metadata'
  Database was generated on Sat, 20 May 2023 17:17:01 GMT Fetching with LWP:
http://www.cpan.org/authors/01mailrc.txt.gz
Reading '/root/.cpan/sources/authors/01mailrc.txt.gz'
............................................................................DONE
Fetching with LWP:
http://www.cpan.org/modules/02packages.details.txt.gz
Reading '/root/.cpan/sources/modules/02packages.details.txt.gz'
  Database was generated on Sat, 27 May 2023 19:29:01 GMT ..............
  New CPAN.pm version (v2.36) available.
  [Currently running version is v2.28]
  You might want to try
    install CPAN
    reload cpan
  to both upgrade CPAN.pm and run the new version without leaving
  the current session.

..............................................................DONE
Fetching with LWP:
http://www.cpan.org/modules/03modlist.data.gz
Reading '/root/.cpan/sources/modules/03modlist.data.gz'
DONE
Writing /root/.cpan/Metadata
Test2 is up to date (1.302195).
Date::Manip is up to date (6.91).
Finance::Quote is up to date (1.55).
$ gnc-fq-check
("1.55" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds"
"australia" "bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada"
"canadamutual" "comdirect" "cse" "deka" "dutch" "dwsfunds" "europe"
"fetch_live_currencies" "fidelity" "fidelity_direct" "finanzpartner"
"fondsweb" "fool" "france" "ftfunds" "fundata" "fundlibrary" "goldmoney"
"greece" "hu" "hufund" "hungary" "hustock" "iexcloud" "india" "indiamutual"
"known_currencies" "morningstarau" "morningstarch" "morningstarjp"
"mstaruk" "nasdaq" "nseindia" "nyse" "nzx" "onvista" "oslobors" "romania"
"seb_funds" "sinvestor" "six" "tesouro_direto" "tiaacref" "tmx" "tradegate"
"tradeville" "treasurydirect" "troweprice" "troweprice_direct" "tsp" "tsx"
"ukfunds" "unionfunds" "usa" "xetra" "yahoo_json" "za") $echo '(yahoo_json "CSCO")' | gnc-fq-helper
(#f)

Therefore, I ran the program with additional log output:

$ gnucash --log gnc.scm=debug

The resulting trace file shows erroneous results:

$ gnucash --log gnc.scm=debug
Found Finance::Quote version 1.55.
$ cat /tmp/gnucash.trace
* 16:40:26 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/standard
* 16:40:26 DEBUG <gnc.scm>
mod-dir=/usr/share/guile/site/3.0/gnucash/reports/standard
* 16:40:26 DEBUG <gnc.scm> dir-files=(owner-report budget net-charts new-aging budget-flow income-statement cash-flow receipt balance-forecast ifrs-cost-basis taxinvoice customer-summary trial-balance advanced-portfolio budget-income-statement job-report register account-summary cashflow-barchart view-column general-journal lot-viewer balsheet-eg invoice reconcile-report balance-sheet budget-barchart new-owner-report account-piecharts transaction category-barchart general-ledger portfolio price-scatter budget-balance-sheet dashboard payables balsheet-pnl receivables income-gst-statement equity-statement)
* 16:40:26 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/example
* 16:40:26 DEBUG <gnc.scm>
mod-dir=/usr/share/guile/site/3.0/gnucash/reports/example
* 16:40:26 DEBUG <gnc.scm> dir-files=(sample-graphs welcome-to-gnucash daily-reports hello-world average-balance)
* 16:40:26 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/locale-specific/us
* 16:40:26 DEBUG <gnc.scm>
mod-dir=/usr/share/guile/site/3.0/gnucash/reports/locale-specific/us
* 16:40:26 DEBUG <gnc.scm> dir-files=(taxtxf)
* 16:40:26 DEBUG <gnc.scm> rpt-subdir=gnucash/report/stylesheets
* 16:40:26 DEBUG <gnc.scm>
mod-dir=/usr/share/guile/site/3.0/gnucash/report/stylesheets
* 16:40:26 DEBUG <gnc.scm> dir-files=(head-or-tail css footer plain)
* 16:40:27 DEBUG <gnc.scm> gnc:fq-check-sources results: (1.55 aex alphavantage amfiindia asegr asx aufunds australia bamosz bet bloomberg bourso bse bseindia canada canadamutual comdirect cse deka dutch dwsfunds europe fetch_live_currencies fidelity fidelity_direct finanzpartner fondsweb fool france ftfunds fundata fundlibrary goldmoney greece hu hufund hungary hustock iexcloud india indiamutual known_currencies morningstarau morningstarch morningstarjp mstaruk nasdaq nseindia nyse nzx onvista oslobors romania seb_funds sinvestor six tesouro_direto tiaacref tmx tradegate tradeville treasurydirect troweprice troweprice_direct tsp tsx ukfunds unionfunds usa xetra yahoo_json za)
* 16:40:27 MESSG <gnc.scm> Found Finance::Quote version 1.55
* 16:40:33 DEBUG <gnc.scm> ALPHAVANTAGE_API_KEY=
* 16:40:33 DEBUG <gnc.scm> handling-request: (yahoo_json IEFA SCHF BSV TFI VWO ITOT FRC VTI STIP GM SCHB HYG PBW MSOS SLYV SLQT MUB VEA SFYX VB LBRT VTV AGG SFY PCY PLTR VBR VOE BFLY QS SCHV NET IWS IJJ SPYV GBTC ETHE MJNA GDLC SICP MRNA FSPSX PRTNX HOLX CRSP VWENX ZM VEMRX RIDE VIMAX ACCD FSMDX TSLA FXNAX VGHAX VTSAX VSCIX COIN FPADX PDMIX CLLS VMCIX VEMIX VIEIX VTSNX VBMPX VWOB ARKK ROKU LCID ANAIX UPST VTIP SNXFX PTLAX EDIT SWRSX VSEC VUSXX VSMAX VBTIX FSSNX VIIIX LI LHYAX SWISX SHV TMO NEAR VSGAX LUNR EMB VEIRX BND RIOT RWIGX VFIAX PYPL JLFIX PARA CWGFX VGSNX BNDX FXAIX MARA SEEL WAPSX VHGEX KAVA-USD KSM-USD DOT-USD ETH-USD MATIC-USD SHIB-USD SOL-USD)
* 16:41:21 DEBUG <gnc.scm> results: (#f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f #f)

This is similar to running the command line helper:

$ echo '(yahoo_json "DAI.DE")'|gnc-fq-helper
(#f)

Regards,
Scott
_______________________________________________
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
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.