Macro on a timer

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I have some stock symbols that are in a particular column. I am trying to
figure out the best way to have the stock prices in another column update
respectively every half hour. How can I do this? My thought was to do it with
a macro on a timer, or maybe have it automatically refresh imported data?
Does anyone know the best way to do this efficiently?
 
Hi,

It depends where your data is coming from. Ideally you want your formulae
static and the data they feed from to be refreshed.

Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Static Web Query 1
Matching with respect to another column? 3
Run Macro (VBA) every 5 minutes 1
Calculating a worksheet 3
Keep Timer Going While Altering Workbook 1
Using macros updates on Excel Workbook 2
Index-Match and Like...maybe... 2
Capture Filter 'AfterUpdate' event in Pivot Table 3

Back
Top