Login Page - Create Account

Support Board


Date/Time: Sun, 05 May 2024 10:14:32 +0000



[User Discussion] - swing high low ?

View Count: 2869

[2015-09-04 03:30:06]
User20450 - Posts: 330
is there not a simple swing high low indicator that plots a line on top of swing high and low ?
[2015-12-14 18:50:42]
Yoda - Posts: 106
There is the Swing High And Low Study. You can change the Draw Style to Dash the Line Style to Solid. However, this only puts a line on the candle which has the swing high and low. Maybe someone can advise how you can extend these lines to be wider than one candle width.

While on this topic, is there a way to limit the Swing High and Low to only the 1st Swing H/L of the day and then extend the line throughout the whole day?

Thanks,
Richard
[2015-12-14 22:45:57]
Sawtooth - Posts: 3993
You could use the Daily OHLC study set to 0 Reference Days Back, and Graph Historically set to Yes, and the Draw Styles of Open and Close set to Ignore.

If this is not the same as a new Swing H/L, then you could do it with a spreadsheet study. Here's an example in post #11 that would need to be modified:
No backtesting results
[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
[2015-12-15 06:22:06]
Sawtooth - Posts: 3993
Richard,

Try these formulas:
K3:
=IF(AND(Q3,R3=1,AA3>0),AA3,K4)
L3:
=IF(AND(Q3,R3>0),TRUE,IF(Q3=FALSE,FALSE,L4))
M3:
=IF(L3,K3,0)
N3:
=IF(AND(Q3,S3=1,AB3>0),AB3,N4)
O3:
=IF(AND(Q3,S3>0),TRUE,IF(Q3=FALSE,FALSE,O4))
P3:
=IF(O3,N3,0)
Q3:
=AND(WEEKDAY(A3)>1,WEEKDAY(A3)<7,A3-INT(A3)>TIMEVALUE("09:30:01"),A3-INT(A3)<TIMEVALUE("16:15:00"))
R3:
=IF(Q3=FALSE,0,IF(AND(Q3,AA3>0),R4+1,R4))
S3:
=IF(Q3=FALSE,0,IF(AND(Q3,AB3>0),S4+1,S4))

-Tom
Date Time Of Last Edit: 2015-12-16 00:52:33
[2015-12-15 23:19:46]
Yoda - Posts: 106
Thank you Tom
[2015-12-16 00:53:26]
Sawtooth - Posts: 3993
The Q3 formula has been edited.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account