I think it will help if you make the LTP only to be updated since other data is only updated once a day.
Do consider that the data we are getting is a free resource and bandwidth abuse should be avoided. Make sure you limit the refresh rate if you do make it automatic.
I hope everyone remembers: With great power comes great responsibility
Those who are looking for Nifty option chain in excel with auto-refresh can download it below. Straight from the horse's mouth (Data from NSE server :lol. I've set the update to every 5mins. Minimum interval is 2min. (The limit is from NSE, nothing can be done to make it real time). It is very basic cause I don't don't have a lot of time right now. If anyone has issues let me know but I don't visit the forum often so will take some time.
http://www.megaupload.com/?d=5N14HZ7O
P.S: Nothing comes free, if you abuse bandwidth then you won't get anything. Bandwidth is a precious resource but most don't realize it. When you don't need auto refresh disable it at file open. Don't worry it doesn't get saved. Next time you open the file it will continue to autorefesh.
Njoy :thumb:
Do consider that the data we are getting is a free resource and bandwidth abuse should be avoided. Make sure you limit the refresh rate if you do make it automatic.
I hope everyone remembers: With great power comes great responsibility
Those who are looking for Nifty option chain in excel with auto-refresh can download it below. Straight from the horse's mouth (Data from NSE server :lol. I've set the update to every 5mins. Minimum interval is 2min. (The limit is from NSE, nothing can be done to make it real time). It is very basic cause I don't don't have a lot of time right now. If anyone has issues let me know but I don't visit the forum often so will take some time.
http://www.megaupload.com/?d=5N14HZ7O
P.S: Nothing comes free, if you abuse bandwidth then you won't get anything. Bandwidth is a precious resource but most don't realize it. When you don't need auto refresh disable it at file open. Don't worry it doesn't get saved. Next time you open the file it will continue to autorefesh.
Njoy :thumb:
Thanx for the useful post.:thumb:
I'm trying to take entry into this area. Recently paper trading. Hope you seniors will always be helpful ......
----aid