[GNC] Issue with Finance::Quote

[John Ralls]

Try this: Open a Strawberry Perl shell, and run

C:\Windows>set ALPHAVANTAGE_API_KEY=A1B2C3D4E5
C:\Windows>c:\Strawberry\cpan\build\Finance-Quote-1.57-0\Examples\stockdump.pl alphavantage QQQ

If you still get the "Can't get an undefined value" error you have good reason to open an issue at https://github.com/finance-quote/finance-quote/issues.

If not there's more to investigate here.

Regards,
John Ralls



> On Jul 27, 2023, at 7:37 AM, bernard at deprez.biz wrote:
> 
> Thanks for that suggestion - did that on 2 different Windows systems, both still fail the same way...
> 
> C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump alphavantage QQQ
> * 10:21:02 ERROR <gnc.price-quotes> [parse_quotesource_error()] Unrecognized Finance::Quote Error Can't use an undefined value as a HASH reference at C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234.
> Finance::Quote retrieval failed with error Unrecognized Finance::Quote Error: Can't use an undefined value as a HASH reference at C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234.
> 
> I've even tried a new Alphavantage API key (with different email) - same issue
> 
> Is Alphavantage the only solution? I see multiple other sources but not googleweb for example...
> 
> Thx,
> B.
> 
> 
> On 26/07/2023 23:57, john wrote:
> 
>> It looks like your Alphavantage.pm got corrupted. Try opening the Strawberry Perl cpan shell and telling it `force install Finance::Quote` to reinstall it.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Jul 26, 2023, at 04:48, bernard at deprez.biz wrote:
>>> 
>>> Hi Ken,
>>> 
>>> I tried googleweb and get a response
>>> 
>>> C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump googleweb QQQ
>>> Finance::Quote fields GnuCash uses:
>>>     symbol: QQQ             <=== required
>>>       date: 07/25/2023      <=== recommended
>>>   currency: USD             <=== required
>>>       last: 378.78          <=\
>>>        nav:                 <=== one of these
>>>      price:                 <=/
>>> 
>>> That is indeed the last price available
>>> 
>>> So I guess it's an issue only with alphavantage? I triplechecked my API key (which is set both as an environment variable & in GnuCash) and it is the correct one.
>>> 
>>> Any other suggestions that could help me?
>>> 
>>> Thanks,
>>> Bernard
>>> 
>>> 
>>> On 25/07/2023 22:01, Ken Farley wrote:
>>>> Are you able to get quotes for that particular security using any of the other sources in F::Q, like googleweb, yahooweb, yahoo_json? I get prices from any one of those.
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> To update your subscription preferences or to unsubscribe:
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> -----
>>>> 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
>>> gnucash-user at gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.