Results 1 to 5 of 5

Thread: Formula for max consecutive wins and loses

  1. #1

    Formula for max consecutive wins and loses



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

    Help Book.xlsx

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    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.


  3. #3
    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!

  4. #4
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,655
    Articles
    0
    Excel Version
    2010 on Xubuntu

  5. #5
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •