Support Board
Date/Time: Thu, 28 Nov 2024 03:57:18 +0000
Post From: Close price at a given time
| [2023-06-08 19:55:39] |
| John - SC Support - Posts: 36350 |
|
You would have to use the Spreadsheet Study to do this and then use the same concept as we gave above within an IF statement where the value if True is the close. So the formula would look like the following in Row 3: =IF(AND(HOUR(A3) = 9, MINUTE(A3) = 0), ID0.SG4@3, IF(AND(HOUR(A3) = 10, MINUTE(A3) = 0), ID0.SG4@3, 0)) You would then need to use the EARLIESTNONZEROVALUE and MOSTRECENTNONZEROVALUE functions to get these two values to the 3rd row, where you can then do what you want with them. Note that this will only work with one day's worth of data in the spreadsheet. You will find the information for the functions here: Spreadsheet Functions For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |