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 - TX / El Paso (GEPAR)
139.00 150.00

Creating a Custom Export for use in the El Paso MLS (GEPAR) - 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 the 'Grid Manager' icon will appear (it's on the same row as the 'Map' icon. Click on 'Grid Manager'.
  • Select 'Create New Grid'.
  • 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 Number
    • Status (Status)
    • List Price
    • Sold/Leased Price
    • Status Change Date
    • List Date
    • Sold/Leased Date
    • Days on Market
    • Pending/Contract Date
    • Special Notes
    • Apx SqFt - Main
    • Style
    • Year built
    • Pool
    • Concession Y/N
    • Concession Amount
    • Lot Size
    • Apx Acres
    • Bedrooms
    • Full Baths
    • 3/4 Baths
    • Half Baths
    • Garage
  • Once the list is complete and in the above order click 'Save' 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 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 of data at once).
  • On the results page of your search, click 'Tools' (There are two 'Tools' buttons so make sure you click the lower one that is on the same row as the 'Map' and 'Grid Manager' icon).
  • Select 'Export Data'.
  • Verify that 'All Records' is selected.
  • For 'Data Export Format:' you should select 'Tab Delimited'.
  • Do not select 'Compress File'.
  • For 'Select Export Grid Format:' choose the custom export you made which should be called 'TrendSheet 4'.
  • Check the box for 'Include Column Headers' and click 'OK'.
  • Save the file by whichever file name and to 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: