Skip Navigation

Case-Shiller % change analysis

Started by haterhater
over 18 years ago
Posts: 16
Member since: Aug 2008
Discussion about
I just downloaded the Case-Shiller data including the latest May 2008 numbers and charted the year-over-year and month-to-month percentage changes for all 20 metro areas plus composite indices in an Excel spreadsheet. You actually have to calculate the % change yourself, but it's not too difficult using simple formulas in Excel. For you data mavens out there, you can download the data at: ... [more]
Response by dco
over 18 years ago
Posts: 1319
Member since: Mar 2008

The crisis is over, everyone back to work.

Ignored comment. Unhide
Response by alpine292
over 18 years ago
Posts: 2771
Member since: Jun 2008

Don't forget that the Case Shiller Index does NOT include apartments.

Ignored comment. Unhide
Response by eric_cartman
over 18 years ago
Posts: 300
Member since: Jun 2007

also does not include coops .. just single family homes.
hence, largely irrelevant for manhattan.

Ignored comment. Unhide
Response by dco
over 18 years ago
Posts: 1319
Member since: Mar 2008

The only certainty, is that national home prices, are still falling. This will in turn cause more write downs, by the banks, and further sicken the consumer. Just the beginning.

Ignored comment. Unhide
Response by LBKL
over 18 years ago
Posts: 10
Member since: Aug 2008

I remember 2003, it was after the tech bubble that created serious malaise on Wall Street, then in 2003 we went to War in Iraq, we had the Wall Street scandals including the illegal mutual fund market timing, really horrible environment on Wall Street, the U.S. economy, and the world stage, and both the real estate market in NYC and the stock market just took off.

Ignored comment. Unhide
Response by EddieWilson
over 18 years ago
Posts: 1112
Member since: Feb 2008

Right... because Greenspan's "fix" to the issues in 2003 was to build the most lax credit market of all time, leading to the bubble which has nowpopped. Easy credit is now over, replaced by supertight credit, which is not only killing RE but the general economy as well. The forces that pushed up RE are now gone...

Ignored comment. Unhide
Response by faustus
over 18 years ago
Posts: 230
Member since: Nov 2007

LBKL - do you really work at Lehman? What do you do there? How long have you worked there? I ask because I find it hard to believe that someone employed on Wall Street doesn't seem to understand the financial dynamics underlying the real estate market boom from 2001-2007.

Ignored comment. Unhide
Response by EddieWilson
over 18 years ago
Posts: 1112
Member since: Feb 2008

I'm not trying to insult the guy, but I'm thinking he's not a banker. Might be like a technology guy...

Ignored comment. Unhide
Response by haterhater
over 18 years ago
Posts: 16
Member since: Aug 2008

Good point about Case-Shiller not including condos and new construction, so not entirely relevant for Manhattan condo market. Still Case-Shiller is the most comprehensive and reliable data available for the overall US metropolitan market, and to a large extent Manhattan is going to follow the larger market. I was interested primarily in charting the historical trend of NYC real estate to compare the bottoms of the current cycle with that of the late 80's-early 90's, and Case-Shiller, despite excluding the Manhattan condo market, does seem to reflect the "street-level" reality of the bottom from that period, at least by my memory. Interestingly, the late 80's-early 90's was also one of the only periods that the NYC real estate market significantly lagged the Comp-10. Those were some dark times in NYC, and I'm not talking about real-estate.

Out of curiosity, I did look for an index that does include condos and found some data provided by Radar Logic. They even have a separate index for Manhattan condos, downloadable here:

http://analytics.radarlogic.com/radar-logic-home/historical-data.aspx

Like Case-Shiller, this data is also flawed. For example, it doesn't provide data prior to 2000. It also charts much more erratically with some extreme outliers. It also uses $psf for data points. I haven't really thought it through but I'm sure there are plenty of problems with that method. Is there a reliable way to get $psf data on sales? Does that include/exclude outdoor space?

