[GNC] Finance quote troubleshooting

[Geoff]

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
>>> =====
>>>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: gnc_alphavantage_test_url.jpg
Type: image/jpeg
Size: 38869 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20200912/98d96224/attachment.jpg>