OK Andreas, so this isn't really a GnuCash issue per se, and we seem to
have narrowed down the problem to one of Perl / Finance::Quote /
Alphavantage / Your computer.
The next steps are to independently verify the connection from your
computer to Alphavantage.
Step 1: Can you access their API documentation page?
https://www.alphavantage.co/documentation/
Step 2: Can you call their API using their *demo* API Key?
https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE&from_currency=USD&to_currency=JPY&apikey=demo
Step 3: Can you call their API using *your* API Key?
Don't forget to append your actual API key to the URL:
https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE&from_currency=GBP&to_currency=EUR&apikey==__Your_Actual_Key__
See attached screenshot.
If all of the above are working, my recommendation would be to uninstall
Perl and reinstall from scratch *or* (if you have Windows 10
Professional) you could use a Windows 10 Sandbox to do a clean
installation of both GnuCash and Perl to try and further isolate the
cause of the problem.
https://www.howtogeek.com/399290/how-to-use-windows-10s-new-sandbox-to-safely-test-apps/
Good luck!
Geoff
=====
P.S. What version of Windows do you have?
P.P.S. What version of Strawberry Perl are you running?
perl -v
On 12/09/2020 6:41 pm, Andreas Vyrides wrote:
Dear Geoff and Ralls
After following along with the provided link, I ended up running "force
install Finance::Quote", to verify the integrity of the module, and
tried a different API key. The similarities end in the post on the 8th
of august, where Samantha is able to query alphavantage and get a
correct exchange rate via the terminal, where I am not. Please see the
attached screenshot for the information described above.
All previous tests that I have run in cmd remain the same
Kind Regards
Andreas Vyrides
On 12/09/2020 08:54, Andreas Vyrides wrote:
Dear Geoff
I apologise for the misunderstanding. Yes I did run set my
alphavantage key before running the commands. Please see the attached
screenshot.
I will have a close look at the link provided. In case you have any
other ideas about why this is happening, please do not hesitate to
contact me
Kind Regards
Andreas Vyrides
On 12/09/2020 01:59, Geoff wrote:
Dear Andreas
Did you set your Alphavantage key as an environment variable before
you ran this test script? Try entering these commands first:
set ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
echo %ALPHAVANTAGE_API_KEY%
See attached screenshot.
See also this long thread on resolving a perl related currency
problem on Windows:
http://gnucash.1415818.n4.nabble.com/GNC-Difficulty-with-online-price-retrieval-John-Ralls-tc4720222.html
Regards
Geoff
=====
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