There are some consistencies between Case-Shiller and Radarlogic. For example, the composite and the NYC (overall) market are down 16% and 7% year-over-year, respectively, compared to 15% and 8% according to Case-Shiller. When you look at the trends, there is no clear bottom for any Radarlogic index. It just looks bad as far as the eye can see. Interestingly, the Manhattan condo index didn't go negative until June 6, and then it has only been down by 1-2% year over year. The trend is clearly downwards, but there is so much volatility with the Radarlogic data that it could just as easily pop back up in a week or two. So I don't know what to draw from this data.

Anyone else know of a database that provides sales-pair data including condos? It seems like such an obvious thing to track.

Ignored comment. Unhide
Response by EddieWilson
over 18 years ago
Posts: 1112
Member since: Feb 2008

> the composite and the NYC (overall) market are down 16% and 7% year-over-year, respectively

So, radar logic includes condos... but what is the area it covers?
Where is the 7% decline defined over?

Ignored comment. Unhide
Response by dco
over 18 years ago
Posts: 1319
Member since: Mar 2008

I still can't believe that people are still trying to compare this credit crisis to other events in our financial history. It's nothing like we have ever seen before. This is nothing like the TECH bubble. Guys every economic indicator is at it's worst levels since the Great Depression. How in the world is this the same as some bubble in 2000. This is far worse then the 70's. The only reason the inflation numbers are not higher is because over the year various administration have changed the way they calculate these numbers.

Go to the supermarket and fill the cart and then compare it to prices 12 months ago. Then tell me that inflation is still below 5%. Most people have no idea, how the gov't, has manipulated calculations of these numbers. I'll give you an example. If milk was $2.50 a gallon last year and now it's $5 that would indicate that inflation on milk rose 100%. The game works like this. The gov't says, that if the price of milk increases to a point that is to high for the consumer, he/she will choice an alternative to milk. So instead of you buying milk, you the consumer, will adjust your spending and buy say soda. Now in stead of factoring the milk at 100% inflation, they just replace it with a "suitable alternative" that best works for their figures. Actual inflation is in the ball park of over 11%. Has anyone ever wondered why, it cost 100% more for something a year later, when the gov't is telling you that inflation is up fractionally. It's a fallacy

Ignored comment. Unhide
Response by Special_K
over 18 years ago
Posts: 638
Member since: Aug 2008

dco - well said. another major issue with the CPI is that "owner equivalent rents (OER)" comprise about a quarter (24%) of the metric. the fed goes around and asks people what they think they could rent their home out for. surprise, surprise - in a down market they start saying "not much more than before" and then it looks like OER inflation is modest. In fact, OER been flat for most of this year, which leads to an understatement of inflation as measured by the CPI.

and don't even get me started on how the birth-death model leads to a ridiculous overstatement of job growth across the country.

"It also uses $psf for data points. I haven't really thought it through but I'm sure there are plenty of problems with that method. Is there a reliable way to get $psf data on sales? Does that include/exclude outdoor space?"

another site that offers good data is www.millersamuel.com. interestingly enough, radar logic was going to merge with miller but for whatever reason, they called off the merger. miller samuel data goes back a ways and price/sq foot is sortable by area within manhattan and viewable by apartment type (e.g., 1 BD vs 2BD)

however, there are plenty of problems even with miller data. while it tracks both condo and coop prices, perhaps the greatest issue is that they simply take a mean/median for all deals during a time period. they don't do an apples-to-apples comparison over time for the same house the way case schiller does. in addition, they don't take out outliers in mean calculations. also, no one has a clue as to whether or not they take all apartments/transactions into account in their figures. and finally, they don't adjust for mix. for example, they don't exclude new units from their measurement (new construction has typically been a more expensive per square foot product than existing inventory)- this exaggerates price increases in booming times with lots of new construction while similarly exaggerates price declines in down periods.

