RE: [CANSLIM] MSN Money Screener Search

From: "Katherine Malm" <kmalm@earthlink.net>
Subject: RE: [CANSLIM] MSN Money Screener Search
Date: Sun, 12 Jan 2003 08:55:41 -0600
Next Article (by Author): RE: [CANSLIM] what happened to the NYSE Composite Index numbers? "Katherine Malm"
Previous Article (by Author): Re: [CANSLIM] what happened to the NYSE Composite Index numbers? Gene Ricci
Articles sorted by: [Date] [Author] [Subject]
This is a multi-part message in MIME format.

- ------=_NextPart_000_0000_01C2BA18.62D19900
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi John,

You won't be able to duplicate my results on MSN because my forward growth rates
come from VectorVest and because I'm not sure how MSN calculates their Relative
Strength Rankings. DGO, HGS and my site use a price weighted 12 month ranking
which puts 40% of the weight on the most recent quarter and 20% weight on each
of the preceding quarters.

MSN, like DGO's screener, has an infuriating habit of limiting the number of
results from any search to < 200. You'll have to break down a broad-based search
like this into 2 parts to pick up all the stocks for RS>=60. Each time you run
it, you have to check that the query has not cut off any of your results, then
adjust the break point in the RS to accommodate a result of <200 stocks. This
particular MSN clone search resulted in 317 names, so I'm afraid the overlap is
not that great. In comparing my personal CANSLIM Hunting screen to the MSN
screen below, there were 179 names in common, 332 names on my list but not on
the MSN list, and 138 names on the MSN list but not on my Hunting list. I have
used the "EPS Growth Next Yr" as a proxy for the VectorVest forward growth rate,
but you might want to experiment a bit with their other available forward
estimated growth rates such as "Next Yr Growth Rate." I have a friend who uses
this particular field and sets is to a slightly lower rate (10-12.5 or so).

      EPS Growth Next Yr >= 15
      Last Price >= 6
      Avg. Daily Vol. Last Month >= 30000
      Last Price >= 0.85*50-Day Moving Average
      Last Price >= 200-Day Moving Average
      12-Month Relative Strength >= 60
      12-Month Relative Strength <= 84



      EPS Growth Next Yr >= 15
      Last Price >= 6
      Avg. Daily Vol. Last Month >= 30000
      Last Price >= 0.85*50-Day Moving Average
      Last Price >= 200-Day Moving Average
      12-Month Relative Strength >= 85

      --Katherine

  -----Original Message-----
  From: owner-canslim@lists.xmission.com
[mailto:owner-canslim@lists.xmission.com]On Behalf Of John Calkins
  Sent: Sunday, January 12, 2003 12:11 AM
  To: canslim@lists.xmission.com
  Subject: [CANSLIM] MSN Money Screener Search


  Katherine,

  Could you show me on how to replicate some of your screens on MSN.  I'm not
sure if I understand it's limitations.  I don't think it will let me enter
percentages.

  jc



http://moneycentral.msn.com/investor/invsub/finder/finderx.asp?Query=SV1QF219Z04
L15ZF3Z04L6ZF114Z04L30000ZF253Z04L60ZF250Z03F250ZF251Z04F251Z&Name=KMclone1&Tick
ers=200


- ------=_NextPart_000_0000_01C2BA18.62D19900
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D593152507-12012003>Hi John,</SPAN></DIV>
<DIV><SPAN class=3D593152507-12012003></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D593152507-12012003>You won't be able to duplicate my =
results on=20
MSN because my forward growth rates come from VectorVest and because I'm =
not=20
sure how MSN calculates their Relative Streng</SPAN><SPAN=20
class=3D593152507-12012003>th Rankings. DGO, HGS and my site use a price =
weighted=20
12 month ranking which puts 40% of the weight on the most recent quarter =
and 20%=20
weight on each of the preceding quarters.</SPAN></DIV>
<DIV><SPAN class=3D593152507-12012003></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D593152507-12012003>MSN, like DGO's screener,&nbsp;has =
an=20
infuriating habit of limiting the number of results from any search to =
&lt; 200.=20
You'll have to break down a broad-based search like this into 2 parts to =
pick up=20
all the stocks for RS&gt;=3D60. Each time you run it, you have to check =
that the=20
query has not cut off any of your results, then adjust the break point =
in the RS=20
to accommodate a result of &lt;200 stocks. This particular MSN clone =
search=20
resulted in 317 names, so I'm afraid the overlap is not that great. In =
comparing=20
my personal CANSLIM Hunting screen to the MSN screen below, there were =
179 names=20
in common, 332 names on my list but not on the MSN list, and 138 names =
on the=20
MSN list but not on my Hunting list. I have used the "EPS Growth Next =
Yr" as a=20
proxy for the VectorVest forward growth rate, but you might want to =
experiment a=20
bit with their other available forward estimated growth rates such as =
"Next Yr=20
Growth Rate." I have a friend who uses this particular field and sets is =
to a=20
slightly lower rate (10-12.5 or so).</SPAN></DIV>
<DIV>&nbsp;</DIV>
<DIV>
<TABLE style=3D"WIDTH: 191pt; BORDER-COLLAPSE: collapse" cellSpacing=3D0 =

cellPadding=3D0 width=3D255 border=3D0 x:str>
  <COLGROUP>
  <COL style=3D"WIDTH: 191pt; mso-width-source: userset; mso-width-alt: =
9325"=20
  width=3D255>
  <TBODY>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; WIDTH: 191pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; =
BACKGROUND-COLOR: transparent"=20
    width=3D255 height=3D17><FONT face=3DArial size=3D2>EPS Growth Next =
Yr &gt;=3D=20
      15</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2>Last Price &gt;=3D =
6</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial><FONT size=3D2>Avg. Daily Vol. Last =
Month &gt;=3D=20
      30<SPAN =
class=3D593152507-12012003>000</SPAN></FONT></FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2>Last Price &gt;=3D =
0.85*50-Day Moving=20
      Average</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2>Last Price &gt;=3D 200-Day =
Moving=20
      Average</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2>12-Month Relative Strength =
&gt;=3D=20
      60</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2>12-Month Relative Strength =
&lt;=3D=20
      84</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2></FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2></FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2></FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2>EPS Growth Next Yr &gt;=3D =
15</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2>Last Price &gt;=3D =
6</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial><FONT size=3D2>Avg. Daily Vol. Last =
Month &gt;=3D=20
      30<SPAN =
class=3D593152507-12012003>000</SPAN></FONT></FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2>Last Price &gt;=3D =
0.85*50-Day Moving=20
      Average</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17><FONT face=3DArial size=3D2>Last Price &gt;=3D 200-Day =
Moving=20
      Average</FONT></TD></TR>
  <TR style=3D"HEIGHT: 12.75pt" height=3D17>
    <TD=20
    style=3D"BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: =
#ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: =
transparent"=20
    height=3D17>
      <DIV><FONT face=3DArial size=3D2>12-Month Relative Strength =
&gt;=3D=20
      85</FONT></DIV>
      <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
      <DIV><SPAN class=3D593152507-12012003><FONT face=3DArial=20
      =
size=3D2>--Katherine</FONT></SPAN></DIV></TD></TR></TBODY></TABLE></DIV>
<BLOCKQUOTE>
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B>=20
  owner-canslim@lists.xmission.com=20
  [mailto:owner-canslim@lists.xmission.com]<B>On Behalf Of </B>John=20
  Calkins<BR><B>Sent:</B> Sunday, January 12, 2003 12:11 =
AM<BR><B>To:</B>=20
  canslim@lists.xmission.com<BR><B>Subject:</B> [CANSLIM] MSN Money =
Screener=20
  Search<BR><BR></FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>Katherine,</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>Could you show me on how to replicate =
some of=20
  your screens on MSN.&nbsp; I'm not sure if I understand it's=20
  limitations.&nbsp; I don't think it will let me enter=20
percentages.</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>jc</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV><A=20
  =
href=3D"http://moneycentral.msn.com/investor/invsub/finder/finderx.asp?Qu=
ery=3DSV1QF219Z04L15ZF3Z04L6ZF114Z04L30000ZF253Z04L60ZF250Z03F250ZF251Z04=
F251Z&amp;Name=3DKMclone1&amp;Tickers=3D200">http://moneycentral.msn.com/=
investor/invsub/finder/finderx.asp?Query=3DSV1QF219Z04L15ZF3Z04L6ZF114Z04=
L30000ZF253Z04L60ZF250Z03F250ZF251Z04F251Z&amp;Name=3DKMclone1&amp;Ticker=
s=3D200</A><BR><BR></BLOCKQUOTE></BODY></HTML>

- ------=_NextPart_000_0000_01C2BA18.62D19900--



- -
- -To subscribe/unsubscribe, email "majordomo@xmission.com"
- -In the email body, write "subscribe canslim" or
- -"unsubscribe canslim".  Do not use quotes in your email.
Go to Jeff Salisbury LWGate Home Page.