Macro on a timer

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

 

[Don Guillett]

Look in the vba help index for ONTIME

 

[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