[GNC] Price Editor Problems

[Eric Coates]

Hi (again!)

OK, if you had AlphaVantage working at some time you'll have an 
AlphAvantage API key.

(In GnuCash 3.5 you can confirm this by going through*Edit > Preferences 
 > Online Quotes *and confirming that the key appears there)

It sounds as if you've hit the problem with AlphaVantage throttling the 
queries; the way to overcome this is to modify the file 
*AlphaVantage.pm.* I had problems finding the correct file to modify but 
I think in Ubuntu 18.04 it is 
at*/usr/local/share/perl/5.22.1/Finance/Quote*; in 19.04 it's at 
*usr/share/perl5/Finance/Quote/AlphaVantage.pm*. Or, to be more exact, 
that's where it was/is on my system; if it's not there a hint (given by 
John Ralls a while ago) is to look in the */etc/share* directory and 
look in folders called perl or perl5.

Having found the file it needs to be modified to add in a delay that 
overcomes the throttling problem. Very close to the end of the file 
there is a line

*select(undef, undef, undef, .7) if ($quantity);*

(although, to be honest, I can't swear that the final semi-colon 
appears) that needs to be modified to read

*select(undef, undef, undef, .7) if ($quantity); sleep(15);*

(the modified line does need the semi-colon).

It took me some time to gather the courage to go in and modify a 
"system" file; if you share my discomfort I can provide some guidance on 
how to do it.

Best wishes

Eric
**


On 11/05/2019 02:18, DaveW wrote:
> Where, please, can I get wo-to-go instructions to get my stock Price
> Editor (Re)working??
>
> I am running Ubuntu 18.04.  GNC ver 3.5.  My stock is all on the ASX
> (Australia).  Things worked wonderfully until the Yahoo demise and
> then for a while I was able to use Alphvantage but that stopped too.
>
> I have tried all sorts of fixes randomly and fear I have completely
> confused GNC in the process.
>
> I would greatly appreciate some step by step assistance.
>
> Dave W
> _______________________________________________
> 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.