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

RE: Excell Question



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.&nbsp; Then set up a 
consecutive column that adds winners.&nbsp; Then total the consectutive with the 
max function.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=840255618-12092000>&nbsp; 
</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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</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)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
=if(win,1,0)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=840255618-12092000></SPAN></FONT>&nbsp;</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>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=840255618-12092000>Michael</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=840255618-12092000></SPAN></FONT>&nbsp;</DIV>
<DIV>&nbsp;</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>&nbsp;</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>&nbsp;</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.&nbsp; i would highly 
appreciate your assistance.</FONT></DIV>
<DIV>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT face="Book Antiqua">thanks in advance and good trading,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face="Book Antiqua">kevin</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

</x-html>