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 .

angira

Well-Known Member
Today 28-Nov As Per OptionData

NIFTY :-

Trend WEAK BULL

MAX_OI @ 8500-8500 pair trading near 247
MAX_CHG_OI @ 8500-8800 pair trading near 97

Jan'15 series

NIFTY :-

Trend STRONG BULL

MAX_OI @ 8000-8700 pair trading near 173
MAX_CHG_OI @ 8200-8800 pair trading near 147

angira...
 

angira

Well-Known Member
Today 1-Dec. As Per OptionData

NIFTY :-

Trend WEAK BEAR
MAX_OI @ 8500 pair trading near 252
MAX_CHG_OI @ 8600-8700 pair trading near 165

Jan'15 series :-

Trend STRONG BULL
MAX_OI @ 8100-8700 pair
MAX_CHG_OI @ 8400-8700 pair

angira...
 

healthraj

Well-Known Member
My oat spreadsheet has stopped working

Expiry date is invalid

Plz give some solution regardin it :)
Yes Since the last Thursday (25-DEC-14) of the month is a Holiday due to Christmas, the expiry will be on 24-DEC-14.

So you have to manually do those changes.

Code:
1. Goto the hidden sheet called "SOData".
2. In Cell AP20, Type "24-DEC-14" without quotes 
3. In Cell AP21, Paste the following formula without quotes "=GetExpiryDate(1,MONTH(AP20)+1,YEAR(AP20))"
4. In Cell Ap22, Paste the following formula without quotes "=GetExpiryDate(1,MONTH(AP21)+1,YEAR(AP21))"
5. In the "OAT" sheet choose "24-DEC-14" as the expiry date and do a "Refresh"
 

Similar threads