[GNC] Still can't update price quotes

John Ralls jralls at ceridwen.fremont.ca.us
Fri Mar 8 10:57:42 EST 2019


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:  "There was an unknown error while
> > retrieving the price quotes"
> > 
> > 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.
> 



More information about the gnucash-user mailing list