Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Adriano Baldi]

Hello to all


After some test I finally ad a delay of 30s delay between two subsequent
downloads.
With this delay the error disappear.

- Quote.pm --
...
  # Don't know if these have to be in upper case, but it's
  # better to be safe than sorry.
  $to = uc($to);
  $from = uc($from);

  return $amount if ($from eq $to); # Trivial case.

  my $ua = $this->user_agent;

  my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
  return undef unless ( defined $ALPHAVANTAGE_API_KEY );

  sleep 30;   <= ADD THIS

  my $reply = $ua->request(GET "${ALPHAVANTAGE_CURRENCY_URL}"
. "_currency=" . ${from}
. "_currency=" . ${to}
. "=" . ${ALPHAVANTAGE_API_KEY} );

---

We are far, from having found the solution but at least I have found a
temporary solution to the problem.
With the hope that the "Maestro" (Italian term) Erik Colson will intervene
for the benefit of everyone with one of his magic codes.

Best regards

 Adriano

2018-02-23 2:09 GMT+01:00 Les <lellio...@gmail.com>:

> Thanks for the explanation Larry.  Now I understand.  I just don't know
> why I am unable to update currency quotes since 02/13/2018. Perhaps
> Alphavantage is just not robust enough to support all the users of GC plus
> what they were supporting before Yahoo went south last year.
>
> I appreciate what Erik Colson was able to put together in such a very
> short time. And Alphavantage seems to be the only game in town for the time
> being. All of the developers of GC need a big round of applause for keeping
> GC moving forward and answering all of the questions from users.
>
> Les
>
>
> On 02/22/2018 05:29 PM, ln.mailingli...@iinet.net.au wrote:
>
>> If you take a look in the Quote.pm perl module, the currency
>> conversion method calls the alpha vantage CURRENCY_EXCHANGE_RATE
>> function. As far as I can see this is the *only* source of exchange
>> rate data available in Finance::Quote (at least assuming you are using
>> version 1.47). Given this, any setting in gnucash is unlikely to
>> change anything (and is probably why gnucash reverts to currency no
>> matter what you do - it's the one data source that binds them all when
>> it comes to currency).
>> Also see the following post from Erik Colson (FQ developer)
>> https://sourceforge.net/p/finance-quote/mailman/message/36112625/
>> And finally, if you want to prove it for yourself, run currency
>> conversion with and without the alpha vantage key set.
>> Cheers,
>> Larry
>>
>> Maybe I am missing something but when I go to Security Editor,
>> click
>> on
>>
>> currencies and then select unknown and then alphavantage and save
>> it
>>
>> reverts back to single, currency. So how is the quote (when I get
>> one)
>>
>> coming from alphavantage?
>>
>> Confused,
>>
>> Les
>>
>> On 02/22/2018 03:09 AM, ln.mailinglists at iinet.net.au [1]
>> wrote:
>>
>> >_ Hi Richard, _
>>
>> >_ It's definitely alphavantage for currency - you can check the
>> data
>> URL _
>>
>> >_ early in the Quote.pm module. _
>>
>> >_ I'd agree with Adriano's assessment that the problem is server
>> side. _
>>
>> >_ I did a test this morning where I repeatedly requested quotes
>> from
>> _
>>
>> >_ gnucash - the first four attempts sucessfully grabbed all of my
>> stock _
>>
>> >_ values but failed on USD/AUD exchange rates, while the fifth
>> test
>> got _
>>
>> >_ everything. _
>>
>> >
>>
>> >_ Cheers, _
>>
>> >_ Larry _
>>
>> >
>>
>> >_ Date: Wed, 21 Feb 2018 11:24:25 + _
>>
>> >_ From: Richard Morris _
>>
>> >_ To: Adriano Baldi _
>>
>> >_ Cc: gnucash-user _
>>
>> >_ Subject: Re: Finance-Quote 1.47 Unable to retrieve Currency
>> quotes
>> _
>>
>> >_ Message-ID: _
>>
>> >
>>
>> >_ Content-Type: text/plain; charset="UTF-8" _
>>
>> >_ But I wonder - does GNUCash use alphavantage for currencies? _
>>
>> >_ I see this: _
>>
>> >_ "There are 3 types of sources of which the first - currency -
>> is _
>>
>> >_ ha

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Les]

