Dear All,
I am Trading Nifty Option. So I am using Nifty symbol only in RAJOAT file.
I have Uploaded 2 Excel Files (Modified Raj sir OAT Files). I didn't do anything new. Just i Modified Raj sir file and added Sheet3 for save CHGOI & OI Details. All Credits go to Mr.Healthraj sir.
Uploded Excel Files:
1.RAJ OAT OptionsChain Analyzer for NSE Index and Stock v1.2F(Only Nifty)
2.RAJ OAT OptionsChain Analyzer for NSE Index and Stock v1.2F
Any reason for not activating auto refresh in All Symbols OAT or any other way to do it.
you can do it. If you use First file (Only Nifty) then open it. Go to Data Menu-----> Click Connection -----> Choose Connections -----> Properties ----->Change to Refresh Every _____(Minutes).
If you use Second file. There are more than 40 connections in this file. If you set Refresh time than Updation may be Slow.
Upon changing symbol will the record of previous symbol will remain or go away.
In the Second file you can change Symbol name. I am using Nifty so Every day Before Market open I will Select "YES" (U2 column in Sheet3) for Clear Previous Data and again select "NO". After Market Open from 9.30 to every 30 minutes CHGOI & OI detail will save automatically in Sheet3.
After Market Closed Every day I will copy Sheet3 Page details as image file in my system for Backtest Purpose.
If you change Symbol name in Market Running hours, which time you change after that next 30 Minutes(9.30,10,10.30,11,11.30,12.. etc.,) Changed Symbol Details will save in Sheet3.
Example :-
first if you watch Nifty from 9.15 to 11.25 than CHGOI & OI details will save (From 9.30,10,10.30,11) in Sheet3. After 11.25 you will change symbol from Nifty to Banknifty than Save Banknifty Detail from 11.30 onwards.
Can multiple copies be run simultaneously to track multiple symbols.
NO.
Changed to symbol to "Banknifty". The values update, the pivots data updates, but it seems that the chart doesn't get updated.
Sorry. I didn't touch in that Portion in this file. So Healthraj sir can only reply to this.
Is it possible for you make an simple NF spot chart (custom TF)removing these charts from file...
I will Try.
"Excel found unreadable content in "Raj OAT......". Do you want to recover the contents of this workbook? If you trust....,click yes" . Upon clicking yes OAT starts but seems like lacks full functionality. Any solution Plz.
I dont know why its happening. I am using Excel 2007. Its Working fine to me.