Stock quote can't be updated
David Carlson
david.carlson.417 at gmail.com
Sun Apr 30 12:02:32 EDT 2017
Yesterday (Saturday evening Central time) I briefly had a problem when
getting a quote for ^GSPC (S&P 500) using Yahoo, but a few minutes later it
worked ok. I wonder if there has recently been a back end change to the
exchange reporting system that is allowing some garbage to escape from time
to time.
David C
On Sun, Apr 30, 2017 at 10:10 AM, Daniel Rosenberg <dnlrsnbrg at gmail.com>
wrote:
> 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
> > *********************************************
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
More information about the gnucash-user
mailing list