Off-topic Talk Where overpaid, underworked S2000 owners waste the worst part of their days before the drive home. This forum is for general chit chat and discussions not covered by the other off-topic forums.

Stock Portfolios Wanted For Analyzing

Thread Tools
 
Old Aug 12, 2006 | 05:45 PM
  #11  
Harpoon's Avatar
20 Year Member
 
Joined: Mar 2005
Posts: 2,402
Likes: 7
From: Oregon
Default

Magician,

Are you doing this as a test for your business or as a guise to drum up some new business?
Reply
Old Aug 12, 2006 | 06:10 PM
  #12  
magician's Avatar
Thread Starter
Registered User
 
Joined: Jul 2001
Posts: 6,592
Likes: 0
From: Yorba Linda, CA
Default

Originally Posted by Harpoon,Aug 12 2006, 05:45 PM
Magician,

Are you doing this as a test for your business or as a guise to drum up some new business?
Both, although I question your use of the word "guise": I haven't tried to hide anything here.
Reply
Old Aug 12, 2006 | 06:24 PM
  #13  
Harpoon's Avatar
20 Year Member
 
Joined: Mar 2005
Posts: 2,402
Likes: 7
From: Oregon
Default

Where in this post did you disclose that you'd receive compensation? The only word I saw was "free".
Reply
Old Aug 12, 2006 | 06:29 PM
  #14  
magician's Avatar
Thread Starter
Registered User
 
Joined: Jul 2001
Posts: 6,592
Likes: 0
From: Yorba Linda, CA
Default

Originally Posted by Harpoon,Aug 12 2006, 06:24 PM
Where in this post did you disclose that you'd receive compensation? The only word I saw was "free".
Everything I'm doing here is free; I'm not receiving any compensation.

If people here like the kind of analysis our software can provide, they may be inclined to buy a copy when it's available, after we finish the beta testing.

I hope so.

If not, they've still received everything here for free, just as advertised.
Reply
Old Aug 13, 2006 | 06:49 PM
  #15  
magician's Avatar
Thread Starter
Registered User
 
Joined: Jul 2001
Posts: 6,592
Likes: 0
From: Yorba Linda, CA
Default

Here's another portfolio, this time a very good one (numbers as of 2/8/06):

ADP $11,821.92
AFL $7,302.07
BBBY $7,296.00
BRK-B $11,568.00
FISV $6,327.00
JNJ $17,662.55
MSFT $6,036.46
QCOM $14,682.64
SBUX $26,040.00
SPLS $7,036.60
STN $6,733.67
VLO $11,154.00
WFC $6,461.73
XTO $18,423.75
Cash $80,231.71

Again, I modeled the cash with ten-year US Treasury Bonds.

These securities are quite risky by themselves:



The annualized risk for each security is between 100% and 750%. However, this mix of securities in a portfolio is very good because of the very low correlations:



No security has an average correlation with the rest of the portfolio that exceeds 30%. When we look at the efficient frontier we get a very interesting picture:



Two features should jump out: the risk of every efficient portfolio is much less than that of the individual securities for the same level of return, and it is possible to create a portfolio with a higher average return than the average returns of any of the constituent securities. (Most people - even experienced portfolio managers - would say that this latter characteristic is, in fact, impossible; they would be wrong.)

What's truly interesting is that the efficient portfolio at the same level of risk as the original portfolio still uses 12 of the original 14 stocks:

ADP $0.00
AFL $15,234.81
BBBY $0.00
BRK-B $32,200.98
FISV $18,322.11
JNJ $36,229.93
MSFT $11,370.24
QCOM $6,574.84
SBUX $3,201.64
SPLS $27,962.02
STN $9,665.60
VLO $22,029.59
WFC $33,313.03
XTO $19,283.72
^TNX $12,172.61

Note, too, that the two securities that were dropped were the two with the highest correlations with the other securities.

The original portfolio - $238,778.10 on February 8, 2006 - would have grown to $242,416.28 by August 8: a profit of 1.52%. The efficient portfolio would have grown to $247,561.11: a profit of 3.68%, $5,144.83 more than the original.

Once again, adding a bond fund that is not strongly, positively correlated with the rest of the securities may have improved the performance. Nevertheless, the stock selection in this portfolio is excellent.
Reply
Old Aug 13, 2006 | 07:04 PM
  #16  
Purple_sky's Avatar
Registered User
 
Joined: Feb 2004
Posts: 2,899
Likes: 0
From: Purple sky
Default

Say what?
Reply
Old Aug 16, 2006 | 03:15 PM
  #17  
