Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 17:52:34 +0000



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

[2023-07-24 15:57:08]
User117222 - Posts: 9
Thank you @tomgilb

Performed all these steps. I think I'm very close, but something's off. I'm seeing the shading in the Area around and below, but not the intended space (between the IDR, from 930am till 1030am).

I've attached a Screenshot fyi.

I've implemented the following steps:

Step 1. Created 2 new Spreadsheet Formula Studies

ID.86 with this formula in the Formula Field: =IF(AND(BARTIME>=TIME(9,30,0),BARTIME<TIME(9,30,1)),O,ID86.SG1[-1])
ID.87 with this formula in the Formula field: =IF(AND(BARTIME>=TIME(10,25,0),BARTIME<TIME(10,25,1)),C,ID87.SG1[-1])

Step 2. I've then created a new Study Subgraphs Reference Study with:

Input Study 1: ID86.SG1
Input Study 2: ID87.SG1

In the Alerts Tab: I've inserted the following Alert Condition:
=AND((ID87.SG1>ID86.SG1), BARTIME >= TIME(9, 30, 0), BARTIME <= TIME(10, 29, 59))

Subgraphs Tab:
SG1 is set to Transparent Fill Top
SG2 is set to Transparent Fill Bottom


Still not working bizarrely. I guess I'm very close, just something small is off. Any suggestions?

Really appreciate all your help.
Thank you.
imageIDR shading Screenshot.png / V - Attached On 2023-07-24 15:55:30 UTC - Size: 92.29 KB - 101 views