Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 02 May 2024 01:05:25 +0000
Post From: locking state plus a value
| [2014-01-22 04:45:26] |
| Bedhog - Posts: 168 |
|
Maybe there was an easier way, but here is how I solved it... The way stash the value of D3 upon a true condition into Column S as shown below. The value will stay in S3 as long as H3 remains true. O3=IF(AND(AA3<AB3,AA4>=AB4),D3,0) P3=IF(AND(AA3>AB3,AA4<=AB4),C3,0) Q3=MATCH(TRUE,O3:O100<>0,0)+2 R3=MATCH(TRUE,P3:P100<>0,0)+2 S3=IF($H$3,INDIRECT("O"&Q$3),0) Now I need your help to plot a point at this value for as long as the number is non-zero. I've tried color bar based on alert using =ID1.SG9, but that simply puts a point on the low of every candle as long as S3 is non-zero. I want to plot a point at the value of S3, not on the low of every subsequent candle. COLUMN S1 S2 S3 4.410999775 S4 4.410999775 S5 4.410999775 S6 4.410999775 S7 4.410999775 S8 4.410999775 S9 4.410999775 S10 4.410999775 S11 0 S12 0 Date Time Of Last Edit: 2014-01-22 04:46:06
|