Login Page - Create Account

Support Board


Date/Time: Sat, 24 May 2025 15:36:57 +0000



calculate price between last to last high/bottom

View Count: 365

[2023-07-26 12:26:15]
User278398 - Posts: 296
hello,
there is a study/formula
to calculate the price from last to last high/bottom?
in the example i want to get the value -0.66 (266.34-267)

regards
image321.png / V - Attached On 2023-07-26 12:26:02 UTC - Size: 145.91 KB - 107 views
[2023-07-26 15:54:52]
John - SC Support - Posts: 40015
Refer to the following:
High/Low for Time Period - Extended
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-07-27 07:32:52]
User278398 - Posts: 296
i need to put specific range time in the parameters, for this study. (for exa: from: 9:45:00 to 10:50:00)
but i need the high/low of the last time (for exa: the last 60 min (relative to last price))

regards
[2023-07-27 13:32:54]
John - SC Support - Posts: 40015
To do this you would need to use the Spreadsheet Study and use the MAX() and MIN() functions to find the high and low. Refer to the following for the MAX() function:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MAX_Function
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