PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>Friday GPS closed above the Bull Fear Level and therefore is a
buy. GPS is a stellar performer is this system; wish I had funds available
for it myself. The system annual percentage gain is an incredible 6544%
vs. Buy and Hold of 4987% (unbelievable). However, caveat emptor as the
system is less than 50% in simple won/loss record (25 wins and 33 losses) since
1980. But GPS is in a sector (Retail) that was getting a lot of good talk
a couple of weeks ago, so it may be ready to go.</FONT></DIV>
<DIV><FONT size=2></FONT><FONT size=1></FONT> </DIV>
<DIV><FONT size=2><FONT size=1></FONT>
<TABLE border=0 cellPadding=2 cellSpacing=0 width=539>
<TBODY>
<TR>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P>
<DIV><FONT size=1></FONT>Good trading</DIV>
<DIV> </DIV>
<DIV><FONT style="BACKGROUND-COLOR: #ffffff">Jeff</FONT></DIV></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=left><FONT size=1>My Positions</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>Stock</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>Entry Date</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>Price</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>Exit Date</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>Price</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>% Gain/Loss</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>AOL</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>09/27/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>99.50</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>148.75</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>49.50</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>BBY</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>10/08/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>65.94</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>10/15/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>61.5</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>-6.73</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>AMD</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>10/26/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>19.3125</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>26.56</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>37.53</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>B&B Fear
Positions</FONT></FONT><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>Entry Date</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>Stock</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>Price</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>Exit Date</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>Price</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>% Gain/Loss</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>07/02/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>MU</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>43.00</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>10/13/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>67.75</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>57.56</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>08/16/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>EMC</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>59.44</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>10/21/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>63</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>5.99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>09/07/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>AEOS</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>46.44</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>10/18/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>43.12</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>-7.15</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>09/28/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>CMGI</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>98.00</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>101.5</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>3.57</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>09/30/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>CSCO</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>67.38</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>10/18/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>66.94</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>-0.65</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>10/29/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>CSCO</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>72.50</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>83.44</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>15.09</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>11/03/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>MU</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>76.5</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>73.5</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>-3.92</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>11/04/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>DELL</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>42.13</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>41.75</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%><FONT color=#000000>
<P align=center><FONT size=1>-0.90</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD></TR>
<TR>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>11/08/99</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>MSPG</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>28.13</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%>
<P><FONT size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=16%><FONT color=#000000>
<P align=center><FONT size=1>28.69</FONT></FONT><FONT
size=1></FONT></P><FONT size=1></FONT></TD>
<TD bgColor=#ffffff height=16 width=20%>
<P align=center><FONT color=#000000 face=""
size=1>1.99</FONT></P></TD></TR></TBODY></TABLE></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2> Disclaimer: The writer
assumes no liability for<BR> losses related to
readers buying or selling stocks that<BR> are
listed in its posts. This post is<BR> not,
nor should be construed as investment advice.
Investing<BR> involves risk. Readers should
do their own research on<BR> any investment,
and agree to take full responsibility for<BR>
their investment decisions. </FONT></DIV></BODY></HTML>
</x-html>From ???@??? Mon Nov 15 06:47:17 1999
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.8.7/8.8.7) with ESMTP id HAA25305
for <neal@xxxxxxxxxxxxx>; Mon, 15 Nov 1999 07:49:49 -0800
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id GAA24333
for metastock-outgoing; Mon, 15 Nov 1999 06:39:10 -0700
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
by listserv.equis.com (8.8.7/8.8.7) with ESMTP id GAA24330
for <metastock@xxxxxxxxxxxxxxxxxx>; Mon, 15 Nov 1999 06:39:07 -0700
Received: from hme0.mailrouter01.sprint.ca (hme0.mailrouter01.sprint.ca [207.107.250.16])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id GAA16077
for <metastock@xxxxxxxxxxxxx>; Mon, 15 Nov 1999 06:44:45 -0700 (MST)
Received: from default (spc-isp-ott-uas-12-26.sprint.ca [209.103.35.77])
by hme0.mailrouter01.sprint.ca (8.8.8/8.8.8) with SMTP id IAA21526
for <metastock@xxxxxxxxxxxxx>; Mon, 15 Nov 1999 08:29:37 -0500 (EST)
Message-ID: <001a01bf2f6d$5fc749a0$4d2367d1@xxxxxxx>
From: "Walter Lake" <wlake@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <003601bf2ea2$5bd79d20$148a6395@xxxxxxx> <382FD85E.CD27186F@xxxxxxxxxxxxxxxxx>
Subject: Re: formulas
Date: Mon, 15 Nov 1999 08:28:44 -0500
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
Hi Lars
This book is a more intermediate book, in the line of Walkenbach but more
smoothly written. No sudden leaps in coding to make you scratch your head.
Whereas the "Excel 97 Developer's Handbook" published by Microsoft is a
"cowboy" book ... a real "no-holds barred" ... lets party with Excel type
book. It assumes that you know what you are doing at all levels. It's much
more advanced.
Will read the chapters again and then post the "cells" and "range" methods
for VBA coding of formulas, in addition to the "name" method.
Best regards
Walter
----- Original Message -----
From: Lars Andersson <Lars.Andersson@xxxxxxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Monday, November 15, 1999 4:54 AM
Subject: Re: formulas
| Hi Walter.
| I know what you mean. I have not learn this yet and I donīt think I ever
do that. The book you mention seems to be very good
| so perhaps I buy it.
| Thatīs not fun when you get 65 000 + rows filled just wonder how to do
this.
| Best regards.
| Lars
|
| Walter Lake skrev:
|
| > Hi Lars
| >
| > Glad that you liked the coding.
| >
| > One of the problems I've been working with is learning different ways to
| > code Excel "in-cell" formulas into VBA code. For example one of Ton's
| > Profit/Loss Index formulas:
| >
| > "... -Where the Formula for the "Units" (col I) cell on Row 3 is:
| > =ABS(IF(A3>C3;((A3)/C3)+1;IF(A3<C3;((-C3)/A3)-1;0))) ..."
| >
| > Using the Macro Recorder and changing the ";" to "," you get this:
| > ActiveCell.FormulaR1C1 =
| >
"=ABS(IF(RC[-7]>RC[-5]((RC[-7])/RC[-5])+1,IF(RC[-7]<RC[-5]((-RC[-5])/RC[-7])
| > -1,0)))"
| >
| > Not many of the reference books i.e., Walkenbach, WROX, Steve Roman, 21
| > Days, etc. have much on writing formulas in VBA code. A new book "Excel
2000
| > Developer's Handbook" by Marion Cottingham at
| >
| > www.sybex.com
| > http://www.sybex.com/cgi-bin/rd_bookpg.pl?2328back.html
| >
| > Has the following chapters which are quite complete:
| >
| > "Part II: Naming Formulas, Functions, and Constants
| > Chapter 4: All About Formulas and Functions
| > Chapter 5: But Names Will Never Hurt Me!
| > Chapter 6: Using Constants
| > etc ..."
| >
| > In Chapter 5, the author writes extensively about "naming" the formula
when
| > you enter it into Excel and then using the name in your VBA code. Lots
of
| > good ideas especially for Metastocker's who have indicator code etc. to
| > write into Excel. It also makes documenting much easier.
| >
| > Of course, it's the "filling down" part that always messes me up and I
end
| > up with 65,000 + rows filled <G>.
| >
| > Best regards
| >
| > Walter
|
|