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 the NNEREN Paragon system

  • Once in the results of a search, click the green 'Reports' button.

  • Under the Spreadsheets folder choose any spreadsheet that you don't normally use because you're going to be modifying it.

  • Click 'Customize' and then 'Fields'.

  • Verify that the class is 'RESIDENTIAL' and group is 'Listing'.

  • Name it 'TrendSheet 4'.

  • Remove all categories except for MLS # and Status (if they're already there). Click 'Save' and then click on 'Customize' and then 'Fields' again.

  • Add the following categories from the left to the right window until the list on the right window matches the list below exactly including the order. If you don't see the field you're looking for, change the 'Group' from 'Listing' to 'Feature' or 'Feature Categories'.

    • MLS #

    • Listing Status (may also say Listing Status - Ascending)

    • Price - List

    • Price - Closed

    • Date - Status Change

    • Date - MLS List

    • Date - Closed

    • Days on Market

    • Date - Pending

    • Foreclosed/Bank-Owned/REO

    • Short Sale

    • SqFt-Apx Total Finished

    • Total Stories

    • Year Built

    • Features - Exterior (in the FEATURE CATEGORIES drop-down)

    • Concessions

    • Concession - Amount

    • Lot - Acres

    • Bedrooms - Total

    • Baths - Full

    • Baths - 3/4

    • Baths - 1/2

    • Garage Capacity

    • Garage Type

  • Once the list is complete and in the above order, UNCHECK the boxes for every row in both the 'Short Lbl' and 'Short Val' columns. All boxes should be unchecked.

  • Click 'Save' and you are done.

How to Export your Data

  • Verify that the search you are exporting includes every type of listing EXCEPT RENTALS (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 of data). 
  • Once in the search results click 'Export' then 'Export to CSV'.
  • Select 'All listings'.
  • Verify that TrendSheet is selected and click 'Export'.
  • 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).

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: