Brewer et al- Interest Rate Data?

[haha]

Hi

Brewer, I am getting into the CPI linked securities more. I want to get a long term look at real interest rates, at least for the post war period. Either a chart showing real rates or interest rate data that I can import and adjust with cpi data from Shiller's site.

I Googled away, but haven't found what I need.

Also, are you aware of any co-variance between real rates and S&P performance? Looking at incomplete data, it seems that the huge bull market of the 80s and 90s began with very high real rates, and continued mostly under conditions of high real rates. Since 2000, the stock market has been choppy, and real rates have been lower and at times negative. Also, periods during the 70s had low to negative real rates, and crappy stock market performance

As to TIPs, did they ever trade at 4% or above?

I'll appreciate any comments or links.*

Ha

[cute fuzzy bunny]

Feds forecast of CPI next year is 1.75-2%.

Worst talking head forecast i've seen was around 2.4%.

:P

[d]

data that I can import

a very convenient data source is "freelunch.com" (you need to register, but as the name implies ... ) though it is generally restricted to the past 25 or 30 years.

[lazyday]

Originally Posted by HaHa

As to TIPs, did they ever trade at 4% or above?

I don't have links, but I think TIPS maxed out around 4 1/4 or so (probably a little higher) and UK inflation bonds significantly higher than that.

IIRC, you can find a 4.25% coupon TIPS note on the treasury website, not sure what the highest yield on it was.

[haha]

Thanks all- these are helpfull suggestions.

Ha

[wabmester]

Originally Posted by HaHa

I want to get a long term look at real interest rates, at least for the post war period. Either a chart showing real rates or interest rate data that I can import and adjust with cpi data from Shiller's site.

Some good charts here going back about 30 years:

Martin Capital

As to TIPs, did they ever trade at 4% or above?

Only when they were first introduced, and that has been attributed to novelty and relatively low liquidity.

[brewer12345]

Hmmm, if you dig around on the Bureau of Labor Stats site you will find CPI data, since they publish it.

As for real rates, I think data will be tough to come by simply because until the introduction of TIPS, you had to calculate real rates, which usually aren't known until after the fact. So if you buy a t-bill, it includes a real rate and an inflation component. The inflation rate isn't known when you buy the note: it is expected inflation that is embedded in the nominal rate. You won't actually find out what inflation is until after the fact. So there is a significant data problem. No doubt many acadmics (and the treasury eggheads) have studied this to death. I would look at the US treasury's site and maybe search the various local Fed webstites for research.

I am happy to accpet a 3+% real rate on some bonds with modest credit risk because A) I know that I get to FIRE by my mid-40s with about 4.5% plus CPI and B) Looking at the 4% SWR, 3+% is pretty darned close. Having said that, I would liquidate the position in a hurry if it ever traded up to par.

[lazyday]

Originally Posted by wab

[on TIPS over 4%] Only when they were first introduced, and that has been attributed to novelty and relatively low liquidity.

I'm not sure, but this might not be the case for the UK bonds. Maybe someone from across the pond can comment, or surely there's data and commentary online somewhere.

