[GNC] Difficulty with online price retrieval

Samantha Payn samantha at boorertranslations.com
Tue Aug 25 06:44:17 EDT 2020


   Hi Geoff

   My locale currency is GBP. As it was when this feature of Gnucash used
   to work for me.

   Thanks for taking the time to get involved.

   Samantha

   On 25 August 2020 09:42 Geoff < [1]cleanoutmyshed at gmail.com> wrote:

   <<< Please excuse me for jumping in late on this thread >>>

   Samantha reported: ""when I click it I get an error window that says:

   "There was a system error while retrieving the price quotes".""

   Samantha's debug output shows the error message:

   * 10:15:31 DEBUG <gnc.scm> handling-request: (currency USD GBP)

   * 10:15:31 DEBUG <gnc.scm> results: #<eof>

   * 10:15:31 DEBUG <gnc.scm> handling-request: (currency EUR GBP)

   * 10:15:31 ERROR <gnc.scm> There was a system error while retrieving
   the

   price quotes.

   But *only* when two non-USD currencies are involved - EUR/GBP in this
   case.

   John - when you said you can't reproduce the problem your log only
   shows

   CAD/USD. Have you tried EUR/GBP? I have the same problem as Samantha

   when I try this, even though both gnc-fq-dump and gnc-gfq-helper are

   working OK.

   Samantha - would you mind checking in gnucash under "Edit / Preferences

   / Accounts" and telling us what your Default Currency setting is
   please?

   See attached screenshot for my settings - DO NOT change yours to mine.

   Thanks

   Geoff

   =====

   <<< Feeel free to tell me to butt out if this isn't helpful >>>

   On 25/08/2020 8:04 am, John Ralls wrote:

   Samantha,

   Sorry, yes, I got busy on other work.

   #<eof> means that no quote information made it in to the code that
   handles the quotes.

   I can't reproduce the problem. Since you revealed your key I even used
   that, worked fine:

   * 14:34:32 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.

   * 14:34:32 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.

   * 14:34:57 DEBUG <gnc.scm> ALPHAVANTAGE_API_KEY=<Yours>

   * 14:34:57 DEBUG <gnc.scm> handling-request: (currency CAD USD)

   * 14:35:04 DEBUG <gnc.scm> results: ((CAD (symbol . CAD)
   (gnc:time-no-zone . 2020-08-24 14:34:58) (last . 15127/20000) (currency
   . USD)))

   * 14:35:04 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.

   * 14:35:04 WARN <qof> [gnc_numeric_to_decimal()] Rounding required when
   'never round' specified.

   It does occur to me the US markets are closed at 10:15 BST, but I
   suppose that you also checked with gnc-fq-dump around the same time and
   that worked OK.

   There's one other thing to try in Powershell but it would be odd if
   gnc-fq-dump works and this doesn't:

   $Env:ALPHAVANTAGE_API_KEY = 'xxx'

   '(currency "USD" "GBP")' | perl 'c:\Program Files
   (x86)\gnucash\bin\gnc-fq-helper

   Should produce something like

   (("USD" (symbol . "USD") (gnc:time-no-zone . "2020-08-24 14:56:25")
   (last . #e0.7658) (currency . "GBP")))

   Regards,

   John Ralls

   On Aug 24, 2020, at 3:16 AM, Samantha Payn <
   [2]samantha at boorertranslations.com> wrote:

   >> Dear John and list

   >> I think this response of mine from a week ago must have fallen
   through the net?

   >> Any assistance gratefully received

   >> Samantha Payn

   >>> ---------- Original Message ----------

   >>> From: Samantha Payn < [3]samantha at boorertranslations.com>

   >>> To: John Ralls < [4]jralls at ceridwen.us>

   >>> CC: Gnucash Users < [5]gnucash-user at gnucash.org>

   >>> Date: 17 August 2020 10:19

   >>> Subject: Re: [GNC] Difficulty with online price retrieval

   >>>

   >>>

   >>> John, thank you for your continued patience!

   >>> This is what I got:

   >>> * 10:13:32 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/standard

   >>> * 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard

   >>> * 10:13:32 DEBUG <gnc.scm> dir-files=(view-column trial-balance
   transaction taxinvoice register reconcile-report receivables receipt
   price-scatter portfolio payables owner-report new-owner-report
   new-aging net-charts lot-viewer job-report invoice income-statement
   income-gst-statement general-ledger general-journal equity-statement
   dashboard customer-summary category-barchart cashflow-barchart
   cash-flow budget budget-income-statement budget-flow budget-barchart
   budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
   balance-forecast advanced-portfolio account-summary account-piecharts)

   >>> * 10:13:32 DEBUG <gnc.scm> rpt-subdir=gnucash/reports/example

   >>> * 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example

   >>> * 10:13:32 DEBUG <gnc.scm> dir-files=(welcome-to-gnucash
   sample-graphs hello-world daily-reports average-balance)

   >>> * 10:13:32 DEBUG <gnc.scm>
   rpt-subdir=gnucash/reports/locale-specific/us

   >>> * 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us

   >>> * 10:13:32 DEBUG <gnc.scm> dir-files=(taxtxf)

   >>> * 10:13:32 DEBUG <gnc.scm> rpt-subdir=gnucash/report/stylesheets

   >>> * 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets

   >>> * 10:13:32 DEBUG <gnc.scm> dir-files=(plain head-or-tail footer
   css)

   >>> * 10:13:33 DEBUG <gnc.scm> gnc:fq-check-sources results: (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)

   >>> * 10:13:33 MESSG <gnc.scm> Found Finance::Quote version 1.49

   >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required
   when 'never round' specified.

   >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required
   when 'never round' specified.

   >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required
   when 'never round' specified.

   >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required
   when 'never round' specified.

   >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required
   when 'never round' specified.

   >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required
   when 'never round' specified.

   >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required
   when 'never round' specified.

   >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding required
   when 'never round' specified.

   >>> * 10:15:31 DEBUG <gnc.scm> ALPHAVANTAGE_API_KEY=<Key>

   >>> * 10:15:31 DEBUG <gnc.scm> handling-request: (currency USD GBP)

   >>> * 10:15:31 DEBUG <gnc.scm> results: #<eof>

   >>> * 10:15:31 DEBUG <gnc.scm> handling-request: (currency EUR GBP)

   >>> * 10:15:31 ERROR <gnc.scm> There was a system error while
   retrieving the price quotes.

   >>> * 10:15:37 WARN <qof> [gnc_numeric_to_decimal()] Rounding required
   when 'never round' specified.

   >>> * 10:15:37 WARN <qof> [gnc_numeric_to_decimal()] Rounding required
   when 'never round' specified.

   >>>> On 15 August 2020 19:20 John Ralls < [6]jralls at ceridwen.us> wrote:

   >>>>

   >>>>

   >>>> Samantha,

   >>>>

   >>>> Run GnuCash from Powershell as you did before:

   >>>> & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log
   gnc.scm=debug

   >>>> (The last time the command was & 'C:\Program Files
   (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug --nofile but that
   last command, --nofile, tells GnuCash to not open the previous data
   file. Last time I didn't need to see anything from a data file and
   starting GnuCash without one is faster. This time I do want you to have
   access to your data file.)

   >>>>

   >>>> This time edit an exchange rate on an existing multi-currency
   transaction and use the Fetch Rate button to attempt to get an online
   quote. Dismiss the error dialog, cancel the edit, and quit GnuCash.

   >>>>

   >>>> Then list the log files

   >>>> Get-ChildItem -Path $Env:USERPROFILE\AppData\Local\Temp -filter
   gnucash.trace.* | Sort-Object -Property Date

   >>>> figure out which is the latest one (the guidance about that is
   still at the bottom of the quoted text in this message if you've
   forgotten)

   >>>> Display the contents

   >>>> Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log

   >>>> (That's the file name from last time, you'll replace VEQEP0 with
   whatever is in the latest file's name.)

   >>>> And copy and paste them into a reply.

   >>>>

   >>>> Regards,

   >>>> John Ralls

   >>>>

   >>>>> On Aug 15, 2020, at 6:42 AM, Samantha Payn <
   [7]samantha at boorertranslations.com> wrote:

   >>>>>

   >>>>> I am sorry John, do what?

   >>>>> I am afraid I just do not understand "Please run from the
   PowerShell command line with the --log gnc.scm=debug option as before,
   try both a Fetch Rate and a Get Quotes and paste in the contents of the
   resulting log file."

   >>>>> I am such a beginner with the Powershell window stuff, all I can
   do is copy/paste what you provide. This problem has been so drawn out
   that we both lost sight of the fact that I had originally raised the
   issue over "Fetch Rates" for foreign currency transactions in my
   business.

   >>>>> Yours apologetically

   >>>>> Samantha

   >>>>>

   >>>>>> On 13 August 2020 01:30 John Ralls < [8]jralls at ceridwen.us>
   wrote:

   >>>>>>

   >>>>>>

   >>>>>> Samantha,

   >>>>>>

   >>>>>> OK. Please do it when running GnuCash from Powershell with the
   --log gnc.scm=debug option and paste in the resulting
   gnucash.trace.XXXXXX.log.

   >>>>>>

   >>>>>> Regards,

   >>>>>> John Ralls

   >>>>>>

   >>>>>>

   >>>>>>> On Aug 12, 2020, at 6:54 AM, Samantha Payn <
   [9]samantha at boorertranslations.com> wrote:

   >>>>>>>

   >>>>>>> John, I am so sorry, I have slightly misled you. It is the
   "Fetch Rate" button which returns the error message. I only use Gnucash
   for my business accounts and have no need of the "Get Quotes" button.

   >>>>>>>> On 11 August 2020 18:54 John Ralls < [10]jralls at ceridwen.us>
   wrote:

   >>>>>>>>

   >>>>>>>>

   >>>>>>>> Samantha,

   >>>>>>>>

   >>>>>>>> Sorry, I lost that in the ensuing conversation about how to
   work Powershell and got hung up on the previous no Get Rate button
   issue.

   >>>>>>>>

   >>>>>>>> The Fetch Rate and Get Quotes buttons work a bit differently
   from each other: The first looks only at the currencies involved in the
   transaction you're entering and the latter tries to retrieve rates for
   all of the currencies in your book. Can you try the Fetch Rate button?
   You can do that most easily by editing the rate on a foreign currency
   split. (Open a foreign currency transaction, put it in split view,
   select a split in the "other" currency, right-click and pick Edit
   Exchange Rate from the context menu. Note that which currency is the
   "other" one depends on which account you started the transaction from
   so it might be GBP if you created the transaction starting from an
   account denominated in, say, EUR.)

   >>>>>>>>

   >>>>>>>> Please run from the PowerShell command line with the --log
   gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes
   and paste in the contents of the resulting log file.

   >>>>>>>>

   >>>>>>>> Regards,

   >>>>>>>> John Ralls

   >>>>>>>>

   >>>>>>>>> On Aug 11, 2020, at 5:00 AM, Samantha Payn <
   [11]samantha at boorertranslations.com> wrote:

   >>>>>>>>>

   >>>>>>>>> I'm afraid the problem has not been solved.

   >>>>>>>>> The Get Quotes button does light up (as I mentioned in an
   email to the list just after I first reported the problem), but when I
   click it I get an error window that says: "There was a system error
   while retrieving the price quotes".

   >>>>>>>>> Thank you for your persisitance and continued support.

   >>>>>>>>> Samantha

   >>>>>>>>>> On 11 August 2020 00:51 John Ralls < [12]jralls at ceridwen.us>
   wrote:

   >>>>>>>>>>

   >>>>>>>>>>

   >>>>>>>>>> Good. It succeeded in finding Finance::Quote from the
   command line. That should be sufficient to enable the Fetch Rate
   button. Was it enabled?

   >>>>>>>>>>

   >>>>>>>>>> Regards,

   >>>>>>>>>> John Ralls

   >>>>>>>>>>

   >>>>>>>>>>> On Aug 10, 2020, at 12:06 PM, Samantha Payn <
   [13]samantha at boorertranslations.com> wrote:

   >>>>>>>>>>>

   >>>>>>>>>>> Hi John

   >>>>>>>>>>> I did what you suggest and this is what I got:

   >>>>>>>>>>>

   >>>>>>>>>>> PS C:\Users\User> Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log

   >>>>>>>>>>> * 11:46:06 DEBUG <gnc.scm>
   rpt-subdir=gnucash/reports/standard

   >>>>>>>>>>> * 11:46:06 DEBUG <gnc.scm> mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard

   >>>>>>>>>>> * 11:46:06 DEBUG <gnc.scm> dir-files=(view-column
   trial-balance transaction taxinvoice register reconcile-report
   receivables receipt price-scatter portfolio payables owner-report
   new-owner-report new-aging net-charts lot-viewer job-report invoice
   income-statement income-gst-statement general-ledger general-journal
   equity-statement dashboard customer-summary category-barchart
   cashflow-barchart cash-flow budget budget-income-statement budget-flow
   budget-barchart budget-balance-sheet balsheet-pnl balsheet-eg
   balance-sheet balance-forecast advanced-portfolio account-summary
   account-piecharts)

   >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm>
   rpt-subdir=gnucash/reports/example

   >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example

   >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> dir-files=(welcome-to-gnucash
   sample-graphs hello-world daily-reports average-balance)

   >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm>
   rpt-subdir=gnucash/reports/locale-specific/us

   >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us

   >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> dir-files=(taxtxf)

   >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm>
   rpt-subdir=gnucash/report/stylesheets

   >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> mod-dir=C:\Program Files
   (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets

   >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> dir-files=(plain head-or-tail
   footer css)

   >>>>>>>>>>> * 11:46:10 DEBUG <gnc.scm> gnc:fq-check-sources results:
   (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)

   >>>>>>>>>>> * 11:46:10 MESSG <gnc.scm> Found Finance::Quote version
   1.49

   >>>>>>>>>>> PS C:\Users\User>

   >>>>>>>>>>>

   >>>>>>>>>>> Cheers

   >>>>>>>>>>> Samantha

   >>>>>>>>>>>> On 10 August 2020 16:37 John Ralls <
   [14]jralls at ceridwen.us> wrote:

   >>>>>>>>>>>>

   >>>>>>>>>>>>

   >>>>>>>>>>>>> On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger <
   [15]frank.h.ellenberger at gmail.com> wrote:

   >>>>>>>>>>>>>

   >>>>>>>>>>>>> Samanta,

   >>>>>>>>>>>>>

   >>>>>>>>>>>>> Am 10.08.20 um 12:53 schrieb Samantha Payn:

   >>>>>>>>>>>>>> But you lost me at the next bit.

   >>>>>>>>>>>>>>

   >>>>>>>>>>>>>> PS C:\Users\User> Get-ChildItem -Path

   >>>>>>>>>>>>>> $Env:USERPROFILE\AppData\Local\Temp -filter
   gnucash.trace.* |

   >>>>>>>>>>>>>> Sort-Object -Property Date

   >>>>>>>>>>>>>> Directory: C:\Users\User\AppData\Local\Temp

   >>>>>>>>>>>>>> Mode LastWriteTime Length Name

   >>>>>>>>>>>>>> ---- ------------- ------ ----

   >>>>>>>>>>>>>> -a---- 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log

   >>>>>>>>>>>>>> -a---- 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log

   >>>>>>>>>>>>>> -a---- 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log

   >>>>>>>>>>>>>> -a---- 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log

   >>>>>>>>>>>>>> -a---- 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log

   >>>>>>>>>>>>>> -a---- 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log

   >>>>>>>>>>>>>> -a---- 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log

   >>>>>>>>>>>>>> -a---- 07/08/2020 08:38 265 gnucash.trace.AH40O0.log

   >>>>>>>>>>>>>> -a---- 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log

   >>>>>>>>>>>>>> -a---- 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log

   >>>>>>>>>>>>>> -a---- 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log

   >>>>>>>>>>>>>> -a---- 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log

   >>>>>>>>>>>>>> PS C:\Users\User>

   >>>>>>>>>>>>>> Where do I substitute the most recent file name from my
   listing? Which

   >>>>>>>>>>>>>> listing?

   >>>>>>>>>>>>>> Awaiting further guidance and thanks again.

   >>>>>>>>>>>>>> Samantha

   >>>>>>>>>>>>> In this case it is the 2nd: gnucash.trace.VEQEP0.log
   created 10/08/2020

   >>>>>>>>>>>>> 11:46

   >>>>>>>>>>>> Samantha,

   >>>>>>>>>>>>

   >>>>>>>>>>>> Specifically, run

   >>>>>>>>>>>> Get-Content
   $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log

   >>>>>>>>>>>>

   >>>>>>>>>>>> and paste the results into a reply.

   >>>>>>>>>>>>

   >>>>>>>>>>>> Regards,

   >>>>>>>>>>>> John Ralls

   _______________________________________________

   gnucash-user mailing list

   [16]gnucash-user at gnucash.org

   To update your subscription preferences or to unsubscribe:

   [17]https://lists.gnucash.org/mailman/listinfo/gnucash-user

   If you are using Nabble or Gmane, please see
   [18]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.

References

   1. mailto:cleanoutmyshed at gmail.com
   2. mailto:samantha at boorertranslations.com
   3. mailto:samantha at boorertranslations.com
   4. mailto:jralls at ceridwen.us
   5. mailto:gnucash-user at gnucash.org
   6. mailto:jralls at ceridwen.us
   7. mailto:samantha at boorertranslations.com
   8. mailto:jralls at ceridwen.us
   9. mailto:samantha at boorertranslations.com
  10. mailto:jralls at ceridwen.us
  11. mailto:samantha at boorertranslations.com
  12. mailto:jralls at ceridwen.us
  13. mailto:samantha at boorertranslations.com
  14. mailto:jralls at ceridwen.us
  15. mailto:frank.h.ellenberger at gmail.com
  16. mailto:gnucash-user at gnucash.org
  17. https://lists.gnucash.org/mailman/listinfo/gnucash-user
  18. https://wiki.gnucash.org/wiki/Mailing_Lists


More information about the gnucash-user mailing list