Selecting and Exporting Data from your MLS

The first step in creating your buying pattern graphs is to do an MLS search from your local MLS.  Once you do that, you will need to export your data into a file and then you are ready to run the Buying Pattern application. 

Selecting Your Data

When you select your data, the data that is most effective is data that is specific to the property that you are evaluating.  For example, look at data that is specific to the neighborhood of the property that you are evaluating.  The balance is to gather enough data so that the graphs show you information that is valid, but not so much data that the number of points is too exhaustive.  While you obviously need to do what makes the most sense, the graphs come out best, when the numbers of points are between 20-40 Solds per year. 

For more detail on comparing properties take a look at the Scattergram Manual that comes with the Scattergram Pricing for Realtors® application (see www.Focus1st.com). 

The graphs also work over a period of the last two years.  So select data from that period of time for the most effective graphs.  Also, select data to include, SOLD, For Sale (or Active), Withdrawn, and Expired properties.  For example, select all the properties in a specific neighborhood which have been SOLD, been Withdrawn, been Expired, or are currently For Sale. 

Set the data to be from January 1, 2006 to present (this assumes the most recent year graphed is 2007).  This will provide a great data set to be analyzed. 

 

The effectiveness of this tool is dependent upon the expertise of the Realtor® and the data selected.  Many MLS do not provide data older than 12-18 months.  If your MLS does not provide data older than 12-18 months, then the Odds of Selling graph will not be complete for previous yeas. 

See a sample search below (note that in the Off-Market date shown is 1/1/2005 and for this case we would use 1/1/2006):

As you get more experience analyzing the data, you may choose to look at only ranch plans, or maybe properties in a wide area that have acreages, etc. 

The next sections contain instructions on how to export data from several MLS that are supported by the Neighborhood Buying Patterns.  Find your MLS in the sections below and follow the procedure as described. 

The graphs work over a period of the last three years.  So select data from that period of time for the most effective graphs.  Also, select data to include, SOLD, For Sale (or Active), Withdrawn, and Expired properties.  For example, select all the properties in a specific neighborhood which have been SOLD, Withdrawn, Expired, or are currently For Sale.