This account is pending registration confirmation. Please click on the link within the confirmation email previously sent you to complete registration.
Need a new registration confirmation email? Click here
TheStreet Open House

Apprenticed Investor: Trading Diary, Part II

The first thing you will notice is that the spread sheet contains many of the same topics we discussed last week in the trading diary. This is no coincidence, as these two tools are designed to complement each other.

By entering the information from the diary to the spreadsheet, you will be able to examine and review five separate components to your portfolio:

  • Performance: Knowing how well you are doing -- on both a relative and absolute basis -- will help you determine if you need to make major or minor course corrections.
  • Asset Allocation: You can very easily see when a position becomes too large relative to the rest of the portfolio. If most of the asset percentages are between 1% to 5%, that one stock or fund that's 14% really sticks out like a sore thumb. Recognizing this at least gives you the opportunity to decide if you want that much risk in a given stock.
  • It's easy to see when your portfolio is being dominated by a given sector. In the 1990s, it was tech and telecom; these days, it seems to be energy and housing that are slowly taking over portfolios. There's a reason you want balance, especially after an outsized move in an extended sector.

  • Data Mining (Strategy review): Price-to-earnings, P/E-to-growth, market cap, growth rate, beta, dividend yield. These are just some of the criteria you can keep track of. This allows you to determine what criteria are working best, just at a glance. Are high P/E and big beta stocks doing well? Or are low P/E stocks with good dividend ratios what's working? Either way, that tells you something about your holdings -- and the overall market as well. It also shows you where some tactical adjustments might be necessary.
  • Charts & Graphics: If a picture is worth a 1,000 words, then a spreadsheet must be worth a million: That's because you can take any and all of the entered data and turn it into a pie chart or graphic.
  • Let's do a quick experiment: look at columns L and M, and rows 35-44. It's the sector totals for both your portfolio and the S&P 500. Highlight column L, rows 35-44, then click on the chart wizard button -- it looks like a chart with a wand. Select a chart type (I like the pie chart), and then a sub type (my favorite is the 3D exploded chart). Click your way through the four steps. On the last one, select new sheet. Then click finish. Do the same thing for column M. The tabs at the bottom of the spreadsheet will let you switch back and forth between charts.

    Look at your sector holdings breakdown, and then the relative weighting of sectors in the S&P 500. Are you comfortable with how similar or different your holdings are from the index?

  • Record Keeping: Your spreadsheet becomes a backup to your regular statements. Trust me when I tell you, this is often a lifesaver in a pinch. Your purchase price, date of buy, quantity and commissions all have tax implications. Keeping a spreadsheet creates a powerful record-keeping system, including cost basis. When some crucial brokerage statement turns up missing around tax time, your accountant will be relieved you have a back up (he can thank me then).
  • Using a spreadsheet gives you the ability to see these items across your entire portfolio, and then to make whatever adjustments are necessary. You can "play with the numbers," to see how different alterations affect your overall holdings in real time.

    The bottom line is that unless you know what the bottom line was, you cannot make adjustments. It's the key to good performance.

    2 of 3

    Select the service that is right for you!

    COMPARE ALL SERVICES
    Action Alerts PLUS
    Try it NOW

    Jim Cramer and Stephanie Link actively manage a real portfolio and reveal their money management tactics while giving advanced notice before every trade.

    Product Features:
    • $2.5+ million portfolio
    • Large-cap and dividend focus
    • Intraday trade alerts from Cramer
    • Weekly roundups
    TheStreet Quant Ratings
    Try it NOW
    Only $49.95/yr

    Access the tool that DOMINATES the Russell 2000 and the S&P 500.

    Product Features:
    • Buy, hold, or sell recommendations for over 4,300 stocks
    • Unlimited research reports on your favorite stocks
    • A custom stock screener
    • Upgrade/downgrade alerts
    Stocks Under $10
    Try it NOW

    David Peltier, uncovers low dollar stocks with extraordinary upside potential that are flying under Wall Street's radar.

    Product Features:
    • Model portfolio
    • Stocks trading below $10
    • Intraday trade alerts
    • Weekly roundups
    Dividend Stock Advisor
    Try it NOW

    Jim Cramer's protege, David Peltier, identifies the best of breed dividend stocks that will pay a reliable AND significant income stream.

    Product Features:
    • Diversified model portfolio of dividend stocks
    • Alerts when market news affect the portfolio
    • Bi-weekly updates with exact steps to take - BUY, HOLD, SELL
    Real Money Pro
    Try it NOW

    All of Real Money, plus 15 more of Wall Street's sharpest minds delivering actionable trading ideas, a comprehensive look at the market, and fundamental and technical analysis.

    Product Features:
    • Real Money + Doug Kass Plus 15 more Wall Street Pros
    • Intraday commentary & news
    • Ultra-actionable trading ideas
    Options Profits
    Try it NOW

    Our options trading pros provide daily market commentary and over 100 monthly option trading ideas and strategies to help you become a well-seasoned trader.

    Product Features:
    • 100+ monthly options trading ideas
    • Actionable options commentary & news
    • Real-time trading community
    • Options TV
    To begin commenting right away, you can log in below using your Disqus, Facebook, Twitter, OpenID or Yahoo login credentials. Alternatively, you can post a comment as a "guest" just by entering an email address. Your use of the commenting tool is subject to multiple terms of service/use and privacy policies - see here for more details.
    Submit an article to us!
    DOW 17,279.74 +13.75 0.08%
    S&P 500 2,010.40 -0.96 -0.05%
    NASDAQ 4,579.7870 -13.6380 -0.30%

    Brokerage Partners

    Rates from Bankrate.com

    • Mortgage
    • Credit Cards
    • Auto

    Free Newsletters from TheStreet

    My Subscriptions:

    After the Bell

    Before the Bell

    Booyah! Newsletter

    Midday Bell

    TheStreet Top 10 Stories

    Winners & Losers

    Register for Newsletters
    Top Rated Stocks Top Rated Funds Top Rated ETFs