Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Alternative sources for daily portfolio position recaps
Old 10-03-2011, 12:51 PM   #1
Recycles dryer sheets
justplainbll's Avatar
 
Join Date: Sep 2011
Location: Easten Long Island
Posts: 414
Alternative sources for daily portfolio position recaps

For the last 10 or so years, I've been downloading the symbols, closing prices, ttm earnings per share, annualized dividends per share, and ex-div dates for all (some 200+) of my equity and mutual fund holdings on a more or less daily basis from Yahoo-Finance. Because these positions are held in over a half dozen accounts, I find it helpful to generate a consolidated position recap report.
What might be some alternative sources for accessing and downloading the above described data to a delimited text file for upwards of 300 equity issues and mutual funds?
__________________

__________________
justplainbll 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 10-03-2011, 01:31 PM   #2
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas Hill Country
Posts: 42,117
Quote:
Originally Posted by justplainbll View Post
What might be some alternative sources for accessing and downloading the above described data to a delimited text file for upwards of 300 equity issues and mutual funds?
Vanguard S&P 500 Index Fund?
__________________

__________________
Numbers is hard

When I hit 70, it hit back

Retired in 2005 at age 58, no pension
REWahoo is offline   Reply With Quote
Old 10-03-2011, 02:24 PM   #3
Recycles dryer sheets
justplainbll's Avatar
 
Join Date: Sep 2011
Location: Easten Long Island
Posts: 414
Need data to generate a report like the attached sample
Attached Files
File Type: doc Sample.doc (23.5 KB, 49 views)
__________________
justplainbll is offline   Reply With Quote
Old 10-03-2011, 02:58 PM   #4
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,284
Quote:
Originally Posted by justplainbll View Post
For the last 10 or so years, I've been downloading the symbols, closing prices, ttm earnings per share, annualized dividends per share, and ex-div dates for all (some 200+) of my equity and mutual fund holdings .... for upwards of 300 equity issues and mutual funds?


Pray tell, what do you achieve with that many holdings? How do you deal with commissions, taxes?

I guess it's hard to even track them well enough to round to the nearest hundred. Is it 200+ or 300+ ?

Have you measured your after-tax, after-commission performance against something like the...

Quote:
Originally Posted by REWahoo View Post
Vanguard S&P 500 Index Fund?
This is amazing. I've heard of people with dozens of MFs and maybe another dozens of stocks. But hundreds? Please fill us in on your thought process here.


-ERD50
__________________
ERD50 is online now   Reply With Quote
Old 10-03-2011, 03:38 PM   #5
Recycles dryer sheets
justplainbll's Avatar
 
Join Date: Sep 2011
Location: Easten Long Island
Posts: 414
Quote:
Originally Posted by ERD50 View Post


Pray tell, what do you achieve with that many holdings? How do you deal with commissions, taxes?

I guess it's hard to even track them well enough to round to the nearest hundred. Is it 200+ or 300+ ?

Have you measured your after-tax, after-commission performance against something like the...



This is amazing. I've heard of people with dozens of MFs and maybe another dozens of stocks. But hundreds? Please fill us in on your thought process here.


-ERD50
I began measuring my overall portfolio performance in earnest on 16 August 2002. As of 23 Sep. 2011 the portfolio market value consisted of 68% equity and a 31% mixture of fixed income and inverse funds. For the 475 weeks ending 9/23/11 the annualized return for the portfolio was 5.9%; equities were at 5.6% and the fixed income & inverse funds at 6.8%. As of 9/30 the 221 issue portfolio's YTD decline was 6.08%.
__________________
justplainbll is offline   Reply With Quote
Old 10-03-2011, 03:52 PM   #6
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas Hill Country
Posts: 42,117
Quote:
Originally Posted by justplainbll View Post
I began measuring my overall portfolio performance in earnest on 16 August 2002.
So for over nine years you've been tracking the daily performance of over 200 stocks on a spreadsheet?

Guess that answers the old "Whattya DO all day?" retirement question...
__________________
Numbers is hard

