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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---