Stock quote can't be updated
Daniel Rosenberg
dnlrsnbrg at gmail.com
Sun Apr 30 11:10:50 EDT 2017
Hi,
I am having a similar problem, my stock quotes haven't been updated since
21 April, but it seems to be a problem within GnuCash (running 2.6.15 on
Windows 10).
gnc-fq-dump and gnc-fq-helper seem to work just fine:
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump europe eunt.de
Finance::Quote fields Gnucash uses:
symbol: eunt.de <=== required
date: 04/28/2017 <=== recommended
currency: EUR <=== required
last: 110.54 <=\
nav: <=== one of these
price: 110.54 <=/
timezone: <=== optional
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")))
When I try to update from within GnuCash (tested with 2.6.14, 2.6.15 and
2.6.16), I either get an error stating that there was a system error during
stock quote retrieval, or I get a message that all stocks retrieved using
Multiple Sources --> Europe (Yahoo...) could not be updated, although
gnc-fq-dump europe works just fine (see above).
I then changed to Single --> Yahoo Europe (or USA for that matter) and F::Q
returns a stock quote, but it is a wrong one. For the above mentioned
EUNT.DE I get a quote of around 0.12, although the quote should be around
110.54 (see above). Same for all the other funds I tested, every quote is
wrong.
Any ideas?
Daniel
d gn
<Message: 2
> Date: Fri, 28 Apr 2017 12:22:15 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: Mick Hartzell <mick.hartzell at mac.com>
> Cc: Chris Henderson <henders254 at gmail.com>, "gnucash-user at gnucash.org"
> <gnucash-user at gnucash.org>
> Subject: Re: Stock quote can't be updated
> Message-ID: <C826D63E-F4FF-4EE8-811F-2660B7D9629D at ceridwen.us>
> Content-Type: text/plain; charset=utf-8
>
>
> > On Apr 28, 2017, at 10:26 AM, Mick Hartzell <mick.hartzell at mac.com>
> wrote:
> >
> > I am also having the same problem.
> >
> > No stock quote update since 20 April 2017.
> >
> > ./gnc-fq-dump nyse -v prwcx
> > Finance::Quote fields Gnucash uses:
> > symbol: -v <=== required
> > date: ** missing ** <=== recommended
> > currency: ** missing ** <=== required
> > last: <=\
> > nav: <=== one of these
> > price: <=/
> > timezone: <=== optional
> >
> > ** This stock quote cannot be used by GnuCash!
> >
> > =====
> >
> > Finance::Quote fields Gnucash uses:
> > symbol: prwcx <=== required
> > date: ** missing ** <=== recommended
> > currency: USD <=== required
> > last: 27.89 <=\
> > nav: <=== one of these
> > price: <=/
> > timezone: <=== optional
> >
> > ** This quote will have today's date, which might be incorrect.
> > GnuCash will use it, but you might prefer that it doesn?t.
> >
> > <PastedGraphic-1.tiff>
> >
> > I changed source to be USA (Yahoo,?) and it made no difference.
> Received the same error message.
>
> Both NYSE and USA are aggregate sources that check a series of real
> sources, beginning with Yahoo!, until they get a result. The first result
> wins even if it's incomplete. In the case of PRWCX it seems that Yahoo!
> isn't returning a date. That's unfortunate because GnuCash will use today's
> date and of course being a mutual fund the price is really the NAV at
> yesterday's market close.
>
> Being that it's a T. Rowe Price fund you'd think that either the
> troweprice or troweprice_direct sources would return data for it, but
> neither does. That's more likely to be because the screen-scraping is
> broken than that those websites aren't reporting the price on their own
> funds.
>
> BTW folks, the '-v' goes *before* the source: gnc-fq-dump -v yahoo prwcx
>
> Regards,
> John Ralls
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 29 Apr 2017 01:33:20 +0200
> From: "Frank H. Ellenberger" <frank.h.ellenberger at gmail.com>
> To: John Ralls <jralls at ceridwen.us>
> Cc: Mick Hartzell <mick.hartzell at mac.com>, "gnucash-user at gnucash.org"
> <gnucash-user at gnucash.org>, Chris Henderson <henders254 at gmail.com>
> Subject: Re: Stock quote can't be updated
> Message-ID: <1bfcdb28-7eda-944b-6133-652a6eb26438 at gmail.com>
> Content-Type: text/plain; charset=utf-8
>
> John, you are right here, but gnc-fq-dump was lying.
> Am 28.04.2017 um 21:22 schrieb John Ralls:
> :
> > BTW folks, the '-v' goes *before* the source: gnc-fq-dump -v yahoo prwcx
> >
> you are right here, but gnc-fq-dump was lying until now.
>
> Fixed in maint.
>
> Regards
> Frank
>
>
> ------------------------------
>
> Message: 4
> Date: Sat, 29 Apr 2017 11:00:32 -0400
> From: Cindy Doughty <dbdoughty at gmail.com>
> To: kr <kr at bell.net>
> Cc: gnucash-user <gnucash-user at gnucash.org>, Christopher Lam
> <christopher.lck at gmail.com>
> Subject: New multiple periods side by side report
> Message-ID:
> <CAB3Z30z9vuxJcPnN_kArberKBaEw4ez4WvM8hpvdqp7Q=
> 3-TwQ at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Attached is a new multiple periods side by side report which will display
> accounts from multiple time periods.
>
> kr- thanks for testing the Beta version.
>
> To install it, place the following three files in your .gnucash folder. On
> windows this is c:\users\YOUR_ID\.gnucash
> The gnctimeperiod-utilities.scm is the same one I have previously posted.
> If you already have a config.user file, just use a text editor and copy in
> the new entries.
>
>
> Doug Doughty
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: comparison-transactions.scm
> Type: application/octet-stream
> Size: 146545 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170429/50580b6c/attachment.obj
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: config.user
> Type: application/octet-stream
> Size: 187 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170429/50580b6c/attachment-0001.obj
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: gnctimeperiod-utilities.scm
> Type: application/octet-stream
> Size: 40024 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170429/50580b6c/attachment-0002.obj
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 169, Issue 57
> *********************************************
>
More information about the gnucash-user
mailing list