NIFTY Options Trading by RAJ

[Maddy123789]

Before I explain it to you. Goto the "TradeAnalyser" sheet where you can analyse the Options Stretegy.

Enter a Debit Spread Strategy Say Buying 6100PE-6700CE

Just change the "VOLATILITY" and see the result for yourself.

Enter a Credit Spread Strategy Say Selling6100PE-6700CE

Just change the "VOLATILITY" and see the result for yourself.

Cant See a option of Debit Spread n Credit Spread

 

[healthraj]

Cant See a option of Debit Spread n Credit Spread

At this Rate I have to become a Full time Instructor and Charge you guys for the time I spend in explaining stuff

I think you have to figure it out. You have to utilize the Grey Cells and Input the values.

For example Let us say you are Selling 6100 PE.

Then enter the following

B1 = Sell Put
Strike Price = 6100
Underlying Price = Ignore - not used
Expiration Date = 26-Dec-13
price = 99
Volatility = 25.4%
Risk Free Rate = Leave it as 10%
Dividend Yield = Leave it as 0%
Days Till Expiration = Right now it is 23
Position Quantity = Enter the quantity you are selling 100 for 2 lots

Also Enter the Start Price say 5900
Increment as say 50

Also enter the similar value for say 6700CE in Cells E1 to E11

Now Look at the Cells (Total) in the table below against each Strike Price
Whatver cells you see in Black is in Profit. If the Cells indicate thevalues in Red then that means for the strategy you will be in loss if it moves to that Strike price

 

[healthraj]

Yesterday ICICIBANK given 1100 res..... Low made today 1063

haha....

Now 1060 support strong

Super... So when you make a decision and see it working I think you are haha. All the best. Please continue

 

[anup]

As the VIX has dropped can we buy options??

 

[healthraj]

NIFTY Credit Spread.

NIFTY I think has consolidated around 6200 in the last 3 days. The INDIAVIX is also stable around the current Level. So tomorrow we can Expect a Turn around and NIFTY might move up.

So those who Want to Trade Pairs can SELL the Pair in the MAX COI which is the 6100PE-6700CE for 116.45. If NIFTY Moves UP to say 6280, and if the VIX goes down this Pair might give minimum 30 points profit. If it moves below 6140 SPOT, then close this Pair

The VIX indicated in the morning is below 24 and the pair 6100-6700 which was opened at 116.5 Yesterday and today traded around 125 is now at 106 - 10 points profit. So the Options I think are being SOLD now.

Those who sold the Pair 6100-6700 can book 50% profit now for 11 points profit. Close the Rest if the Market moves below 6180 SPOT. Hold it otherwise

 

[VJAY]

It is working for me. If you want to see XX50 strikes on main page then you need to enter "NIFTY" 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

Thanks relish,
Is need to enter NIFTY in all cells from BA2-BA15?!!

 

[healthraj]

As the VIX has dropped can we buy options??

ATM and ITM options should be fine I think. But OTM options should be avoided.

 

[Relish]

Thanks relish,
Is need to enter NIFTY in all cells from BA2-BA15?!!

NO Only once if you want XX50 strikes if not Then no need to write.

 

[dprikka]

Super... So when you make a decision and see it working I think you are haha. All the best. Please continue

Thanks Raj sir

I am making this decision just bcoz of God's grace and You.

Thanks for teaching me OI.

 

[babumehta]

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

Dear Relishsir, can you upload your excel sheet?