Support Board
Date/Time: Wed, 05 Feb 2025 16:47:07 +0000
Post From: Horizontal line when a color bar based alert triggers
| [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
|