Recording Data

[koanitrading]

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 ...

 

[ryguy7272]

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

HTH,
Ryan---