[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

B&B Fear Alert



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.&nbsp; GPS is a stellar performer is this system; wish I had funds available 
for it myself.&nbsp; The system annual percentage gain is an incredible 6544% 
vs. Buy and Hold of 4987% (unbelievable).&nbsp; However, caveat emptor as the 
system is less than 50% in simple won/loss record (25 wins and 33 losses) since 
1980.&nbsp; 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>&nbsp;</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>&nbsp;</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&amp;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>&nbsp;</DIV>
<DIV><FONT size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Disclaimer:&nbsp; The writer 
assumes no liability for<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; losses related to 
readers buying or selling stocks that<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; are 
listed in its posts.&nbsp; This post is<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; not, 
nor should be construed as investment advice.&nbsp; 
Investing<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; involves risk.&nbsp; Readers should 
do their own research on<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; any&nbsp; investment, 
and agree to take full responsibility for<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
their investment decisions.&nbsp; </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
|