Support Board
Date/Time: Sat, 11 Jan 2025 10:05:07 +0000
Post From: how to extend prior hours 50% retracement? i guess tomgilb knows
| [2016-11-10 23:04:01] |
| Sawtooth - Posts: 4147 |
|
This can be done with the Spreadsheet Study study. Try this: -Add the Spreadsheet Study study -Set the Chart Region to 1 -Give it a name in the Spreadsheet Name field -Set the Draw Style of K(SG1) to Ignore and others to Dash or Point -Use these formulas: Cell K3: =FLOOR(A3-INT(A3),1/24) Cell L3: =IF(K3>K4,ID1.SG3@4,L4) -This assumes the Auto Retracement/Projection study is ID1; edit as needed. -This assumes the Auto Retracement/Projection study's Time Period is set to 60 Minutes. -This is an example for one of the lines. To repeat for other lines, use the L3 formula in other Formula Columns, editing the respective SG# and column, e.g. in column M: =IF(K3>K4,ID1.SG4@4,M4) |