Correct - you don't have to use his spreadsheet as he regularly posts this info in the thread. Didn't mean to imply otherwise, since it's pretty obvious once somebody goes to the thread. I, on the other hand, actually like spreadsheets and prefer to dump the actual holdings of my funds into it, which I do once per quarter. Naturally the results are similar, but not always exactly the same since at any given point in time, funds won't necessarily hold have exactly the same bonds as its index in exactly the same proportions. Biggest issue here is that some fund companies have up to a quarter lag regarding when they report their holdings. Others have the data available daily and already downloadable in convenient spreadsheet form.Angst wrote: ↑Sat Sep 18, 2021 11:28 amYes, really anyone comparing TIPS funds, or comparing them to nominal bond funds in terms of YTM, is almost obligated to consider #Cruncher's thread, and you don't need to actually use his spreadsheets. From its first post, note the following funds associations with their respective indexes:dcabler wrote: ↑Sat Sep 18, 2021 4:56 am This is why I follow #cruncher's thread where he regularly calculates real yield and duration of the major TIPs indexes that funds track. Nice spreadsheet that, if you're into spreadsheets, is easy to modify to allow you to dump the actual current holdings of your favorite fund into it.
viewtopic.php?f=10&t=104845&start=100
cheers.
Also Note: Although Vanguard's VAIPX TIPS fund is not technically an index fund, it's reasonable to use the "1+ Years" index for comparison purposes.#Cruncher wrote: ↑Fri Oct 26, 2012 8:53 pm[Snip]...
The three main statistics to help in making this decision are, in my opinion, average Real Yield-to-Maturity (YTM), average Real Duration, and Expense Ratio. Unfortunately TIPS funds don't always calculate the first two or do so inconsistently.
[Snip]...
Here are the TIPS ETFs I'm aware of that fit into these four maturity categories. Since they are index funds all of the ones in the same category will have pretty much the same average real YTM and duration as shown in the table above.
0 - 5 Years: iShares STIP, Vanguard VTIP (2)
1 - 5 Years: PIMCO STPZ
1+ Years: SPDR IPE, Schwab SCHP, iShares TIP, PIMCO TIPZ
15+ Years: PIMCO LTPZ
To find #Cruncher's latest YTM and Duration calculations for these different indexes (for their associated funds), you need to navigate to the latest page and latest post within the thread. The most recent post I see that #Cruncher has done is dated June 30, 2021, including a few edits within it as recently as yesterday, 9/17: https://www.bogleheads.org/forum/viewtopic.php?p=6094640#p6094640
Within that post you'll find the all-important YTM and Duration numbers, which I believe are current thru 6-30-2021:
Code: Select all
# Real Avg - Real Duration - - Fall if Rates Rise - TIPS YTM Life Macaulay Modified 1% 2% 3% Index ---- ----- ---- -------- -------- ----- ----- ----- ------------ 19 (2.40%) 2.83 2.81 2.84% 2.78% 5.45% 8.02% 0 - 5 Years 16 (2.23%) 3.13 3.10 3.13% 3.07% 6.01% 8.84% 1 - 5 Years 31 (1.77%) 5.01 4.89 4.93% 4.77% 9.24% 13.43% 1 - 10 Years 44 (1.47%) 8.70 8.18 8.21% 7.62% 14.22% 19.97% 1+ Years 12 (0.28%) 23.30 21.18 21.20% 18.90% 33.89% 45.80% 15+ Years
Besides, some day #cruncher may choose to no longer provide this service and there may be no other BH'er willing to pick it up. Of course the right answer is for the fund companies to give this info directly or for the indexes to provide it easily.