finally, one of miller samuels largest corporate customers is douglas elliman and i believe the owners of miller samuel have been long involved in nyc real estate as both appraisers and owners. so obviously they are highly incentivized to show positive price data for nyc. bottom line, take it with a grain of salt...

Ignored comment. Unhide
Response by bjw2103
over 18 years ago
Posts: 6236
Member since: Jul 2007

"Has anyone ever wondered why, it cost 100% more for something a year later, when the gov't is telling you that inflation is up fractionally. It's a fallacy"

dco, apologies if I'm misconstruing what you're saying here, but inflation is measured from the CPI, so looking at a few individual items isn't going to tell you the whole story. And as you likely know, using the CPI invites a ton of issues - what exactly do you throw in that basket, how do you account for other variables (ie: geography, taxes, etc.)? There are other indices that attempt to mitigate these biases, but the CPI is what's generally used when measuring inflation, warts and all.

Ignored comment. Unhide
Response by dco
over 18 years ago
Posts: 1319
Member since: Mar 2008

bjw2103- I get what you are saying. By no means did my example, set out to explain, the whole system. It was meant to highlight how the gov't manipulates numbers, to bolster their economic agenda's. I was trying to point out that, when they release these numbers, it's not the full truth. If you shop for yourself you may find it harder to recognize. However, ask any "soccer" mom, and she could tell you, that she is paying a lot more then 5% over last year. It's ridiculous to think that people will stop buying milk and replace it with soda.

Once you realize how these numbers are manipulated, you start to get the picture of how bad the situation really is and how hard it will be to recover anytime soon.

Ignored comment. Unhide
Response by haterhater
over 18 years ago
Posts: 16
Member since: Aug 2008

dco - I wasn't comparing the current credit crisis to the tech bubble; I was comparing it to the Savings and Loan crisis. The reasons for the fall of Bear Stearns are not unlike the reasons for the fall of Drexel Burnham. Granted the world markets are more integrated today, and there are different players, but the sequence of events bear remarkable similarities. Read Liar's Poker or Den of Thieves if you don't know what I'm talking about.

Ignored comment. Unhide
Response by dco
over 18 years ago
Posts: 1319
Member since: Mar 2008

haterhater- No biggie. My point is you can point to any other financial crisis since the great depression and I see no similarities as a whole. This is nothing like we have ever seen. So when people say that wr're in the recovery phase, I just find it mind blowing.

Ignored comment. Unhide
Response by newbuyer99
over 18 years ago
Posts: 1231
Member since: Jul 2008

Look at any crisis, and there is usually a (long) phase when people underestimate the severity/length of it, call false bottoms, proclaim starts of a recovery, etc. As the crisis continues or gets worse, those voices get fewer and fewer. When they disappear and it starts to feel like the crisis/downturn will go on forever, that's when the recovery usually begins. Of course, this is the direct mirror image of the dynamics of a boom - it usually ends just when people start to think it will last forever.

And yes, the above is a gross generalization, but interesting nonetheless.

It's also the reason for Buffett's famous quote, i.e. be greedy when others are fearful and fearful when others are greedy.

Ignored comment. Unhide
Response by newbuyer99
over 18 years ago
Posts: 1231
Member since: Jul 2008

Look at any crisis, and there is usually a (long) phase when people underestimate the severity/length of it, call false bottoms, proclaim starts of a recovery, etc. As the crisis continues or gets worse, those voices get fewer and fewer. When they disappear and it starts to feel like the crisis/downturn will go on forever, that's when the recovery usually begins. Of course, this is the direct mirror image of the dynamics of a boom - it usually ends just when people start to think it will last forever.

And yes, the above is a gross generalization, but interesting nonetheless.

It's also the reason for Buffett's famous quote, i.e. be greedy when others are fearful and fearful when others are greedy.

Ignored comment. Unhide
Response by EddieWilson
over 18 years ago
Posts: 1112
Member since: Feb 2008

Well said, newbuyer

Ignored comment. Unhide

Add Your Comment