Macro on a timer

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?
 
S

Sam Wilson

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
 
Top