[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 http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT 
size=2>cell&nbsp;A1&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; 
{if possible hit, then value is 1}</FONT></DIV>
<DIV><FONT 
size=2>cell&nbsp;B1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</FONT><FONT 
size=2>=$A1&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; 
{is the&nbsp;value from A1 and is also the previous value}</DIV></FONT>
<DIV><FONT size=2>cell 
A2&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; 
{if possible hit, then value is 1, else 0}</FONT></DIV>
<DIV><FONT size=2>cell 
B2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</FONT><FONT size=2>=If($A2=1, $B1+$A2, $B1)</FONT></DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<DIV><FONT size=2>and fill the rest of column B</FONT><FONT 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT>&nbsp;</DIV>
<DIV><FONT size=2><BR>Regards,<BR>Ton Maas<BR><A 
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";>ms-irb@xxxxxxxxxxxxxxxx</A><BR>Dismiss the 
".nospam" bit (including the dot) when replying.<BR>Homepage&nbsp; <A 
href="http://home.planet.nl/~anthmaas";>http://home.planet.nl/~anthmaas</A></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=ltr 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> 
  <A title=pompatis@xxxxxxxxxxxx href="mailto:pompatis@xxxxxxxxxxxx";>kevin 
  miles</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A title=metastock@xxxxxxxxxxxxx 
  href="mailto:metastock@xxxxxxxxxxxxx";>metastocklist</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> dinsdag 12 september 2000 
  17:59</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> Fw: Excell Question</DIV>
  <DIV><BR></DIV>
  <DIV>&nbsp;</DIV>
  <DIV style="FONT: 10pt arial">----- Original Message ----- 
  <DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A 
  title=pompatis@xxxxxxxxxxxx href="mailto:pompatis@xxxxxxxxxxxx";>kevin 
  miles</A> </DIV>
  <DIV><B>To:</B> <A title=realtraders@xxxxxxxxxxxxxxx 
  href="mailto: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></BLOCKQUOTE></BODY></HTML>

</x-html>