Login Page - Create Account

Support Board


Date/Time: Tue, 07 May 2024 16:20:42 +0000



Finding the Open Print in spreadsheet

View Count: 641

[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:

Login

Login Page - Create Account