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.

Creating a Custom Export for use in Midwest Ohio - WRIST-MOAR / Fusion

  • First thing you'll need to do is get into the results of a residential search.
  • Once you're in the results of a search click on the 'Column Manager' icon toward the top left.
  • Select 'Create New Column Report'.
  • Name the grid 'TrendSheet 4'.
  • Click on each of the following categories individually and click the Right Arrow each one to get them to appear in the right window. 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:
    • MLS# (MLS#)
    • Status (STATUS)
    • Price (Price)
    • Sold Price (Sold Price)
    • Status Change Date (Status Change Date)
    • Listing Date (Listing Date)
    • Sold Date (Sold Date)
    • Cumulative DOM (Cumulative DOM)
    • Contract Date (Contract Date)
    • Ownership (Ownership)
    • Sq Ft(Sq Ft)
    • Level / Style (Level / Style)
    • Year Built (Year Built)
    • Outside Features (Outside Features)
    • Type of Contract (Type of Contract)
    • Acres (Acres)
    • Beds (Beds)
    • Baths (Baths)
    • Half Baths (Half Baths)
    • Garage (Garage)
  • Once the list is complete and in the above order click 'Save' and then click 'Done'.

 

How to Export your Data

  • Verify that the search you are exporting includes every type of listing ( all variations of active, contingent, pending, closed, expired, canceled, etc but not including leased) 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 4 analyzes two years worth of data).
  • At the bottom left click the green arrow next to 'Export Data'.
  • Verify that 'All Records' is selected.
  • For 'Data Export Format:' you should select 'Tab Delimited'.
  • Do not select 'Compress File'.
  • Click 'Next'.
  • In the drop-down menu at the top left select 'TrendSheet 4'.
  • Check the box for 'Include Column Headers' and click 'Next'.
  • Save the file (or it may save automatically depending on your browser settings) by whatever name and to whatever folder you prefer.

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: