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 <[email protected]> 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 <[email protected]> wrote:
>>
>>
>>
>>> On Feb 20, 2019, at 7:06 AM, GB <[email protected]> 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
>> [email protected]
>> 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
[email protected]
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.
