Hey all!
Please find attached a spreadsheet.
Under "Outcome 3" tab you will see that colum "D" has the following words:
"LOSS" - "WIN" - "SCRATCH"
Under "Graph 3" there is a box "D4" this is a freely changeable value. It is currently set to "120" which means, I intend to take 120 "trades" over the next 12 months.
On the same tab there are "Year 1" through to "Year 4" charts and boxes.
In these boxes you will see "Losing Streak" and "Winning Streak".
Based upon the value I input to cell "D4" on "Graph 3" (which is currently 120) I'd like a formula that look at that range on "Outcome 3, Column D" and tell me over that period (120) what was my consecutive win and loss streak - I'd like the results to be place within the corresponding boxes.
Year 2's range in this particular scenario would be 120:240 of Column D... and same rules apply for year 3 and 4....
Appreciate anyone's time in advance!
Thanks!!
Bookmarks