Support Board

Date/Time: Mon, 13 May 2024 22:20:58 +0000

Post From: Shortcut for Alert Requiring Multipe Prior Bars in MAX Formula

[2016-09-06 21:13:00] Link To Thread - Link To Post [Go To First Post]
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.