counting a string of negative or positive numbers

[mcarrington]

These are daily performance figures. How would I calculate the mos
consecutive losing days and related to that, the largest drawdow
(cummulative performance of that streak of losing days). What about th
2nd and 3rd longest streaks and drawdowns? My real set of numbers i

1000, so eyeballing it on a chart doesn't work. I'm thinking I wil

need to use the sumif command, but haven't gotten any farther tha
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