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

[dennis adams]

John,
It is finally working.  Tried the “gnc-fq-dump -v yahoo_json XOM” command a few times and always got same “Internal Server” error.  Tried “sudo cpan” to start download of Mozilla::CA process with same results stating “ running another cpan process” despite finding no cpan running processes in Activity Monitor and eventually using “sudo killall cpan”.  Finally just told it to overwrite the lock file.  Once that was done, ran the “install Mozilla::CA” command which it did and after that quote download worked.  I’ve attached the Terminal dump in case you are interested.  Again, I appreciate all your help and patience and David R’s help




On Feb 11, 2022, at 15:12, John Ralls <jralls at ceridwen.us<mailto: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<mailto: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<http://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




-------------- next part --------------
A non-text attachment was scrubbed...
Name: Install Mozilla--CA 2-12-22.pdf
Type: application/pdf
Size: 31739 bytes
Desc: Install Mozilla--CA 2-12-22.pdf
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220213/20a57dee/attachment-0001.pdf>