Re: [GNC] Next release of F::Q

[Eric Coates]

Hi

Apologies. It seems that my email system has developed a mind of its own 
and sent an early and incomplete version of this note.


I've been away for some time. Since returning I have not been able to 
find any information about an upgrade to Finance::Quote.


It seemed from the work done by Erik Colson and Chris Good that an 
update to version 1.47 (which I have installed) was within grasp. Is it 
expected to be released soon?


If not, is there a way that I (ignorant as I am) can in any way 
dupliacte Chris's work to get something working on my machine?


As always. many thanks to all who develop and support gnucash.

Eric

=

On 10/09/2018 10:33, Chris Good wrote:

Erik Colson
 eco
at ecocode.net wrote on gnucash-user Thu Aug 16 05:20:42 EDT 2018

  


Hello all,

  


I'm on some extended vacation and will be back home next week.  My

intent is to release F::Q from master at the end of this month.

  


The alphavantage module has undergone some modifications which should

make it more reliable since we can now tell the module at which speed it

can question the alphavantage API.

  


Before releasing F::Q, I would like as many feedback as possible on the

best working arguments.  You can therefor play with the following

variables in the Alphavantage.pm file:

  


my $maxQueries = { quantity =>20 , seconds => 65}; # no more than x queries
per y seconds

  


Probably we should now set quantity to 5 and seconds to 61, but maybe

there are some better values?  The values above seem to work pretty well

on my automated home system.  Sometimes queries get rejected, but the

module is now smart enough to insert a delay if alphavantage API refuses

to answer queries.

  


The purpose of next release is to fix the problems with Alphavantage

speed control, so I won't add any other commits to other modules for

this release.  I've seen some messages on github concerning

Alphavantage.pm and will read those while enhancing the module.

  


best

--

erik colson

  

  


Hi Erik,

  


Thanks for working on this.

I have done some testing using the current github master Quote.pm &
AlphaVantage.pm.

  


Here are my results:

  


I have 16 stocks but only 1 currency.

  


Using the F::Q 1.47  code:

Only the first 5 stocks worked, the others failed.

  


Using your mods (& my variations in timing), there was never a failure to
return all the quotes requested. Yay!

  


Using your timing of no more than 20 queries per 65 seconds:

real3m0.735s

real2m20.476s

real2m19.217s

real2m17.692s

real2m19.923s

  


Using timing of no more than 5 queries per 60 seconds:

real3m2.503s

real3m2.320s

real2m9.449s

real2m32.282s

  


Using timing of no more than 5 queries per 59 seconds:

real2m59.858s

  


Using timing of no more than 20 queries per 50 seconds:

real3m1.121s

real2m38.678s

  


Looks like your 20 in 65 seconds is pretty good, which doesn't seem to agree
with

https://www.alphavantage.co/premium/ which says:

  


In certain high-frequency use cases that exceed our standard call-frequency
limit (5 requests per minute), we offer a dedicated, premium API key which
allows various tiers of API calls per minute.

  


Can you please release the new version asap?

  


Can you please also merge
https://github.com/finance-quote/finance-quote/pull/79

   (yahooJSON.pm returns date 00/00/2000 in Windows)

as this also fixes perl warnings which can cause GnuCash to hang when
multiple quotes (>15) are requested.

  


Regards, Chris Good

  


___
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: [GNC] Next release of F::Q

[Chris Good]

Erik Colson
 eco
at ecocode.net wrote on gnucash-user Thu Aug 16 05:20:42 EDT 2018

 

Hello all,

 

I'm on some extended vacation and will be back home next week.  My

intent is to release F::Q from master at the end of this month.

 

The alphavantage module has undergone some modifications which should

make it more reliable since we can now tell the module at which speed it

can question the alphavantage API.

 

Before releasing F::Q, I would like as many feedback as possible on the

best working arguments.  You can therefor play with the following

variables in the Alphavantage.pm file:

 

my $maxQueries = { quantity =>20 , seconds => 65}; # no more than x queries
per y seconds

 

Probably we should now set quantity to 5 and seconds to 61, but maybe

there are some better values?  The values above seem to work pretty well

on my automated home system.  Sometimes queries get rejected, but the

