Choice Valuation, PLLC

Your choice for residential appraisals and appraiser products

Performing single- and multi-family residential appraisals and creating simple, useful software for appraisers.

TrendSheet 4 - IL / MRED
139.00 150.00
Purchase

Creating a Custom Export for use in the MRED system - ConnectMLS

  • First thing you'll need to do is get into ConnectMLS.
  • Hover over Reports and click on 'Custom Reports'.
  • Then you'll click 'Add New Report'.
  • Verify that for 'Property Type' you select 'Detached Single' (or 'Attached Single') and name the report 'TrendSheet 4'. You'll have to repeat this process for both property types (Detached and Attached).
  • Then you'll go through the list on the right and remove all of the fields except for 'MLS #' and 'Status' by clicking on each one and then clicking on the 'move left arrow' which looks like this: '<-'.
  • Next you'll add the following categories from the left window to the right window using the 'move right arrow' which looks like this: '->'.
  • The final list on the right should look like this and the fields must be in this order:
    • MLS #
    • Status
    • List Price
    • Sold Price
    • Status Date
    • List Date
    • Closed Date
    • Listing Market Time
    • Contract Date
    • Short Sale/Foreclosed/Court Approved
    • Approx Sq Ft
    • Type Detached (when doing the Attached Single setup use 'Type Attached')
    • Approx Year Built
    • Exterior Property Features
    • Seller Concessions Amount/Points
    • Lot Size (when doing the Attached Single setup use 'Total # of Units in Building')
    • Acreage (when doing the Attached Single setup use 'Lot Description')
    • # Bedrooms
    • Total Full/Half Baths
    • # Garage Spaces
    • Garage Type
    • # Parking Spaces
  • Once the list is complete and in the above order click 'Save'.
  • Be sure and do this process for both Detached Single and Attached Single.

How to Export your Data

  • Verify that the search you are exporting includes every type of listing EXCEPT RENTALS (all active and all off-market excluding leased) for at least one year back from the effective date you're using.  The further back you go the more likely you are to include pertinent data. I recommend going 2.5 years back since TrendSheet 4 analyzes two years of data at once.
  • Once you are in the results screen of your search click the 'Export' button which is a picture of a folder with a down arrow on it.
  • Verify that 'All listings' is selected and click 'Next'.
  • Click the drop-down box on the 'All fields in this report' line, choose 'TrendSheet 4', then click 'Next'.
  • In the 'File format' verify that 'Tab-delimited text' is chosen then click 'Continue'.
  • Save the file as whatever name and to whatever folder you prefer (depending on browser settings you may not be given the option to choose the name and location).

The last thing to do is copy and paste the data from the export into TrendSheet 4. If you need help with this please check out our video below on the topic. When you open your file that was downloaded from your MLS system it may say the file is in a different format and ask if you are sure you want to open it. Just choose 'Yes'. 

In this MLS if your computer gives an error when trying to open the downloaded file, it will given an option for you to choose which program to open the file with. Choose 'Notepad'. Your computer will save this setting and you will only have to choose that 'Notepad' once.