I partly disagree that completed sales will settle it, because they lag the listings you are watching and may reflect different financing conditions. I’d split the sample by neighbourhood, condition and initial versus reduced price, then record under-offer, withdrawn and still available...