Creating a Custom Export for use with QCARA (Quad City MLS) in the Paragon system
Once in the results of a residential 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'.
Name it 'TrendSheet 4'.
Remove all categories except for MLS # and Status (if they're already there).
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'.
Status (may also say Status - Ascending)
Days on Market
Disclosed Short Sale
ADDITIONAL AMENITIES-Pool/In Ground (in the 'Feature' section)
ADDITIONAL AMENITIES-Pool/Indoor (in the 'Feature' section)
Apx Lot Size
Total Full Baths
# Full Baths-Basement
Total 3/4 Baths
# 3/4 Baths-Basement
Total 1/2 Baths
# 1/2 Baths-Basement
GARAGE/PARKING (in the 'Feature Categories' section)
Once the list is complete and in the above order, be sure to UNCHECK the boxes (all of them) for every row in both the 'Short Lbl' and 'Short Val' columns.
Click 'Save' and you are done.
Please contact us if you have any issues with this setup and we will be happy to do it for you or walk you through it.
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'.
- Be sure to select 'TrendSheet 4' (or whatever you named the export you made in the above section) in the drop-down then 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 - if this happens that means your browser should have saved the file to your Downloads folder).
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: