NIFTY Options Trading by RAJ

How do you use OAT tool?

  • For Intraday Naked Options trading

    Votes: 58 37.7%
  • For Intraday Pair trading of Options

    Votes: 27 17.5%
  • For Intraday Futures trading

    Votes: 18 11.7%
  • For Positional Naked Options trading

    Votes: 35 22.7%
  • For Positional Pair trading of options

    Votes: 29 18.8%
  • For Positional Futures trading

    Votes: 11 7.1%
  • To trade in Cash market

    Votes: 13 8.4%
  • Overall trading has improved with OAT

    Votes: 27 17.5%
  • Understanding of Options has improved with OAT

    Votes: 57 37.0%

  • Total voters
    154
  • Poll closed .
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

Well-Known Member
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

Well-Known Member
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

Well-Known Member
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?!!:confused:
 
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?
 

Similar threads