Thanks for the explanation Larry.  Now I understand.  I just don't know 
why I am unable to update currency quotes since 02/13/2018. Perhaps 
Alphavantage is just not robust enough to support all the users of GC 
plus what they were supporting before Yahoo went south last year.


I appreciate what Erik Colson was able to put together in such a very 
short time. And Alphavantage seems to be the only game in town for the 
time being. All of the developers of GC need a big round of applause for 
keeping GC moving forward and answering all of the questions from users.


Les


On 02/22/2018 05:29 PM, ln.mailingli...@iinet.net.au wrote:

If you take a look in the Quote.pm perl module, the currency
conversion method calls the alpha vantage CURRENCY_EXCHANGE_RATE
function. As far as I can see this is the *only* source of exchange
rate data available in Finance::Quote (at least assuming you are using
version 1.47). Given this, any setting in gnucash is unlikely to
change anything (and is probably why gnucash reverts to currency no
matter what you do - it's the one data source that binds them all when
it comes to currency).
Also see the following post from Erik Colson (FQ developer)
https://sourceforge.net/p/finance-quote/mailman/message/36112625/
And finally, if you want to prove it for yourself, run currency
conversion with and without the alpha vantage key set.
Cheers,
Larry

Maybe I am missing something but when I go to Security Editor, click
on

currencies and then select unknown and then alphavantage and save it

reverts back to single, currency. So how is the quote (when I get
one)

coming from alphavantage?

Confused,

Les

On 02/22/2018 03:09 AM, ln.mailinglists at iinet.net.au [1] wrote:

>_ Hi Richard, _

>_ It's definitely alphavantage for currency - you can check the data
URL _

>_ early in the Quote.pm module. _

>_ I'd agree with Adriano's assessment that the problem is server
side. _

>_ I did a test this morning where I repeatedly requested quotes from
_

>_ gnucash - the first four attempts sucessfully grabbed all of my
stock _

>_ values but failed on USD/AUD exchange rates, while the fifth test
got _

>_ everything. _

>

>_ Cheers, _

>_ Larry _

>

>_ Date: Wed, 21 Feb 2018 11:24:25 + _

>_ From: Richard Morris _

>_ To: Adriano Baldi _

>_ Cc: gnucash-user _

    >_ Subject: Re: Finance-Quote 1.47 Unable to retrieve Currency quotes
_

>_ Message-ID: _

>

>_ Content-Type: text/plain; charset="UTF-8" _

>_ But I wonder - does GNUCash use alphavantage for currencies? _

>_ I see this: _

>_ "There are 3 types of sources of which the first - currency - is _

>_ hardcoded _

>_ and responsible to fetch ISO currencies. The other two can be
selected _

>_ in _

>_ the security editor." _

>_ https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html [2] _

>_ I'm still having the issue with currencies. How about you Adriano?
_

>_ And isn't it odd that gnc-fq-dump currency USD EUR (for example) _

>_ works? _

>_ ___ _

>_ gnucash-user mailing list _

>_ gnucash-user at gnucash.org [3] _

>_ To update your subscription preferences or to unsubscribe: _

>_ https://lists.gnucash.org/mailman/listinfo/gnucash-user [4] _

>_ If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists [5] 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._

Links:
--
[1] https://lists.gnucash.org/mailman/listinfo/gnucash-user
[2] https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html
[3] https://lists.gnucash.org/mailman/listinfo/gnucash-user
[4] https://lists.gnucash.org/mailman/listinfo/gnucash-user
[5] https://wiki.gnucash.org/wiki/Mailing_Lists

___
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 

Finance-Quote 1.47 Unable to retrieve Currency quotes

[ln . mailinglists]

If you take a look in the Quote.pm perl module, the currency
conversion method calls the alpha vantage CURRENCY_EXCHANGE_RATE
function. As far as I can see this is the *only* source of exchange
rate data available in Finance::Quote (at least assuming you are using
version 1.47). Given this, any setting in gnucash is unlikely to
change anything (and is probably why gnucash reverts to currency no
matter what you do - it's the one data source that binds them all when
it comes to currency). 
Also see the following post from Erik Colson (FQ developer)
https://sourceforge.net/p/finance-quote/mailman/message/36112625/
And finally, if you want to prove it for yourself, run currency
conversion with and without the alpha vantage key set. 
Cheers,
Larry

