If you want to run code periodically, this should work for you:
http://www.cpearson.com/excel/OnTime.aspx

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"koanitrading" wrote:

Currently, I monitor financial market data. I'd like to do a couple things:

1. For a specified time period, say 15 minutes, record the price level of a
stock at the open and close of the period
2. In that time period, record the high and low of the period

Thoughts? Thanks in advance ...