ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Recording Data (https://www.excelbanter.com/excel-programming/431830-recording-data.html)

koanitrading

Recording Data
 
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

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



All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com