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, bern...@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, bern...@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@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@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@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.
