Excel Spreadsheets For 1004 MC

[Mike Garrett RAA]

According to my MLS they cannot provide me with the number of listings other than current, so I have a statement on the 1004mc "Some information needed for analysis on this form is not available at this time such as the number of active listings, days on the market, and median sales price of listings for prior quarters". I then indicate in those boxes "Info not available". I also have a comment that MLS data shows an average and not median sales price. As I said, no one has ever questioned this. Most of the members of our local appraiser's group (CAREA) do the same as I am doing. There are a few who use data from another source and also use programs available such as yours.

If it would make my job easier and faster I would be interested in learning your program provided it would work with my MLS.

 

[VegasWayne]

If the MLS records date fields and can export data it will work with a spreadsheet. I've seen one really bad MLS system that wouldn't work, but it would sometimes require that you call the listing agent even to get an address of a listing. To manually process the data would require six carefully setup searches and lots of tedious calculations and sorting. Computers are very good at tedious calculations and sorting so you might as well let them do what they are best at.

 

[George Hatch]

According to my MLS they cannot provide me with the number of listings other than current, so I have a statement on the 1004mc "Some information needed for analysis on this form is not available at this time such as the number of active listings, days on the market, and median sales price of listings for prior quarters". I then indicate in those boxes "Info not available". I also have a comment that MLS data shows an average and not median sales price. As I said, no one has ever questioned this. Most of the members of our local appraiser's group (CAREA) do the same as I am doing. There are a few who use data from another source and also use programs available such as yours.

If it would make my job easier and faster I would be interested in learning your program provided it would work with my MLS.

So you're saying you have no way of searching for expireds, cancelled or withdrawn listings? If so how do you go about analyzing your subject's listing history?

At any rate, even if all you can export are your actives, pendings and closed sales a spreadsheet can analyze those a lot faster and a lot more accurately than you can. Not that anyone reads that info anyway, but if you're going to put it out there you might as well let the machine do all the drudge work.

 

[Mike Garrett RAA]

I can do expired, cancelled, withdrawn, etc. The problem is that our MLS only shows current active listings. I cannot, as an example tell you how many active listings there were between, say, 12/01/2012 and 06/01/2012.

 

[gregb]

Mike, which MLS system is in use for Colorado Springs?

 

[Lee Lansford]

Why not ask your local MLS to develop a search function (having your particular parameters) for the 1004MC?

 

[VegasWayne]

The way the spreadsheets determine when listings were active is by the date fields. Each listing has an initial listing date and a date when it was no longer active. This is either the pending date, withdrawn date, or the expired date. The spreadsheet checks each comparable to see if it was active on one of the dates that need to be reported and if it is it is stored in a table where the calculations and sorting are done. You only need to get the results from one search that includes actives, pendings, closed sales, withdrawns, and expireds. You put this data in the spreadsheet and it does the rest.

 

[George Hatch]

I can do expired, cancelled, withdrawn, etc. The problem is that our MLS only shows current active listings. I cannot, as an example tell you how many active listings there were between, say, 12/01/2012 and 06/01/2012.

If I enter a search of all listings (active, pending, sold, expireds etc) going back 2 years my spreadsheet will correctly identify which listings were active as of the respective dates as well as including them in the analyses. Regardless of their current status.

All the other listings that don't meet the specified criteria simply get ignored by the worksheet.

The worksheet operates off a single search/download. As I say, once I load in the search parameters into my MLS it only takes 2-3 minutes to retrieve the download from the MLS system and plug it into the worksheet. The worksheet analyses and displays the results in the grid immediately. The main limitation is the accuracy and consistency of the MLS data itself.

Don's worksheet operates the same way as do the other options I've seen. It's been a couple years since I've seen them but the last I saw he bundles some other tools and graphs in with his that I don't include so some people find those useful.


With all of them you run a search, download it from the MLS and copy/paste it into their systems and the results are displayed immediately. They all use some form of spreadsheet programming to do it even if they're running it in the background where you can't see it.

MLS systems nationwide that use Rappatoni software incorporated my worksheet directly into their system for their "1004mc Report" option so all of those users have been using a variant of my worksheet for a long time now.

 

[The Bob]

I've been using Mr Hatch's SS for some time now, I tweaked it so that it lists seller concessions and seller by type (REO, Individual, corporate, etc..). Our MLS offers an auto populate feature, but it is worthless, imo.

 

[JTip]

According to my MLS they cannot provide me with the number of listings other than current,

Depends on the MLS. My MLS that I use: Navica CANNOT do it while Interface Express CAN provide historical active listing numbers, for example.