Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 23 Apr 2024 16:44:00 +0000
Adjust the position of a
View Count: 1219
| [2014-01-20 23:37:18] |
| moonmist - Posts: 127 |
|
Hi, I am coding a "Spreadsheet System/Alert" study to mark the descending triangles by putting a logical statement into the cell M3(Sell Entry). I then clicked the Subgraphs tab, and selected "Arrow Down" as "Draw Style" and size 3 for SG3. However, some arrows were below the high of the associated bars. Please refer to the attached chart for details. The "Color Bar Based on Alert Condition" study allows me to put the "down arrow" 15% above the high of a bar. Does the spreadsheet provide similar options ? Thanks. Date Time Of Last Edit: 2014-01-20 23:43:21
|
 TriangleMarker.png / V - Attached On 2014-01-20 23:34:00 UTC - Size: 74.18 KB - 393 views |
| [2014-01-21 01:15:29] |
| Sawtooth - Posts: 3976 |
|
You can adjust the distance of the arrow in ticks using this formula: =IF(YourConditions,C3+$J$21*3,0) This will put the arrow 3 ticks above the High. |
| [2014-01-21 01:21:29] |
| moonmist - Posts: 127 |
|
Thanks. I'll give try that. |
To post a message in this thread, you need to log in with your Sierra Chart account: