Counts the number of consecutive times the formula evaluates to the streak type specified
formula: the formula to be executed in the loop. iterations: the number of times to execute the formula (up to 502) start: the starting value of CTR (default 0) increment: how much CTR is incremented for each iteration (default 1) streak: #Positive, #NotPositive, #Increasing, #NotIncreasing recent: set this to TRUE to stop when streak fails. Use FALSE to evaluate all iterations and find the longest streak.
Example
Find companies that have closed higher than previous day for 10 trading days in a row
When a streak ends does the tally reset and begin counting again or does it end without starting over?
For example if a company has had positive earnings for 3 years out of ten and on the fourth it has negative earnings before resuming being positive for the rest of the time period what is the streak number using recent="TRUE"?
LoopStreak by default is the most recent. Set the "recent" paramter to FALSE to calculate the longest streak.
So for example if the Bears lose 5 games in a row, then they win one, then lose 3:
Then the current loss streak is 3. The longest loss streak is 5
PS. the above assumes we use a function like LoopStreak("BearsLost(CTR)",9) which returns 1 if they lost, 0 otherwise. With CTR=0 being the last game they played.
Thank you Marco. Your first reply makes a lot of sense to me and I also get the second one since you mention the "false" setting, but the recent: "true" description threw me off a bit when I first read it. I think what threw me off is the first line in the "recent" description. I was expecting that the count would reset once a streak was interrupted but was not sure if stop here meant a literal stop or a reset.
I guess one could interpret a streak of 0 as the recent positive streak of Bear games but also a streak of one as the most recent positive streak. If it stops, then even if that streak got subsequently interrupted and is no longer positive the formula would yield a positive streak. If it resets it goes to zero. A reset to me would be more timely in practice and further differentiate it from loopsum.
In the Bears example, a "stop" would mean the most recent positive streak is one despite multiple recent loses. If it "resets" then it is zero as of the most recent period. I would expect the default setting to "reset" and give me a streak of zero since the recent losses would have reset the streak. Maybe I can do some tests to clarify this in my mind.
recent=true: function returns the most recent streak length. recent=false: returns the length of the longest streak by evaluating all the values in the loop.
The example with da Bears was confusing since it's not clear what formula is being evaluated. In the example I provided it would be "BearsLose(CTR)" which returns 1 if they lost, 0 otherwise. With CTR=0 being the last game they played.
Yes, zero otherwise makes perfect sense. Thanks Marco! With reset I just meant the count/streak. I get it now. I have started creating formulas using the function and they look quite promising. Thanks for the explanation.
I will be trying this out for the coming weeks hehe