Hi....my first post here....will try to make it simple.
I have a trading system spreadsheet where I want to calculate Consecutive Day Wins / Loss, as well as the money won or loss by those consecutive days.
IF I would have valid data (call it a WIN or LOSS) EVERY day, I know how to do this in some way (maybe not the ideal way). BUT the problem I face is there are many days that there is no trade (no value win/loss), so the concept of consecutive is not really consecutive days, but consecutive days WITH TRADES. Not sure how to do this.
The real output I need is the MAX number of consecutive wins (and the $ it represents) as well as for losses.
I attached the example on the file to visualize it better.
Thanks a lot.
Bookmarks