Re: [CANSLIM] Leaders List Spreadsheet

From: "Dave Massaglia" <dmassaglia@hotmail.com>
Subject: Re: [CANSLIM] Leaders List Spreadsheet
Date: Wed, 03 May 2000 20:57:58 PDT

Next Article (by Author): RE: [CANSLIM] Leaders List Spreadsheet "Dwayne Andras"
Previous Article (by Author): [CANSLIM] Definition of base and pivot point Carter Diggs
Top of Thread: Re: [CANSLIM] Leaders List Spreadsheet asosis@ca.ibm.com
Next in Thread: Re: [CANSLIM] Leaders List Spreadsheet "Tom Worley"
Articles sorted by: [Date] [Author] [Subject]

Earl,

Thanks so much for the spreadsheets.
Obviously you're busting your butt putting this information together.

I am relatively new to investing and new to CANSLIM. I've been reading these 
posts for about a month and have read HTMMIS.

I have found several members talking about DGO. Can you tell me what the 
site is? I am under the impression that it is similar to stocktables.com and 
would like to have a site available that sorts data like IBD.

In addition, I was attempting to analyze the numbers in your spreadsheet and 
would like clarification on a couple items.

What is the significance of the pivot, 5% and 20% down numbers?
Is the pivot point a point of resistance to watch for?

Thanks, Earl, I wish I had found this group before I invested some cash in 
April....I'm down 35% since mid March ...all tech stocks...

I think you said you were 100% cash, but I'm holding, hoping for a rebound 
this fall...

Dave Massaglia


>
>I had several requests for the spreadsheet I use to generate my leaders
>list.  I didn't expect that amount of interest!!  Thanks for the
>compliments and I'm glad several of you find it useful.  I have decided to
>go ahead and post the file on the CANSLIM FTP site.  You can get the file 
>at:
>
>ftp://ftp.xmission.com/pub/users/m/mcjathan/canslim/CANSLIM_Data.xls
>
>The following notes are what I originally wrote to one person, now modified
>for a broader audience.  This describes the spreadsheet and how I generate 
>it.
>
>The spreadsheet is a compilation of CANSLIM data on various stocks.  I get
>the rankings from IBD and enter them manually.  I enter 10/8/6/3/0 for
>rankings of A-E.  The Quant formulas are an attempt to combine all of the
>rankings into a single ranking that will highlight the strongest stocks.
>
>I don't (generally) post my spreadsheet publicly.  It is generally a work
>in progress, and I also have a bunch of other worksheets included like my
>CANSLIM performance, other investments, etc.  I went ahead and deleted the
>rest of the worksheets so you guys could get a copy and see what I'm doing.
>  I update the worksheet on most weekends, and try to make sure all of the
>data is no more than one month old.  This last weekend, I updated all of
>the EPS/RPS/SMR/Acc numbers since it's earnings season.
>
>The file I've uploaded is in a different order than the original list.
>After I generate the list, I do my own technical scan of each of the
>stocks.  The "Technical Chart Status" column is my notes as of this last
>weekend.  Then I re-sort the top 100 to put the longest bases on top,
>recent breakouts next, shorter bases in the middle, and stocks without
>bases at the bottom.  This gives me a watch list for the week.  I have
>bolded some stocks.  These are stocks that are closest to breakouts and
>warrant closer watching.  I try to review these several times during the
>day.  (Note that some stocks show well on the list, but I really don't care
>for the chart or something else about the stock.  SMTC is an example of one
>that I probably won't buy.)
>
>Note that I have 2 quant formulas I'm evaluating.  Both formulas combine
>EPS, RPS, SPR, Acc/Dist, and Sponsorship rankings.  The formula called "Old
>Quant" also gives credit for IGP rank (#1 gets more points than #2), while
>the new one "New Quant" doesn't.  I'm leaning towards sticking with the new
>formula, but only using the top 20 industry groups.
>
>Trying to keep this somewhat up-to-date has been quite a challenge.  I'm
>probably going to subscribe to DGO hoping I can accomplish this without
>much or all of the work, sometime in the near future.  I'm also very
>interested in what on-line screening tools IBD is adding to their website.
>I may wait on DGO until it becomes clear what capabilities they are really
>going to offer (in "early" summer).
>
>Enjoy.
>
>
>
>-
>

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


- -

Go to Jeff Salisbury LWGate Home Page.