Dear Raj,
I have made a small change in the formula which finds the MAX change in OI because ,
(1) The original formula finds the MAX CHNG OI , but if there are more than 1 strike with the same change, then it adds those strikes and gives the output !!
(2) MAX CHNG can be -ve also, so if suppose there are 2 strikes with change of -125 and -1000 then the MAX function doesnt give a correct output !! Instead of giving -1000 as the MAX change it gives -125 !!
So , the change is as follows :
original formula :
=MAX($C$15:$C$200)
rectified formula: =IF(ABS(MAX($C$15:$C$200))>ABS(MIN($C$15:$C$200)),(MAX($C$15:$C$200)),(MIN($C$15:$C$200)))
So,here i could overcome the 2nd problem by changing the formula ,but couldnt rectify the 1st !!
If anybody can do that , then plz do the needful !!
Happy Diwali to all members,Modertors
God bless u !
Regards !!