I found this example online. It actually refreshed every 15 seconds continuously, but if you press the F12 key, it will stop the refresh (that way you do not have to ^Break the code)
http://forums.pcworld.co.nz/showthread.php?t=54801 On Feb 28, 2:17 am, himu <himadri....@gmail.com> wrote: > Hi All, > > I am trying to create a spreadheet of indian equity market. In the > spreadsheet I have Nifty 50 stocks. I have linked the data from nse > india site. I have also created the drop down box of all the 50 > scrips. Now my problem starts... 1))All i want to do is to keep a > timer of less than 1 min (this is the lowest interval by default in ms > excel for refresh). I know this can be done through writing macro..plz > if anybody can help me in that. > 2)) Suppose i select a particular scrip. i want another macro to > record the change in price in another work sheet so that we can keep a > tab on the % change of each and every tick data. > > I would be helpful if any one can help me in writing the macro. I > guess it would help all of us (who have interest in Indian stock > market) --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---