When I hit 70, it hit back

Retired in 2005 at age 58, no pension
REWahoo is offline   Reply With Quote
Old 10-03-2011, 03:56 PM   #7
Moderator
MichaelB's Avatar
 
Join Date: Jan 2008
Location: Rocky Inlets
Posts: 24,465
Quote:
Originally Posted by justplainbll View Post
I began measuring my overall portfolio performance in earnest on 16 August 2002. As of 23 Sep. 2011 the portfolio market value consisted of 68% equity and a 31% mixture of fixed income and inverse funds. For the 475 weeks ending 9/23/11 the annualized return for the portfolio was 5.9%; equities were at 5.6% and the fixed income & inverse funds at 6.8%. As of 9/30 the 221 issue portfolio's YTD decline was 6.08%.
At what time on 9/30?

Why don't you get some portfolio tracking SW like Quicken? Probably help during tax prep as well...
__________________
MichaelB is offline   Reply With Quote
Old 10-03-2011, 04:18 PM   #8
Recycles dryer sheets
 
Join Date: Feb 2011
Posts: 200
Have you looked at Morningstar's Portfolio report? Once you put in all your holdings, it does the tracking. You can add and subtract columns to give you more info. I can't imagine needing more info that that, and we have pretty busy accounts too.
__________________
PaddyMac is offline   Reply With Quote
Old 10-03-2011, 04:22 PM   #9
Recycles dryer sheets
justplainbll's Avatar
 
Join Date: Sep 2011
Location: Easten Long Island
Posts: 414
Quote:
Originally Posted by MichaelB View Post
At what time on 9/30?

Why don't you get some portfolio tracking SW like Quicken? Probably help during tax prep as well...
At 1900 eastern time.
__________________
justplainbll is offline   Reply With Quote
Old 10-03-2011, 04:30 PM   #10
Recycles dryer sheets
justplainbll's Avatar
 
Join Date: Sep 2011
Location: Easten Long Island
Posts: 414
Thanks for the responses thus far. All I was asking about is an alternative daily delimited feed for the data I described above. I've developed my own software for performance analysis. The annualized appreciation of the value of my equity investments for the 476 weeks (through 9/30/2011) has exceeded the S&P 500 by 3.3%.
PS I watch about 300 issues but am currently invested in only 222.
__________________
justplainbll is offline   Reply With Quote
Old 10-03-2011, 05:16 PM   #11
Thinks s/he gets paid by the post
GregLee's Avatar
 
Join Date: Oct 2010
Location: Waimanalo, HI
Posts: 1,881
Quote:
Originally Posted by PaddyMac View Post
Have you looked at Morningstar's Portfolio report? Once you put in all your holdings, it does the tracking. You can add and subtract columns to give you more info. I can't imagine needing more info that that, and we have pretty busy accounts too.
T. Rowe Price uses the Morningstar Portfolio report program. Here are a couple of screen pages from the "X-ray" option for my portfolio. I think it's pretty neat.
Attached Images
File Type: jpg snapshot2.jpg (397.8 KB, 13 views)
File Type: jpg snapshot3.jpg (380.8 KB, 9 views)
__________________
Greg (retired in 2010 at age 68, state pension)
GregLee is offline   Reply With Quote
Old 10-03-2011, 10:00 PM   #12
Thinks s/he gets paid by the post
 
Join Date: Jul 2005
Posts: 3,862
I download all that Yahoo data directly into an Excel spreadsheet, either a push of one button or automatically every 2 minutes (guess what I do all day!) There's a way to load web pages directly to the spreadsheet. Not sure if you are doing that or not, but once set up it's easy. Table values will load nicely into cells so that you can look up a symbol on the downloaded web page and grab the price and other info you want. You can download your portfolio info if you save them on Yahoo, or I copy a report from Quicken into the same spreadsheet with all of my holdings. Heck I used to get real-time data from Yahoo for a real-time spreadsheet. Now I've mellowed out enough to use the free delayed quotes. And sometimes I don't even look at it for a few hours. Never know these days if things might drop 5% or something.
__________________
Animorph is offline   Reply With Quote
Old 10-03-2011, 10:34 PM   #13
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,284
Quote:
Originally Posted by justplainbll View Post
I began measuring my overall portfolio performance in earnest on 16 August 2002. As of 23 Sep. 2011 the portfolio market value consisted of 68% equity and a 31% mixture of fixed income and inverse funds. For the 475 weeks ending 9/23/11 the annualized return for the portfolio was 5.9%; equities were at 5.6% and the fixed income & inverse funds at 6.8%. As of 9/30 the 221 issue portfolio's YTD decline was 6.08%.
I hope I'm not coming across as negative, I'm just fascinated that someone would try to out-do an index by investing in so many equities. I've never heard of this approach.

Now, maybe I misinterpreted your math, or made some mistakes, but it appears to me that:

1) Your blend is roughly equivalent to some balanced funds (they probably would not do inverse investments, though some actively managed ones do).

2) If I take your 5.9% to mean "compounded annual return", and assume 147 weeks = 9.1346 years, then -
1.059 ^ 9.1346 = 1.6682 (66.82% increase)
3) A well known balanced fund ( VWIAX - 'psssst-Wellesley') grew by 69.32% in that time.

VWIAX Historical Prices | VANGUARD WELLESLEY INCOME FD AD Stock - Yahoo! Finance

(see the 'Adj Close' to include divs and other distributions)


If my math/understanding of your numbers is correct, you seem to be doing a lot of work that Vanguard could be doing for you.

Cue unclemick.....

-ERD50
__________________
ERD50 is online now   Reply With Quote
Old 10-04-2011, 02:01 AM   #14
Recycles dryer sheets
justplainbll's Avatar
 
Join Date: Sep 2011
Location: Easten Long Island
Posts: 414
Quote:
Originally Posted by Animorph View Post
I download all that Yahoo data directly into an Excel spreadsheet, either a push of one button or automatically every 2 minutes (guess what I do all day!) There's a way to load web pages directly to the spreadsheet. Not sure if you are doing that or not, but once set up it's easy. Table values will load nicely into cells so that you can look up a symbol on the downloaded web page and grab the price and other info you want. You can download your portfolio info if you save them on Yahoo, or I copy a report from Quicken into the same spreadsheet with all of my holdings. Heck I used to get real-time data from Yahoo for a real-time spreadsheet. Now I've mellowed out enough to use the free delayed quotes. And sometimes I don't even look at it for a few hours. Never know these days if things might drop 5% or something.
I also use Yahoo. My original question was prompted by the possibility that sometime in the future Yahoo's information might cease to be freely available.
__________________
justplainbll is offline   Reply With Quote
Old 10-04-2011, 02:41 AM   #15
Recycles dryer sheets
justplainbll's Avatar
 
Join Date: Sep 2011
Location: Easten Long Island
Posts: 414
Quote:
Originally Posted by ERD50 View Post
I hope I'm not coming across as negative, I'm just fascinated that someone would try to out-do an index by investing in so many equities. I've never heard of this approach.

Now, maybe I misinterpreted your math, or made some mistakes, but it appears to me that:

1) Your blend is roughly equivalent to some balanced funds (they probably would not do inverse investments, though some actively managed ones do).

2) If I take your 5.9% to mean "compounded annual return", and assume 147 weeks = 9.1346 years, then -
1.059 ^ 9.1346 = 1.6682 (66.82% increase)
3) A well known balanced fund ( VWIAX - 'psssst-Wellesley') grew by 69.32% in that time.

VWIAX Historical Prices | VANGUARD WELLESLEY INCOME FD AD Stock - Yahoo! Finance

(see the 'Adj Close' to include divs and other distributions)


If my math/understanding of your numbers is correct, you seem to be doing a lot of work that Vanguard could be doing for you.

Cue unclemick.....

-ERD50
Pretty close ERD:

