The Competitive Set Ratio: An Early Warning Signal Most Investors Miss

Every investor watches days-on-market and price cuts to gauge where a market is headed. The problem is that both of those numbers are lagging indicators. A property has to sit unsold for weeks before days-on-market ticks up, and a seller has to get discouraged before they cut price. By the time those signals show up clearly, the shift they're describing already happened.

There's a simpler number that tends to move first: the ratio of active listings to recent sales in a specific, tightly defined radius. Some investors call it a competitive set ratio. It's not a new concept; appraisers and analysts have used versions of it for years under the term absorption rate, but most investors either don't track it consistently or only look at it at a resolution too broad to be useful.

What the Ratio Actually Measures

The math is straightforward. Absorption rate is typically calculated as the number of homes sold in a given period divided by the total number of active listings, according to Noradarealestate's explainer on absorption rate and months of inventory. Flip that same relationship around, active listings divided by sales, and you get months of supply: how long it would take to sell through current inventory at the current pace, assuming no new listings come on.

The general benchmarks are well established. Five to six months of supply is considered a balanced market, more than six months points to a buyer's market, and less than five points to a seller's market. 

On the absorption side, a rate between 15% and 20% suggests balance, below 15% suggests a buyer's market where homes move slowly, and above 20% suggests a seller's market with quick turnover, according to the same source. A submarket with 200 active listings and 30 closed sales in a month, for example, is running at 15% monthly absorption and roughly 6.7 months of supply, right on the edge between balanced and buyer-favorable.

Why the Radius Matters More Than the Ratio Itself

The formula is easy. The mistake most investors make is calculating it at too broad a level. A countywide or zip-code-level absorption rate blends together neighborhoods, price points, and property conditions that don't actually compete with each other. A grandma house that needs a full renovation and a recently flipped, move-in-ready home three blocks away are not part of the same buyer decision, and averaging their sale prices and time on market together tells you very little about either one.

The more useful version of this exercise is narrow: pick a radius of a half mile to a mile, pull active listings and closed sales for a comparable property type over the trailing 3, 6, and 12 months, and calculate the ratio at that scale. Done consistently over time, the trend line matters more than any single snapshot. A ratio that's been drifting from 4 months of supply to 6 months of supply over two quarters is telling you something is shifting in that specific pocket of the market, well before it shows up as slower sales or visible price reductions.

Why It Leads Rather Than Lags

The reason this ratio moves early comes down to what it's actually capturing. Days-on-market only updates once a listing sits long enough to reflect a slowdown. Price cuts only happen after a seller has already experienced weak buyer response and decided to act on it. 

The competitive set ratio, by contrast, updates the moment new inventory hits the market or a sale closes, which means it reflects supply and demand pressure in near real time rather than after sellers and buyers have already reacted to it.

That gives investors a practical edge in a few specific situations. When comping a potential acquisition, a rising ratio in that radius is a signal to underwrite more conservatively on your exit timeline and price, even if recent comps still look strong. 

When deciding whether to hold a property as a rental or sell it, a tightening ratio can support pushing forward with a sale before competition increases, while a loosening ratio can be a reason to hold and rent instead of listing into a softening pool. And when evaluating a new market or submarket entirely, tracking this ratio over several quarters gives a much clearer read on direction than a single month of headline data ever will.

How to Start Tracking It

This doesn't require expensive tools. Most MLS access already provides the raw inputs: active listings and closed sales within a defined radius and property type. The discipline is in doing it consistently, on the same radius and comparable property definition, and recalculating it on a regular cadence rather than only when pulling comps for a specific deal. 

Investors who build this into a recurring habit, monthly or quarterly, end up with a private, hyper-local trend line that most published market reports simply can't offer.