Lowvalue=LLV(L,220); Filter = DateNum()==1061227 AND Close/Lowvalue*100 <= 110; // this filter is to get only active securities and also only those // which are close to year's lows ie within 10%. AddColumn(Lowvalue,"Lowest",1.2); AddColumn(C," Today'sclose",1.2); AddColumn((Close/Lowvalue*100)-100," % Change",1.2); // this column is for sorting the results.
LowDate = ValueWhen(L < Ref(LLV(L,200),-1),DateTime()); AddColumn(LowDate,"",formatDateTime); // now this is where i want help.. I want to know the date of the lowvalue. Any kind soul ???