Ha, another source might be Ibbotson's Stocks Bonds Bills and Inflation. Book comes out yearly I believe, but I haven't had a chance to look at one yet. (Well, maybe around 10 years ago, but I don't remember anything about it )

[wabmester]

You're right -- it doesn't look like it was a liquidity premium.

Canada introduced their real-return bond (RRB) in 1991. I only found data going back to 1996, but it hit almost 5% real in April 1996, and yielded over 4% real several times prior to 2000.

data

[brewer12345]

Originally Posted by wab

You're right -- it doesn't look like it was a liquidity premium.

Canada introduced their real-return* bond (RRB) in 1991.* *I only found data going back to 1996, but it hit almost 5% real in April 1996, and yielded over 4% real several times prior to 2000.

data

Interesting that real rates in canada are lower than for the US treasury. I suspect that the real rate depends on the requirements of the marginal buyer of gummint debt. I've no clue who it is for Canada. For the US, it is clearly foreignn central banks, many of which are already full-up with US treasuries, thank you very much.

[saluki9]

I have a fairly easy result for you.

1. Go to the federal reserve home page.
2. Use their Data Download Application (on the right side of the page)
3. Set up a data series using T-bills (data is from 1919 on)
4. This will create a XLS file with the monthly data
5. Go to www.BLS.gov and select inflation data
6. Use their Most Requested Stats tool to build a table on monthly CPI data (CPI-U)
7. Merge the data and it would seem that you have what you're looking for

[brewer12345]

8. Let us know what you think this shows you.

[saluki9]

Originally Posted by brewer12345

8. Let us know what you think this shows you.

Hey, if spending countless hours compiling seemingly endless data actually had to lead you to a profitable conclusion there would be a lot more unemployed people on Wall St.

I thought this might have just been an academic discussion

[haha]

Thanks all.

There is a lot here to look at and massage.

Ha

[lazyday]

More on TIPS & real rates

http://socialize.morningstar.com/New...eqNumber=50559

A quote from a quote from a quote of

the fixed income group head at Wellington management

,Paul Kaplan:

Yeah, but it's all during times of declining inflation. The first TIPS, the first securities came out in the U.K. in like 1980. Ever since then inflation's been going down. So suppose inflation is flat or goes up, what do I know? I don't know. That's my problem. I'm just not brave enough to try to figure out what that real yield is going to do. And I think it's important because if that real yield changes a lot it can kill you. Now, people will say, "Well, when they first came out, they were just mispriced, and the real yield was 4% and it really belongs at 2%." Uh huh, maybe. But that's my puzzle.

-I suppose one could have good sounding theories about how TIPS will behave, but until TIPS have been around a few market cycles (including inflation cycles) you can't find the holes in your theories.

-Interesting about the Tips yield dropping when inflation dropped. So, is there a theoretical explanatory guess? It's not like the disinflation was caused by economic decline, which might be expected to drive real rates down.

-The VG DH conversation linked above is pretty good, worth reading if this topic interests you. There's more quotes from Kaplan too.

[wabmester]

I agree with just about everything Swedroe said.* *You need to compare TIPS to nominal bonds.* *Both will lose value if real rates go up.* *Historically, nominal bonds have returned around 2.5% real, so if your TIPS are getting something in that range, you're getting guaranteed average returns for the life of that bond.* * For those who are looking to protect their principal, that's a good thing.

[haha]

Originally Posted by wab

I agree with just about everything Swedroe said.* *You need to compare TIPS to nominal bonds.* *Both will lose value if real rates go up.* *Historically, nominal bonds have returned around 2.5% real, so if your TIPS are getting something in that range, you're getting guaranteed average returns for the life of that bond.* * For those who are looking to protect their principal, that's a good thing.

Me too. Thanks LazyDay for linking this very interesting discussion. Kaplan was looking at what I was trying to get a handle on- how might these things behave going forward, in what many of us expect might be a less benign environment wrt inflation.

Since I at least don't want long term bonds, what are my choices in high quality fixed? Cds, Intermedidate govts or bills, and TIPs. Since Bernanke can directly influence bills, and thus to a large extent influence 2-5 year notes and bonds, I think the chances of getting a positive real return are likely better with TIPS. The TIPs owner would not ever suffer the fate of the bondholder or short duration fixed investor in the late 70s. He will get a pretax return >=CPI. And, if he buys now close to 2.5%, it will be 2.5%> CPI.

Also, if on average risk must be rewarded with higher return, then removing CPI risk as TIPs do should allow them to trade at a lower real yield than intermediate term bonds.

This may look awfully good in the not too distant future.

Ha

[wabmester]

Originally Posted by HaHa

This may look awfully good in the not too distant future.

[Queue scary music....]

[d]

Both will lose value if real rates go up

many mistakenly believe TIPS are a "sure thing" ... note the return YTD: -2% (vanguard); -2.24% (tiaa/cref).* even if holding and not liquidating, the value of*TIPS can noneless fall.* that many have been surprised by this perhaps reinforces Kaplan's point.