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
 

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

Setting column width in a table with a macro is not working 0
Update specific cell at a specific time 6
how to strip an individual symbol from each row in a column 1
Static Web Query 1
Making a macro only work on certain files 2
Create a chart from a table in word thats dynamic 0
Two columns followed by single page-width column on same page 0
VBA to create stock analytics display 1

Top