NIFTY Options Trading by RAJ

[healthraj]

Today market opens with a Small Gap down. The PIVOT in the 60 min chart is at 6177. So if 6177 is broken can go till 6095. In the lower timeframes the Support is around 6190. So try to Sell around 6190. Since the MAX Pain is at 6150, probably 6150 would be Tested today and if the VIX shows some change and indicates a BUY then you can BUY for Reversal around 6150-6170.

The Pivot is at 6167 after the opening. So it should first test the Pivot at 6167. NIFTY came above 6190 to take the SELL positions

 

[adg123]

VIX increases continuously - consecutive 3 days...
Waiting for sell..........

 

[anup0212]

Hey Raj, this seesaw is going to continue also...do you have any suggestion for stock option ? better to look for it...
Thanks,
-Anup0212-

 

[healthraj]

VIX increases continuously - consecutive 3 days...
Waiting for sell..........

Yes Agreed. Today it has gone up by another 2.5%. So overall around 25% in the last four days has gone UP from the lows of 20.2 to today 25.4. For any BUY signal it needs to GO below the Support of 24

 

[sach007]

No I don't think any other update is required. Probably others can comment whether it is working for them.

Relish, Is the update working and are you getting the Right Strikes now?

That Formulas entered.. but where to check that we get the right strikes.. or not.. on MAIN PAGE?

Or SODATA? COZ in SODATA.. even before entering formula... that sheet showing all strikes...

 

[healthraj]

That Formulas entered.. but where to check that we get the right strikes.. or not.. on MAIN PAGE?

Or SODATA? COZ in SODATA.. even before entering formula... that sheet showing all strikes...

Please check the Main page

 

[Maddy123789]

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

 =ROUND(COUNTIF(L15:L200,">0")/2,0)+14

In the cell K1 input the formula as follows

 =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

 =INDIRECT("L"&L1)-INDIRECT("L"&L1-1)

, which is used for MAX Pain Calculation

Dear raj,
When insert 2nd formula in K1 value not active....is need any other modification?

M Also facing the same problem...

 

[dprikka]

Me also Raj sir

 

[dprikka]

Still showing 6200 max pain

 

[Relish]

Me also Raj sir

M Also facing the same problem...

That Formulas entered.. but where to check that we get the right strikes.. or not.. on MAIN PAGE?

Or SODATA? COZ in SODATA.. even before entering formula... that sheet showing all strikes...

Dear raj,
When insert 2nd formula in K1 value not active....is need any other modification?

It is working for me. If you want to see XX50 strikes on main page then you need to enter "NIFTY" only once in sheet "SOData" in column "BA2 - BA15".

If you did not want to see XX50 strikes then delete from there.

First and second code work good but third code which we put in BE25 is empty cell before putting code; does not know it effect max pain or not since if we delete it no effect on max pain.

Max pain @6200; COI@6300-6000 and Max OI @6500-6000 @10.13 for me . is it matches with other? Thank's