Formula for max consecutive wins and loses

ChaosTrader63

New member
Joined
Nov 25, 2013
Messages
10
Reaction score
0
Points
0
Hello all! I am attaching my trading journal with an overview tab and a journal tab. I am attempting to calculate the max consecutive wins and the max consecutive loses onto the overview tab from the journal tab cell L. Can anyone help me with this? Thank you!

View attachment Help Book.xlsx
 
Try these:


=MAX(FREQUENCY(IF(Journal!$L$2:$L$200="WIN",ROW(Journal!$L$2:$L$200)),IF(Journal!$L$2:$L$200<>"WIN",ROW(Journal!$L$2:$L$200))))

and

=MAX(FREQUENCY(IF(Journal!$L$2:$L$200="LOSS",ROW(Journal!$L$2:$L$200)),IF(Journal!$L$2:$L$200<>"LOSS",ROW(Journal!$L$2:$L$200))))

each has to be confirmed with CTRL+SHIFT+ENTER not just ENTER.
 
NBVC yes that worked for me! I am such a newbie at this that the $ sign was not needed so I just figured that out to remove them and it came up great. Thank you very much!
 
Sorry about the cross posting! I didn't notice I posted that question here but at any cost I have the solution and formula needed so this posting can be closed. Thanks!
 
Back
Top