[GNC] No Stock Quotes - OS Monterey, Gnucash 4.8(Build ID: 4.8a+(2021-09-28))

[smada46 at hotmail.com]

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 at 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 at 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 <jralls at 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, smada46 at 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 at 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 at 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 at 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 at 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
>> 
>> 
>