Yahoo!! It works now. I had to uninstall two copies of Strawberry Perl (5.26.1001) and an older one. Attempting to run the "Install Online Quotes Tool" downloaded Strawberry Perl and then failed with error code 1602. A brief search suggested that I might need to turn off my antivirus program. Instead, I found and installed Strawberry Perl myself. Then I reran the " Install Online Quotes Tool" again. This time it chugged along merrily, spitting out several pages of messages, which I took as a good sign. Trying "perl gnc-fq-dump -v alphavantage JNJ" finally produced the expected result. The last test was to get quotes from within gnucash. That went very well. My investments are up to date again.
Thank you so much for your help! Cheers, Anne -----Original Message----- From: John Ralls [mailto:jra...@ceridwen.us] Sent: Saturday, Apr 28, 2018 4:47 PM To: Anne Bartley Cc: gnucash-user@gnucash.org Subject: Re: [GNC] quotes - internal server error I'm guess then that the problem is somewhere in your perl http stack. Unless you're comfortable with perl development the simplest thing to try next is to uninstall perl and re-run the "Install Online Quotes Tool" in the GnuCash folder of the Start Menu. Regards, John Ralls > On Apr 28, 2018, at 12:28 PM, Anne Bartley <ambart...@sympatico.ca> wrote: > > 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:jra...@ceridwen.us] > Sent: Saturday, Apr 28, 2018 3:12 PM > To: Anne Bartley > Cc: gnucash-user@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 <ambart...@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: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&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 >>> >> >> >> >> Virus-free. 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.
