[GNC] Difficulty with online price retrieval

Samantha Payn samantha at boorertranslations.com
Wed Aug 12 09:54:02 EDT 2020


   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 < [1]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 <
   [2]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 < [3]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 <
   [4]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 < [5]jralls at ceridwen.us> wrote:

   On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger <
   [6]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

References

   1. mailto:jralls at ceridwen.us
   2. mailto:samantha at boorertranslations.com
   3. mailto:jralls at ceridwen.us
   4. mailto:samantha at boorertranslations.com
   5. mailto:jralls at ceridwen.us
   6. mailto:frank.h.ellenberger at gmail.com


More information about the gnucash-user mailing list