NIFTY Options Trading by RAJ

How do you use OAT tool?

  • For Intraday Naked Options trading

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

    Votes: 27 17.6%
  • For Intraday Futures trading

    Votes: 18 11.8%
  • For Positional Naked Options trading

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

    Votes: 29 19.0%
  • For Positional Futures trading

    Votes: 11 7.2%
  • To trade in Cash market

    Votes: 12 7.8%
  • Overall trading has improved with OAT

    Votes: 26 17.0%
  • Understanding of Options has improved with OAT

    Votes: 56 36.6%

  • Total voters
    153
  • This poll will close: .
Could anyone please provide the password to unprotect the sheets. I am facing issue in price distribution loading.
If password is there means, it will be helpful to assign values.
I cracked the sheet. And found why the value is not populating. In Sheet51 ( which is in hidden state), Expiry date is hardcoded and because of that all conditions failed and value not getting populated.
 

Raj232

Well-Known Member
I cracked the sheet. And found why the value is not populating. In Sheet51 ( which is in hidden state), Expiry date is hardcoded and because of that all conditions failed and value not getting populated.
Is it possible to fix the hardcoded Expiry date issue. Maybe an excel field where the date can manually be input if drop down is not possible.
 

Raj232

Well-Known Member
I cracked the sheet. And found why the value is not populating. In Sheet51 ( which is in hidden state), Expiry date is hardcoded and because of that all conditions failed and value not getting populated.
Is it possible to fix the hardcoded Expiry date issue. Maybe an excel field where the date can manually be input if drop down is not possible.
 
Can anyone post working and unlocked copy of nifty and bank nifty sheet. earlier files are not working. tried the file which Ravi had posted but except futures data its not showing anything.
 

checkmate7

Well-Known Member
Can anyone post working and unlocked copy of nifty and bank nifty sheet. earlier files are not working. tried the file which Ravi had posted but except futures data its not showing anything.
Date Issue fixed..Sheet51 and data sheet is hidden but can be made to unhide if you wish to change something...
 

Attachments

checkmate7

Well-Known Member
checkmate, thanks for uploading the file, this is for stock derivative, can you upload for nifty and banknifty.
I only use for stock will check if BNF and nf with me is in working condition and will post according...
 

checkmate7

Well-Known Member
NF and BNF sheets with changes incorporated for working...Also attaching doc file which was present in the earlier zip file for changing expiry date.....

All credit to original creator :)
 

Attachments

Raj232

Well-Known Member
NF and BNF sheets with changes incorporated for working...Also attaching doc file which was present in the earlier zip file for changing expiry date.....

All credit to original creator :)
Yep, Original creator has definitely done good work. Keep t up !!!
In fact I created a similar file 3-4 years ago but without the coloration. In sideways markets there is not much clarity on direction of BNF.

Probably we should look deeper and suggest how it can be used as a crisp trading tool. :wideyed:
 

Similar threads

Broker Special Offers

Intraday Higher Leverage

Save up to 90% in brokerage and get higher leverage for intraday trades.

Name:Phone:
Email:City:
State:
Are you a day trader?