Real Estate Appraisal Forum

appraisersforum.com logo
The Premiere Online Community for Real Estate Appraisers!
 Fastest Way to Find a Real Estate Appraiser Enter Zip Code:
 
 
Go Back   Appraisers Forum > Real Estate Appraisal Forums > Fannie Mae, Freddie Mac, USPAP
Register Help Our Rules Calendar Archives Mark Forums Read


Closed Thread
 
Thread Tools
  #1  
Old 03-15-2009, 12:27 PM
William Rightsell's Avatar
William Rightsell William Rightsell is offline
 
Join Date: Oct 2004
Location: Greensboro, NC
State: North Carolina
Professional Status: Certified Residential Appraiser
Posts: 842
Default Tempo5 MLS & 1004MC

Any other Tempo5 MLS users out there??

Tempo has a "statistics" feature to display the search results in a statistical chart rather than individual records....Looks like it may work pretty well for the 1004MC stuff..Gives number of listings, average DOM, list/sale price ratios, etc. If you search correctly, I think it will work pretty slick.

Anybody else tried it/know what I am talking about?

Just curious.

todd


Edit to add....It will still take at least 3 searches (the way I am doing it) to get it done - one for each time period.

Last edited by William Rightsell : 03-15-2009 at 12:29 PM. Reason: Added to post
Sponsored Links

  #2  
Old 03-15-2009, 12:46 PM
George Hatch's Avatar
George Hatch George Hatch is offline
 
Join Date: Jan 2002
Location: Carlsbad, California
State: California
Professional Status: Certified General Appraiser
Posts: 16,245
Default

The problem with the statistics reports is that they break out separate numbers for all the different status categories (active, pending, sold, withdrawn, etc). That means that you have to aggregate the medians, at which point your result isn't a median (or an average) at all.

Besides that there is the extra time and effort involved in running multiple searches.

I built one of my worksheets for a Tempo 5 system; I think it would work with your system, too. It requires the user to run a single search and does everything else automatically. If you can get it to work it would probably save you a ton of time and turn out more accurate results.

http://www.box.net/shared/it1uf1n82v

Look for the "Sandicor" version of the worksheet and it's instructional guides - that was built off a Tempo 5 system. It also works with any system that allows user-defined export formats.

Once you get it together this is a 5-minute operation. Less, even.
  #3  
Old 03-15-2009, 12:58 PM
moh malekpour moh malekpour is offline
 
Join Date: May 2002
Location: Southern California
State: California
Professional Status: Certified Residential Appraiser
Posts: 5,528
Default

I have simple tempo with no version number. It counts and does Average, Max, Min for brs, ba and GLA.
Is that what you have or yours is different?
  #4  
Old 03-15-2009, 01:03 PM
George Hatch's Avatar
George Hatch George Hatch is offline
 
Join Date: Jan 2002
Location: Carlsbad, California
State: California
Professional Status: Certified General Appraiser
Posts: 16,245
Default

Moh, I think your system uses the Tempo 3 software, which also allows user-defined exports. Some SoCal users are reporting that the worksheet works with your system too.
  #5  
Old 03-15-2009, 01:14 PM
moh malekpour moh malekpour is offline
 
Join Date: May 2002
Location: Southern California
State: California
Professional Status: Certified Residential Appraiser
Posts: 5,528
Default

Quote:
Originally Posted by George Hatch View Post
Moh, I think your system uses the Tempo 3 software, which also allows user-defined exports. Some SoCal users are reporting that the worksheet works with your system too.
The worksheet works very well with my tempo version. The user define exporting of this version is fantastic. I can pick and choose any single item of listings in MLS in the order that I want. All I have to do is to find out what is in the worksheet column and select the range of exporting MLS accordingly. It right fits on the worksheet. I may have to widen some of the worksheet columns but that is only once.
  #6  
Old 03-15-2009, 01:22 PM
George Hatch's Avatar
George Hatch George Hatch is offline
 
Join Date: Jan 2002
Location: Carlsbad, California
State: California
Professional Status: Certified General Appraiser
Posts: 16,245
Default

Quote:
Originally Posted by moh malekpour View Post
The worksheet works very well with my tempo version. The user define exporting of this version is fantastic. I can pick and choose any single item of listings in MLS in the order that I want. All I have to do is to find out what is in the worksheet column and select the range of exporting MLS accordingly. It right fits on the worksheet. I may have to widen some of the worksheet columns but that is only once.
The instructional guide shows exactly which columns you need and in what order. If you've figured out how to build your own export format it should be plug-n-play for you.
  #7  
Old 03-15-2009, 02:05 PM
William Rightsell's Avatar
William Rightsell William Rightsell is offline
 
