No, Yahoo-JSON is a normal restful API over https, as you observed earlier with your browser.
Do you get the http 500 error if you try curl https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl from the command line? Regards, John Ralls > On Mar 22, 2019, at 11:47 AM, Bruno Acklin <back...@gmail.com> wrote: > > Thanks John, > > I deleted Library/Perl/Finance and reinstalled finance::quote using the sudo > command. > Installed ok, but no change on errors and messages. > > The only change I made between finance::Quote running and now failing was > replacing my router from an old Apple TimeCapsule to a U-verse PACE 5268AC > modem.. > > Is there a TCP or UDP port, or another router setting that FQ, respectively > JSON needs, which may not be set properly by default? > > Thanks, Bruno > > >> On Mar 21, 2019, at 12:17 PM, John Ralls <jra...@ceridwen.fremont.ca.us> >> wrote: >> >> Probably not. What would change is the Perl version and consequently what >> folders @INC points to, but that hasn't changed in the last 5 versions, it's >> been 5.18 since Yosemite. >> >> gnc-fq-dump doesn't use Date::Manip, but if your Date::Manip is broken it's >> quite possible that your Finance::Quote is too. They should be installed in >> /Library/Perl/5.18. I suggest deleting them and running the Finance Quote >> Update again; if you're comfortable with the command line you can just use >> `sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update` from >> there, that's all that Finance Quote Update does. >> >> Regards, >> John Ralls >> >>> On Mar 21, 2019, at 10:54 AM, Bruno Acklin <back...@gmail.com> wrote: >>> >>> Hi John, >>> >>> Thanks so much for all the work you do supporting us and your diligent test >>> of the Yahoo_json script! >>> >>> I have restarted my Mac and Gnucash. The price quote keeps failing on my >>> desktop and laptop test systems. >>> >>> I keep getting the 500 server error when I use the Terminal command: >>> gnc-fq-dump -v yahoo_json aapl >>> >>> But I get another message and hint when I use the helper command: >>> gnc-fq-helper yahoo_json aapl >>> >>> Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip >>> module) (@INC contains: /Library/Perl/5.18/darwin-thread-multi-2level >>> /Library/Perl/5.18 /Network/Library/Perl/5.18/darwin-thread-multi-2level >>> /Network/Library/Perl/5.18 >>> /Library/Perl/Updates/5.18.2/darwin-thread-multi-2level >>> /Library/Perl/Updates/5.18.2 >>> /System/Library/Perl/5.18/darwin-thread-multi-2level >>> /System/Library/Perl/5.18 >>> /System/Library/Perl/Extras/5.18/darwin-thread-multi-2level >>> /System/Library/Perl/Extras/5.18 .) at >>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper line 29. >>> BEGIN failed--compilation aborted at >>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper line 29. >>> >>> Did a MacOS update change something in.my working Perl configuration, and >>> do you have any recommendations on how to fix this? >>> >>> Thanks, Bruno >>> >>>> On Mar 20, 2019, at 5:26 PM, John Ralls <jra...@ceridwen.fremont.ca.us> >>>> wrote: >>>> >>>> Bruno, >>>> >>>> I just tested, works fine for me: >>>> $ Argus:/Users/john> gnc-fq-dump yahoo_json AAPL >>>> Finance::Quote fields Gnucash uses: >>>> symbol: AAPL <=== required >>>> date: 03/20/2019 <=== recommended >>>> currency: USD <=== required >>>> last: 188.16 <=\ >>>> nav: <=== one of these >>>> price: <=/ >>>> timezone: <=== optional >>>> >>>> A 500 server error means a glitch at Yahoo!, not anything to do with >>>> Finance::Quote. They'd obviously resolved it by the time you used your >>>> browser. >>>> >>>> Regards, >>>> John Ralls >>>> >>>> >>>>> On Mar 20, 2019, at 3:43 PM, Bruno Acklin <back...@gmail.com> wrote: >>>>> >>>>> Hi John, et all, >>>>> >>>>> I am adding to this string as I experience a similar, possibly related >>>>> problem: >>>>> >>>>> I am using Gnucash on OSX Mojave 10.14.3. Alphavantage never really >>>>> worked for me and importantly, crashed Gnucash instead of reporting >>>>> stocks that could not be retrieved. >>>>> >>>>> Then in February I switched all my stocks tickers to yahoo_json, >>>>> verifying them with the fnc-gc-dump procedure and it worked great, last >>>>> on 3/8/19. >>>>> >>>>> Now, since 3/17/19, it suddenly fails all tickers, and fnc-gc-dump >>>>> reports this error: >>>>> Error retrieving quote for aapl. Attempt to fetch the URL >>>>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl resulted >>>>> in HTTP response 500 (Internal Server Error) >>>>> >>>>> But, a browser call to the same website >>>>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl >>>>> >>>>> returns the data properly: >>>>> {"quoteResponse":{"result":[{"language":"en-US","region":"US","quoteType":"EQUITY","quoteSourceName":"Nasdaq >>>>> Real Time >>>>> Price","currency":"USD","priceHint":2,"postMarketChangePercent":-0.09571613,"postMarketTime":1553116993,"postMarketChange":-0.18009949,"regularMarketChangePercent":0.873857,"regularMarketDayRange":"184.73 >>>>> - >>>>> 189.49","regularMarketPreviousClose":186.53,"bid":187.83,"ask":187.98,"bidSize":13,"askSize":13,"messageBoardId":"finmb_24937","fullExchangeName":"NasdaqGS","longName":”Apple >>>>> ... >>>>> >>>>> I surmise that the URL response may have changed so the yahoo_json parser >>>>> does not recognize the information, but I am not a SW person familiar >>>>> with PERL.. >>>>> Any suggestion what might have changed, and what to fix? >>>>> >>>>> Thanks, Bruno >>>>>> On Feb 22, 2019, at 7:11 AM, John Ralls <jra...@ceridwen.us> wrote: >>>>>> >>>>>> >>>>>> >>>>>>> On Feb 20, 2019, at 7:06 AM, GB <galaxy-b...@hotmail.com> wrote: >>>>>>> >>>>>>> Thank you John Ralls, I think I've narrowed down the problem. >>>>>>> >>>>>>> I unchecked all of the securities that had source of "tsp" and I was >>>>>>> able to >>>>>>> get all the quotes from yahoo_json. Then I used a terminal window to >>>>>>> run >>>>>>> "./gnc-fq-dump -v tsp c" and received response of: >>>>>>> "No results found for stock C." The funds are C,S,I. I have used this >>>>>>> for >>>>>>> at least several years and have not had any problems, this has been >>>>>>> appearing recently. When I include the tsp funds in the security >>>>>>> editor, it >>>>>>> causes all of the other security quotes to fail, even those from other >>>>>>> sources. >>>>>>> >>>>>>> Any clues as to what I should do next? >>>>>> >>>>>> It looks like >>>>>> https://www.tsp.gov/investmentfunds/shareprice/sharePriceHistory.shtml >>>>>> has an invalid redirect, so there's nothing to retrieve. Unless that's >>>>>> fixed you won't be able to use Finance::Quote to retrieve prices. I >>>>>> found https://www.tsp.gov/InvestmentFunds/FundPerformance/index.html >>>>>> where you can download a CSV that you might be able to import into >>>>>> GnuCash. >>>>>> >>>>>> Regards, >>>>>> John Ralls >>>>>> _______________________________________________ >>>>>> 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. >>>>> >>>> >>> >> > > _______________________________________________ > 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. _______________________________________________ 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.
