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 <saman...@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 <saman...@boorertranslations.com>
>> To: John Ralls <jra...@ceridwen.us>
>> CC: Gnucash Users <gnucash-user@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 < jra...@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 <
>>>> saman...@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 < jra...@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 <
>>>>>> saman...@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 < jra...@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 <
>>>>>>>> saman...@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 < jra...@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 <
>>>>>>>>>> saman...@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 < jra...@ceridwen.us> wrote:
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>> On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger <
>>>>>>>>>>>> frank.h.ellenber...@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
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
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.
