How can we count, how often a stock have loss more than 25 Percent from the high of the last 1000 days?
My thoughts are inspired from: Counting number of times an indicator has triggered - #2 by portfoliobuilder
but it doesn't work for me at moment:
Filter =1;
HighestValue = Ref(HHV(High,1000),-1);
Condition = HighestValue * 0.75 < C ;
CountConditions = Cum(Condition);
FirstConditionBar = ValueWhen(CountConditions == 1 AND Condition, BarIndex());
AddColumn(FirstConditionBar, "FirstConditionBar", 1);
My goal ist to check out how stable a stock has moved in the past and show it in exploration. How is this possible?