 |
Yahoo fund chart built-in distortion
12-17-2007, 09:42 PM
|
#1
|
Full time employment: Posting here.
Join Date: Apr 2007
Posts: 871
|
Yahoo fund chart built-in distortion
On 12/6/2007 my Matthews Pacific Tiger Fund MAPTX gave out a really large distribution. This made the price of the fund go down by nearly 10% but the total dollar amount of my holdings actually went up a little that day.
When I look at the Yahoo one year chart (new format) it just shows this as if it took a big nose dive.
I would think that the chart should somehow reflect that this is really not a drop. Perhaps it should recalculate all the past data points and adjust them to a common scale that accounts for the distribution. I think they would do this if the stock split.
Has anyone else noticed this? Does anyone have any thoughts?
|
|
|
 |
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!
|
12-17-2007, 10:15 PM
|
#2
|
Recycles dryer sheets
Join Date: Aug 2005
Posts: 191
|
Quote:
Originally Posted by joesxm
On 12/6/2007 my Matthews Pacific Tiger Fund MAPTX gave out a really large distribution. This made the price of the fund go down by nearly 10% but the total dollar amount of my holdings actually went up a little that day.
When I look at the Yahoo one year chart (new format) it just shows this as if it took a big nose dive....
|
I have observed and been caught off guard by the same thing, though with a different fund. The share price chart still serves a purpose, though.
__________________
Retired in 2001 at age 49.
|
|
|
12-17-2007, 10:52 PM
|
#3
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Sep 2005
Location: Northern IL
Posts: 25,686
|
This is a major (not a pet) peeve of mine. I have yet to find a (free) charting service that INCLUDES dividends. You can do 'compare', and when you compare a high dividend bond fund to a no dividend stock or lower dividend bond fund, it is meaningless. The bond fund can look like it is flat-lined, even though it may be returning more than the stock....
Yahoo 'historical prices' has an 'adjusted' column that does this, but you need to import to a spreadsheet to graph it. So the concept is there, just not a good implementation.
I have posted the question to a few forums, looking for a site that includes dividends, and never got a good answer.
-ERD50
|
|
|
12-17-2007, 11:07 PM
|
#4
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2003
Location: Losing my whump
Posts: 22,702
|
Depends on what sort of chart you ask for.
A 'price chart' can be misleading as to what total return looks like, but its sort of handy for looking at a fund long term to see if a principal-only holding will stand up to inflation.
A chart of price+distributions will show better for what you're looking for. For someone who isnt planning on taking anything from the fund, a "return of $xx,xxx dollars" showing price, distributions and compound earnings on the distributions over time can be interesting.
When evaluating investments, I look at both a price-only chart and the "return" chart. Both may tell very different stories...
__________________
Be fearful when others are greedy, and greedy when others are fearful. Just another form of "buy low, sell high" for those who have trouble with things. This rule is not universal. Do not buy a 1973 Pinto because everyone else is afraid of it.
|
|
|
12-17-2007, 11:25 PM
|
#5
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2005
Location: Chicago
Posts: 12,625
|
Vanguard International Growth (VWIGX) dropped over 12% today. Could that also be because they made a distribution?
Edit: Never mind. Just went to the Vanguard site. ST, LT and Divs all reinvested today.
__________________
"I wasn't born blue blood. I was born blue-collar." John Wort Hannam
|
|
|
12-17-2007, 11:52 PM
|
#6
|
Recycles dryer sheets
Join Date: Jul 2007
Posts: 55
|
Wow, I have been upset about this exact thing for a while too. Seriously, charting mutual funds where this isn't taken into effect is ridiculous. Anyone know a site pay or not that will show price plus distribution charts?
__________________
"Been dreaming of ER since I was 16"
|
|
|
12-18-2007, 10:58 AM
|
#7
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 34,072
|
Gosh, I guess you get what you pay for from the "free" charting services!
Actually, the Morningstar charts are corrected for distributions over time, but this doesn't happen immediately and you can't see day-to-day detail.
Audrey
|
|
|
12-18-2007, 09:26 PM
|
#8
|
Thinks s/he gets paid by the post
Join Date: Jul 2005
Posts: 4,362
|
Try this site:
PerfChart - StockCharts.com
It takes them a while to adjust for recent distributions, but it has looked good for all the fund distributions I have checked it on. It's more flexible than Morningstar.
Just goes to show how backwards the whole retail market is. Stupid price-only charts and the most followed index is the Dow.
Dan
|
|
|
12-18-2007, 10:10 PM
|
#9
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Sep 2005
Location: Northern IL
Posts: 25,686
|
Quote:
Originally Posted by Animorph
|
Thanks for trying, but it does not seem to do it for the Vanguard & Fidelity bond funds I tried.
SPHIX - fidelity 'junk' fund - yahoo says YTD return (to Nov 30) is 1.7%. When I look at the daily 'adjusted' price history, I get $8.49 on 12/29/2006 and $8.64 on 11/30/2007 - so that matches (1.76%).
SPHIX: Summary for FIDELITY HIGH INCOME FUND - Yahoo! Finance
But stockcharts.com says it is down about 5% YTD, the differences are the dividends.
Sorry - no cigar. I agree with you - this stuff is really backwards.
-ERD50
PS - these divs are paid monthly, so it should catch most of them
|
|
|
12-19-2007, 10:44 AM
|
#10
|
Thinks s/he gets paid by the post
Join Date: Jul 2005
Posts: 4,362
|
ERD50:
Yup, looks like it missed that one completely. I have confirmed correct total returns with most of the funds I have, some with very large distributions, but it's only a limited sample. Earlier historical data would be nice too. stockcharts.com only goes back about 8 years. Morningstar is even worse.
I tried plotting Yahoo adjusted price data in Excel until I had a problem where the adjusted price included only dividends and not capital gains. So I don't think that data can be blindly trusted either. Otherwise that would be the best solution I know.
I haven't double checked the Morningstar data, but surely they would get it right?
Dan
|
|
|
12-19-2007, 11:33 AM
|
#11
|
Thinks s/he gets paid by the post
Join Date: Jul 2005
Posts: 4,362
|
I double checked some data on Yahoo and stockcharts.com for FISMX one of my funds that declared a big capital gains distribution last on 12/8/06 (last year, and this year as well).
The Yahoo data
Date Open High Low Close Volume Adj Close*
8-Dec-06 24.36 24.36 24.36 24.36 0 24.36
8-Dec-06 $ 5.74 Dividend
7-Dec-06 30.30 30.30 30.30 30.30 0 24.56
6-Dec-06 30.22 30.22 30.22 30.22 0 24.50
That agrees with the fund distribution on the Fidelity website, other than the technicality that the distribution was $5.675 LT cap gains and $0.065 dividends. So plotting the Yahoo adjusted price looks good.
StockCharts.com plots FISMX as 20.1 on 12/7/06 and 19.94 on 12/8/06, pretty close to the same small daily drop reported on Yahoo, though with a different absolute adjusted price. So they both have good total return data in this one case.
Here's the Yahoo data for the same period this year ($5.176 LT cap gains and $0.12 dividends on 12/7/07):
Date Open High Low Close Volume Adj Close*
10-Dec-07 23.98 23.98 23.98 23.98 0 23.98
7-Dec-07 23.88 23.88 23.88 23.88 0 23.88
6-Dec-07 29.17 29.17 29.17 29.17 0 29.17
5-Dec-07 28.88 28.88 28.88 28.88 0 28.88
Yahoo hasn't been updated for the 12/7/07 distribution yet. Strangely enough (they are usually slower), StockCharts has adjusted prices of 23.87 for 12/6/07 and 23.88 for 12/7/07. So for 2007, they have the correct total return and Yahoo doesn't. That explains the difference in adjusted prices for 2006 too.
So, I wouldn't trust any of these places blindly, but either one should be pretty good most of the time.
The Fidelity website has (I haven't looked recently) a way to get a total returns chart that can compare 5 funds for 3 years I think. With Morningstar data if I remember correctly.
Dan
|
|
|
12-19-2007, 01:18 PM
|
#12
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2006
Location: Rio Grande Valley
Posts: 34,072
|
I don't think the Fidelity bond funds adjust the NAV when they pay out the dividends - many bond funds do not. But a few do - DODIX for example.
This just makes the charts more complicated.
Audrey
|
|
|
 |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
Search this Thread |
|
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|