Support Board
Date/Time: Fri, 10 Jan 2025 13:21:18 +0000
Post From: Shortcut for Alert Requiring Multipe Prior Bars in MAX Formula
| [2016-09-06 21:13:00] |
| bhetterick - Posts: 8 |
|
I am trying to create an alert using Color Bar Based On Alert Condition that colors the bar when a study subgraph current bar is the max of the most recent 20 bars of the subgraph. I tried writing the alert condition similar to how one would do it in a spreadsheet (i.e. =ID22.SG1=max(id22.SG1:id22.SG1[-19]) but cannot get it to work as written. The trouble seems to be when trying to incorporate other studies/subgraphs into the formula, because a formula like =C=MAX(C:C[-19]) does work. How would one write this formula to refer to a different study and subgraph when trying to find the MAX of a series of prior bars of the subgraph? Thanks for your help. |