The Enable Multiple MLS File Read function is comparable to the Enable Multiple Export File Read function in that it allows to read in multiple files. The key difference is that the Enable Multiple MLS File Read allows you to read in files from Multiple MLS’’.
When would you want to use this feature?
This function is very useful for situations where you are near the edge of an MLS area, that may be also covered by another MLS area. In these situations, it is not unusual for Realtors to have to put listings in both MLS’s. Of course, you’ll always find some listings in only one of the MLS’s. This functionality does require that you have access to both MLS. To do an analysis of the area, you can export data from both MLS’s and then merge the data. When using this feature, we recommend that you also set the Duplicate Listing Interval to a non-zero value, so that listings that are in both MLS’s are not duplicated. [For more information on the Duplicate Listing Interval select this link.]
To set the Enable Multiple MLS File Read:
- Go to the Visual Pricing “Start” tab
- Using the Add-In Menu, select the Focus1st, then select the Configure menu item
- Select the Enable Multiple MLS File Read box (an arrow will appear).
After selecting this option, each time you read in a file, you will be prompted for the MLS area that the specific file is from.
The Duplicate Listing Interval is a parameter that can be set to remove duplicate listings from the data shown on the Visual Pricing Graphs. This is useful for two situations:
- There are several situations where listings will be taken off the market, and put right back on at a lower price range. This is done to make the property look like a new listing. In these cases, you may prefer to have those two listings combined as one, rather than as two separate listings. The Visual Pricing System can combine them automatically for you. All you need to do is to determine how long the property should be off the market, before you’d want to consider them two separate listings and set the Duplicate Listing Interval appropriately.
- There are some MLS’s ( Denver, CO Metrolist for example) where each time a property has a price adjustment, it results in a new MLS and the previous MLS number is withdrawn. This creates a lot of extra MLS activity which really didn’t happen. Using the Duplicate Listing Interval will help remove all that extra MLS activity that didn’t happen.
To set the Duplicate Listing Interval:
- Go to the Visual Pricing “Start” tab
- Using the Add-In menu, select Focus 1st, then select the Configure menu item
- Set the Duplicate Listing Interval to 30 (or the number of days you’d prefer)
Absolutely! Be aware that the colors of the data on your scattergram graph do match the colors on the other graphs on the Visual Pricing System. For example, the blue shows SOLD properties on the Odds of Selling, Time to Sell, and the Scattergram.
That being the case, you can easily modify the colors on your scattergram graph. To modify the colors first select one of the data points of the data set you want to change by left-clicking on a data point in that set. When you select one of the data points you will notice that all the data points are highlighted (although in my case I notice that some of the data points are not highlighted but all the data points are impacted). In the example below, we’ve selected the Red or Withdrawn/Expired data points. Once you’ve selected a data point of the set you want to change, right-click on one of the selected data points and select the “Format Data Series” menu.
Once you’ve selected the “Format Data Series” menu, you will see a dialog box similar to that shown below. Select the “Marker Fil” option to change the color of the Marker. This will change the color on all the data points of that set. Select the “Line Color” option to change the outside line color of the Marker”. This will the change the color on the line on all the data points of that set. Notice that you can also change the type of marker that is used as well. In most cases, you will want to change both the Marker Fil and Line Color to match.
You are also able to change the color of just one of the data points as well. As before, select the data point by using the left-click on that data point. Again, all the data points in that data set are selected. Now, left-click the specific data point you want to change (so you’ve left-click on that data point twice). This time, only that data point will be selected. Right-click that specific data point and select the “Format Data Point” menu to change only that data point.
Is it possible to get more than one trend line on the scattergram chart? One of our agents likes to show the trend for sales and for under contracts.
Yes, you are able to do more than one trend line on the scattergram charts.
To add additional trend lines, select one of the data points in the set. For example, if you want to add a trendline for the withdrawn/expired properties, select one of the withdrawn/expired data points. When you do that you will find that all of the data points are highlighted (or most of them). Then right-click that data point. A menu will appear. Select the “Add Trendline” option. A dialog box will appear. The default is the linear trendline which is what you will want.
Take a close look at the dialog box. You may also select the line color option to change the line color and the line style to change the thickness of the line. Also, you can always make changes later (including deleting the trend line) by selecting the trend line and then right-clicking and selecting the “format trendline” to make changes.
The location of the focus1st menu depends on the version of Microsoft Excel you are using.
If you are using Microsoft Excel 2007 or Microsoft Excel 2010 the Focus1st menu can be found by 1) first select the Add-On menu item. 2) Once you select the Add-On menu, the Focus1st menu will drop down below, as shown below.
If you are using Microsoft Excel 2011 (or the MAC version), 1) move your cursor over the Scattergram (or Pricelines) column. Once you do that you will see a comment show up that states “Right-Click Here for Scattergram Menu”. So, Right-Click to make use of the Scattergram Menu. To access the Competitive Price Line menus, Right-Click on that heading.
If you are using the Microsoft Excel 2003, your Focus 1st menu should be at the top menu item as shown in 1 below.
I’ve updated my Scattergram and the legend is overlapping the heading at the bottom. What can I do to see the heading?
When the Scattergram charts are ‘Update’d, using the ‘Update’ feature is not unusual to get extra legend entries that take up space in the legend unnecessarily. When that happens, the legend will grow and hide the square footage values behind it. Take a look at a recent legend that was created using the Scattergram Update feature.
In the chart above, the legend has the excess “Series 5”, “Series6” and “Series7” labels in the legend. To get rid of those labels you can easily delete them. Just select them and then hit the delete key. To select them, just position your cursor over the entry and left click. You will see a box around that label and four circles located in the corners as shown below. Once you’ve selected the series, just press the “delete” key to delete it.
Be sure that you do not delete the legend. If you accidently do delete the legend, you can just undo that operation to bring it back. Be aware, that these series are not needed and when you delete them, you will not change the actual graph or data in any way. In the example above, once we delete all three of these extra labels our chart looks like that shown below.
Now that we’ve gotten rid of the extra labels, all we have to do is to play with the legend size and shape. Select the legend by pressing anywhere in the legend. When the legend is selected, you will see a box surrounding the legend and four circles on the corners. Position your cursor at one of the corners. Then you can hold down the left mouse button (the cursor will change to a two headed arrow), and you can drag the corner to resize and reposition the legend. By resizing and repositioning corners on both sides of the legend we created the following result.
The Visual Pricing System works best when the date format being used is the US Format. the date format will impact the date sorting that occurs when using the Select Data for both the scattergram and Competitive Price lines functions. Usually this would impact our Canadian customers whose date formats may be set to the Canadian format. While US dates are displayed showing the Month, Day, and the Year, the Canadian format shows the Day, Month, and the Year.
The process below will show you how to change your date format to the US date format on a PC. If you have a MAC, select this link to see how to change your date format to the US date format on a MAC.
- Open up the Control Panel application on your PC. Once you open up the Control Panel, select the “Clock, Language & Region” option as shown below.
- When you select the “Clock, Language & Region” option, you will see a dialog box similar to that shown below. Select the “Format” tab (see pointer 1), and the using the down arrows (see pointer 2), select the “English (United States)” format. Once you do that you will see in the “Dates and time formats” section (see pointer 3), the formats will change to reflect the date format of the US.
Your date format change will be reflected when you read in the next export file.