Support Board
Date/Time: Sat, 11 Jan 2025 06:55:15 +0000
[Programming Help] - how to extend prior hours 50% retracement? i guess tomgilb knows
View Count: 956
| [2016-11-10 14:13:29] |
| User63439 - Posts: 83 |
|
i would like to extend the 50% retracement of the last hour to the close of the next one. i use the auto retracement/ projection indicator for actual 60 minutes, and thought if this can be done by a spreadsheet study. i know theres a tool for retracements, but it must be drawn automatically just for next 60 minutes. please see attached chart and thanks in advance |
| [2016-11-10 18:33:22] |
| jackw - Posts: 57 |
|
You can do what your trying to accomplish without a spreadsheet, although it will require that you keep an hourly chart open in the background. The attached chart shows what it looks like, and the attached chartbook shows how I did it. Note that you will have to change the chart's symbol to something you have data for. Of course, This can also be done with a spreadsheet. I sure Tom will post something for you when he gets time. |
 Chart1.png / V - Attached On 2016-11-10 18:32:04 UTC - Size: 58.56 KB - 258 views  Hourly Midpoint.cht - Attached On 2016-11-10 18:32:26 UTC - Size: 59.94 KB - 306 views |
| [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) |
To post a message in this thread, you need to log in with your Sierra Chart account: