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@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.