magician's Avatar
Thread Starter
Registered User
 
Joined: Jul 2001
Posts: 6,592
Likes: 0
From: Yorba Linda, CA
Default

Here's another portfolio, as of 2/8/06:

AMAT $30,015.00
AMZN $76,340.00
ASEI $56,032.00
CSCO $5,820.00
EBAY $20,245.00
GOOG $11,072.40
INTC $13,292.50
MSFT $8,013.00
OSTK $25,460.00
ORCL $5,028.00

Because of Google I can only get historical data for the entire portfolio for 19 months. Over that period of time, the stocks have the following returns and volatilities:



and the following correlations:



This is an extremely risky portfolio.

If we created the efficient portfolio with the same expected return we get:

AMAT $52,822.62
AMZN $1,859.62
ASEI $21,070.73
CSCO $67,657.48
EBAY $0.00
GOOG $40,291.16
INTC $0.00
MSFT $67,616.29
OSTK $0.00
ORCL $0.00


From 2/8/06 to 8/8/06 the original portfolio would have lost 27.4%, dropping from $251,317.90 to $182,483. The efficient portfolio with the same expected return but a lower risk would have lost 12.9%, dropping from $251,317.90 to $218,827.69. While the efficient portfoliowould have lost money, it would still come out $36,344.69 better than the original.

Once again, the addition of some lower risk or lower correlation securities would improve the portfolio considerably.
Reply
Old Aug 17, 2006 | 12:56 PM
  #18  
Purple_sky's Avatar
Registered User
 
Joined: Feb 2004
Posts: 2,899
Likes: 0
From: Purple sky
Default

Originally Posted by magician,Aug 16 2006, 03:15 PM
This is an extremely risky portfolio.
I'm disappointed and sad to hear this. But since then, I've gotten rid of some of the riskier ones. Fortunately, I profited. Thanks for the analysis! You're very much appreciated!
Reply
Old Aug 19, 2006 | 08:17 PM
  #19  
magician's Avatar
Thread Starter
Registered User
 
Joined: Jul 2001
Posts: 6,592
Likes: 0
From: Yorba Linda, CA
Default

Originally Posted by Purple_sky,Aug 17 2006, 12:56 PM
Thanks for the analysis! You're very much appreciated!
My pleasure.
Reply
Old Aug 19, 2006 | 09:06 PM
  #20  
magician's Avatar
Thread Starter
Registered User
 
Joined: Jul 2001
Posts: 6,592
Likes: 0
From: Yorba Linda, CA
Default

Another portfolio, as of 2/17/06:



Some of the stocks are quite risky by themselves, but note the correlations:



Here are the historical returns:



Because of the large spike in returns ending about February, 2002, I chose to use 4 years of historical data for risks, returns, and correlations.

The original portfolio has an annual risk of 89.5% and an expected annual return of 0.75%: pretty risky for an extremely low expected return.

I created two efficient portfolios: one with minimum risk - 48.8% - and an expected annual return of 11.5% and another with an expected return of 15%, and risk of 49.7%. The former allocation is:

AMAT $0.00
ARTG $0.00
BA $139,589.77
EBAY $0.00
HOG $85,255.84
KKD $0.00
NOK $0.00
NSANY $308,914.78
ORCL $0.00
PAYX $6,073.00
SBUX $271,325.82
SGP $188,840.80

The latter is:

AMAT $0.03
ARTG $0.00
BA $118,363.80
EBAY $0.00
HOG $138,640.06
KKD $0.03
NOK $0.00
NSANY $274,299.68
ORCL $0.03
PAYX $26,135.55
SBUX $207,276.68
SGP $235,284.12

The original portfolio would have grown from $1,000,000.00 on 2/17/06 to $1,063,280.66 on 8/17/06: a profit of 6.3%. The minimum risk efficient portfolio would have dropped to $992,279.00: a loss of 0.77%. The 15% efficient portfolio would have grown to $1,007,644.02: a profit of 0.76%.

In this case, the inefficient portfolio did better than either of the efficient portfolios, at least for the first six months: sometimes even the best analysis cannot predict the future. It will be interesting to see what happens over the next six months.
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
gpwuster
Money and Investing
6
Apr 16, 2010 12:54 PM
replicah
Aus & NZ Off Topic
119
Aug 10, 2009 02:44 PM
hansai00
Money and Investing
5
Aug 15, 2008 02:16 PM
Trent06
Money and Investing
6
Feb 11, 2008 04:58 PM
VisualEchos
Off-topic Talk
17
Aug 4, 2006 08:35 AM




All times are GMT -8. The time now is 12:06 PM.