PureBytes Links
Trading Reference Links
|
<x-html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.3105.105" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=840255618-12092000>First
set up a column that tests for a winner or loser. Then set up a
consecutive column that adds winners. Then total the consectutive with the
max function.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=840255618-12092000>
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=840255618-12092000><FONT
color=#0000ff face=Arial size=2><SPAN
class=840255618-12092000>CONSEC
</SPAN></FONT>TEST</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=840255618-12092000>=if(test=1, test today+ test
yesterday,0)
=if(win,1,0)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=840255618-12092000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=840255618-12092000>Max in
a Row</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=840255618-12092000>=max(consec)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=840255618-12092000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=840255618-12092000>Hope
this helps,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=840255618-12092000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=840255618-12092000>Michael</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=840255618-12092000></SPAN></FONT> </DIV>
<DIV> </DIV>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]<B>On Behalf Of </B>kevin
miles<BR><B>Sent:</B> Tuesday, September 12, 2000 12:00 PM<BR><B>To:</B>
metastocklist<BR><B>Subject:</B> Fw: Excell Question<BR><BR></FONT></DIV>
<DIV> </DIV>
<DIV style="FONT: 10pt arial">----- Original Message -----
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A
href="mailto:pompatis@xxxxxxxxxxxx" title=pompatis@xxxxxxxxxxxx>kevin miles</A>
</DIV>
<DIV><B>To:</B> <A href="mailto:realtraders@xxxxxxxxxxxxxxx"
title=realtraders@xxxxxxxxxxxxxxx>realtraders</A> </DIV>
<DIV><B>Sent:</B> Tuesday, September 12, 2000 10:59 AM</DIV>
<DIV><B>Subject:</B> GEN: Excell Question</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face="Book Antiqua">Greetings traders,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Book Antiqua">if any of you know of a way to return the maximum
consecutive entries in a column, please drop me a note. i would highly
appreciate your assistance.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Book Antiqua">i know of the max and min value functions (which
i use for largest win and largest loss) but i have not come up with a way to get
the max consecutive entries (wich i need for max number winners/losers in a
row).</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Book Antiqua">thanks in advance and good trading,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Book Antiqua">kevin</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>
</x-html>
|