Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Overlapping Mutual Funds
Old 06-05-2007, 01:07 PM   #1
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
Overlapping Mutual Funds

The other day I was trying to figure out how much VTSMX overlapped with NAESX. Any good tools for that purpose without getting into commercial software?
__________________

__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.

As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
Rich_by_the_Bay is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 06-05-2007, 02:40 PM   #2
Recycles dryer sheets
 
Join Date: Dec 2004
Posts: 273
Doesn't Morningstar X-ray provide that info?
__________________

__________________
time flies like an arrow, fruit flies like a banana
larry is offline   Reply With Quote
Old 06-05-2007, 02:56 PM   #3
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
Quote:
Originally Posted by larry View Post
Doesn't Morningstar X-ray provide that info?
Not that I can see, though it may be available with a "Premium Membership" package.
__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.

As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
Rich_by_the_Bay is offline   Reply With Quote
Old 06-05-2007, 02:59 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Jun 2005
Posts: 8,619
Rich, the premium M* tools are available FREE at www.troweprice.com as long as you register for free. You do not need to be a TRP customer. Then you can easily see fund overlap.
__________________
LOL! is offline   Reply With Quote
Old 06-05-2007, 03:07 PM   #5
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
travelover's Avatar
 
Join Date: Mar 2007
Posts: 9,889
Morningstar premium is also available through my library, for use at home - you might want to check your library's website. And yes, the X-ray does show holdings overlap as a sub-feature.
__________________
Yes, I have achieved work / life balance.
travelover is online now   Reply With Quote
Old 06-05-2007, 03:55 PM   #6
Moderator Emeritus
Nords's Avatar
 
Join Date: Dec 2002
Location: Oahu
Posts: 26,617
Quote:
Originally Posted by LOL! View Post
Rich, the premium M* tools are available FREE at www.troweprice.com as long as you register for free. You do not need to be a TRP customer. Then you can easily see fund overlap.
Hot dog, finally a good reason that our kid has her Roth IRA with them. Thanks, LOL!

I've been wondering how much our S&P600 small-cap ETF overlaps our other investments, and I've been particularly interested in how much our Dow Dividends ETF (DVY) overlaps the S&P500.

Even if they don't overlap that much I think it's time I considered correlations (R2).
__________________
*
*

The book written on E-R.org, "The Military Guide to Financial Independence and Retirement", on sale now! For more info see "About Me" in my profile.
I don't spend much time here anymore, so please send me a PM. Thanks.
Nords is offline   Reply With Quote
Old 06-05-2007, 05:15 PM   #7
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
Quote:
Originally Posted by LOL! View Post
Rich, the premium M* tools are available FREE at www.troweprice.com as long as you register for free. You do not need to be a TRP customer. Then you can easily see fund overlap.
Thanks - I did look there and confirmed that I can get in. Wasn't able to find an overlap tool, though. I'll look more later but if anyone knows where to find it, I'd appreciate it.
__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.

As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
Rich_by_the_Bay is offline   Reply With Quote
Old 06-05-2007, 05:34 PM   #8
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Jun 2005
Posts: 8,619
Click on "Use Morningstar tools", "portfolio manager", enter a portfolio, then "portfolio x-ray" (i.e. NOT instant X-ray), then either "x-ray details" (and "stock style") or "stock intersection"
__________________
LOL! is offline   Reply With Quote
Old 06-05-2007, 06:08 PM   #9
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Jul 2005
Posts: 5,412
most of the morningstar info is outdated and sometimes months old.

as an example magellan had its entire porfolio revamped in a matter of weeks and morningstar was still 2 months behind. thats why i subscribe to a newsletter where the staff meets daily with fidelity managers to keep tabs on major changes . their model portfolios are very well layed out so as not to overlap.
__________________
mathjak107 is offline   Reply With Quote
Old 06-05-2007, 07:15 PM   #10
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
Quote:
Originally Posted by LOL! View Post
Click on "Use Morningstar tools", "portfolio manager", enter a portfolio, then "portfolio x-ray" (i.e. NOT instant X-ray), then either "x-ray details" (and "stock style") or "stock intersection"
OK, I found and generated a stock intersection report. Thanks for the guidance.
It really confused me at first because I expected some overlap of VTSMX and NAESX but there was none, so the report seemed goofy. Then I ran it with VTSMX and VFINX and duplicates showed up all over the place.

Mission accomplished. I was trying to decide between [VTSMX + NAESX] or [VFINX + VEXMX], thinking the latter would have similar performance with less overlap. Not so - no overlap either pair.
__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.

As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
Rich_by_the_Bay is offline   Reply With Quote
Old 06-06-2007, 03:41 PM   #11
Full time employment: Posting here.
 
Join Date: Oct 2003
Posts: 961
Rich,

I double checked your results with the 3/31/07 portfolio holdings of VTSMX vs. NAESX from Vanguard's website. [VFINX + VEXMX should have no overlap b/c VEXMX's index is the completion index to the S&P 500 index.]

VTSMX [3,673 stocks] + NAESX [1,708 stocks] hold 1,702 of the same stocks. These 1,702 stocks account for roughly 12% of the assets of VTSMX and 99% of the assets of NAESX. I think we can say that there is significant overlap b/w the two.

