Support Board
Date/Time: Mon, 25 Nov 2024 23:31:36 +0000
Post From: Opening Swing High
| [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?
|