software

These are daily performance figures. How would I calculate the most
consecutive losing days and related to that, the largest drawdown
(cummulative performance of that streak of losing days). What about
the 2nd and 3rd longest streaks and drawdowns? My real set of numbers
is gt;1000, so eyeballing it on a chart doesn't work. I'm thinking I
will need to use the sumif command, but haven't gotten any farther than
that. Thanks for any help you can provide.

Megan

0.32%
0.73%
0.61%
0.90%
-0.23%
0.41%
0.00%
0.24%
-0.07%
0.09%
-0.32%
0.46%
0.06%
-0.81%
0.53%
0.40%--
mcarrington
------------------------------------------------------------------------
mcarrington's Profile: www.excelforum.com/member.php...oamp;userid=21641
View this thread: www.excelforum.com/showthread...hreadid=500832Hi,

You query is not at all clear. Could you mail your excel file to me atquot;mcarringtonquot; wrote:

gt;
gt; These are daily performance figures. How would I calculate the most
gt; consecutive losing days and related to that, the largest drawdown
gt; (cummulative performance of that streak of losing days). What about
gt; the 2nd and 3rd longest streaks and drawdowns? My real set of numbers
gt; is gt;1000, so eyeballing it on a chart doesn't work. I'm thinking I
gt; will need to use the sumif command, but haven't gotten any farther than
gt; that. Thanks for any help you can provide.
gt;
gt; Megan
gt;
gt; 0.32%
gt; 0.73%
gt; 0.61%
gt; 0.90%
gt; -0.23%
gt; 0.41%
gt; 0.00%
gt; 0.24%
gt; -0.07%
gt; 0.09%
gt; -0.32%
gt; 0.46%
gt; 0.06%
gt; -0.81%
gt; 0.53%
gt; 0.40%
gt;
gt;
gt; --
gt; mcarrington
gt; ------------------------------------------------------------------------
gt; mcarrington's Profile: www.excelforum.com/member.php...oamp;userid=21641
gt; View this thread: www.excelforum.com/showthread...hreadid=500832
gt;
gt;