Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 12:41:41 +0000



[Programming Help] - Horizontal line when a color bar based alert triggers

View Count: 517

[2020-03-20 17:41:01]
User355030 - Posts: 163
I'm trying to draw a horizontal line when a color bar based alert triggers. I used the spreadsheet study as well to identify the color bar alert, and the next step was to grab the value of the market where that alert happened. I am grabbing the market value with the formula [=GETCORRESPONDINGMATCH($K3:$K1002, K$1, 0, 1, 0, $D3:$D1002, 0)]

The problem I am having is the formula is not grabbing the latest alert value and I cannot figure out why for the life of me.
[2020-03-20 18:13:57]
Sawtooth - Posts: 3952
Try this:
=GETCORRESPONDINGMATCH(ID3.SG1@3:ID3.SG1@1002,1,1,0,0,$D3:$D1002,0)
where ID3 is the color bar study.
This will return the Low of the bar where the alert occurred, and repeat it until the next alert.

This also does the same thing:
=INDEX(D3:D1002,MATCH(1,ID3.SG1@3:ID3.SG1@1002,0),1)

And this is the simplest way, e.g. in cell N3:
=IF(ID3.SG1@3,D3,N4)
Date Time Of Last Edit: 2020-03-20 23:27:32
[2020-03-20 19:51:52]
User355030 - Posts: 163
Thank you!
[2020-03-20 23:27:57]
Sawtooth - Posts: 3952
Post#2 edited

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

Login

Login Page - Create Account