Support Board
Date/Time: Thu, 28 Nov 2024 17:44:01 +0000
Post From: HOW TO GET CELL VALUE OF A SPECIFC TIME
| [2023-04-20 15:12:21] |
| John - SC Support - Posts: 36350 |
|
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 |