|
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.4207.2601" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Kevin,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I don't know of a direct function that does
this. </FONT></DIV>
<DIV><FONT face=Arial size=2>A soultion that I've used in the past is to set
</FONT></DIV>
<DIV><FONT face=Arial size=2>up tracking columns, often on another sheet
of</FONT></DIV>
<DIV><FONT face=Arial size=2>in a hidden column.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>These colums cells generally are if statement
</FONT></DIV>
<DIV><FONT face=Arial size=2>tests </FONT><FONT face=Arial size=2>set for either
cumulative counts or starting </FONT></DIV>
<DIV><FONT face=Arial size=2>over at 1 if the test is not met.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If it gets too complicated for an approach like
that </FONT></DIV>
<DIV><FONT face=Arial size=2>then I have to resort to VBA.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>John</FONT></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> Tuesday, September 12, 2000 10:59
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Fw: Excell Question</DIV>
<DIV><BR></DIV>
<DIV> </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> </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></BLOCKQUOTE></BODY></HTML>
</x-html>
|