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 .
Dear PT,

1. The list of connections is big in 'ALL SCRIPS' and small in 'Nifty ONLY' sheet.
2. Not all connections are shown to be used.
3. Do we need to set auto refresh for all connections or used connections only.
4. Upon trying to set auto refresh for connections FOVOLT etc at the bottom of list, the Excel crashes.

Plz guide.

Thanks
Rajesh
Dear Rajesh,
I am trading only in Nifty Option. So i didn't try all symbol.

you should change Connection, Connection1 and Connection2 in (Nifty Only) file .
 
I had earlier enquired if we can use the Excel for watching multiple stocks simultaneously; answer was 'no'.
But there appears to be a way available, here is how it can be done.

1. Make multiple copies of Raj Excel for All Stocks, enter required scrip and save them with different names/numbers.
2. Open one excel.
3. Press ‘shift’ and left click on the Excel icon in bottom taskbar(or simply center click on it); this opens a new Excel in SEPRATE window running independently AND simultaneously.
4. Open the required Excel as usual; this will cause it to open in window opened/created in previous step.
5. Repeat previous two steps.
6. One can open any number of Excel sheets to run simultaneously.

Thanks
Rajesh
Dear Rajesh,
Thanks for your information.
 
you should change Connection, Connection1 and Connection2 in (Nifty Only) file
Dear PT,

Pardon me for pestering you, but what I was looking for was--
1. ability to auto-refresh in AllScrips Excel
2. Auto pasting in sheet 3 at shorter period

This would enable one to keep the sheet 3 open and monitor the movement of ChOI as it happens.

Would be obliged if guided.

Thanks
Rajesh
 

VJAY

Well-Known Member
Dear PT,

Pardon me for pestering you, but what I was looking for was--
1. ability to auto-refresh in AllScrips Excel
2. Auto pasting in sheet 3 at shorter period

This would enable one to keep the sheet 3 open and monitor the movement of ChOI as it happens.

Would be obliged if guided.

Thanks
Rajesh
Dear PT,
with it one more suggestion -Is it possible to sheet 3 copy when there is change in CHGOI strikes changes?
 

anilnegi

Well-Known Member
Dear Rajesh,
Thanks for your information.
Hello profittaker

i am getting following error in new file i updated, moreover, data in sheet 2 is not updating, anything we should do to correct this



thanks
 

Similar threads