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 
<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.

Reply via email to