I am trying to find stocks that have met a particular condition in the past and have moved up at least 50% since the condition was met . The code works for the stock i know has moved up, but i would like to find all stocks that have moved up at least 50% in 100 days of condition?
Any suggestions on how proceed?
HVECon = Highest( Volume );
HVE = IIf( Volume >= HVECon , True, False );
PriceatHVE = ValueWhen(HVE,Close);
PriceChange = (Close - PriceatHVE)/PriceatHVE * 100;
HighestPChange = (LastValue(Close) - PriceatHVE)/PriceatHVE * 100;
Filter = HVE;
AddColumn(Close,"Close");
AddColumn(PriceatHVE,"PriceatHVE");
AddColumn(Volume,"HVECon");
//AddColumn(PriceChange,"PriceChange%");
AddColumn(LastValue(Close) ,"HighClose");
AddColumn(HighestPChange,"HighestPChange%");