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 - RealTracs
139.00 150.00
Purchase

NOTE: CONDOMINIUM SEARCHES AND EXPORTS DO NOT CURRENTLY WORK WITH TRENDSHEET IN THIS MLS.

Creating a Custom Export for use with RealTracs in Tennessee, Alabama, and Kentucky

  • Perform a residential search and get to the results screen of that search by clicking the green 'Search' button. 

  • Click the 'Columns' button toward the top, then click 'Add/Remove'.

  • At the top click the box next to 'Save As' and type in 'TrendSheet 4' as the name.

  • In the list below, un-check ALL boxes and then put a check mark next to each of the following fields and put the check mark next to each one in the same order that they appear in the list below. 

    • MLS Number

    • Status

    • List Price

    • Sales Price

    • Expiration Date

    • List Date

    • Closed Date

    • DOM - Days on Market

    • Under Contract Date

    • Withdrawn Date

    • Listing Type

    • SqFt Total

    • Stories

    • Year Built

    • Pool Description

    • Seller Participation

    • Acres

    • Bedrooms Total

    • Full Baths Total

    • Half Baths Total

    • Garage Description

    • Garage Capacity

  • Once all the boxes have been checked for the fields above click 'OK'.

  • Verify that the columns on the current results screen that you now see match up in order identically with the list above. So MLS Number should be first on the left and Garage Capacity should be last on the right.

  • NOTE: CONDOMINIUM SEARCHES AND EXPORTS DO NOT CURRENTLY WORK WITH TRENDSHEET IN THIS MLS.

How to Export your Data

  • Verify that the search you are exporting includes every type of listing (active, contingent, pending, closed, expired, canceled, etc 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 2.5 years (since TrendSheet 4 analyzes two years worth of data). 
  • In the search results screen click 'Columns' (toward the top) then hover your mouse over 'My Layouts' then click 'TrendSheet 4'.
  • Click the 'More' button (toward the top) then click 'Download'.
  • On the window that pops up choose 'All' for All Results or Selected Results. Choose 'List Layout' for All Fields or Current List Layout. Choose 'Text' for File Type.
  • Save the file by whichever file name and into whichever folder you prefer (depending on browser settings you may not be given the option to choose the file name/location - if this happens your browser most likely saved the file into the Downloads folder of your computer).

 

  • FOR A STATS ONLY SEARCH:
  • If you are doing a Stats only search where you can't view the list of properties then click the 'Down Arrow' icon just above your search parameters.
  • Choose 'Text' for File Type. Choose 'List Layout' then 'TrendSheet 4' for the Download All Fields or List Layout option.
  • Save the file by whichever file name and into whichever folder you prefer (depending on browser settings you may not be given the option to choose the file name/location - if this happens your browser most likely saved the file into the Downloads folder of your computer).

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: