Support Board
Date/Time: Thu, 28 Nov 2024 15:35:08 +0000
HOW TO GET CELL VALUE OF A SPECIFC TIME
View Count: 272
| [2023-04-20 03:06:09] |
| User642012 - Posts: 54 |
|
HI HOW TO GET THE CELL VALUE OF A SPEFIC TIME, FOR EXAMPLE HIGH AND LOW OF THE 9:15:00 PLEASE ADVISE THANKS |
| [2023-04-20 13:49:58] |
| John - SC Support - Posts: 36350 |
|
Since you use the word "Cell" we assume you are wanting to know how to do this within a Spreadsheet study. As such, refer to the following information regarding how Time is handled in the Spreadsheet and how to make time comparisons. In the end, you would be checking the time of the bar in the A column and then outputting the High or Low column data when the time matches. Spreadsheet Functions: Serial DateTime Values For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-04-20 14:46:28] |
| User642012 - Posts: 54 |
|
Hi Still a bit confusing what would be a formula looks like to get the value at cell C when a match of 9:15:00 found in Cell A ? Thanks |
| [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 |
| [2023-04-21 08:16:07] |
| User642012 - Posts: 54 |
|
Hi How can I find out the row number of a specific time ,said 9:15:00 as the chart is running the location keep changing . And address the cell value of C in the that ? For example the 9:15:00 is at A3 now but it became A6 three min later and keep on changing through out the day so how can I keep track the cell value at C at 9:15:00 ? Appreciate your help |
| [2023-04-21 14:12:28] |
| John - SC Support - Posts: 36350 |
|
That is what the MOSTRECENTNONZEROVALUE() does for you. Refer to the information here: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MOSTRECENTNONZEROVALUE_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: