Hi All, I am creating a spreadsheet for day trading in the stock market. The data source is from web through excel web data query. This is how the data looks like
*Col A* *Col B* *Col C* *Col D* *Col E* *Col F* *Col G* 2700 155894 215222.58 62.3 4653450 =% Change (Col D) =% Change (Col E) 2600 91029 123302.42 110.5 3088800 =% Change (Col D) =% Change (Col E) 2800 85823 121416.8 29.55 4921000 =% Change (Col D) =% Change (Col E) 2900 33497 48778.83 12.2 3717400 =% Change (Col D) =% Change (Col E) Now i need to solve two things, First, Since this is a web data, it changes every minute. I need to write a macro which will store the last data set when it get refreshed to get the value in Col F &G Second, how can I manually input my time frame to get the data refreshed from the web for less than a minute Plz if anyone can help me in this Thanks in advance Himadri --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
