[GNC] Finance quote troubleshooting

[Andreas Vyrides]

Dear Geoff,

Thank you for all your feedback. I have done as you instructed.

I was able to follow the instructions from the 3 first points with 
success, as I am able to access the documentation, the demo key, as well 
as the exchange rates using my own key. Please see the screenshot (6) 
provided (using my own key)

I was also able to do a clean install in windows sandbox, which was also 
a success, where I am able to get forex data from both cmd as well as 
gnucash (from F::Q) (please see attached screenshot 8).

The issue at this point in time is that I am not aware of how to 
proceed, in order to allow F::Q to work on my machine without requiring 
the use of sandbox. I have already removed and re-installed gnucash and 
F::Q multiple times without any changes. On first look one of the things 
that differs from the native windows environment and sandbox is the 
presence of my antivirus, which would be an unlikely candidate as I have 
the same antivirus in a desktop computer and F::Q works fine.

I am open to any type of suggestions.

I appreciate all your help and feedback helping me deal with this issue.

Kind Regards

Andreas Vyrides

On 12/09/2020 12:19, Geoff wrote:
> 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: Screenshot (6)_LI.jpg
Type: image/jpeg
Size: 106452 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20200912/52b5e9b8/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot (8)_st.jpg
Type: image/jpeg
Size: 594960 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20200912/52b5e9b8/attachment-0003.jpg>