module is now smart enough to insert a delay if alphavantage API refuses

to answer queries.

 

The purpose of next release is to fix the problems with Alphavantage

speed control, so I won't add any other commits to other modules for

this release.  I've seen some messages on github concerning

Alphavantage.pm and will read those while enhancing the module.

 

best

--

erik colson

 

 

Hi Erik,

 

Thanks for working on this.

I have done some testing using the current github master Quote.pm &
AlphaVantage.pm.

 

Here are my results:

 

I have 16 stocks but only 1 currency.

 

Using the F::Q 1.47  code:

Only the first 5 stocks worked, the others failed.

 

Using your mods (& my variations in timing), there was never a failure to
return all the quotes requested. Yay!

 

Using your timing of no more than 20 queries per 65 seconds:

real3m0.735s

real2m20.476s

real2m19.217s

real2m17.692s

real2m19.923s

 

Using timing of no more than 5 queries per 60 seconds:

real3m2.503s

real3m2.320s

real2m9.449s

real2m32.282s

 

Using timing of no more than 5 queries per 59 seconds:

real2m59.858s

 

Using timing of no more than 20 queries per 50 seconds:

real3m1.121s

real2m38.678s

 

Looks like your 20 in 65 seconds is pretty good, which doesn't seem to agree
with

https://www.alphavantage.co/premium/ which says:

 

In certain high-frequency use cases that exceed our standard call-frequency
limit (5 requests per minute), we offer a dedicated, premium API key which
allows various tiers of API calls per minute.

 

Can you please release the new version asap?

 

Can you please also merge
https://github.com/finance-quote/finance-quote/pull/79 

  (yahooJSON.pm returns date 00/00/2000 in Windows)

as this also fixes perl warnings which can cause GnuCash to hang when
multiple quotes (>15) are requested.

 

Regards, Chris Good

 

___
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: [GNC] Next release of F::Q

[Erik Colson]

brad  writes:

> My version of AlphaVantage.pm in
> /usr/local/share/perl/5.26.1/Finance/Quote/AlphaVantage.pm has no
> maxQueries variable. I just ran gnc-fq-update. Do we need to get the
> latest from github?

Hello Brad,

You need to get the whole F::Q from github master branch.  F::Q is
developed using Dist::Zilla.  So you need to install Dist::Zilla first,
get F::Q either with "git clone" or download the zip-file at
https://github.com/finance-quote/finance-quote/archive/master.zip.

Then run "dzil install" from the command line to actually install F::Q.
Dzil will probably ask you to install some dependencies, just follow the
instructions given.

You will then have a version F::Q 1.48 installed.  It is however a
pre-release version and therefor you will have to force install F::Q
1.48 once finally released.

If you are not familiar with command-line and git, or if you hardly
understand what this does, I wouldn't recommend to install F::Q from
github at all.

best
--
erik colson
___
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: [GNC] Next release of F::Q

[brad]

My version of  AlphaVantage.pm in 
/usr/local/share/perl/5.26.1/Finance/Quote/AlphaVantage.pm has no 
maxQueries variable.   I just ran gnc-fq-update.   Do we need to get the 
latest from github?


On 08/16/2018 03:20 AM, Erik Colson wrote:

Hello all,

I'm on some extended vacation and will be back home next week.  My
intent is to release F::Q from master at the end of this month.

The alphavantage module has undergone some modifications which should
make it more reliable since we can now tell the module at which speed it
can question the alphavantage API.

Before releasing F::Q, I would like as many feedback as possible on the
best working arguments.  You can therefor play with the following
variables in the Alphavantage.pm file:

my $maxQueries = { quantity =>20 , seconds => 65}; # no more than x queries per 
y seconds

Probably we should now set quantity to 5 and seconds to 61, but maybe
there are some better values?  The values above seem to work pretty well
on my automated home system.  Sometimes queries get rejected, but the
module is now smart enough to insert a delay if alphavantage API refuses
to answer queries.

The purpose of next release is to fix the problems with Alphavantage
speed control, so I won't add any other commits to other modules for
this release.  I've seen some messages on github concerning
Alphavantage.pm and will read those while enhancing the module.

best
--
erik colson
___
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.