Unable to download stock quotes

[Steven Anter]

How do I run the test from command prompt

On Mar 20, 2018 9:06 PM, "Chris Good" <goodchris96 at gmail.com> wrote:

> Hi Steven,
>
>
>
> If it has been running for 15 minutes, it is very probably hung.
>
> I usually use Task Manager to kill the perl process when this happens.
>
>
>
> Nothing has changed about this that I know of for at least several months.
>
> GnuCash in Windows has been hanging when trying to get > 15 stock prices
> from Yahoo JSON since at least Nov 21 2017 for me.
>
> I didn’t use Yahoo JSON before that.
>
> This has not been a problem for me since I fixed the problems causing
> ‘uninitialized value’ perl warnings with my new YahooJSON.pm.
>
>
>
> Re suffix: To use Yahoo_JSON to get prices for stocks NOT on US exchanges,
> you have to add a suffix to the Symbol in the GnuCash Security Editor.
>
> Ie For Australia:                Add suffix .AX     E.g.        CBA ->
> CBA.AX
>
>
>
> Please run the test from the command prompt to verify you are not getting
> any ‘uninitialized value’ perl warnings.
>
>
>
> Regards, Chris Good
>
>
>
> *From:* Steven Anter <anter.s at gmail.com>
> *Sent:* Wednesday, 21 March 2018 1:28 PM
> *To:* Chris Good <goodchris96 at gmail.com>
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
>
>
> It's been running for at least 15 mins.  This used to work fine up until
> recently. Has something changed? What do you mean by  Symbol suffix?
>
>
>
> On Tue, Mar 20, 2018 at 7:14 PM, Chris Good <goodchris96 at gmail.com> wrote:
>
> Hi Steven,
>
>  You don’t need to restart GnuCash.
>
> Oh and of course now that I think about it, as you were previously using
> Yahoo JSON, you don’t need to change the Symbol suffixes.
>
> As your stocks are US stocks, you don’t need to use any Symbol suffix,
> unless you need to use info from a non US exchange.
>
>
>
> Don’t forget to do the test as per my email in the nabble link and check
> you don’t get any warnings, to ensure you have actually installed the fix
> properly.
>
>
>
> Regards, Chris Good
>
>  *From:* Steven Anter <anter.s at gmail.com>
> *Sent:* Wednesday, 21 March 2018 12:55 PM
> *To:* Chris Good <goodchris96 at gmail.com>
> *Cc:* gnucash-user at gnucash.org
>
> *Subject:* Re: Unable to download stock quotes
>
>  Chris,
>
>  Just installed your patch. I'm running finance::quote to see if it
> works.  Still slow. Did I need to restart gnucash after copying your code?
>
>  On Tue, Mar 20, 2018 at 6:42 PM, Chris Good <goodchris96 at gmail.com>
> wrote:
>
> Hi Steven,
>
> Nabble is a web site (unrelated to GnuCash) that archives many mailing
> lists including GnuCash.
>
> I included this link to Nabble:
>
> http://gnucash.1415818.n4.nabble.com/Fix-for-yahoo-json-
> for-Windows-users-tt4697837.html
> in a previous email to you as it includes instructions for getting and
> installing my fixed YahooJSON.pm.
>
> I have found using links to Nabble to be an easy way of linking to
> previous GnuCash emails.
>
> Regards, Chris Good
>
> *From:* Steven Anter <anter.s at gmail.com>
> *Sent:* Wednesday, 21 March 2018 12:32 PM
> *To:* Chris Good <goodchris96 at gmail.com>
> *Cc:* gnucash-user at gnucash.org
> *Subject:* RE: Unable to download stock quotes
>
> Chris,
>
> I'm using Windows 10. What is nabble?
>
> On Mar 20, 2018 6:18 PM, "Chris Good" <goodchris96 at gmail.com> wrote:
>
> Hi Steven,
>
>
>
> Are you using Windows? My fix only helps for Windows.
>
> In Security Editor, Select Type of quote source      Single    Yahoo as
> JSON
>
> My fix hasn’t yet been incorporated into CPAN Finance::Quote so the only
> way to get it now is to follow instructions in the nabble link. That is the
> latest version.
>
> You haven’t said from what exchange you are getting prices for, but
> similar to using suffix .AX on the symbol for Australian exchange, you will
> have to add the appropriate suffix to your Symbol if not US.
>
> I see you haven’t copied gnucash-user at gnucash.org on your reply.
>
> I assume that is because you understandably didn’t want to share how many
> stocks you have with the world.
>
> I would appreciate it if you share your experience with
> gnucash-user at gnucash.org when it is resolved, however it turns out.
>
> Regards, Chris Good
>
> *From:* Steven Anter <anter.s at gmail.com>
> *Sent:* Wednesday, 21 March 2018 11:27 AM
> *To:* Chris Good <goodchris96 at gmail.com>
> *Subject:* Re: Unable to download stock quotes
>
> Chris,
>
> Yahoo JSON was working fine until recently.  Last time I tried it, it hung
> for a while then came back with a long list of securities it couldn't
> process. I'm trying to get quotes for about 50 tickers.
>
> How do I use  YahooJSON.pm?  It's not one of the listed sites, should I
> enter it manually as "unknown?"  How do I know I have your latest version?
>
>
>
> On Tue, Mar 20, 2018 at 4:31 PM, Chris Good <goodchris96 at gmail.com> wrote:
>
> > Message: 5
> > Date: Mon, 19 Mar 2018 20:56:40 -0700
> > From: John Ralls <jralls at ceridwen.us>
> > To: santer <anter.s at gmail.com>
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: Unable to download stock quotes
> > Message-ID: <FDA85E0F-F78B-4CF3-99AB-779C45E57C62 at ceridwen.us>
> > Content-Type: text/plain;     charset=utf-8
> >
> > > On Mar 19, 2018, at 7:53 PM, santer <anter.s at gmail.com> wrote:
> > >
> > > The ability to download stock quotes has been a critical feature of
> gnucash.
> > > The yahoo resource stopped working over the last few months. A work
> > > around for me has been yahoo json, which is now so slow it's unusable.
> > >
> > > Does anyone know if something is being done to resolve this problem.
> > > What are some other work around options?
> >
> > The only general workaround besides yahoo-json that we know of is
> > Alphavantage, as explained at
> > https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3
> > F
> > <https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.
> > 3F>. It is also quite slow compared to the former Yahoo! service.
> >
> > Another alternative might be Google Finance, but there?s some concern
> about
> > their terms of service vis-a-vis screen-scraping.
> >
> > GnuCash 3.0 includes a new importer for stock prices in CSV format. If
> you
> can
> > arrange to download quotes from a financial institution with which you do
> > business you may be able to format those downloads for import.
> >
> > Beyond that, we?re pretty much stuck. Neither we nor Erik Colson, the
> > maintainer of Finance::Quote, can do much about retrieving quotes without
> a
> > service to retrieve from.
> >
> > Regards,
> > John Ralls
>
> Hi Santer,
>
> I don't think I have heard of Yahoo JSON being slow before.
> I just did a test and for my 16 stocks it took approx. 15 seconds.
> Is it just slow for you or does it actually hang?
> If you don't mind telling us, how many stocks do you have using Yahoo JSON?
>
> If you are using Windows, have you tried using my new YahooJSON.pm that has
> the warning messages fixed?
> See
> http://gnucash.1415818.n4.nabble.com/Fix-for-yahoo-json-
> for-Windows-users-tt
> 4697837.html
>
> Regards, Chris Good
>
>
>
>
>
>
>