I think the M* overlap tool showed virtually no overlap because the largest holdings in VTSMX account for a large amount of the fund's assets, while the largest holdings in NAESX account for only a small amount of the fund's assets.

Personally, I think that if you're trying to have a small tilt to your portfolio, the most efficient way to do so is to start with VTSMX and then tilt with either NAESX or VISVX.

- Alec
__________________
ats5g is offline   Reply With Quote
Old 06-06-2007, 03:51 PM   #12
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
Quote:
Originally Posted by ats5g View Post
Personally, I think that if you're trying to have a small tilt to your portfolio, the most efficient way to do so is to start with VTSMX and then tilt with either NAESX or VISVX.
Thanks, Alec. The M* analysis is very deceptive in that case. Yes, I want VTSMX exposure with just a small tilt. I skipped VISVX because I wanted to be value/growth neutral.

Can you tell me where in the Vgd web site you were able to get these overlap analyses?
__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.

As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
Rich_by_the_Bay is offline   Reply With Quote
Old 06-06-2007, 07:33 PM   #13
Full time employment: Posting here.
 
Join Date: Oct 2003
Posts: 961
Rich,

Unfortunately, Vanguard's site doesn't have the overlap function you're looking for. So, I just copied and pasted the all the holdings of VTSMX and NAESX into Excel, and then did some "vlookup" functions. Only took 1/2 hour of cuting and pasting.

Here's the spreadsheet if you're interested: VTSMXvNAESX.xls

fyi - if this is for a taxable account you should be aware that not all the dividends from NAESX will be "qualified dividends." See Qualified dividend income—2006 year-end figures and
Qualified dividend income—2007 year-to-date estimates.
However, all the dividends from the Tax Managed Small Cap fund are qualified. IIRC, most small cap indices [S&P, Russell, MSCI, etc], on which most ETF's are based, now include REITS, so some of their dividends will be non-qualified. Somehow, even though Vanguard's Tax Managed funds include REITs, all their dividends that are distributed are qualified.

- Alec
__________________
ats5g is offline   Reply With Quote
Old 06-06-2007, 08:31 PM   #14
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
Thanks - I looked over the big spreadsheet. So even NAESX has an 11% overlap with VTSMX. Why not just go with VFINX and NAESX then, and be certain of no overlap? True you aren't quite as diversivied as VTSMX but at least you are cleanly diviided.

My goal is VTSMX with a gentle small tilt. I hope to stay neutral on value and growth.
__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.

As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
Rich_by_the_Bay is offline   Reply With Quote
Old 06-07-2007, 11:46 AM   #15
Full time employment: Posting here.
 
Join Date: Oct 2003
Posts: 961
Quote:
Originally Posted by Rich_in_Tampa View Post
Thanks - I looked over the big spreadsheet. So even NAESX has an 11% overlap with VTSMX. Why not just go with VFINX and NAESX then, and be certain of no overlap? True you aren't quite as diversivied as VTSMX but at least you are cleanly diviided.
Rich,

Don't get caught in any paralysis of analysis here. Overlap isn't necessarily bad in this case. If you were using both VFINX + VTSMX, then that'd be kinda stupid overlap.

Quote:
My goal is VTSMX with a gentle small tilt. I hope to stay neutral on value and growth.
If that is your goal, then just use VTSMX and tilt with either a small cap index fund/etf or a micro cap fund/etf [your choice]. While the S&P 500 index funds are IMO great funds, personally I'd rather be totally passive, and not have to deal with the S&P Committee choosing those 500 stocks for me. Also, I would want to hold the 250-350 mid cap stocks that wouldn't be in the VFINX + NAESX portfolio.

btw - I do the small/value tilt w/ VTSMX, but b/c I only have access to VFINX + a VEXMX clone, I've to to use both to create a total stock market fund with a small value tilt [w/ VISVX].

- Alec
__________________
ats5g is offline   Reply With Quote
Old 06-07-2007, 12:33 PM   #16
Thinks s/he gets paid by the post
 
Join Date: Nov 2006
Posts: 2,268
Im glad someone corrected the mistake because I was sitting here thinking I was an idiot. How can the "total stock market index" fund..NOT have overlap with other funds.
__________________
utrecht is offline   Reply With Quote
Old 06-07-2007, 01:54 PM   #17
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
Quote:
Originally Posted by ats5g View Post
Rich,
If that is your goal, then just use VTSMX and tilt with either a small cap index fund/etf or a micro cap fund/etf [your choice].
Well, that completes the circle since that's exactly what I was doing, albeit without fully understanding the overlap issue. Your recommendations and perspective make good sense to me.
__________________

__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.

As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
Rich_by_the_Bay is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
My 401k's expense ratios, Bogle, lowest-cost quartile data for stock funds? Dude FIRE and Money 19 02-07-2007 02:17 PM
Please help - question on Mutual Funds ADJ Young Dreamers 2 01-27-2007 09:58 AM
Canadian Mutual Funds nwsteve FIRE and Money 0 09-26-2006 04:07 PM
Stocks or Mutual Funds renferme FIRE and Money 7 03-01-2006 07:14 PM
M* discovers that ETFs are more tax efficient than mutual funds Nords FIRE and Money 4 02-15-2006 07:14 PM

 

 
All times are GMT -6. The time now is 12:45 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.