Support Board
Date/Time: Wed, 05 Feb 2025 14:13:47 +0000
[Programming Help] - Horizontal line when a color bar based alert triggers
View Count: 606
| [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: 4167 |
|
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: 4167 |
|
Post#2 edited
|
To post a message in this thread, you need to log in with your Sierra Chart account: