Re: [CANSLIM] Leaders List Spreadsheet

From: asosis@ca.ibm.com
Subject: Re: [CANSLIM] Leaders List Spreadsheet
Date: Wed, 3 May 2000 10:27:52 -0400

Next Article (by Date): [CANSLIM] Definition of base and pivot point Carter Diggs
Previous Article (by Date): [CANSLIM] Accessing the discussion canslim archives... owner-canslim@xmission.com (Jeff Salisbury)
Next in Thread: Re: [CANSLIM] Leaders List Spreadsheet "Dave Massaglia"
Articles sorted by: [Date] [Author] [Subject]

Earl, thank you.

Anna


Earl Setser <esetser@csolutions.net> on 05/03/2000 09:02:45 AM

Please respond to canslim@lists.xmission.com

To:   canslim@xmission.com
cc:
Subject:  [CANSLIM] Leaders List Spreadsheet




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.



- -





- -

Go to Jeff Salisbury LWGate Home Page.