[GNC] Finance::Quotes stopped working for me

Fri Mar 22 15:05:55 EDT 2019

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 <backlin at 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 <jralls at 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 <backlin at 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 <jralls at 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 <backlin at 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 <jralls at ceridwen.us> wrote:
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>>> On Feb 20, 2019, at 7:06 AM, GB <galaxy-bars at 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 at 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 at 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.