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
 
Back
Top