Check out all past tips in the archive HERE

Tracking Market Shifts Daily – A System You Can Replicate

In a recent Dave Ramsey Agent Mastermind, the conversation turned to how we can better understand the shifts in our local markets. A number of agents asked me about a chart I shared, so I thought I’d break down exactly what I’m doing in case you’d like to replicate it in your own MLS.

Back in July, I started manually recording key market stats every morning because clients and fellow agents were telling me they “felt” like the market was changing. I didn’t want to rely on feelings — I wanted the data.

Why Manual Tracking Matters

Sure, I could automate the process. But I’ve found that by spending just a couple of minutes each morning pulling the numbers myself, the data sticks in my head. Now when a client, neighbor, or agent asks, “How’s the market?”, I can answer confidently with real numbers and context instead of generalizations.

The 10 Data Points I Track Daily

Every morning, I log in to my MLS and capture these:

• Active Today

• Pending Today

• Closed (Last 30 Days)

• New Listings (Last 24 Hrs)

• Price Decreases (Last 24 Hrs)

• Expired/Withdrawn (Last 24 Hrs)

• Pending (Last 24 Hrs)

• Closed Last 30 Days: Avg. List Price

• Closed Last 30 Days: Avg. Sales Price

• Closed Last 30 Days: Avg. DOM

From those, I calculate:

• Months’ Supply of Inventory (MSI)

• List-to-Sale Price Ratio

• How many listings would be needed for a Buyer’s Market

Turning Data into Insight

I use the numbers to chart MSI and to track active vs. pending listings over time. This has been eye-opening — for example, our market recently dipped below 1 month of supply, the lowest I’ve seen since I began tracking. That kind of shift is hard to ignore, and it instantly informs conversations with buyers and sellers.

I have been sharing these insights on my various channels to make sure my audience knows that I have my finger on the pulse of the market.

Sharing the Resource

To make this easier for those who are interested, I’ve given read-only access to my Google Sheet. You’re welcome to view it, study the setup, and replicate the approach in your own MLS. If you choose to adopt it, you’ll have a simple system to keep your finger on the pulse of your market every single day.

Tony Piraino
The Key Team | Brinkoetter Realtors
📍 Decatur, IL
📲 217.972.2867

Archive of Previous Month’s Tips

In January of 2024, I started sending out a monthly email to high-producing real estate agents across the country, agents I’ve connected with at various points. My goal was simple: keep our connection strong without sending the typical local market updates that might not be relevant. Instead, I wanted to share something valuable each month that has helped my business and could potentially benefit yours, too.

A few months ago, I realized it would be helpful to make previous tips easily accessible, especially for new agents I’ve added to the list. That’s why I’ve transitioned from a traditional email to a newsletter format, where you can now find an archive of all the tips I’ve shared since January. You can access the archive HERE.

As a reminder, here are the topics I’ve covered so far:

January 2024: Artificial Intelligence Tools
February 2024: Key Team Client Events
March 2024: Zillow CMA (ZMA)
April 2024: Creating a Google Map of Address List
May 2024: 2-1 Mortgage Buydown
June 2024: “Did You Hear About Your Neighbor?” Door Hangers
July 2024: Unsolicited Video CMA
August 2024: Beehiiv Email Newsletter
September 2024: Fiverr Virtual Assistant
October 2024: “Working With You Would Be A Treat” Halloween Geofarm Door Hanger
November 2024: Fall Mini Photo Session Event
December 2024: “Get Handshake” Free Agent Referral App
January 2025: Exporting Birthdays from Facebook and Importing to your CRM
February 2025: Sisu Transaction Management
March 2025: Synthensia AI Video Avatar
April 2025: Leveling Up Your Geo Farming with AI
May 2025: Steal This Dad Joke Idea
June 2025: Utilizing Canva as an AI Real Estate Coach
August 2025: Winning the AI Search Game: Why I’m Paying Attention

Have any of these topics been helpful to you? Are there any great tips you’d be willing to share? I’d love to hear from you!

Thank you!