Join Date: Oct 2004
Location: Greensboro, NC
State: North Carolina
Professional Status: Certified Residential Appraiser
Posts: 842
Default

This whole form is pretty whacko in my book...

What do you consider a large enough data set to make the thing have any meaning??...ie....I was thinking of breaking it down by zip code and including ALL properties within that data set to get a sample large enough to mean anything and large enough to develop a trend.

I know the directions say to apply the same criteria the market participant would apply when choosing the data set, but if I do that many times it is too small to make any sense...or the numbers jump around so much that its useless as far as determining a trend. Hence the zip code idea.

And what exactly are they asking for on the form where it says "Median Comparable List Price"? Are they looking for the median list price of the sold sales you just presented two boxes above?? This would make sense, as you could calculate the LP/SP ratio two boxes below from those two figures....

But if they are asking for the median price of the active listings...then the ratio is not meaningful at all....ie...you are comparing sold properties to a whole different set of active listings whose LP and SP are not tied to one another...Ridiculous.

Any input??

And yes George, you are correct...the stats feature breaks it out by property status...closed, active, pending, pending AB, etc....To make my life simple I may just use two statuses...closed and active. Give the form what it is requesting to the letter. May not be precise, as that leaves out the pendings, pendingAB etc, but the whole FSBO market is not accounted for anyway when working solely with MLS data, so its far from a complete picture to start with.

The whole form can lead to conflicting results with what is actually going on, and unless the data sets are large enough, a trend cannot be determined.

And how do ya get the total number of active listings for a given time period? It literally changes every day of the period. Ridiculous. I can give ya a count for TODAY, which is what I did in my trial runs. But the count for the prior 0-3 months is different every day during that time. The whole form is flawed beyond belief.

Did they even ASK an appraiser when they drempt this thing up??

Rant over...

todd
  #8  
Old 03-15-2009, 02:12 PM
William Rightsell's Avatar
William Rightsell William Rightsell is offline
 
Join Date: Oct 2004
Location: Greensboro, NC
State: North Carolina
Professional Status: Certified Residential Appraiser
Posts: 842
Default

George et al,

Here is what my MLS stat report spits out.

I just used closd and active.

todd
Attached Files
File Type: pdf Stat Report.pdf (53.5 KB, 25 views)
  #9  
Old 03-15-2009, 02:24 PM
Mr Rex's Avatar
Mr Rex Mr Rex is offline
 
Join Date: Jan 2004
Location: X Marks the spot
State: North Carolina
Professional Status: Certified Residential Appraiser
Posts: 25,929
Default

The biggest shortfall with Tempo 5/1004MC is that Tempo doesn't have the capability to search active listings in discrete prior periods (3-6, 7-12) that the form asks for. Or am I missing something?

Of course since Tempo is a derivative of First American, I'm sure they will provide a 1004MC search capability soon. I would dare bet before the deadline.
__________________
You talking to me?
  #10  
Old 03-15-2009, 02:46 PM
William Rightsell's Avatar
William Rightsell William Rightsell is offline
 
Join Date: Oct 2004
Location: Greensboro, NC
State: North Carolina
Professional Status: Certified Residential Appraiser
Posts: 842
Default

Rex,

Actually, you can get an idea of the previous listings per time period by searching on the "list date" field. Just search for each time period. But even that is not really accurate, as there may be listings in that period which were actually listed in the prior period and still active, so the whole thing is a mess.

Gonna be fun...
Sponsored Links

Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump




Copyright © 2000-, AppraisersForum.com, All Rights Reserved
     Terms of Use  Privacy Policy
AppraisersForum.com is proudly hosted by the folks at AppraiserSites.com

Fastest Way to Find a Real Estate Appraiser Enter Zip Code:
Partner Sites:
AppraiserUSA.com - National Appraiser Directory AllDomainsUSA.com - Domain Name Registration
DeadbeatListings.com - Deadbeat ListingsAppraiserSites.com - Web Hosting for the Professional Real Estate Appraiser
Find FHA Appraisers - FHA Appraiser Search Commercial Appraisers - Commercial Appraiser Search
Relocation Appraisal - Find Relocation Appraisers Domain Reseller - Business Opportunity
Home Security Buzz - Home Security Info Radon Testing - Radon Gas Info
My Medicare Forum - Medicare Info Stop Smoking Help - Help Quitting Smoking
CordlessPhoneStore.com - Great Cordless Phones AndroidTabletCity.com - Android Tablet Computers

Follow AppraisersForum.com:          Find us on Facebook            Follow us on Twitter


All times are GMT -5. The time now is 09:25 PM.

SiteMap: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93