Filter list stocks highest rising and highest decline in time period / Please helps

#1
Hi All!

I am trying to create a formulas to stocks highest rising and highest decline in time period. I do as bellow:

Filter = 1;
Vola = 100*(HHV(C,20)-LLV(C,20))/HHV(C,20);
AddColumn(Vola,"% Valolity");

Really this formula only list the highest volatility stock and it dont know the highest rising rate is rising or declining.

Please kindly helps me to solve this problem.

Thanks you a lot
 

Similar threads