Support Board
Date/Time: Wed, 14 Jan 2026 21:01:51 +0000
Post From: HOW TO GET CELL VALUE OF A SPECIFC TIME
| [2023-04-20 15:12:21] |
| John - SC Support - Posts: 43983 |
|
To get the High at 09:15 would be the following: =IF(AND(HOUR(A3) = 9, MINUTE(A3) = 15), C3, 0) Note that this will only output the High at that specific time. You may need to use another column and use =MOSTRECENTNONZEROVALUE(K3:K200) to get the most recent 9:15 high to display on all bars up to the current time. Refer to the following: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MOSTRECENTNONZEROVALUE_Function Then, depending on how you want to view the information, you could use the Text Display for Study. Refer to the information here: Text Display For Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |