Support Board
Date/Time: Thu, 31 Oct 2024 12:15:05 +0000
Post From: Is there a way to show me at what time the daily low was in a spreadsheet study?
| [2024-10-28 20:03:19] |
| John - SC Support - Posts: 35639 |
|
In order to get the time for a Daily High or Daily Low, you would need to use the "Daily OHLC" study and set the Input for "Graph High and Low Historically" to "Yes". We are not sure what you are looking for in terms of the time, but to get the time for the most recent High (for instance), you would use the following formulas in a Spreadsheet Study after you have added the "Daily OHLC" to the chart: - Cell K3: =IF(ID1.SG2@3 <> ID1.SG2@4, A3, 0) - Cell L3: =MOSTRECENTNONZEROVALUE(K$3:K$2000) Where ID1 is the ID of the "Daily OHLC" study, SG2 is the High subgraph of the "Daily OHLC" study, @3 specifies row 3 of the spreadsheet. Cell L3 will then give the time of when the most recent high was made. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |