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.
