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