★ wanayoo — archive 1999 http://www.fool.com/ddow/2000/ddow000630.htmNouvelle recherche | Portail wanayoo
Home TabsFool.com HomeDiscussion BoardsQuotes and DataStock ResearchShop FoolMartMy PortfolioMy FoolLogin
Home/Features NavNewsSpecial FeaturesInvesting StrategiesRetirementPersonal FinanceFool's SchoolHelp
Stock StrategiesFool.com HomeFool.com Home
  
 
  
Home / Strategies / Foolish Four Portfolio
Email this article Email this article
Format for Printing Format for printing

Database Dreamin'

By Ann Coleman (TMF AnnC)
June 30, 2000

I'm taking something of a chance today in describing a database that I haven't actually seen yet, but I really want to get input from our community on what we should be looking for and how we should go about looking for it. So today I will lay out for you what it is that we will have to work with and invite you to suggest ways in which we can make the best use of this resource.

Here is what we are getting from the Center for Research in Security Prices (CRSP).

For each month from January 1950 on, the database will list the 500 largest (by market cap) U.S. companies, excluding transportation and utility companies. (They are excluded because they were never included in the Dow.) Each company is identified by a unique code so that it can be tracked over time as names and tickers change, companies merge, go out of business, spin off divisions, etc. In addition to identifying information, for each company we will have:

Price as of the first trading day of the month

Regular cash dividend

Yield (most recently declared dividend * 4 / price)

RP (yield/square root of price)

Number of shares outstanding (from which market cap is calculated by multiplying the number of shares outstanding by the share price)

Returns for subsequent one to three years at three-month intervals

We will also have an adjusted share price and adjusted number of shares outstanding (adjusted for splits, spin-offs, etc.). These numbers are adjusted to their equivalent in today's values. All dividend and other payout information is included in a separate database. From this information we can calculate returns for other periods. CRSP is also ranking the stocks for us by price, yield, market cap, and RP.

Naturally, the folks at CRSP are concerned about how their data is used. I have some idea how difficult this information is to assemble, and I fully understand and support their concerns -- even if they weren't backed by law! The raw data is copyrighted material. Any sharing we do with members of the community must be in line with our contract, which rules out sharing raw price and dividend data right off the bat.

Naturally, the results we get can be shared, and "derived" data -- like the RP, returns, and rankings -- can also be shared. I am working on a way to make some parts of the database available to certain members of the community in a limited way that doesn't violate our contract with CRSP. Also, anyone who wishes to travel to Alexandria, Virginia, may view the raw database right here on the computer where it lives.

My plan for the first, quick-and-dirty test is to extract the 50 largest, dividend-paying stocks by market cap for each month, sort them by RP, and compare the one-year returns of the stocks ranked 2-5 (the Foolish Four method) with that of the 500-stock database as a whole and also with the return for the 50 largest-cap stocks. (By the way, when I say "quick," don't take that too literally!)

Please feel free to e-mail me (TMFAnnC@aol.com) with your suggestions for this first study or post them on the discussion board. In particular, I would love to hear what kind of statistical test readers would find valuable for comparing returns, and what you would feel is an acceptable confidence level to establish validity.

There are a number of other questions that can be addressed, but my first focus is going to be validating, or not, the original concept. As I keep saying so often that my fingers type it of their own accord, even if the new database confirms the results of our earlier work, that won't prove anything about the future performance of the Foolish Four. But it will give me, personally, a reason to hold on during uncomfortable periods like this one.

Fool on and prosper!


 See Also

  • Dow Investing/F4 Discussion Board
  • Foolish Workshop
  • Portfolio Trade Alerts
  • Retiree Portfolios
  • Strategies
     

    Fools Wanted: Apply Within.

     Recent Foolish Four Portfolio Headlines
      08/14/00  How to Win the Lottery
      08/11/00  A "Gone Fishing" Investing Strategy
      08/10/00  Returns Can Be Misleading
      08/09/00  Investing Is Like Shopping
      08/08/00  Five Tips for Finding Great Companies
    Foolish Four Portfolio Archives »  

     


  • Today's Features

     Enter Symbol(s):
      
     Choose a Broker
     Create a Portfolio

    Top Dow Stocks
    ( RP Order )

    6/30/00

    1. Philip Morris
       (NYSE:MO)
    2. * Caterpillar
       (NYSE:CAT)
    3. * Int'l Paper
       (NYSE:IP)
    4. * AT&T
       (NYSE:T)
    5. * DuPont
       (NYSE:DD)
    6. General Motors
       (NYSE:GM)
    7. Honeywell
       (NYSE:HON)
    8. Eastman Kodak
       (NYSE:EK)
    9. SBC Comm.
       (NYSE:SBC)
    10. JP Morgan
       (NYSE:JPM)

    NOTE: Today's Foolish Four stock selections are marked with an asterisk.



     Foolish Four
     Portfolio
  • Today's Numbers
  • Current Report
  • F4 Archives
  • F4 Information
  • F4 Explained
  • F4 Evolution
  • Statistics Center
  • Today's Stock Lists
  • Don't Mimic Us

    Discussion Board

  • Dow Investing/F4

  •  Investing
     Strategies
  • Rule Breaker Port
  • Rule Maker Port
  • Foolish Four Port
  • Drip Port
  • Boring Port
  • Workshop
  • NOW 50 Index


  •  In FoolMart
    Foolish Four Investment Guide
    Find out how to crush your mutual funds in just fifteen minutes a year with the Foolish Four Investment Guide.


      

    Foolish Four Portfolio

    6/30/2000 Closing Numbers
    Ticker Company Day Chg % Chg Price
    CATCATERPILLAR INC-1 1/8-3.21%$33.88
    EKEASTMAN KODAK-3/4-1.24%$59.63
    GMGENL MOTORS-1 1/4-2.11%$58.00
    JPMMORGAN (JP)-2 3/8-2.11%$110.13

      Day Week Month Year
    To Date
    Since
    12/24/1998
    Annualized
    Foolish Four -2.04% -3.22% -10.69% -16.28% 3.01% 1.97%
    S&P 500(DA) .85% .91% 2.39% -1.00% 18.98% 12.12%
    NASDAQ 2.29% 3.14% 16.62% -2.54% 82.56% 48.60%
    DJIA (DA) .48% .41% -.71% -9.13% 15.36% 9.86%

    Trade Date # Shares Ticker Cost/Share Price LT % Val Chg
    12/24/19989JPM105.514$110.134.37%
    12/27/199920EK65.088$59.63-8.39%
    12/27/199918GM73.257$58.00-20.83%
    12/24/199824CAT43.083$33.88-21.37%

    Trade Date # Shares Ticker Cost Value LT $ Val Ch
    12/24/19989JPM$949.63$991.13$41.50
    12/27/199920EK$1,301.75$1,192.50($109.25)
    12/24/199824CAT$1,034.00$813.00($221.00)
    12/27/199918GM$1,318.63$1,044.00($274.63)
      Cash: $79.92  
      Total: $4,120.55  


    Key
    • S&P 500 (DA) = dividend adjusted. Dividends have been added to the total return of the index.
    • DJIA (DA) = dividend adjusted. Dividends have been added to the total return of the DJIA.

    Note
    The Foolish Four Portfolio was launched on December 24, 1998, with $4,000. Additional cash is never added, all transactions are discussed and explained publicly before being made, and returns are compared daily to the S&P 500 and the Dow. (Dividends are included in the yearly, historic and annualized returns.) Stocks are chosen once per year using a formula based on dividend yield and price. See The Foolish Four Explained for details.



     
    Home/Features NavNewsSpecial FeaturesInvesting StrategiesRetirementPersonal FinanceFool's SchoolHelp
    Legal Information. ©1995-2000 The Motley Fool. All rights reserved.
    USVAWeb009
    Archives · Contact Us · Work at the Fool