Home >> Support Board

Support Board

Date/Time: Tue, 04 Nov 2025 06:42:57 +0000

How to Post a Message for Support

[User Discussion] - alerts issue

View Count: 877

[2021-11-05 11:07:26] #1 [Go To First Post]
User278398 - Posts: 296
which formula i need to put to see allways the background of last bar in chart? *photo is attached for example regards


2.png / V - Attached On 2021-11-05 11:07:10 UTC - Size: 69.19 KB - 187 views Attachment Deleted.

[2021-11-05 14:51:53] #2 [Go To First Post]
Sawtooth - Posts: 4285
To color the background of the current bar, try this: 1. Add the Color Background Based On Alert Condition study - Check 'Hide Study' - Use this formula on its Alerts tab: =C[1] 2. Add another instance of the Color Background Based On Alert Condition study - Use a formula like this on its Alerts tab: =ID1.SG1=0 where the hidden color background study is ID1; edit the ID# as needed. Hide currently forming candle See post #10

[2021-11-05 17:10:11] #3 [Go To First Post]
User278398 - Posts: 296
working perfect

[2021-11-14 10:11:12] #4 [Go To First Post]
User278398 - Posts: 296
hello for the same issue, there is a way to show for "study subgraph above/below bar as text" study only for the last candle ? regards

[2021-11-14 13:27:56] #5 [Go To First Post]
Sawtooth - Posts: 4285
Since you've already identified the last candle using the steps in post #2: 1. Add the Spreadsheet Formula study - Check 'Hide Study' - Set 'Draw Zero Values' to No. - Use a formula like this in its Formula field: =IF(ID1.SG1,ID2.SG1,0) where ID1 is the hidden color background study from post #2, and ID2.SG1 is the study subgraph that you currently reference with the Study Subgraph Above/Below Bar as Text study. Edit these as needed. 2. In the Study Subgraph Above/Below Bar as Text study, change the reference to the Spreadsheet Formula study's ID#.SG1 Explanation: The Spreadsheet Formula study is filtering all except the last bar of what the Study Subgraph Above/Below Bar as Text study was previously referencing. The Study Subgraph Above/Below Bar as Text study now references the Spreadsheet Formula study instead.

[2021-11-14 15:31:51] #6 [Go To First Post]
User278398 - Posts: 296
Hello, it doesn't work for me, because u ask for me to reference to the spreadsheet formula study,but my "Study Subgraph Above/Below Bar as Text study" study (id58) is already refer to another study (bar difference, id47),see in pic number 2 in the "spreadsheetformula" study i put the equation as u told me see in pic number 1 id2 - where ID2 is the hidden color background study from post #2 see in pic number 3* Explanation: i want to see only the last bar data from "Study Subgraph Above/Below Bar as Text study" that refer to another study (bar differnce). what can i do to fix it ? regards


1.png / V - Attached On 2021-11-14 15:13:41 UTC - Size: 453.88 KB - 182 views 2.png / V - Attached On 2021-11-14 15:13:52 UTC - Size: 492.67 KB - 178 views 3.png / V - Attached On 2021-11-14 15:20:37 UTC - Size: 824.49 KB - 175 views

[2021-11-14 19:13:23] #7 [Go To First Post]
Sawtooth - Posts: 4285
what can i do to fix it ? Use this formula in the Spreadsheet Formula study's Formula field: =IF(ID25.SG1,ID47.SG1,0) Reference the Spreadsheet Formula study subgraph in the Study Subgraph Above/Below Bar as Text study's 'Input Study Subgraph': ID45.SG1

[2021-11-14 19:22:12] #8 [Go To First Post]
User278398 - Posts: 296
works perfect !!! thank u very much :):):)

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