Support Board
Date/Time: Thu, 28 Nov 2024 23:40:52 +0000
Post From: Adding a filter to color background based on alert condition study
| [2023-04-03 03:06:28] |
| User273277 - Posts: 59 |
|
I managed to make a list of the time of the most recent HH for each price level: K=round(GetCorrespondingMatch(ID3.SG2@3:ID3.SG2@1003,2,0,0,0,A3:A1003,0),8) This creates a serial time list like this: 45016.66538991 45016.66538991 45016.66538991 45016.64598403 45016.64598403 45016.64598403 45016.64598403 45016.588594 45016.588594 45016.51995282 45016.51995282 Then I mark each HH with a 1, thinking I can use this to deliniate each new "sub-array" staring point. Another way to think of this is a trigger or enable switch to start looking for the next part: L=if(K3>K4,1,0) 45016.66538991 0 45016.66538991 0 45016.66538991 1 45016.64598403 0 45016.64598403 0 45016.64598403 0 45016.64598403 1 45016.588594 0 45016.588594 1 45016.51995282 0 45016.51995282 0 Now I need to grab the first pivot low after each HH (the 1's above) is triggered. How do I grab the EARLIESTNONZEROVALUE for the "sub-array" containing the pivot low between the most recent HH (column L marked with a 1, and now() / current bar ? Date Time Of Last Edit: 2023-04-03 03:52:23
|