Maybe I am missing something but when I go to Security Editor, click
on 

currencies and then select unknown and then alphavantage and save it 

reverts back to single, currency. So how is the quote (when I get
one) 

coming from alphavantage?

Confused,

Les

On 02/22/2018 03:09 AM, ln.mailinglists at iinet.net.au [1] wrote:

>_ Hi Richard, _

>_ It's definitely alphavantage for currency - you can check the data
URL _

>_ early in the Quote.pm module. _

>_ I'd agree with Adriano's assessment that the problem is server
side. _

>_ I did a test this morning where I repeatedly requested quotes from
_

>_ gnucash - the first four attempts sucessfully grabbed all of my
stock _

>_ values but failed on USD/AUD exchange rates, while the fifth test
got _

>_ everything. _

>

>_ Cheers, _

>_ Larry _

>

>_ Date: Wed, 21 Feb 2018 11:24:25 + _

>_ From: Richard Morris _

>_ To: Adriano Baldi _

>_ Cc: gnucash-user _

    >_ Subject: Re: Finance-Quote 1.47 Unable to retrieve Currency quotes
_

>_ Message-ID: _

>

>_ Content-Type: text/plain; charset="UTF-8" _

>_ But I wonder - does GNUCash use alphavantage for currencies? _

>_ I see this: _

>_ "There are 3 types of sources of which the first - currency - is _

>_ hardcoded _

>_ and responsible to fetch ISO currencies. The other two can be
selected _

>_ in _

>_ the security editor." _

>_ https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html [2] _

>_ I'm still having the issue with currencies. How about you Adriano?
_

>_ And isn't it odd that gnc-fq-dump currency USD EUR (for example) _

>_ works? _

>_ ___ _

>_ gnucash-user mailing list _

>_ gnucash-user at gnucash.org [3] _

>_ To update your subscription preferences or to unsubscribe: _

>_ https://lists.gnucash.org/mailman/listinfo/gnucash-user [4] _

>_ If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists [5] 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._

Links:
--
[1] https://lists.gnucash.org/mailman/listinfo/gnucash-user
[2] https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html
[3] https://lists.gnucash.org/mailman/listinfo/gnucash-user
[4] https://lists.gnucash.org/mailman/listinfo/gnucash-user
[5] https://wiki.gnucash.org/wiki/Mailing_Lists

___
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.

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[John Ralls]

You can't change the quote source for currencies. Currency retrieval in 
Finance::Quote needs two symbols, one for each currency, while stock symbols 
require only one. Finance::Quote has the currency source hardwired: Formerly to 
Yahoo! now to Alphavantage. 

I was able to get a currency price (EUR->USD) just now with no trouble and not 
much delay.

Regards,
John Ralls
> On Feb 22, 2018, at 2:46 PM, Les <lellio...@gmail.com> wrote:
> 
> I forgot to add that the last update I received for currencies (all 9 of 
> them) was 02/13/2018.
> 
> 
> On 02/22/2018 03:09 AM, ln.mailingli...@iinet.net.au wrote:
>> Hi Richard,
>> It's definitely alphavantage for currency - you can check the data URL
>> early in the Quote.pm module.
>> I'd agree with Adriano's assessment that the problem is server side.
>> I did a test this morning where I repeatedly requested quotes from
>> gnucash - the first four attempts sucessfully grabbed all of my stock
>> values but failed on USD/AUD exchange rates, while the fifth test got
>> everything.
>> 
>> Cheers,
>> Larry
>> 
>> Date: Wed, 21 Feb 2018 11:24:25 +0000
>> From: Richard Morris
>> To: Adriano Baldi
>> Cc: gnucash-user
>> Subject: Re: Finance-Quote 1.47 Unable to retrieve Currency quotes
>> Message-ID:
>> 
>> Content-Type: text/plain; charset="UTF-8"
>> But I wonder - does GNUCash use alphavantage for currencies?
>> I see this:
>> "There are 3 types of sources of which the first - currency - is
>> hardcoded
>> and responsible to fetch ISO currencies. The other two can be selected
>> in
>> the security editor."
>> https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html
>> I'm still having the issue with currencies. How about you Adriano?
>> And isn't it odd that gnc-fq-dump currency USD EUR (for example)
>> works?
>> ___
>> 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.

