Support Board

Date/Time: Sat, 20 Apr 2024 16:17:57 +0000

Post From: Hide Indicator based on Slope

[2019-02-09 23:37:45] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3976
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.