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 .
Raj232

Raj232

Well-Known Member
#8,331
#8,331
iamsaran said:
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.
Click to expand...
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.
 
H

hames

Active Member
#8,332
#8,332
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

checkmate7

Well-Known Member
#8,333
#8,333
hames said:
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.
Click to expand...
Date Issue fixed..Sheet51 and data sheet is hidden but can be made to unhide if you wish to change something...
 

Attachments

checkmate7

checkmate7

Well-Known Member
#8,335
#8,335
hames said:
checkmate, thanks for uploading the file, this is for stock derivative, can you upload for nifty and banknifty.
Click to expand...
I only use for stock will check if BNF and nf with me is in working condition and will post according...
 
checkmate7

checkmate7

Well-Known Member
#8,336
#8,336
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

Raj232

Well-Known Member
#8,338
#8,338
checkmate7 said:
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 :)
Click to expand...
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:
 
S

swapoo

New Member
#8,339
#8,339
Raj232 said:
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:
Click to expand...
Sir i am using first time this excel ,how to use this excel plz explain
thank u
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
P Nifty and Bank nifty options trading Trading Diary 15
P Day trading in nifty options for 1% profit Options 8
S Fall in volume of trading in Nifty-50 call options in 2016? Derivatives 0
kingsmasher1 Too much risk in trading BankNifty or its options. Views welcome. General Trading & Investing Chat 10
gopija Is trading on nifty options illegal ? Derivatives 4

Similar threads