___
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.

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Les]

I forgot to add that the last update I received for currencies (all 9 of 
them) was 02/13/2018.



On 02/22/2018 03:09 AM, ln.mailingli...@iinet.net.au wrote:

Hi Richard,
It's definitely alphavantage for currency - you can check the data URL
early in the Quote.pm module.
I'd agree with Adriano's assessment that the problem is server side.
I did a test this morning where I repeatedly requested quotes from
gnucash - the first four attempts sucessfully grabbed all of my stock
values but failed on USD/AUD exchange rates, while the fifth test got
everything.

Cheers,
Larry

Date: Wed, 21 Feb 2018 11:24:25 +
From: Richard Morris
To: Adriano Baldi
Cc: gnucash-user
Subject: Re: Finance-Quote 1.47 Unable to retrieve Currency quotes
Message-ID:

Content-Type: text/plain; charset="UTF-8"
But I wonder - does GNUCash use alphavantage for currencies?
I see this:
"There are 3 types of sources of which the first - currency - is
hardcoded
and responsible to fetch ISO currencies. The other two can be selected
in
the security editor."
https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html
I'm still having the issue with currencies. How about you Adriano?
And isn't it odd that gnc-fq-dump currency USD EUR (for example)
works?
___
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.

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Les]

Maybe I am missing something but when I go to Security Editor, click on 
currencies and then select unknown and then alphavantage and save it 
reverts back to single, currency. So how is the quote (when I get one) 
coming from alphavantage?


Confused,

Les


On 02/22/2018 03:09 AM, ln.mailingli...@iinet.net.au wrote:

Hi Richard,
It's definitely alphavantage for currency - you can check the data URL
early in the Quote.pm module.
I'd agree with Adriano's assessment that the problem is server side.
I did a test this morning where I repeatedly requested quotes from
gnucash - the first four attempts sucessfully grabbed all of my stock
values but failed on USD/AUD exchange rates, while the fifth test got
everything.

Cheers,
Larry

Date: Wed, 21 Feb 2018 11:24:25 +
From: Richard Morris
To: Adriano Baldi
Cc: gnucash-user
Subject: Re: Finance-Quote 1.47 Unable to retrieve Currency quotes
Message-ID:

Content-Type: text/plain; charset="UTF-8"
But I wonder - does GNUCash use alphavantage for currencies?
I see this:
"There are 3 types of sources of which the first - currency - is
hardcoded
and responsible to fetch ISO currencies. The other two can be selected
in
the security editor."
https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html
I'm still having the issue with currencies. How about you Adriano?
And isn't it odd that gnc-fq-dump currency USD EUR (for example)
works?
___
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.

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Richard Morris]

Cunning stuff Adriano!

Here's someone else finding that implementing a delay doesn't seem to work:
https://www.alpha-vantage.community/post/how-to-reduce-api-call-frequency-tried-up-to-sleep80-between-curls-but-still-hitting-9655828

I suspect it's throttled on the basis of 'x requests allowed from the same
IP address within y minutes', or some such (where x and y are now very low
values!).

However the block only seems to last a short while. So one way around it
might be to fiddle with Quote.pm and test the Perl::LWP response, If it's,
say "200" and the response content contains their 'contact support'
message, then sleep() for say 2 minutes.

But then what are we doing here? Trying to game their system? Doesn't seem
the right way forward...

Best

Richard
(Perl fan)


On 22 February 2018 at 14:39, Adriano Baldi  wrote:

