[GNC] quotes - internal server error

Anne Bartley ambartley at sympatico.ca
Sat Apr 28 15:28:18 EDT 2018


Yes, it did include the listing of modules. I assumed the information of interest was the version code so I didn't include the rest. 

Anne

-----Original Message-----
From: John Ralls [mailto:jralls at ceridwen.us] 
Sent: Saturday, Apr 28, 2018 3:12 PM
To: Anne Bartley
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] quotes - internal server error

Hmm, something I missed from your first post: You said that "The reply to [perl gnc-fq-check] is 1.47".
It should return 
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual" "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")

Did it, and you just elided the rest, or did it not return the listing of the modules?

Regards,
John Ralls



> On Apr 28, 2018, at 8:28 AM, Anne Bartley <ambartley at sympatico.ca> wrote:
> 
> 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&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
>> 
>  
>  
> 
> Virus-free. www.avg.com



More information about the gnucash-user mailing list