Awesome, Jason 😃 I’ve taken 3-4 of your classes and am better for doing so. Trendsheet Lite v2 helps me create poly charts like below which speak volumes about what’s taking place in the most recent competing market segment. With fewer and fewer sales, it’s been more difficult to analyze trends so I expand sources such as Infosparks, Appraiser Genie (Freedom) export & charts, and Redfin for that local market. I’m cautious about basing a time or market change % adjustment on 12-months chart, more like 6-months in Infosparks.
Yesterday, I had the privilege of leading the "Developing & Analyzing Residential Market Conditions" class. We dived deep into the world of market trends and Supply/Demand, addressing key questions that many appraisers grapple with: Data Selection: How do you choose the right data for trend analysis? Or do you use all sales data? Do you rely on daily sale prices, or prefer average or median values over different timeframes like monthly, quarterly, semi-annual or annual? Scope of Analysis: What geographical limits do you consider? Do you analyze data by subdivisions, neighborhood boundaries, zip codes, entire cities, or perhaps broader areas like counties or MSAs? Which is the most reasonable? Timeframe and Segmentation: How extensive should the historical data be? Is it more telling to examine trends over 1, 2, 5, or even 10 years? And is it truly indicative of a trend if you are only comparing one period to another? We also explored the nuances of Inferred vs. Fundamental analyses and four different Levels of Market Conditions Analysis. Always a highlight of the class for me was demonstrating how Excel can be a powerful tool to develop the trends and necessary adjustments easily, efficiently, and accurately. For all the appraisers, analysts, and data enthusiasts out there, I'm curious to hear about your approaches. How do you determine market trends? What strategies have you found most effective?