> Hello Richard
>
> You can't introduce a delay in Gnucash but you can modify the
> Finance::Quote module that Gnucash use.
> For the currency is Quote.pm (for me is in  
> /usr/local/share/perl/5.22.1/Finance/
> ) and I try tho chance it :
>
>
> 
>
> # ===
> # currency (public object method)
> #
> # currency allows the conversion of one currency to another.
> #
> # Usage: $quoter->currency("USD","AUD");
> #  $quoter->currency("15.95 USD","AUD");
> #
> # undef is returned upon error.
>
> sub currency {
>   my $this = shift if (ref($_[0]));
>   $this ||= _dummy();
>
>   my ($from, $to) = @_;
>   return undef unless ($from and $to);
>
>   $from =~ s/^\s*(\d*\.?\d*)\s*//;
>   my $amount = $1 || 1;
>
>   # Don't know if these have to be in upper case, but it's
>   # better to be safe than sorry.
>   $to = uc($to);
>   $from = uc($from);
>
>   return $amount if ($from eq $to); # Trivial case.
>
>   my $ua = $this->user_agent;
>
>   my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
>   return undef unless ( defined $ALPHAVANTAGE_API_KEY );
> # change start --
>
>
>
>
> *my $key_n=0;  sleep 1;   # This introduce a 1s delay  $key_n =
> int(rand(10));  # Select randomly one of the following API key (change the
> keys with your keys)*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *  if($key_n == 0)  {$ALPHAVANTAGE_API_KEY="xx_KEY_00_xx"};
> if($key_n == 1)  {$ALPHAVANTAGE_API_KEY="xx_KEY_01_xx"};
> if($key_n == 2)  {$ALPHAVANTAGE_API_KEY="xx_KEY_02_xx"};
> if($key_n == 3)  {$ALPHAVANTAGE_API_KEY="xx_KEY_03_xx"};
> if($key_n == 4)  {$ALPHAVANTAGE_API_KEY="xx_KEY_04_xx"};
> if($key_n == 5)  {$ALPHAVANTAGE_API_KEY="xx_KEY_05_xx"};
> if($key_n == 6)  {$ALPHAVANTAGE_API_KEY="xx_KEY_06_xx"};
> if($key_n == 7)  {$ALPHAVANTAGE_API_KEY="xx_KEY_07_xx"};
> if($key_n == 8)  {$ALPHAVANTAGE_API_KEY="xx_KEY_08_xx"};
> if($key_n == 9)  {$ALPHAVANTAGE_API_KEY="xx_KEY_09_xx"};
> if($key_n == 10) {$ALPHAVANTAGE_API_KEY="xx_KEY_10_xx"};*  my
> $reply = $ua->request(GET "${ALPHAVANTAGE_CURRENCY_URL}"
> . "_currency=" . ${from}
> . "_currency=" . ${to}
> . "=" . ${ALPHAVANTAGE_API_KEY} );
>
>
> *# This print the request, and you can see the key used*
>
>
>
>
>
>
>
>
> *  print "${ALPHAVANTAGE_CURRENCY_URL}". "_currency=" .
> ${from}. "_currency=" . ${to}. "=" .
> ${ALPHAVANTAGE_API_KEY}."\n";  print
> $reply;# change end
> --*
> if you run  *gnc-fq-dump currency usd eur  *you are able to test it
> outside Gnucash.
> This apply a request every 0,1s  but the delay inside the module (*sleep
> 1; *) decide the real frequency and you can change it.
>
> root@ASUS-N56VZ:/usr/local/share/perl/5.22.1/Finance# *watch -n 0
> gnc-fq-dump currency usd eur*
> https://www.alphavantage.co/query?function=CURRENCY_
> EXCHANGE_RATE_currency=USD_currency=EUR=xxx
> HTTP::Response=HASH(0x42eb5a0)1 usd = 0.812089 eur
>
> The problem it's than after two polling, same time the download fail.
>
> Best regard
>
>Adriano
>
>
>
> 2018-02-22 9:47 GMT+01:00 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 
>> wrote:
>>
>>> Hello Richard
>>>
>>> After doing countless tests I think that 

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Adriano Baldi]

Hello Richard

You can't introduce a delay in Gnucash but you can modify the
Finance::Quote module that Gnucash use.
For the currency is Quote.pm (for me is in
/usr/local/share/perl/5.22.1/Finance/ ) and I try tho chance it :




# ===
# currency (public object method)
#
# currency allows the conversion of one currency to another.
#
# Usage: $quoter->currency("USD","AUD");
#  $quoter->currency("15.95 USD","AUD");
#
# undef is returned upon error.

