Support Board
Date/Time: Mon, 25 Nov 2024 21:36:06 +0000
Opening Swing High
View Count: 246
| [2024-01-30 23:15:47] |
| User827002 - Posts: 36 |
|
I'm trying to create a column in a spreadsheet study that shows the high of the first 10 minutes of the session from 7:30 - 7:40 MST, or the high after a 50% pullback within the first 10 minutes. In column EZ I have the current high of day, in FA I have the low of day. Column T shows me the current daily range with the formula, =EZ3-FA3. Column U shows me where 50% of the range is with the formula =(EZ3-(T3/2)). Now I'm trying to create the column that shows the high if the low of any candle between 7:30 - 7:40 becomes less than U3, or if price never drops below 50% of the day's range within 10 minutes, to just show the high of the first 10 minutes. I then want that "High" to persist through the rest of the trading session. I hope that makes sense. Do you have any suggestions?
|
| [2024-01-31 15:29:05] |
| John - SC Support - Posts: 36280 |
|
First you need to isolate the data between 07:30 and 07:40. To get all the Lows in this time use the following formula in Cell 3 of the a formula column: =IF(AND(FRACTIME(A3) >= TIME(07, 30, 00), FRACTIME(A3) <= TIME(07, 40, 00)), ID0.SG3@3, 0) Then you can use the MIN() to get the lowest value in that column. Hopefully this gives you enough to get the rest worked out. 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: