NIFTY Options Trading by RAJ

[amitrandive]

Every time if you open this excel file first will ask enable or disable option. If you should choose enable . After that every 3 minutes ones this file will update automatically.

(or)

Click Excel Left Top Corner menu ---> Select Excel Options --->Click Trust Center --->Trust Center Settings ---> Trusted Location ---> Click Add new Location ---> Browse and Select your Modified OAT file folder ---> Click Ok.

Now you won't enable Macros Everytime . Try this.

Thanks for your patience and help.
:clapping::clapping::clapping:

 

[XRAY27]

Dear All,

I have Updated new file. kindly check this.

Sorry for the Late Reply. Last one week i was in out of station. So i Couldn't update.

Note : I have Mentioned how to change Symbol name and Expiry Date Details in ALL Stock OAT file (View 51th Row of Main Sheet) .

COURTYSEY : Mr.Healthraj.

HAPPY TRADING. :thumb:.


Thanks & Regards,
Profittrader

Thanks Profittrader...for the excel works .!!!

 

[Help_Mee]

Hi profittaker,
Can you record these intraday? i mean , can we store daily data ?
like daily backfill.
Thank you

 

[nitingosavi]

thanks Profit taker...

excellent excell works !

 

[Relish]

Hi profittaker

Can you please tell how to trade these signal in auto sheet as I posted pic?

Does Pivot sheet supposed to remain empty or had to show some levels ? I find these cells empty & we can't add price as required ...

One more when will be Suggestion Pair 2 will appear in Main sheet.. All information from OAT all symbols (using VBA code).
Thank's for your excel file.

 

[vidhi]

Dear Profittaker, and Rajsir,

I have been using Rajsir's Excel file and recently trying to use file by Profittaker.

Great work done by both of them.

I have noticed that in Excel file created by Raj Sir is giving Option Pain of Sept Nifty at 8000 while Profittaker OAT file give 7900

Kindly check on your end abt Option pain

 

[angira]

Hello Raj,
Last month i've not got any positional pair for short with magical figure near 120.
This month also does not happened same in first two week, well i only consider MAX_OI.
Then 11 sept. friday MAX_CHG_OI @ 7400-8000, which is available near 120-121.
So i've short this pair near 120, it's my positional trade not intraday.
Today pair trading near 107.
Can this way if we not get any MAX_OI pair near 120 then can we go with MAX_CHG_OI pair near 120 as positional trade ?
I think best time for play positional pair in first two week. Am i right or not?

I'm not whole a day infront of my laptop screen but i've just obsereved above, please clarify me if i'm wrong.

Today MAX_OI @ 7500-8000, trading at 121.

thanx,
angira...

 

[anilnegi]

Hello Raj,
Last month i've not got any positional pair for short with magical figure near 120.
This month also does not happened same in first two week, well i only consider MAX_OI.
Then 11 sept. friday MAX_CHG_OI @ 7400-8000, which is available near 120-121.
So i've short this pair near 120, it's my positional trade not intraday.
Today pair trading near 107.
Can this way if we not get any MAX_OI pair near 120 then can we go with MAX_CHG_OI pair near 120 as positional trade ?
I think best time for play positional pair in first two week. Am i right or not?

I'm not whole a day infront of my laptop screen but i've just obsereved above, please clarify me if i'm wrong.

Today MAX_OI @ 7500-8000, trading at 121.

thanx,
angira...

Hello angira

actually idea is to sell 120 in first week so that it you will be able to ear full premium, hence we have to divide the ration with 40 each, so in this 2nd week you should look for 80-90 pair and not 120.

thanks

 

[angira]

Hello angira

actually idea is to sell 120 in first week so that it you will be able to ear full premium, hence we have to divide the ration with 40 each, so in this 2nd week you should look for 80-90 pair and not 120.

thanks

Thanks for your input Anil.

angira...

 

[Relish]

In my opinion we also look in VIX which shoots from 15-17 to 25-30. It also cost option price high. So instead of 120 pair; we can look for 135-145 price pair also, which may adjust some volatility... i don't know how to adjust vix but only idea if vix increased then increase price from 120 to 150 range if vix is above 25... Thank's