Finance-Quote 1.47 Unable to retrieve Currency quotes

[Richard Morris]

Sorry I couldn't reply to this before Adriano - I've been finding using
this list a bit too difficult for me! (A confusion between my @gmail and
@googlemail email domain identities)

I think you are probably on to something in trying to throttle your
requests. But may I ask - how are you adding the delay? Where is the
setting in GNUCash for that?

I have about 35 stocks to check, of which about 7 or 8 are in USD etc. I
run "gnucash --add-price-quotes" on the hour as a cron job. I wouldn't have
thought that was too demanding on Alphavantage. But then - how many of us
are making requests to them via GNUCash?

Best

Richard

On 20 February 2018 at 11:47, Adriano Baldi <adriano.baldi at gmail.com> wrote:

> Hello Richard
>
> After doing countless tests I think that the problem is related to the
> management of the demands of Alphavantage.
> But I can not figure out where we are wrong.
> These are the declared performances:
>
> *>> What is the expected server-side performance (e.g., throughput time)
> for the API service?*
>
> *>> Based on the latest instrumentation, the throughput time for our API
> endpoint is under 500 milliseconds per request at 25% to 75% percentile. *
>
> *>> While we are proud to provide free API service with no
> daily/weekly/monthly call limits, we recommend that API call frequency does
> not extend far beyond ~1 call per second *
>
> *>> so that we can continue to deliver the optimal server-side
> performance.*
>
> So I tried to put a delay between one request and another of 1 or more
> seconds, with no result.
> In addition I tried to ensure that for each request was used a different
> key, randomly chosen among 10 keys, even here without result.
>
> I need new idea to test.
>
> Best regards
>
> Adriano
>
>
> 2018-02-20 9:28 GMT+01:00 Richard Morris <sgtzeno5 at googlemail.com>:
>
>> I have this problem too (starting yesterday). I was going to do a post -
>> then, late in the day, the problem went away! But now it's back again.
>>
>> I wonder if this is a connectivity issue with whatever GNUCash uses for
>> currency sources? (This is hard-wired I think, and I'm not sure what that
>> is).
>>
>> I'm on Ubuntu too: GnuCash 2.6.17 + Ubuntu 17.10 + Finance::Quote 1.47
>>
>>
>> On Tue, Feb 20, 2018 at 6:09 AM, Adriano Baldi <adriano.baldi at gmail.com>
>> wrote:
>>
>>> Hello
>>>
>>> I apologize for my poor English.
>>>
>>> I use GnuCash since 2011 and usually I am able to solve this kind of
>>> problem by myself if necessary modifing the perl files of Finance::Quote.
>>> But now I'm going crazy with this problem.
>>>
>>> I've got this error since february 14 on two different PC with Ubuntu
>>> 14.04
>>> and 16.04 with GnuCash 2.6.12 and Finance::Quote 1.47.
>>>
>>> Unable to retrieve quotes for these items:
>>>   CURRENCY:XAU
>>>   CURRENCY:XPT
>>>   CURRENCY:XAG
>>>   CURRENCY:NZD
>>>   CURRENCY:CAD
>>>   CURRENCY:AUD
>>>   CURRENCY:CHF
>>>   CURRENCY:CNY
>>>   CURRENCY:RUB
>>>   CURRENCY:DKK
>>>   CURRENCY:NOK
>>>   CURRENCY:GBP
>>>   CURRENCY:USD
>>>   CURRENCY:JPY
>>> Continue using only the good quotes?
>>>
>>> If I try from the consolle Finance::Quote work fine
>>>
>>> $ gnc-fq-dump currency USD EUR
>>> 1 USD = 0.805969 EUR
>>>
>>> $ gnc-fq-dump currency XAU EUR
>>> 1 XAU = 1085.3924262 EUR
>>>
>>> $ gnc-fq-check
>>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
>>> "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil"
>>> "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" "indiamutual"
>>> "known_currencies" "lerevenu" "maninv" "morningstar" "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" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe"
>>> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")
>>>
>>> I don't know if this problem afflict only me (I hope so) or if others
>>> have
>>> the same problem.
>>> The problem afflicts only the currency with continuity, on some stocks I
>>> can have the problem occasionally, but generally a second download work
>>> fine.
>>> I retreive more of 40 stocks from 6 excange with no problem using
>>> Alphavantage.
>>> Does anyone have an idea from what can be determined?
>>> Does anyone have a suggestion to give me to solve this problem?
>>> Thanks in advance to anyone who can help me.
>>>
>>> Best regards
>>>
>>>                 Adriano
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at 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.
>>>
>>
>>
>
>