Support Board
Date/Time: Fri, 07 Feb 2025 16:54:58 +0000
Post From: Extension Line defined by Oscillator/MA cross
| [2020-06-06 14:22:41] |
| Sawtooth - Posts: 4173 |
|
There is a solution but it requires using the Spreadsheet Study study.
Add the Spreadsheet Study study. - Set the Chart Region to 1. - Give it a name in the Spreadsheet Name field. - Note the Formula Source Sheet Number (ln:7) This will be the sheet# for the formulas. - On the Subgraphs tab: -- Set the K(SG1) DrawStyle to Dash, and choose the High color. -- Set the M(SG3) DrawStyle to Dash, and choose the Low color. -- Set all other Drawstyles to Ignore. - On the spreadsheet, use these formulas: Cell K3: =IF(CROSSFROMBELOW(ID17.SG2@3:ID17.SG2@4,ID17.SG1@3:ID17.SG1@4),D3,IF(CROSSFROMABOVE(ID17.SG2@3:ID17.SG2@4,ID17.SG1@3:ID17.SG1@4),C3,K4)) Cell L3: =IF(CROSSFROMBELOW(ID17.SG2@3:ID17.SG2@4,ID17.SG1@3:ID17.SG1@4),-1,IF(CROSSFROMABOVE(ID17.SG2@3:ID17.SG2@4,ID17.SG1@3:ID17.SG1@4),1,L4)) Cell M3: =IF(L3=-1,K3,0) where ID17 is the Hilbert Sine Wave study; edit K3/L3 as needed. |