Login Page - Create Account

Support Board


Date/Time: Wed, 11 Mar 2026 14:16:28 +0000



[Programming Help] - High/Low-from input price instead of time period

View Count: 129

[2026-01-24 07:07:47]
User61168 - Posts: 474
Hello SC Users,
I am wondering if there is a way to display high/low from a specific price level (calculated dynamically via Spreadsheet formula study and then passed as an input).

Similar to High/Low for Time Period , I want to replace start/end time period with just one starting price (or a horizontal line which I control via spreadsheet formula study).

I would appreciate any tips or guidance.

Edit: If input price is set to 0, then disable the study (to reduce CPU overhead)
Date Time Of Last Edit: 2026-01-24 07:12:31
[2026-01-26 16:29:50]
John - SC Support - Posts: 45036
The one way we can think of to do this would be to use the Spreadsheet Study. You would then be able to calculate the difference between the High/Low of each bar and the price level you want as a reference, and then use the MAX()/MIN() functions to find the greatest departure and then determine the High/Low from that.

But, we really are not understanding how this is any different from the "High/Low for Time Period". You will have to adjust the number of bars that are being calculated in the "Spreadsheet Formula" to control the time period over which you are determining these values. So in the end, as far as we can tell, it amounts to the same thing.
For the most reliable, advanced, and zero cost futures order routing, use 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