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
=====
On 12/09/2020 7:34 am, Andreas Vyrides wrote:
Dear Mr Ralls,
It turn out you were able to correctly identify the issue for me
since I am not able to access the server. I am copying below the
results after running each command provided. I would be grateful if
you could guide me to resolve this issue.
"
C:\Program Files (x86)\gnucash\bin>perl
c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\currency-lookup.pl
GBP EUR
Urgh! Nothing back
"
and
"
C:\Program Files (x86)\gnucash\bin>perl
c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\stockdump.pl
alphavantage CSCO
$VAR1 = {
'CSCO∟errormsg' => 'Internal Server Error',
'CSCO∟success' => 0
};
"
I apreciate all your help.
Kind Regards
Andreas Vyrides
On 11/09/2020 22:03, John Ralls wrote:
Dear Mr. Vyrides,
Please remember to copy the list on all replies.
Try testing Finance::Quote directly:
set ALPHAVANTAGE_API_KEY=<your key>
perl
c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\currency-lookup.pl
GBP EUR
If that fails, try
perl
c:\strawberry\cpan\build\Finance-Quote-1.49-0\Examples\stockdump.pl
alphavantage CSCO
to make sure that you can successfully query alphavantage.
Regards,
John Ralls
On Sep 9, 2020, at 10:27 PM, Andreas Vyrides <vyr...@gmail.com> wrote:
Dear Mr Ralls,
Thank you for your prompt response
Yes I have been through both gnc-fq-check which does not produce
any errors
"
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr"
"asx" "aufunds" "australia" "bamosz" "bet" "bmonesbittburns"
"bourso" "bse" "bsero" "canada" "canadamutual" "citywire"
"cominvest" "cse" "deka" "dutch" "dwsfunds" "europe"
"fetch_live_currencies" "fidelity" "fidelity_direct"
"fidelityfixed" "financecanada" "finanzpartner" "finland" "fool"
"france" "ftfunds" "ftportfolios" "ftportfolios_direct"
"fundlibrary" "goldmoney" "greece" "hex" "hu" "hufund" "hungary"
"hustock" "iexcloud" "indiamutual" "known_currencies" "lerevenu"
"maninv" "morningstar" "morningstarau" "morningstarch"
"morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum"
"romania" "seb_funds" "sixfunds" "sixshares"
"stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref"
"tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx"
"uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds"
"vanguard" "vwd" "yahoo_json" "yahoo_yql" "za" "za_unittrusts")
"
and echo (yahoo_json "CSCO") | perl gnc-fq-helper which produces
the following result:
"
C:\Program Files (x86)\gnucash\bin>echo (yahoo_json "CSCO") | perl
gnc-fq-helper
(("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2020-09-09
12:00:00") (last . #e40.13) (currency . "USD")))
"
I forgot to mention in my previous email that I have already tried
completely removing and reinstalling both gnucash, and
strawberryperl with not avail.
I hope this was helpful.
Kind Regards
DNR
On 10/09/2020 03:30, John Ralls wrote:
On Sep 9, 2020, at 6:44 AM, Andreas Vyrides <vyr...@gmail.com>
wrote:
Dear Sir,
I have been having some trouble retrieving currency quotes from
Perl using Finance::Quote. I am only interested in currency
exchange rates (have not attempted using anything else). I have
been going through all steps of the wiki, such as running
"Install online price Retrieval", even changing my alpha-vantage
key by requesting a new one. I have also tried to get quotes from
outside gnucash by using the terminal with the following result
"
C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --quotes get
file://C:\Users\EoL\Documents\gnuCash\test\test.gnucash
Found Finance::Quote version 1.49.
* 14:35:49 WARN <gnc.scm> Unable to retrieve quotes for these
items:
CURRENCY:USD
CURRENCY:EUR
Continuing with good quotes.
"
In my attempts to get a single exchange rate from the terminal I
get the following results
"
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump currency EUR GBP
1 EUR = <unknown> GBP
"
I would like to ensure that I have tried using both API keys in
the appropriate "online quote" in the preferences settings, but
every time I try to get quotes I get an error with "unable to
retrieve quotes for these items: Currency: USD, Currency:EUR"
I am currently using F::Q v1.49, and gnucash v4.1
Thank you for your time and all your support
Have you read https://wiki.gnucash.org/wiki/Online_Quotes, in
particular
https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting
?
Regards,
John Ralls
_______________________________________________
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.
_______________________________________________
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.
