Support Board
Date/Time: Sat, 11 Jan 2025 05:04:01 +0000
Finding the Open Print in spreadsheet
View Count: 716
[2016-11-08 16:12:21] |
GiantAvocado - Posts: 67 |
I looked and searched & can't seem to find a way to search down column 'A' of a spreadsheet to reference the opening print for the session; i.e. 09:30:00 for /ES? Can this be done or can someone guide me to a solution? I have tried most of the functions with the new spreadsheets to no avail. I can do this in Excel with VBA... any help would be appreciated: Steve |
[2016-11-08 16:22:02] |
Sierra Chart Engineering - Posts: 104368 |
The best way to do this is to use the Daily OHLC study: https://www.sierrachart.com/index.php?page=doc/TechnicalStudiesReference.html#s137 And then reference the Open price from the particular Sheet column the Open values are outputted in. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: