Login Page - Create Account

Support Board


Date/Time: Wed, 01 Apr 2020 23:59:46 +0000



[User Discussion] - highlight entired background once EMA cross over SMA

[2014-10-02 21:38:39]
User35749 - Posts: 32 | Ending Date: 2014-09-03 [Expired]
Dear Sir or Madam:
I know how to highlight a background once EMA15 cross over SMA50; however, I just wonder can I highlight the background as long as EMA15 cross below SMA50 (one color) and EMA15 cross above SMA50 (different color background highlight)? Thanks,
Van
[2014-10-02 21:51:30]
Sierra Chart Engineering - Posts: 82993 | Ending Date: 2020-06-09
Since you want to use two different colors, you need to use two instances of the Color Background Based on Alert Condition studies. One for each condition and color.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2014-10-02 21:51:40
[2014-10-03 21:40:55]
User35749 - Posts: 32 | Ending Date: 2014-09-03 [Expired]
How can I highlight an entire background as long as EMA15 below SMA50? Thanks!
[2014-10-03 21:47:04]
Sierra Chart Engineering - Posts: 82993 | Ending Date: 2020-06-09
You could only do this with ACSIL by changing the background color of the chart. Not using the Color Background study.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2014-10-03 22:11:20]
tomgilb - Posts: 2429 | Ending Date: 2020-04-30
How can I highlight an entire background as long as EMA15 below SMA50? Thanks!

You can do it with the Spreadsheet Study study, using very simple formulas:

-Add the Spreadsheet Study study, give it a name in the Spreadsheet Name field, and set the Chart Region to 1.
-Set the Draw Style of K(SG1) and L(SG2) to Background, and set each subgraph to it's own color
-Put these formulas in these cells:
Cell K3:
=$AA$3>$AC$3
Cell L3:
=$AA$3<$AC$3

This assumes the MAs are at the top of the Studies to Graph list, so that their output is in columns AA and AC.
You can also edit the formulas to reference different columns.

To post a message in this thread, you need to login with your Sierra Chart account:

Login

Login Page - Create Account