John, sorry about not copying list.
Ran command using yahoo_json XOM with similar result - Internal Server Error
Last login: Fri Feb 11 15:22:54 on ttys000
dwa1@dwa1 ~ % /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
yahoo_json XOM
Finance::Quote fields Gnucash uses:
symbol: XOM <=== required
date: ** missing ** <=== recommended
currency: ** missing ** <=== required
last: **missing** <=\
nav: **missing** <=== one of these
price: **missing** <=/
timezone: <=== optional
** This stock quote cannot be used by GnuCash!
All fields returned by Finance::Quote for stock XOM
stock field value
----- ----- -----
XOM errormsg: Error retrieving quote for XOM. Attempt to fetch the URL
https://query1.finance.yahoo.com/v7/finance/quote?symbols=XOM resulted in HTTP
response 500 (Internal Server Error)
XOM last: **missing**
XOM nav: **missing**
XOM price: **missing**
XOM success: 0
XOM symbol: XOM
dwa1@dwa1 ~ %
Could the error be caused by something wrong in FQ. Seems strange same error
for two different servers.
> On Feb 11, 2022, at 15:12, John Ralls <jra...@ceridwen.us> wrote:
>
> Dennis,
>
> Please remember to copy the list on all replies.
>
> No, "internal server error" indicates that something went wrong on
> Alphavantage's end. Try again after a few minutes or using yahoo_json instead:
>
> Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v yahoo_json XOM
>
>
> Regards,
> John Ralls
>
>> On Feb 11, 2022, at 1:38 PM, smad...@hotmail.com wrote:
>>
>> John,
>>
>> Ran gnc-fq-check. Version 1.51 no errors. The example in Wiki showed an
>> error message about a missing Mozilla/CA.pm. Since no error I didn’t run
>> Mozilla::CA update figuring I had certificates and that wasn’t the current
>> problem.
>> Ran gnc-fq-dump for stock XOM with result indicating the Alphavantage key
>> was missing:
>>
>> dwa1@dwa1 ~ % /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump
>> -v alphavantage XOM
>> ERROR: ALPHAVANTAGE_API_KEY *must* be set for currency quotes and
>> stock quotes with source 'alphavantage' or 'vanguard'; see
>> https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US
>> dwa1@dwa1 ~ %
>>
>> However, in checking GC Preferences, Online quotes, the Alpha Vantage API
>> Key is there. So I tried using it in the Helper dump script per the WIKI:
>> “ALPHAVANTAGE_API_KEY=XXXX
>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v alphavantage
>> XOM” with the following Terminal results:
>>
>> dwa1@dwa1 ~ % ALPHAVANTAGE_API_KEY=XXXX
>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v alphavantage
>> XOM
>> Finance::Quote fields Gnucash uses:
>> symbol: XOM (deduced) <=== required
>> date: ** missing ** <=== recommended
>> currency: ** missing ** <=== required
>> last: **missing** <=\
>> nav: **missing** <=== one of these
>> price: **missing** <=/
>> timezone: <=== optional
>>
>> ** This stock quote cannot be used by GnuCash!
>>
>> All fields returned by Finance::Quote for stock XOM
>>
>> stock field value
>> ----- ----- -----
>> XOM errormsg: Internal Server Error
>> XOM last: **missing**
>> XOM nav: **missing**
>> XOM price: **missing**
>> XOM success: 0
>>
>> dwa1@dwa1 ~ %
>>
>> So even though I have the Alphavantage key in place, it is somehow not being
>> seen and appears to be the current problem.
>>
>> Thanks
>>
>>
>> john jralls at ceridwen.us
>> Fri Feb 11 00:01:27 EST 2022
>>
>> • Previous message (by thread): [GNC] No Stock Quotes - OS Monterey,
>> Gnucash 4.8(Build ID: 4.8a+(2021-09-28))
>> • Next message (by thread): [GNC] Settings in environment.local does
>> not work
>> • Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
>> Dennis,
>>
>> You can examine the running processes in /Applications/Utilities/Actiivity
>> Monitor and kill them from there, or you can just nuke the lot with
>> sudo killall cpan
>> if you're reasonably sure that there shouldn't be any left running.
>>
>> 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.
