Support Board

Date/Time: Fri, 07 Feb 2025 15:06:27 +0000

Post From: Line slope

[2021-03-11 22:04:55] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4173
Since that study can have consecutive level segments, you'll need this example formula to match the slope coloring of a line: Spreadsheet Example Formulas and Usage: Formula that Matches the Slope Coloring of a Study Subgraph Line This formula would need to be modified from spreadsheet syntax to Simple Alert syntax. Use it in the Formula field of the Spreadsheet Formula study: =IF(OR(ID70.SG1>ID70.SG1[-1],AND(ID70.SG1[-2]>=ID70.SG1[-1],ID70.SG1>ID70.SG1[-1])),1,IF(OR(ID70.SG1<ID70.SG1[-1],AND(ID70.SG1[-2]<=ID70.SG1[-1],ID70.SG1<ID70.SG1[-1])),-1,ID1,SG1[-1])) -where ID1 is the Spreadsheet Formula study. Hide this study. Then use this formula on the Alerts tab of the Color Bar Based On Alert Condition study to find the transitions: =ID2.SG1<>ID2.SG1[-1] -where ID2 is the color bar study.