[GNC] Excessive Quote Lookups

[Kalpesh Patel]

F::Q can be used as a standalone or through another application as well.

I am pretty sure Yahoo has throttling capabilities so it is getting throttled at that rate and erroring unless F::Q module was modified to handle commercial rate with an active subscription -- it is easily doable in couple of hours as good amount of plumbing is in it already. I had done something similar as a demo for myself to be able to retrieve portfolio definitions.


-----Original Message-----
From: Patrick James <patrickjames14 at comcast.net> 
Sent: Thursday, September 03, 2026 10:34 AM
To: gnucash-user at lists.gnucash.org
Subject: Re: [GNC] Excessive Quote Lookups

Sounds like someone is playing a day trading game.

I'll divide by 20, but there were 21 NYSE trading days in August. Maybe they took a day or two off, or something.

So 300k divided by 20 = 15k requests per day on average, which we can start to guess some sort of division of that.

Maybe the person is requesting 100 different quotes 150 times a day, and with some nice assumptions about the trading hours, we're getting many requests for those 100 different quotes per hour.

Based on the types of messages here, please place my bet that sort of request level is no one associated with this GnuCash list.


> On 09/02/2026 11:05 AM PDT Bruce Schuck <bschuck at asgard-systems.com> wrote:
> 
>  
> I'm looking at the statistics for Finance::Quote usage for last month. 
> I came across a surprising statistic where a single IP has utilized 
> the yahoo_json method over 300,000 times in August. That is 
> approximately 10K uses of yahoo_json per day!
> 
> 
> I would just like to warn, that this is an example of excessive usage 
> that could lead to Yahoo making changes that minimize or prevent tools 
> like F::Q to be able to scrape securities price data.
> 
> 
> Bruce S
>