Hi All,

I have set up a web query for a share price and I have 2 questions.

Firstly, how can I make Excel update this web query, for example once a
minute?

Secondly I would like to log some fields (time, shareprice etc) possibly to
another sheet every time the data is updated. Can anyone help with this?

Thanks in advance,

Rob