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.
