Support Board
Date/Time: Fri, 09 May 2025 21:12:08 +0000
Post From: Hide Indicator based on Slope
| [2019-02-09 23:37:45] |
| Sawtooth - Posts: 4214 |
|
To do it with a spreadsheet study: 1. Add the Spreadsheet Study study. - Set the Chart Region to 1. - Give it a name in the Spreadsheet Name field. On the Subgraphs tab: - Set the Draw Style of L(SG2) to 'Line - Skip Zeros' and choose the same color and line size as your EMA. - Set all other subgraphs to Ignore. - Press OK and OK. On the spreadsheet: - Go here and copy/paste the formula in cell K3: Spreadsheet Example Formulas and Usage: Formula that Matches the Slope Coloring of a Study Subgraph Line (this formula will exactly match Sierra's slope coloring). - Put this in cell L3: =IF(K3=1,ID1.SG1@3,0) - The formulas assume your EMA is ID1.SG1; edit all instances of ID1.SG1 to the ID#/SG# of your EMA, if necessary. - You can minimize the spreadsheet if you want. 2. Hide your EMA study. |