Login Page - Create Account

Support Board


Date/Time: Tue, 07 May 2024 03:46:12 +0000



Daily OHLC on intraday chart

View Count: 758

[2016-12-18 18:13:02]
User170575 - Posts: 221
Hi--I am trying to determine if an equity has hit a 3 day low using the Daily OHLC
on an intraday chart.

I think my formula is ok--ID2 being the Daily OHLC study:

=AND(ID2.SG3<ID2.SG3[-1], ID2.SG3<ID2.SG3[-2], ID2.SG3<ID2.SG3[-3])

I marked the ones that do not meet the criteria:

http://www.sierrachart.com/image.php?Image=1482084614644.png

What am I missing?? Seems just too simple--LOL

Many thanks,
Cy
[2016-12-18 23:28:32]
Sawtooth - Posts: 3993
Your formula is only looking at the previous 3 60min bars, not the previous 3 days.
You'll need another three instances of the Daily OHLC study, and set Reference Days Back to 1,2 and 3, respectively, then compare the three Lows to the current day's Low, like this:
=AND(ID2.SG3<ID3.SG3,ID2.SG3<ID4.SG3,ID2.SG3<ID5.SG3)
where ID3, ID4, ID5 are the Daily OHLC of 1,2,3 days ago, respectively.
[2016-12-19 14:16:36]
User170575 - Posts: 221
Many thanks Tom--appreciate your help

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

Login

Login Page - Create Account