TOTAL RETURNS SINCE 8/16/02 (exclusive of September 2011 dividends)
# Weeks Date_ Equity Total Portfolio
474 ___ 09/16 75.7% 76.6%
475 ___ 09/23 63.8% 69.2%
476 ___ 09/30 65.0% 67.7%
The Vanguard Wellesley Income Fund's Admiral shares indeed have done nicely. However it is my understanding that their asset mix runs about 40% equity and 60% fixed income. My median target mix with assets at brokers and mutual funds is about 65% equity and 35% fixed income.
__________________
justplainbll is offline   Reply With Quote
Old 10-04-2011, 08:38 AM   #16
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,284
Quote:
Originally Posted by justplainbll View Post
Pretty close ERD:

TOTAL RETURNS SINCE 8/16/02 (exclusive of September 2011 dividends)
# Weeks Date_ Equity Total Portfolio
474 ___ 09/16 75.7% 76.6%
475 ___ 09/23 63.8% 69.2%
476 ___ 09/30 65.0% 67.7%
The Vanguard Wellesley Income Fund's Admiral shares indeed have done nicely. However it is my understanding that their asset mix runs about 40% equity and 60% fixed income. My median target mix with assets at brokers and mutual funds is about 65% equity and 35% fixed income.
OK, so the next thing would be to compare volatility. Or maybe bull/bear markets.

I also tend to lean to a more aggressive AA than Wellesley, but that is based on indexes for each. IF you have selected a mix of more conservative and/or div paying stocks, the end result may actually 'look' more like 40%/60%?

I assume you want a higher eq ratio for long term growth (I do), but I wonder if you will get it with that particular mix of stocks? The bull/bear time period comparisons might help you determine that.

-ERD50
__________________
ERD50 is online now   Reply With Quote
Old 10-04-2011, 08:59 AM   #17
Recycles dryer sheets
justplainbll's Avatar
 
Join Date: Sep 2011
Location: Easten Long Island
Posts: 414
My greatest concern is the erosion of the dollar's purchasing power. That has plagued this country for the greater part of its history.
Too many fools out there who think they'd be on easy street if the minimum wage was raised to $100 per hour or their monthly SS benefit was raised to $7,000.
__________________
justplainbll is offline   Reply With Quote
Old 10-04-2011, 09:22 AM   #18
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas Hill Country
Posts: 42,117
Quote:
Originally Posted by justplainbll View Post
My median target mix with assets at brokers and mutual funds is about 65% equity and 35% fixed income.
That AA closely matches Vanguard Wellington (VWENX) which has an expense ratio of 0.22%.

Of course the big question with that move would be what to do with all your free time...
__________________
Numbers is hard

When I hit 70, it hit back

Retired in 2005 at age 58, no pension
REWahoo is offline   Reply With Quote
Old 10-04-2011, 09:30 AM   #19
Moderator
MichaelB's Avatar
 
Join Date: Jan 2008
Location: Rocky Inlets
Posts: 24,465
Quote:
Originally Posted by REWahoo View Post
That AA closely matches Vanguard Wellington (VWENX) which has an expense ratio of 0.22%.
Wellington fund since 8/16/02 +86.5% according to M*
Attached Images
File Type: jpg wellington.jpg (53.5 KB, 11 views)
__________________
MichaelB is offline   Reply With Quote
Old 10-04-2011, 09:41 AM   #20
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 18,284
Quote:
Originally Posted by REWahoo View Post
That AA closely matches Vanguard Wellington (VWENX) which has an expense ratio of 0.22%.
Quote:
Originally Posted by MichaelB View Post
Wellington fund since 8/16/02 +86.5% according to M*
Looks like we have a WINNUH!

Using adjusted closes from Yahoo (for consistency with previous numbers), I got a 78.6% return for Wellington, from 08/16/02 - 09/23/11. Not sure why the difference, but it appears to beat the OPs numbers in either case.

-ERD50
__________________

__________________
ERD50 is online now   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


 

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