I tried the URL and got good data going back to early December. I had already done something similar which suggested to me that the problem isn’t at Alphavantage.
I tried gnc-fq-update and got this reponse: Database was generated on Sat, 18 Apr 2018 14:48:16 GMT Date::Manip is up to date (6.61). Finance::Quote is up to date (1.47). I appreciate your help. I hope you’ll have another suggestion. Anne From: John Ralls [mailto:jra...@ceridwen.us] Sent: Saturday, Apr 28, 2018 11:12 AM To: Anne Bartley Cc: gnucash Users-List Subject: Re: [GNC] quotes - internal server error Please remember to copy the list on all replies. I tried munging my key and found that alphavantage didn’t seem to care, so that’s probably not a source of the problem. You could try the URL https://www.alphavantage.co/query?function=TIME_SERIES_DAILY <https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&outputsize=compact&datatype=json&apikey=XXXXXXXXXXXXXXX&symbol=JNJ> &outputsize=compact&datatype=json&apikey=XXXXXXXXXXXXXXX&symbol=JNJ In your browser, replacing XXXXXXXXXXXXXXX with your API key. You should get a several-mont JSON dump of JNJ price history. If that works then I’d suspect that something is wrong with the networking setup in your perl installation. Running gnc-fq-update might help. Regards, John Ralls On Apr 28, 2018, at 7:49 AM, Anne Bartley <ambart...@sympatico.ca> wrote: Thanks for the reply. I just tried again and it didn't work. I've been trying this for two weeks. There hasn't been much complaint so there must be something wrong with my system but I can't figure out what. One possible source of error is the API key but if I try to get a new one from Alphavantage it tells me that I already have one and gives me the one that I'm using so it can't be wrong. Is there something else I can do? Thank you. Anne -----Original Message----- From: John Ralls [mailto:jra...@ceridwen.us] Sent: Saturday, Apr 28, 2018 10:32 AM To: Anne Bartley Cc: gnucash-user@gnucash.org Subject: Re: [GNC] quotes - internal server error On Apr 26, 2018, at 6:49 PM, Anne Bartley <ambart...@sympatico.ca> wrote: The last online quote I have is on April 11. A few days later, they stopped working, The message is always "Unable to retrieve quotes for these items: ." I tried updating to F::Q 1.47 and gnucash 2.6.21. I found the new online quote entry in preferences and set it to my alphavantage API key but it still didn't work. After much digging around, here's what I came with to try: In a cmd window on Windows 10: cd ..\..\Program Files (x86)\gnucash\bin set ALPHAVANTAGE_API_KEY=[my api key] perl gnc-fq-dump -v alphavantage JNJ There's nothing useful in what comes back. The errormsg is "Internal Server Error" I've done the following: perl gnc-fq-check perl -v The reply to the first is 1.47. The reply to the second is "This is perl 5, version 26, subversion 1. Can someone give me some advice on how to get quotes working again? “Internal server error” usually means that the server you’re trying to connect to--i.e. alphavantage--had a problem with the request. It worked for me just now, so try again. Regards, John Ralls --- This email has been checked for viruses by AVG. http://www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> Virus-free. <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> www.avg.com _______________________________________________ gnucash-user mailing list gnucash-user@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.