sub currency {
  my $this = shift if (ref($_[0]));
  $this ||= _dummy();

  my ($from, $to) = @_;
  return undef unless ($from and $to);

  $from =~ s/^\s*(\d*\.?\d*)\s*//;
  my $amount = $1 || 1;

  # Don't know if these have to be in upper case, but it's
  # better to be safe than sorry.
  $to = uc($to);
  $from = uc($from);

  return $amount if ($from eq $to); # Trivial case.

  my $ua = $this->user_agent;

  my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
  return undef unless ( defined $ALPHAVANTAGE_API_KEY );
# change start --




*my $key_n=0;  sleep 1;   # This introduce a 1s delay  $key_n =
int(rand(10));  # Select randomly one of the following API key (change the
keys with your keys)*














*  if($key_n == 0)  {$ALPHAVANTAGE_API_KEY="xx_KEY_00_xx"};
if($key_n == 1)  {$ALPHAVANTAGE_API_KEY="xx_KEY_01_xx"};
if($key_n == 2)  {$ALPHAVANTAGE_API_KEY="xx_KEY_02_xx"};
if($key_n == 3)  {$ALPHAVANTAGE_API_KEY="xx_KEY_03_xx"};
if($key_n == 4)  {$ALPHAVANTAGE_API_KEY="xx_KEY_04_xx"};
if($key_n == 5)  {$ALPHAVANTAGE_API_KEY="xx_KEY_05_xx"};
if($key_n == 6)  {$ALPHAVANTAGE_API_KEY="xx_KEY_06_xx"};
if($key_n == 7)  {$ALPHAVANTAGE_API_KEY="xx_KEY_07_xx"};
if($key_n == 8)  {$ALPHAVANTAGE_API_KEY="xx_KEY_08_xx"};
if($key_n == 9)  {$ALPHAVANTAGE_API_KEY="xx_KEY_09_xx"};
if($key_n == 10) {$ALPHAVANTAGE_API_KEY="xx_KEY_10_xx"};*  my
$reply = $ua->request(GET "${ALPHAVANTAGE_CURRENCY_URL}"
. "_currency=" . ${from}
. "_currency=" . ${to}
. "=" . ${ALPHAVANTAGE_API_KEY} );


*# This print the request, and you can see the key used*








*  print "${ALPHAVANTAGE_CURRENCY_URL}". "_currency=" . ${from}
. "_currency=" . ${to}. "=" . ${ALPHAVANTAGE_API_KEY}."\n";
print $reply;# change end
--*
if you run  *gnc-fq-dump currency usd eur  *you are able to test it outside
Gnucash.
This apply a request every 0,1s  but the delay inside the module (*sleep 1;
*) decide the real frequency and you can change it.

root@ASUS-N56VZ:/usr/local/share/perl/5.22.1/Finance# *watch -n 0
gnc-fq-dump currency usd eur*
https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE_currency=USD_currency=EUR=xxx
HTTP::Response=HASH(0x42eb5a0)1 usd = 0.812089 eur

The problem it's than after two polling, same time the download fail.

Best regard

   Adriano



2018-02-22 9:47 GMT+01:00 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 
> 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 

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Richard Morris]

I think they have introduced rate limiting.

As an experiment, I put this URL in my browser:
https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE_currency=USD_currency=GBP=[my
key]

After about 6 browser refreshes with a second or two between, I got:

"Thank you for using the CURRENCY_EXCHANGE_RATE API! Please kindly contact
supp...@alphavantage.co if you would like to have a higher API
call volume"

So I have emailed support to see what the options are.


On 22 February 2018 at 09:09, <ln.mailingli...@iinet.net.au> wrote:

> Hi Richard,
> It's definitely alphavantage for currency - you can check the data URL
> early in the Quote.pm module.
> I'd agree with Adriano's assessment that the problem is server side.
> I did a test this morning where I repeatedly requested quotes from
> gnucash - the first four attempts sucessfully grabbed all of my stock
> values but failed on USD/AUD exchange rates, while the fifth test got
> everything.
>
> Cheers,
> Larry
>
> Date: Wed, 21 Feb 2018 11:24:25 +
> From: Richard Morris
> To: Adriano Baldi
> Cc: gnucash-user
> Subject: Re: Finance-Quote 1.47 Unable to retrieve Currency quotes
> Message-ID:
>
> Content-Type: text/plain; charset="UTF-8"
> But I wonder - does GNUCash use alphavantage for currencies?
> I see this:
> "There are 3 types of sources of which the first - currency - is
> hardcoded
> and responsible to fetch ISO currencies. The other two can be selected
> in
> the security editor."
> https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html
> I'm still having the issue with currencies. How about you Adriano?
> And isn't it odd that gnc-fq-dump currency USD EUR (for example)
> works?
> ___
> 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.

