Calculating streaks of "WINS" & "LOSSES"?

[domgilberto]

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!!

[domgilberto]

---bump----

[Ron Coderre]

Here you go...try these ARRAY FORMULAS, completed by holding down CTRL and SHIFT when you press ENTER (instead of just pressing ENTER),
And by the way...These are NOT pretty.

On your Graph 3 tab

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Copy D60:D61 and
...paste into M60:M61
...paste into D87:D88
...paste into M87:M88

Is that something you can work with?

[domgilberto]

:O?

That's incredible! haha...

UPDATE: Forget that I got it working! Once again, amazing stuff!

I'll check to see if this is working and report back! :D

[domgilberto]

Ok, so I've check it out, pretty amazing!

Update: It's actually perfect! Thank you once again for your kindness!!