RE: re[2]: Fundamental Philosophies (was: [CANSLIM] NXTL, SXT)

From: "Katherine Malm" <kmalm@earthlink.net>
Subject: RE: re[2]: Fundamental Philosophies (was: [CANSLIM] NXTL, SXT)
Date: Wed, 11 Dec 2002 07:45:08 -0600
Next Article (by Date): [CANSLIM] FYI - IBD monthly subscription "rolf hertenstein"
Previous Article (by Date): Re: re[2]: Fundamental Philosophies (was: [CANSLIM] NXTL, SXT) AJAskey@aol.com
Top of Thread: Re: re[2]: Fundamental Philosophies (was: [CANSLIM] NXTL, SXT) AJAskey@aol.com
Articles sorted by: [Date] [Author] [Subject]
This is a multi-part message in MIME format.

- ------=_NextPart_000_000A_01C2A0E9.3A1453B0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Hi Andy,

By hand? Heavens no! I'm like you...I've written an extensive set of macros that
pulls data from several free and paid sources. It takes me about 10 minutes each
evening to click a few buttons and then update my entire spreadsheet which
includes both technical and fundamental criteria. I keep the last year's
price/volume info on each stock so that I can calculate moving averages, U/D
volumes, accum/distribution, etc. (I use, for example, Retriever, to pull the
price/volume for new stocks added to the spreadsheet each week.) I make
extensive use of the Custom View feature within Excel to look at subsets of
information on the stocks. Probably the biggest difference in our approach is
that I don't preselect stocks to go onto the list except by minimum price and
average volume. ($6/30K is the floor and its designed for minimum liquidity more
than anything else.). That way, I can look at what's moving whether or not it
meets all my personal standards for a buyable candidate. After many years of
keeping a "master watchlist" of stocks I found through various sources, I
switched to this approach in late 2000. Since all stocks in an industry are
listed, for example, I can easily perform industry analysis and find which
stocks are also moving with the stock in question. This eliminates all my
personal biases and keeps me from missing good stocks that may not have caught
my eye on a list or in an article somewhere. It also helps me to ask "what if,"
to look at the preponderance of evidence on a stock and to keep from eliminating
good candidates by using overly restrictive filtering criteria to generate the
master watchlist itself.

Katherine
  -----Original Message-----
  From: owner-canslim@lists.xmission.com
[mailto:owner-canslim@lists.xmission.com]On Behalf Of AJAskey@aol.com
  Sent: Wednesday, December 11, 2002 7:29 AM
  To: canslim@lists.xmission.com
  Subject: Re: re[2]: Fundamental Philosophies (was: [CANSLIM] NXTL, SXT)


  My spreadsheet is a combo of Stock Investor Pro and a couple excel macros.  It
takes only about 5-10 to generate that output for any set of symbols.

  Katherine,

  I am interested in how you generate your data.  Did you write some software to
compile all of that info or do you do everything by hand?

  Andy

  In a message dated 12/10/2002 10:37:37 AM Central Standard Time,
kmalm@earthlink.net writes:



    The spreadsheet is Andy's handiwork. My understanding is that he uses the
    AAII (Stock Investor Pro) program to collect the data, though I'll leave it
    to him to confirm that when he next checks his list email.




- ------=_NextPart_000_000A_01C2A0E9.3A1453B0
Content-Type: text/html;
	charset="US-ASCII"
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=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D500363013-11122002>Hi Andy,</SPAN></DIV>
<DIV><SPAN class=3D500363013-11122002></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D500363013-11122002>By hand? Heavens no! I'm like =
you...I've=20
written an extensive set of macros that pulls data from several free and =
paid=20
sources. It takes me about 10 minutes each evening to click a few =
buttons and=20
then update my entire spreadsheet which includes both technical and =
fundamental=20
criteria. I keep the last&nbsp;year's&nbsp;price/volume info&nbsp;on =
each stock=20
so that I can calculate moving averages, U/D volumes, =
accum/distribution, etc.=20
(I use, for example, Retriever, to pull the price/volume for new stocks =
added to=20
the spreadsheet each week.)&nbsp;I make extensive&nbsp;use of the Custom =
View=20
feature within Excel to look at subsets of information on the stocks. =
Probably=20
the biggest difference in our approach is that I don't preselect stocks =
to go=20
onto the list except by minimum price and average volume. ($6/30K is the =
floor=20
and its designed for minimum liquidity more than anything else.). That =
way, I=20
can look at what's moving whether or not it meets all my personal =
standards for=20
a buyable candidate. After many years of keeping a "master watchlist" of =
stocks=20
I found through various sources, I switched to this =
approach&nbsp;in&nbsp;late=20
2000. Since all stocks in an industry are listed, for example, I can =
easily=20
perform industry analysis and find which stocks are also moving with the =
stock=20
in question. This eliminates all my personal biases and keeps me from =
missing=20
good stocks that may not have caught my eye on a list or in an article=20
somewhere. It also helps me to ask "what if," to look at the =
preponderance of=20
evidence on a stock and to keep from eliminating good candidates by =
using overly=20
restrictive filtering criteria to generate the master watchlist=20
itself.</SPAN></DIV>
<DIV><SPAN class=3D500363013-11122002></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D500363013-11122002>Katherine</SPAN></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=20
  </B>AJAskey@aol.com<BR><B>Sent:</B> Wednesday, December 11, 2002 7:29=20
  AM<BR><B>To:</B> canslim@lists.xmission.com<BR><B>Subject:</B> Re: =
re[2]:=20
  Fundamental Philosophies (was: [CANSLIM] NXTL, =
SXT)<BR><BR></FONT></DIV><FONT=20
  face=3Darial,helvetica><FONT size=3D2>My spreadsheet is a combo of =
Stock Investor=20
  Pro and a couple excel macros.&nbsp; It takes only about 5-10 to =
generate that=20
  output for any set of symbols.<BR><BR>Katherine,<BR><BR>I am =
interested in how=20
  you generate your data.&nbsp; Did you write some software to compile =
all of=20
  that info or do you do everything by hand?<BR><BR>Andy<BR><BR>In a =
message=20
  dated 12/10/2002 10:37:37 AM Central Standard Time, =
kmalm@earthlink.net=20
  writes:<BR><BR><BR>
  <BLOCKQUOTE=20
  style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid; MARGIN-RIGHT: 0px"=20
  TYPE=3D"CITE">The spreadsheet is Andy's handiwork. My understanding is =
that he=20
    uses the<BR>AAII (Stock Investor Pro) program to collect the data, =
though=20
    I'll leave it<BR>to him to confirm that when he next checks his list =

    =
email.<BR></BLOCKQUOTE><BR><BR></BLOCKQUOTE></FONT></FONT></BODY></HTML>

- ------=_NextPart_000_000A_01C2A0E9.3A1453B0--



- -
- -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.