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]
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: http://www2.standardandpoors.com/portal/site/sp/en/us/page.topic/indices_csmahp/0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0.html Anyway, I found some interesting things: 1) It looks like the year-over-year percentage decline in NYC and the Comp-20 are bottoming out. The NYC and Comp-20 reached negative territory around March 2007. However, there has yet to be an uptick in the year-over-year analysis. In the month-to-month analysis, the NYC market has been on the up-slope since spring 2008, but that may be accounted for by the spring buying season. 2) Even though the rate of percentage of decline is bottoming out, we are still in negative territory with about 8% year over year decline for NYC and 15% for Comp-20. 3) Historically, the only other time that the NYC market was in negative territory, for which Case-Shiller data is available, was between March 1989 and February 1992. During that period, the bottom in percentage decline occurred around around April 1991. 4) However, between Feb 1992 and June 1997, the NYC market grew at an anemic year-over-year increase of between 1-4%. 5) The Miami and Las Vegas markets still appear to be accelerating to the downside. [less]
The crisis is over, everyone back to work.
Don't forget that the Case Shiller Index does NOT include apartments.
also does not include coops .. just single family homes.
hence, largely irrelevant for manhattan.
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.
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.
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...
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.
I'm not trying to insult the guy, but I'm thinking he's not a banker. Might be like a technology guy...
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.
> 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?
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
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...
"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.
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.
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.
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.
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.
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.
Well said, newbuyer