Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 17:32:39 +0000



Post From: Missing Open to Close(Last) Range in "High/Low for Time Period" study

[2023-07-24 08:53:42]
User117222 - Posts: 9
Hi @tomgilb @SCSupport

The overall DR/IDR levels created using the mix of various studies (based on the earlier .CHT file shared by @tomgilb) is working well.

I'm trying to refine this further, but I'm a little stuck.

There is a Shaded Box that's created between 930am and 1030am, which highlights the area between the IDR High & Low. This standard Grey shading is working fine.

However, I'm trying to get this area to be shaded Green if the Closing Price at 1030am is > Opening Price at 930am (and Red vice versa)

I'm using the following Alerts formula in the Shaded study:

=AND((C>O), BARTIME >= TIME(9, 30, 0), BARTIME <= TIME(10, 29, 59))

... and created 2 such studies - one Green (for C>O) & one Red (for O>C)

But, for some reason, Both Green AND Red shading is appearing on ALL boxes, rendering the Alert ineffective.

Any suggestions on what I'm doing wrong?

Many thanks