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 - MO / SOMO
139.00 150.00
Purchase

Creating a Custom Export for use in the SOMO MLS system - FlexMLS

  • Hover your mouse over 'Preferences' and select 'My Exports'.
  • Select 'New'.
  • Name the export 'TrendSheet 4', make sure 'Detail group names show in front of the detail name' is selected and that 'Residential' is also selected and click 'Next'.
  • Click on each of the following categories individually and click 'Add' after each one. Once you are done, the categories will appear on the right side of the window and they must be in the same order as below:
    • Status
    • List Price
    • Sold Price
    • Status Change Date
    • Begin Date
    • Sold Date
    • Days on Market
    • Under Contract Date
    • Foreclosure/Short Sale
    • Total Finished SqFt (All Levels)
    • Stories
    • Aprx Year Built
    • Exterior Extras: Pool/In-Ground
    • Aprx Lot Size (Acres)
    • Total Bedrooms
    • Baths - Full
    • Baths - Half
    • Garage/Parking: 1 Car Attached Garage
    • Garage/Parking: 1 Car Detached Garage
    • Garage/Parking: 2 Car Attached Garage
    • Garage/Parking: 2 Car Detached Garage
    • Garage/Parking: 3+ Car Attached Garage
    • Garage/Parking: 3+ Car Detached Garage
    • Garage/Parking: 1 Car Carport Attached
    • Garage/Parking: 1 Car Carport Detached
    • Garage/Parking: 2 Car Carport Attached
    • Garage/Parking: 2 Car Carport Detached
    • Garage/Parking: 3+ Car Carport Attached
    • Garage/Parking: 3+ Car Carport Detached
  • Once the list is complete and in the above order click 'Next' and you are done.

How to Export your Data

  • Verify that the search you are exporting includes every type of listing (active, contingent, pending, closed, expired, canceled, etc) for at least one year back from the effective date you're using.  It is better to go further back than one year to verify that all relevant listings are included so I recommend going 2.5 years back (since TrendSheet analyzes two years of data at once).
  • Click 'Export' at the top right.
  • Verify that 'Export all matches' is selected.
  • Click 'Custom Text Export' and choose the export you created which should be named 'TrendSheet 4'.
  • Type in the verification text and click 'Export'.
  • Save the file by whichever file name and into whichever folder you prefer (depending on your browser settings you may not be given the option to choose the file name/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 on the topic: