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


"Doug" wrote:

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?
--
Thank you!