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

[John Ralls]

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