Finance-Quote 1.47 Unable to retrieve Currency quotes

[ln . mailinglists]

Hi Richard,
It's definitely alphavantage for currency - you can check the data URL
early in the Quote.pm module.
I'd agree with Adriano's assessment that the problem is server side. 
I did a test this morning where I repeatedly requested quotes from
gnucash - the first four attempts sucessfully grabbed all of my stock
values but failed on USD/AUD exchange rates, while the fifth test got
everything. 

Cheers,
Larry

Date: Wed, 21 Feb 2018 11:24:25 +
From: Richard Morris 
To: Adriano Baldi 
Cc: gnucash-user 
Subject: Re: Finance-Quote 1.47 Unable to retrieve Currency quotes
Message-ID:

Content-Type: text/plain; charset="UTF-8"
But I wonder - does GNUCash use alphavantage for currencies?
I see this:
"There are 3 types of sources of which the first - currency - is
hardcoded
and responsible to fetch ISO currencies. The other two can be selected
in
the security editor."
https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html
I'm still having the issue with currencies. How about you Adriano?
And isn't it odd that gnc-fq-dump currency USD EUR (for example)
works?
___
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.

Re: 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  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 :
>
>> 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 
>> 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
>>> ___
>>> 

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Richard Morris]

But I wonder - does GNUCash actually use alphavantage for currencies?

I see this:
"There are 3 types of sources of which the first - currency - is hardcoded
and responsible to fetch ISO currencies. The other two can be selected in
the security editor."  https://www.gnucash.org/docs/
v2.6/C/gnucash-help/apas01.html

I'm still having the issue with currencies. How about you Adriano?

And isn't it odd that e.g. "gnc-fq-dump currency USD EUR" (for example)
works?


On 20 February 2018 at 12:05, Adriano Baldi  wrote:

> Hello
>
> Maybe I found something 
>
> https://www.alpha-vantage.community/post/unable-to-get-
> the-response-when-using-currencyexchangerate-api-9654331
>
> we are not alone...
>
> Best regards
>
> Adriano
>
> 2018-02-20 12:47 GMT+01:00 Adriano Baldi :
>
>> 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 :
>>
>>> 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 
>>> 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 

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Richard Morris via gnucash-user]

But I wonder - does GNUCash use alphavantage for currencies?

I see this:
"There are 3 types of sources of which the first - currency - is hardcoded
and responsible to fetch ISO currencies. The other two can be selected in
the security editor."
https://www.gnucash.org/docs/v2.6/C/gnucash-help/apas01.html

I'm still having the issue with currencies. How about you Adriano?

And isn't it odd that gnc-fq-dump currency USD EUR (for example) works?

On Tue, Feb 20, 2018 at 12:05 PM, Adriano Baldi 
wrote:

> Hello
>
> Maybe I found something 
>
> https://www.alpha-vantage.community/post/unable-to-get-
> the-response-when-using-currencyexchangerate-api-9654331
>
> we are not alone...
>
> Best regards
>
> Adriano
>
> 2018-02-20 12:47 GMT+01:00 Adriano Baldi :
>
>> 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 :
>>
>>> 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 
>>> 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 

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Adriano Baldi]

Hello

Maybe I found something 

https://www.alpha-vantage.community/post/unable-to-get-the-response-when-using-currencyexchangerate-api-9654331

we are not alone...

Best regards

Adriano

2018-02-20 12:47 GMT+01:00 Adriano Baldi :

> 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 :
>
>> 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 
>> 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@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.
>>>
>>
>>
>
>

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Adriano Baldi]

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 :

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

Re: Finance-Quote 1.47 Unable to retrieve Currency quotes

[Richard Morris via gnucash-user]

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 
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@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.

Finance-Quote 1.47 Unable to retrieve Currency quotes

[Adriano Baldi]

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@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.