Support Board
Date/Time: Fri, 09 May 2025 22:44:22 +0000
Post From: swing high low ?
| [2015-12-15 01:59:49] |
| Yoda - Posts: 106 |
|
Thank you Tom for the reply. I have been playing with the spreadsheet study and cannot figure out how to limit the Swing High/Low to only the first one of the regular trading hours (RTH) for the ES (9:30 to 16:15 EST). As a first step, I inserted the following formula in column Q (to check if we were in RTH): =AND(weekday(A3)>=2,weekday(A3)<=6,hour(A3)>=9,hour(A3)<=16,if(hour(A3)=9,if(minute(A3)<=30,TRUE,FALSE),TRUE),if(hour(A3)=16,if(minute(A3)<15,TRUE,FALSE),TRUE))
I then ran into a wall when I tried to determine if the Swing High in AA and Swing Low in AB were the 1st of the day. Are you able to provide some help how I can modify the study to: 1. Determine whether the Swing High in AA and Swing Low in AB are the 1st of the day 2. Stop determining any further swing hi/lo so that the 1st swing lines would extend across the day. 3. Reset the study at the start of the next day. Richard |