 |
08-01-2007, 08:24 PM
|
#1
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2003
Location: Losing my whump
Posts: 22,697
|
Lazy bottom feeding
So I'm thinking with all this carnage and volatility going on, it might be a bit of fun to start watching some of the vanguard funds for better valuations.
Basically what I'd love to do is chart all (or many) of the vanguard funds past 30-60 day performance to see which ones are really getting clipped.
The vanguard sites not helping me...they like to show 'value of money invested' rather than price changes in their charts. Which look way better, but arent helping me.
Seems all the fund screeners I looked at have "year to date" as finest and most recent granularity. Also not particularly helpful.
Anyone know of a real flexible screener where I could say "gimme all the vanguard fund family xx days total return below zero" or something similar?
__________________
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.
|
|
|
 |
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!
|
08-01-2007, 08:32 PM
|
#2
|
Full time employment: Posting here.
Join Date: Jun 2007
Posts: 567
|
Do you have a list of all Vanguard tickers?
|
|
|
08-01-2007, 08:43 PM
|
#3
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2003
Location: Losing my whump
Posts: 22,697
|
No, but I could make one easily enough.
__________________
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.
|
|
|
08-01-2007, 08:55 PM
|
#4
|
Full time employment: Posting here.
Join Date: Jun 2007
Posts: 567
|
I'm kind of wondering if Google's spiffy charts could handle it.
|
|
|
08-01-2007, 09:04 PM
|
#5
|
Recycles dryer sheets
Join Date: Jul 2005
Posts: 423
|
If you type multiple tickers into Bigcharts.com and pick a timespan, it defaults to showing %ages instead of prices.
For instance:
BigCharts - Printer-Friendly Format
That is small cap index, reit index, total market index over 2 months. Maybe that helps? It isn't really an automated screener, but easy to eyeball different periods of time.
|
|
|
08-01-2007, 09:05 PM
|
#6
|
Full time employment: Posting here.
Join Date: Apr 2006
Posts: 891
|
Spread 'em.
How about just the spread?
Dirty data mining market timer!
Going by the spread, you'd be buying REIT, Emer. Mkts., etc. Blah.
-CC
__________________
"There's those thinkin' more or less, less is more, but if less is more, how you keepin' score?
It means for every point you make, your level drops. Kinda like you're startin' from the top..." "Society" - Eddie Vedder
|
|
|
08-01-2007, 09:41 PM
|
#7
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2003
Location: Losing my whump
Posts: 22,697
|
Guilty as charged. I'm a bargain shopper. Gotta be some bargains coming up. REITS are still overpriced and so are emerging markets. I'm looking for stuff that'll be breaking the 200 day MA and then its 52 week lows...and then some.
Huh, I looked at bigcharts and it wasnt immediately obvious that I could do multiple tickers concurrently, but thats actually exactly what I want...chart of percent drop so I can further investigate funds without parachutes. Any idea how many tickers it'll take all at once? I'll probably be watching this daily for a few months.
I saw that vanguard data but I'd have to write a little macro to parse it quickly...i'm too frickin lazy to read all that stuff
__________________
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.
|
|
|
08-02-2007, 02:02 AM
|
#8
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Feb 2007
Posts: 5,072
|
Quote:
Originally Posted by cute fuzzy bunny
So I'm thinking with all this carnage and volatility going on, it might be a bit of fun to start watching some of the vanguard funds for better valuations.
Basically what I'd love to do is chart all (or many) of the vanguard funds past 30-60 day performance to see which ones are really getting clipped.
The vanguard sites not helping me...they like to show 'value of money invested' rather than price changes in their charts. Which look way better, but arent helping me.
Seems all the fund screeners I looked at have "year to date" as finest and most recent granularity. Also not particularly helpful.
Anyone know of a real flexible screener where I could say "gimme all the vanguard fund family xx days total return below zero" or something similar?
|
Spreadsheet!
|
|
|
08-02-2007, 04:57 AM
|
#9
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2005
Posts: 10,234
|
Use the MSN deluxe fund screener and the MSN deluxe stock screener. You can also use the MSN deluxe charting tool which has granularity down to real-time intraday.
It is pretty trivial to find Vanguard stuff that has dropped: just look in my portfolio. OTOH, I think what I would do is just look at various index ETFs as a proxy for the corresponding asset classes. Since Vanguard has ETF share classes of many of its index funds, the whole exercise becomes even more trivial.
Some asset classes that are down quite are bit are REITs (VNQ), financials (VFH), small cap value (VBR).
Vanguard ETFs by asset type
|
|
|
08-02-2007, 05:52 AM
|
#10
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2005
Posts: 10,234
|
Oh, don't forget that emerging markets has been clipped. I've been "daytrading" EEM with some success in the last week. VG has a corresponding emerging markets fund. But last year, EM dropped more than 25% before it hit it's intrayear bottom and recovered nicely.
|
|
|
08-02-2007, 06:31 AM
|
#11
|
Thinks s/he gets paid by the post
Join Date: Dec 2004
Location: Minneapolis
Posts: 4,401
|
Follow the instructions from this site to download the data into a spreadsheet.
Yahoo data download
|
|
|
08-02-2007, 10:28 AM
|
#12
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2003
Location: Losing my whump
Posts: 22,697
|
Quote:
Originally Posted by Olav23
If you type multiple tickers into Bigcharts.com and pick a timespan, it defaults to showing %ages instead of prices.
|
Hmm, how did you do that? I just fiddled with bigcharts for a half hour and cant make it do that. I put in three symbols with spaces, commas and pluses, and all it spits out is a chart for some italian stock starting with the letter 'v'.
Ah nevermind, I figured it out. Interactive charts, pick one symbol, then the rest go into 'compare'. That'll work.
Nevermind the nevermind, it'll only take six symbols and I have about 20. Still looking...
(sort of amused that with all these web sites and tools, there isnt something that'll tell you 30/60/90 day performance of a mutual fund family..."YTD" is of somewhat limited usefullness)
__________________
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.
|
|
|
08-02-2007, 11:36 AM
|
#13
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2003
Location: Losing my whump
Posts: 22,697
|
Okay, I got what I wanted with a little work.
Went into the microsoft moneycentral advanced charting tool, which requires some activex downloads and works only in Internet Exploder.
That lets you put in a seemingly endless list of fund symbols and look at them with a decent amount of analysis and in the time-frames I wanted.
Very interesting to look at all of this represented visually.
__________________
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.
|
|
|
08-02-2007, 11:42 AM
|
#14
|
Full time employment: Posting here.
Join Date: Apr 2006
Posts: 891
|
Link?
-CC
__________________
"There's those thinkin' more or less, less is more, but if less is more, how you keepin' score?
It means for every point you make, your level drops. Kinda like you're startin' from the top..." "Society" - Eddie Vedder
|
|
|
08-02-2007, 01:25 PM
|
#15
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jun 2005
Posts: 10,234
|
Quote:
Originally Posted by cute fuzzy bunny
(sort of amused that with all these web sites and tools, there isnt something that'll tell you 30/60/90 day performance of a mutual fund family...
|
The MSN deluxe charting tool can tell you the performance over any time period.
Ah, I see you finally got it going.
Investing: Stock Quotes, Charts & Market News - MSN Money is the link for all the tools along the left-hand panel.
|
|
|
08-02-2007, 03:17 PM
|
#16
|
Recycles dryer sheets
Join Date: Jul 2005
Posts: 423
|
Sorry, didn't see your question till just now. With a bit of hackery, you can add as many symbols as you want, and just bookmark each for the time period you want:
BigCharts - Printer-Friendly Format
If you click the link, you will see:
comp=VTSMX+VGSIX+INTC+SUNW+EFA+EEM+MSFT at the beginning. Just add as many tickers as you want with + between them. It looks like it allows up to 10 symbols without any problem  Gotta love url hacking.
Hopefully your way is easier!
|
|
|
08-02-2007, 07:16 PM
|
#17
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Dec 2003
Location: Losing my whump
Posts: 22,697
|
Its pretty smooth, except for having to type in all the fund symbols. And unless you've got a cheat sheet of symbols to fund names handy, you have to point at each line to see what it is. I've only got a dozen or so symbols memorized. Dang i'm rusty. Too many years of buying and holding index funds.
Hmmm...link...I'll have to figure that out. It lets me 'save' it within moneycentrals charting tool but I havent tried an export, if it even allows that. Its easy enough to reproduce with the funds you like...get a list from vanguard under 'list funds alphabetically', print it out or write down your faves, open moneycentrals chart tool, click on the 'download money toolbox' or whatever the hell the links called if you dont get the slick activex gray box charts, put in your benchmark fund (I used the S&P 500), then under 'compare' put in one symbol at a time and click add. I put in a shitload...more than 25...and it worked fine. Gets a little busy but you can uncheck them all and then click in the 4-5 specific funds you want to look at.
Definitely fixed the time frame problem I was having...this lets you look at 1-5-10-30-90-ytd and then as far back as you'd like to go from there.
At a minimum, I can snapshot a few charts and post them. Once I've really figured out what the hell i'm looking at.
Looks like the guys who got the good spanking as of late were REIT, small cap value, strategic equity, extended markets, mid cap, and value index. EM and energy took a good walloping too but once you see how far they skyrocketed prior to that they still dont look like good bargains. REIT kinda falls into this bucket as well...fell far but was way too lofty to begin with.
The high yield corp fund, when viewed over a significant time period and against other similar risk investments...looks like a giant suckball to own. I think I'd have to see it fall far enough to give me a 9.5-10% yield before I'd bother with taking it vs a lower risk equity fund. Its a real stinker when viewed by price alone over time.
__________________
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.
|
|
|
 |
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
|
|
|