This Day On The Street
Continue to site
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

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

    Check Out Our Best Services for Investors

    Action Alerts PLUS

    Portfolio Manager Jim Cramer and Director of Research Jack Mohr reveal their investment tactics while giving advanced notice before every trade.

    Product Features:
    • $2.5+ million portfolio
    • Large-cap and dividend focus
    • Intraday trade alerts from Cramer
    Quant Ratings

    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
    Stocks Under $10

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

    Product Features:
    • Model portfolio
    • Stocks trading below $10
    • Intraday trade alerts
    14-Days Free
    Only $9.95
    14-Days Free
    Dividend Stock Advisor

    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
    • Updates with exact steps to take - BUY, HOLD, SELL
    Trifecta Stocks

    Every recommendation goes through 3 layers of intense scrutiny—quantitative, fundamental and technical analysis—to maximize profit potential and minimize risk.

    Product Features:
    • Model Portfolio
    • Intra Day Trade alerts
    • Access to Quant Ratings
    Real Money

    More than 30 investing pros with skin in the game give you actionable insight and investment ideas.

    Product Features:
    • Access to Jim Cramer's daily blog
    • Intraday commentary and news
    • Real-time trading forums
    Only $49.95
    14-Days Free
    14-Days Free
    GOOG $684.12 0.00%
    YHOO $27.10 0.00%
    AAPL $93.25 -1.10%
    FB $99.62 -1.40%
    TSLA $150.00 4.40%


    Chart of I:DJI
    DOW 15,914.74 -99.64 -0.62%
    S&P 500 1,851.86 -0.35 -0.02%
    NASDAQ 4,283.5920 +14.8290 0.35%

    Free Reports

    Top Rated Stocks Top Rated Funds Top Rated ETFs