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.
