[GNC] Excessive Quote Lookups

Kalpesh Patel kalpesh.patel at usa.net
Thu Sep 3 16:42:04 EDT 2026


For day trading, I recommend they look at Alpaca rather than abusing YahooJSON ... it is the go to platform for APIs if relishing on it is the thrill. You'll also be able to execute paper and live trades there. 

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




More information about the gnucash-user mailing list