[GNC] Issue with Finance::Quote

[bernard at deprez.biz]

Hi John,

Tried that - same issue:

C:\Strawberry\cpan\build\Finance-Quote-1.57-0\Examples>perl stockdump.pl 
alphavantage QQQ
Can't use an undefined value as a HASH reference at 
../lib/Finance/Quote/AlphaVantage.pm line 234.

I'll look into creating that issue today.

Thanks!
B.

On 27/07/2023 15:19, John Ralls wrote:
> 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.