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 .
Last edited:
Dear Kumar,
Option Chain Data is fetching from Nse Site. This Data will update every 2 or 3 Minutes once in this site. Some times taking more than 5 Miuntes also.

Now Data is saving every 15 minutes once in Auto Sheet. I will try to Save Every 5 Minutes in Auto Sheet.
Profitaker

Your files are not working for some reason for 2017 Series. Even after changing the options query, the error returned is "Web Query returned no data"
Could you please take a look or share the password for us to correct?
 
The NSE website is also having problems today.
I'd suggest to check later in the evening or tomo.
Thanks... its interesting, there is a hidden sheet called as Data which presumably is used to download the Option table. This sheet gets filled in correctly, but the macro processor does not take the data for display on the each of the main sheets. Will try tomorrow and see
 
As posted earlier, NSE site was having some problems.
I'v checked now and the OAT updates properly.
Lucky you.. .no such luck in here... looks like completely broken for some reason.
I think the reason is bcos, the expiry this january is not on last thursday (being 26th is a holiday) and internally the sheet is taking 26-Jan as expiry and not returning the query. As we dont have the password, its difficult to change this
 
Last edited:

travi

Well-Known Member
You will have to change the auto refresh time currently 3m to around 10 minutes.
NSE is blocking hits on their servers that are too frequent.
I'm observing this since 2-3 days. I get the same "web query data not downloaded" error.
If the refresh is for 10m, it works.
 

Similar threads