Stock quote can't be updated

[Daniel Rosenberg]

Hi John,

thanks a lot for the input, although this was not the solution, it pushed
me to dig a bit further and find the cause for my sytem error.
First of all, I recently added a few stocks but didn't think much of it as
being the cause for the system error, as I don't update the quotes very
often. So when I updated the first time about 2 weeks ago, I got the system
error and it hasn't worked since then.
Right after your mail I looked into the stock editor and saw something
strange: the new stocks were showing as having two lines while the old
stocks where showing as one line (see attaches file stock editor overview).
In the editor detail view everything seemed normal, but I deleted the stock
symbol entries and typed them again. After that, the stock would show as
one line onky in the overview window.
Then it came to me: while I was entering my new stocks and funds, I copied
the symbol into the editor from a CSV file my stock broker provided me.
Somehow this led to the symbol having 2 lines (possibly a CR/LF at the end
of the symbol?)
I then manually typed the symbol into all my new stocks and funds and now
it works, even with Multiple Sources --> Europe.

I hope this helps somebody with the same problem.


Daniel
[image: stock editor overview.jpg]

John Ralls <jralls at ceridwen.us> schrieb am Sa., 6. Mai 2017 um 18:30 Uhr:

>
> On May 6, 2017, at 8:19 AM, Daniel Rosenberg <dnlrsnbrg at gmail.com> wrote:
>
> It seems to me the problem lies within the system error that alway comes up
> the first time I update the quotes. Maybe this messes something up, so that
> the second update retrieves wrong values.
> I have uninstalled and reinstalled GnuCash and Strawberry Perl, to no
> effect.
> I created a new GnuCash file, added 2 stocks and updated it without a
> problem (using Single-->Yahoo Europe).
> Could it be possible that I am quoting too many stocks (27 funds, 4
> currencies at the moment)?
> Or could it be that my GnuCash file is corrupted?
> Or is it too big (2.2 MB, over 9 years of data)?
> Is there any possibility to get more detailed information about this system
> error that pops up? It doesn't seem to write anything to the log file in
> debug mode.
>
>
> It's the "system error". Your output from gnc-fq-helper shows the actual
> problem:
>
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-helper
> (europe "eunt.de")
> Parsing of undecoded UTF-8 will give garbage when decoding entities at
> C:/strawberry/perl/site/lib/HTML/TableExtract.pm line 204, <> line 1.
> (("eunt.de" (symbol . "eunt.de") (gnc:time-no-zone . "2017-04-28
> 17:36:00")
> (last . 110.54) (currency . "EUR")))
>
>
> The code that reads that output can't parse the error message part and
> isn't smart enough to skip it, so it raises the "system error". Erik Colson
> (the Finance::Quote maintainer) will have to fix that.  Try changing the
> price source on those commodities from Multiple:Europe to Single:Yahoo
> Europe.
>
> Regards,
> John Ralls
>
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: stock editor overview.jpg
Type: image/jpeg
Size: 46450 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170506/fed3ca23/attachment-0001.jpg>