[GNC] Not Getting Complete Stock Quotes with Price Database Tool

[David T.]

Dan,

You are not alone with this problem; numerous users have lamented the ongoing saga of retrieving commodity prices online since Yahoo! decided to pull the plug on its quote system. AlphaVantage has been the solution that everyone here flocked to, and now AlphaVantage is altering its enforcement. [I will note that my solution to this has been to accept that GnuCash will not provide me a daily balance on my investment accounts, and leave it at that.]

Having run into F::Q problems twice in a short period of time, it seems to me that this problem is likely to rear its head repeatedly, insofar as when a glut of users suddenly puts the hit on a free server, the increased demand forces the provider to throttle access in some way to maintain its viability. 

Your idea is an interesting one, but I would actually broaden the RFE to ask that Finance::Quote have some mechanism that would allow more principled list tactics, such as: 
* limiting requests submitted at a given time
* retrying entries “n” times before returning an error
* starting retrieval of prices with the oldest commodities in the file

This last would allow a user to maintain price updates for a file with a large number of commodities. 

Adding this sort of configuration to F::Q might reduce the likelihood that GnuCash users slam the next online quote source and cause them to lock down.

David


> On Aug 24, 2018, at 10:07 AM, Dan Nelms <dan99nelms at gmail.com> wrote:
> 
> Thanks for your reply, derek. Alpha Vantage wants $19.95 a month for a
> premium API number that would solve the problem, but if I only wants
> updates once or so a week, it's not worth it. Maybe GnuCash could
> provide a check box indicator in the Price Tool where I could limit my
> API calls to 5 at a time. Maybe Alpha Vantage could offer a different
> limiting method for casual users like me and others who are just trying
> to keep their personal finances in order. Forgive my rambling on. Thanks.
> 
> Dan
> 
> 
> On 8/24/2018 6:35 AM, Derek Atkins wrote:
>> Hi,
>> 
>> Dan Nelms <dan99nelms at gmail.com> writes:
>> 
>> [snip]
>>> What happened on August 1? Did Alpha Vantage start enforcing their 5
>>> calls per minute limit for their free API numbers? 
>> [snip]
>> 
>> Yes.
>> 
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> -derek
>> 
> 
> 
> _______________________________________________
> 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.