MLS statistics

[J Grant]

If anyone has Flex MLS ( which seems a system common in many areas )
I can save people pain if interested cause it took hours to find the simplest way to run a statistical chart for trend line market conditions-
1) do a quick search area, property type etc ( as you normally would search) for sales or listings or whatever you want
click view results
go up to the upper left click Menu
scroll down to statistics, click it , and it will give choices of a chart or different options and when it shows it you can refine it by lower part check median price or average or both etc

you can print the chart and save it to pdf and add it to the report or export it to wherever -

 

[Terrel L. Shields]

I have flex but it is pretty rudimentary here but does that. What I miss is the inability to draw a trendline like you can in Excel. Our prices are under pressure (this is Grove, Oklahoma about 129 sales in 2023-24) And the sale vs asking price has steadily deteriorated over the year - but month to month simply doesn't have much meaning. Of course, you can draw a trend line manually but not accurately.

 

[zutero771]

I’ve read here that using Flex MLS for running statistical charts can be tricky, but this method should save you some time. You just do your normal search for the area, property type, etc., and click "View Results." Then, click the "Menu" at the top left, scroll down to "Statistics," and you’ll have options for different charts. From there, you can refine the results by selecting median or average prices, and even print or save it as a PDF for reports.

 

[Tom D]

Terrel & J Grant. Interesting charts, but is there any non statics expert who can understand those charts the way they present it. It over tech gibberish to the normal reader, not that's there anything wrong with it when you don't have anything better..

 

[J Grant]

I have flex but it is pretty rudimentary here but does that. What I miss is the inability to draw a trendline like you can in Excel. Our prices are under pressure (this is Grove, Oklahoma about 129 sales in 2023-24) And the sale vs asking price has steadily deteriorated over the year - but month to month simply doesn't have much meaning. Of course, you can draw a trend line manually but not accurately.
View attachment 96024View attachment 96025

It starts out like that, but then ( at least on my end ) you can choose median, average, etc from boxes on the lower left and it brings teh trend lines much closer together.

Take the steps I outlined in my first post, and it should take you there was super easy to do once I figured out the steps to take, the boxes are very skinny below the chart , almost like a line, but when I checked them it worked,

 

[J Grant]

Terrel & J Grant. Interesting charts, but is there any non statics expert who can understand those charts the way they present it. It over tech gibberish to the normal reader, not that's there anything wrong with it when you don't have anything better..

Imo it is low tech, and it runs off the sales if you wany to include and attach them to illustrate what data was used - it looks like Terrell did not use the trend line as a last step I'll see if I can post a sample

 

[RSW]

If anyone has Flex MLS ( which seems a system common in many areas )
I can save people pain if interested cause it took hours to find the simplest way to run a statistical chart for trend line market conditions-
1) do a quick search area, property type etc ( as you normally would search) for sales or listings or whatever you want
click view results
go up to the upper left click Menu
scroll down to statistics, click it , and it will give choices of a chart or different options and when it shows it you can refine it by lower part check median price or average or both etc

you can print the chart and save it to pdf and add it to the report or export it to wherever -

I just do my search in Flex and then export it to Excel.

 

[J Grant]

 

[J Grant]

I just do my search in Flex and then export it to Excel.

What is the advantage of exporting it to Excel? Above post is the trend line directly from MLS it is what I insert into the report

 

[BRCJR]

What is the advantage of exporting it to Excel? Above post is the trend line directly from MLS it is what I insert into the report

You can clean up the data as it is generally corrupted to some degree (see attached). You then make your own chart within excel.
(did not intend to circle last date at bottom of sheet)