Problem in getting the XX50 strikes in OAT.
In this month, for NIFTY in the OAT XX50 strikes are not shown even after entering the value in BA2:BA22 cells because this month the Speculation is very high and there 96 strikes which are being traded. May be we will have a larger range in this month.
To fix the problem, Please goto the hidden sheet "SOData" and change the Forumulas as follows
In the cell L1 input the formula as follows
Code:
=ROUND(COUNTIF(L15:L200,">0")/2,0)+14
In the cell K1 input the formula as follows
Code:
=IF(COUNTIF(BA2:BA22,A3)>0, INDIRECT("L"&L1)-INDIRECT("L"&L1-1),( INDIRECT("L"&L1)-INDIRECT("L"&L1-1))*2)
In the Cell BE25 Input the formula as
Code:
=INDIRECT("L"&L1)-INDIRECT("L"&L1-1)
, which is used for MAX Pain Calculation