[GNC] quotes - internal server error

[Anne Bartley]

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:jralls at 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 <ambartley at 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:jralls at ceridwen.us] 
Sent: Saturday, Apr 28, 2018 10:32 AM
To: Anne Bartley
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] quotes - internal server error






On Apr 26, 2018, at 6:49 PM, Anne Bartley <ambartley at 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