| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting a string of negative or positive numbers
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 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: http://www.excelforum.com/member.php...o&userid=21641 View this thread: http://www.excelforum.com/showthread...hreadid=500879 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| change cell from negative to positive | Excel Discussion (Misc queries) | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| Erf (the error function) for both negative and positive numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
