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.
Dear Amit Sir,
I think you may changed Link in Edit Web Query window.
Try do this:
Step 1 : Go to Data (in Excel) --> Connection ---> Select STOCK FUTURE -->
Properties --> Select Defination Tab ---> Click Edit Query --> Just Change Stock name from RELIANCE to INFY in Address Bar and...
I have Set Refresh Time : 3 Min. You Can Change it. Go to Data Menu ---> Click Connections ---> Here You Can Adjust Every Refresh ---Minutes in Usage Tab. (I recommend It should be Min 3 Minutes is better for Updation. )
Every time if you open this excel file first will ask enable or disable option. If you should choose enable . After that every 3 minutes ones this file will update automatically.
Click Excel Left Top Corner menu ---> Select Excel Options --->Click Trust Center --->Trust Center...
First sheet also not updating. check your screenshot.(Top of the main page there showing Underlying index nifty 8001.95 As on Aug28,2015 15:30:46) .
I think you didnt enable Macros. kindly close and open this excel and enable macros. or try to click Data Menu in excel and click Refresh All Button .
I have Updated new file. kindly check this.
Sorry for the Late Reply. Last one week i was in out of station. So i Couldn't update.
Note : I have Mentioned how to change Symbol name and Expiry Date Details in ALL Stock OAT file (View...