Support Board
Date/Time: Fri, 31 Oct 2025 23:42:48 +0000
Current Price Line
View Count: 1243
| [2016-05-15 21:16:14] |
| User478384 - Posts: 4 |
|
Is there a way to have the CPL configured so that the whole line turns Green when the next tick goes higher than the previous close , and red when the next tick goes lower than the previous close? If so, how? (auto-coloring doesn't seem to work)
Date Time Of Last Edit: 2016-05-15 22:03:19
|
| [2016-05-15 22:00:44] |
| |
|
No, this is not supported.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-05-16 12:59:04] |
| Sawtooth - Posts: 4281 |
|
You could do this with the Spreadsheet Study study, if you didn't mind that the line is only 10 bars into the past.
|
| [2016-05-16 14:58:03] |
| User478384 - Posts: 4 |
|
@tomgilb: I've added the Spreadsheet Study study, please advise as to how to get it to work.
|
| [2016-05-16 17:28:47] |
| Sawtooth - Posts: 4281 |
|
I'll give you the formulas if you share the ID# of your CPL study.
|
| [2016-05-16 17:43:06] |
| User478384 - Posts: 4 |
|
the ID# of the CPL study is ID:9
|
| [2016-05-16 20:34:58] |
| Sawtooth - Posts: 4281 |
|
Use these formulas on the spreadsheet: Cell K3: =IF(ID9.SG1@$3>E$4,ID9.SG1@$3,0) Cell L3: =IF(ID9.SG1@$3<E$4,ID9.SG1@$3,0) Cell M3: =IF(ID9.SG1@$3=E$4,ID9.SG1@$3,0) Then go to the spreadsheet study settings: -set the Number of Rows to 10. -set the Draw Styles of K(SG1), L(SG2), M(SG3), and set colors for each. (There is a third color for equal) Then Hide the CPL study. |
| [2016-05-17 03:58:19] |
| apollofl - Posts: 95 |
|
Nice Tom. How can I shorten that to 3 or 5 rows, instead of 10?
|
| [2016-05-17 04:17:59] |
| User478384 - Posts: 4 |
|
@tomgilb: Thank you, it is working fine. But why is it not possible to extend the line to more than 10 rows? |
| [2016-05-17 04:33:45] |
| Sawtooth - Posts: 4281 |
|
The spreadsheet will not update on every uptick/downtick beyond 10 rows. This is done for performance reasons. 10 is the minimum Number of Rows setting, however, you can use these formulas to limit it to 5 rows: Cell K3: =IF(AND(ROW()<8,ID9.SG1@$3>E$4),ID9.SG1@$3,0) Cell L3: =IF(AND(ROW()<8,ID9.SG1@$3<E$4),ID9.SG1@$3,0) Cell M3: =IF(AND(ROW()<8,ID9.SG1@$3=E$4),ID9.SG1@$3,0) |
| [2016-05-17 05:01:30] |
| apollofl - Posts: 95 |
|
Thanks Tom.
Date Time Of Last Edit: 2016-05-17 05:55:54
|
To post a message in this thread, you need to log in with your Sierra Chart account: