Exporting Data from CAN, Toronto – Matrix

Note: The exporting process described below will not work with the Microsoft Explorer.  You will need to download the google Chrome browser to use the steps below to export your data from the Toronto MLS Listing MLS. 

Searching Toronto MLS Listings

In selecting data from the Toronto MLS Listings, be sure to select the options below:

First you will want to select both “available” and “unavailable” properties.  Make sure that all the status options are selected (as shown below) for the last two years.  These options will make sure that all the data that is needed to create the appropriate graphs, is collected.  

You should also make your normal selection choice by selecting other options that you would normally select in doing a CMA.  As mentioned earlier, looking at activity in specific subdivisions is a good starting point. 

It is also recommended that you include data from the last two years to enable you to see the recent patterns.  In this example (the search is run in early 2013), we've included all items with a status date of "1/1/2011" and beyond. 

Once you’ve selected the search criteria, press the ‘Search’ button to see the results as shown below.  Now you are ready to download the results.  Before you download the results you must customize the columns to include additional fields that are needed by the Visual Pricing System.  To do so, select the “customize” button, as shown below. 

Once you select the “Customize” button, you will see a dialog box similar to that below.  This will allow you to add additional fields to the existing “TREB Generic Default (Default)” fields. 

You can add the fields you need by selecting the fields. 

Note:  Add the following fields to the TREB Generic Default (Default) definition. 

·      Listing Entry Date

·      Approx Square Footage

·      Approx Age

·      Expire Date

·      Days on Market

·      Last Update


Once you have completed the task above, save the results by pressing the  button or you can use the “SAVE AS” button to rename the new format.  You will need to use this format when you are ready to export the results. 

Next select the small box, to include all the properties you’ve found in your search results.  This should high-light all the properties as shown below. 


You are now ready to save your results to an export file which you can read into the Visual Pricing System.  To save your results right click and select the “Save As” menu item as shown below.  

Note:  This operation does NOT work with the Microsoft Explorer or Safari browsers. It will require that you use the Chrome Browser.

Once you select the “Save As” menu, you will be shown a dialog box similar to that shown below.  Select the “Webpage, Complete” type and choose a file name that you will recognize as the search results that you’ve just saved. 

Your file will now be exported. 

Be sure to remember where you save your file.  This is the exported file that will be used to create your graphs.

Once you have saved your exported file, you are ready to run the application.

When you run the application you will need to point to the exported data file, so make sure that you’ve placed the file in an easy to find place. 

For instructions on how to run the application, be sure to see the tutorials located at http://www.focus1st.com.


If you are having trouble reading in the export file

We have noticed that in some cases, if your search screen is showing the “thumbnail photos” of the search results that the export format doesn’t work.  So we suggest that you do turn off those thumbnail photos before you export data.   To turn of the thumbnail photos, go to the “Info Center” -> “Settings” and then make sure that the “Show Thumbnail Photos at Search Results Lists” is turned off (as shown below).  Then re-run your search to export data.