Support Board
Date/Time: Thu, 26 Jun 2025 13:09:23 +0000
[User Discussion] - alerts issue
View Count: 818
| [2021-11-05 11:07:26] |
| 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 |
| Attachment Deleted. |
2.png| [2021-11-05 14:51:53] |
| Sawtooth - Posts: 4231 |
|
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] |
| User278398 - Posts: 296 |
|
working perfect
|
| [2021-11-14 10:11:12] |
| 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] |
| Sawtooth - Posts: 4231 |
|
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] |
| 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 |
| [2021-11-14 19:13:23] |
| Sawtooth - Posts: 4231 |
|
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] |
| 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: