[GNC] Still can't update price quotes

Tue Mar 19 23:22:40 EDT 2019

I think I tracked it down. First gnc-fq-dump alphavantage APPL returns
"This stock quote cannot be used by GnuCash!". Next I tried gnc-fq-dump
yahoo-json APPL and go the same error, however if I use yahoo_json with a
stock in my gnucash price database it correctly gives me the price. I have
a number of stocks so on David's advice I switch all of my stocks to
yahoo-json, tried to get quotes and got the same "There was an unknown
error while retrieving the price quotes". I then looked at each security
closer and found one that seemed odd and disabled it. I no longer get the
unknown error and my prices are up to date.

Thank you all

On Fri, Mar 8, 2019 at 1:18 PM D <sunfish62 at yahoo.com> wrote:

> How many quotes are you attempting to retrieve? If it's more than five,
> you're likely to run into Alphavantage's throttling. That is a major reason
> why many users switched onward to Yahoo-json.
>
> David
>
> On March 8, 2019, at 11:25 PM, rmcasali at gmail.com wrote:
>
> Hi,
>
> I'm having the same problem. All source works with 'gnc-fq-dump', but
> gnucash still giving error message "Unable to retrieve quotes for these
> items:".
>
> The last time I update the price quotes was 01st March, after that my
> linux system update perl5 packages and I couldn't update any price
> quotes anymore. I don't know with have some relation, but it was only
> thing I saw different.
>
> I hope it's helps to find out the problem.
>
> Rafael Casali
>
>
> On Fri, 2019-03-08 at 07:57 -0800, John Ralls wrote:
> > Unfortunately there are no logs.
> >
> > Have you triple-checked that you have the Alphavantage API key set
> > correctly?
> >
> > To troubleshoot further first check that quote retrieval works at
> > all: Try
> >   gnc-fq-dump alphavantage AAPL
> > from the command line. You'll probably need to specify a full path to
> > gnc-fq-dump, and you'll need to set ALPHAVANTAGE_API_KEY in the
> > environment. If that works try one of your own stocks (unless you
> > hold Apple in which case you already have). If that works then
> > disable quote retrieval on all but that stock inside of GnuCash and
> > try to get prices. If that works then there's some security that's
> > causing F::Q to blow up and you need to figure out which one.
> >
> > The best way to do that is called "binary search": You disable half
> > of the active ones and try. If that fails, disable half of the rest
> > and try again. Keep doing that until it succeeds. At that
> > point  reenable the most recent set that you disabled and disable the
> > others. Keep doing that until you've found one security that fails.
> > Re-enable all of the rest and try. If it fails then you need to
> > repeat the process, perhaps several times, to find all of the
> > securities that fail.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Mar 7, 2019, at 9:15 PM, Elias K Gardner <zorkerz at gmail.com>
> > > wrote:
> > >
> > > Thanks John I just double checked all of my securities. They all
> > > either have online quotes disabled or are set to alphavantage, no
> > > Yahoo left. Is there a log or something to get more details about
> > > the error?
> > >
> > > On Thu, Mar 7, 2019 at 10:59 AM John Ralls <
> > > jralls at ceridwen.fremont.ca.us> wrote:
> > > Make sure that you have no securities using any yahoo source except
> > > yahoo_json (which BTW still works well and unlike alphavantage
> > > doesn't throttle). Any attempt to use the other yahoo sources will
> > > cause the entire retrieval to fail.
> > >
> > > Regards,
> > > John Ralls
> > >
> > >
> > > > On Mar 7, 2019, at 7:34 AM, Elias K Gardner <zorkerz at gmail.com>
> > > > wrote:
> > > >
> > > > My apologies I left out the error, its:  "
> > > >
> > > > On Thu, Mar 7, 2019 at 10:32 AM Elias K Gardner <
> > > > zorkerz at gmail.com> wrote:
> > > >
> > > > > I'm still getting the"" error when trying to update my price
> > > > > database. I
> > > > > got an alpha advantage key, put it in gnucash, and updated my
> > > > > Finance::Quote perl module to 1.47. At one point that seemed to
> > > > > sort of
> > > > > work but now I just get the "" error. Most of my quotes are
> > > > > approaching a
> > > > > year old. The absolute newest is from November 2018.
> > > > >
> > > > > Any suggestions on what I can do? I've searched this list
> > > > > multiple times
> > > > > already without luck. I fear that I broke something in one of
> > > > > my many
> > > > > attempts to fix this over the past year. Maybe I should start
> > > > > fresh. I've
> > > > > attempted to purge gnucash and reinstall but this does not seem
> > > > > to start
> > > > > everything fresh and frankly purging perl is a little over my
> > > > > head without
> > > > > clear guidance. Someday I'll reinstall ubuntu entirely (using
> > > > > 18.10 now, no
> > > > > fresh install for a few years) but thats become a bigger and
> > > > > bigger chore.
> > > > >
> > > > > I'm open to any suggestions. Much appreciated.
> > > > > <gnucash-user at gnucash.org>
> > > > >
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user at 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.
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at 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.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>