HOW TO EXPORT DATA FROM YOUR MLS
Perchwell
STEPS TO EXPORT DATA FROM YOUR MLS
1. Create your MLS search
In selecting data, make sure that ALL status options are selected.
Selecting all status activity will ensure that all the data needed to create the graphs is collected.
Additionally, you will need to select the "Sold or Rented", "Canceled", and "Expired" dates to be two
years
back.
Note: at the current time,
properties that have been "Canceled" are not recognized.
The support of "Canceled" properties requires a change from the MLS.
We will support "Canceled" properties as soon as possible.
To select all the listing activity,
go to the Search Filters.
Then scroll down to the Current Status area.
Be sure that all status options are selected.
Next you will want to limit the data from the last two years.
To set the date range,
scroll down to the Listing Activity area just below.
Then for the Went off market,
Expired
and Sold or Rented status items,
select the checkbox to set the date range.
When you select the "checkbox" a calendar will appear allowing you to set the dates.
You will need to select both the start and end dates.
Select the date range to go back two (or more) years starting at the begining of a year
(January 1).
When searching for all status activity for the last two years,
your search results should be in the 50 to 100 comparable properties range (this is a rough guideline).
If you have slightly less than 50 that works, or a little above 100 is fine as well.
You should also make your normal selection choice by selecting other options that you would normally select
in doing a CMA.
For example, options you would normally use when doing a CMA,
this could include a map search (using a polygon), subdivision or neighborhood,
city, zip code, lot size (<.5 acre, 1-5 acres, etc. ), on water. Looking at activity in specific
subdivisions is also good starting point. For your initial search you want to focus on location
(location, location) and add in unique features (only if necesssary). To view a short tutorial on how to
do an effective search to use in your Focus 1st Pricing, select
this link.
Once you've selected the search criteria, and can see your results you are ready to export your data.
2. Export your results
Once you have your search results, you are ready to export your results.
To export the results, while on your search results screen,
select the Export Data option.
The Export Data option is located just above the search
results on the left side of the screen.
When you select the Export Data option, you will see the
CSV Export Dialog box as shown below.
Select the Select All link just above list of fields located
at the right side of the dialog box to select all the fields (they may already be selected).
Then select the Export button.
Once you've selected the Export button,
you will see the dialog box shown above stating that
the export file will be emailed to you.
When you run the Focus 1st software,
you will need to find the exported data file.
So you will need to download the file from your email.
In most cases the name of the file will be automatic by your MLS.
It may make sense to move the file to a location that is easy to find.
For a short video on how to do your search, and export your results to download into the
Focus1st Pricing software, select this
link.
For more instructions on how to run the Focus 1st software, be sure to check out our Youtube channel by
selecting this link:
