Support Board
Date/Time: Sun, 24 Nov 2024 15:22:01 +0000
[Programming Help] - Question about Spreadsheet System Alert Study
View Count: 204
| [2024-05-25 16:06:59] |
| User936417 - Posts: 12 |
|
Hi I have a Question about Spreadsheet System Alert Study I have a formula in Column O that works (I get a 1 for true when condition is true and 0 for false when condition is false) However I can only get the Color Bar draw style to appear on the chart. This is the only draw style that will work. I would like to use the up or down arrow but they will not appear. Any idea what I am doing wrong? thanks much, bob |
| [2024-05-25 22:47:19] |
| Sawtooth - Posts: 4118 |
|
Use formulas like this: =IF(YourConditions,C3,0) This will place the arrow at the high of the bar. Or this: =IF(YourConditions,C3+$J$21*2,0) This will place the arrow two ticks above the high of the bar. Or this: =IF(YourConditions,D3-$J$21*2,0) This will place the arrow two ticks below the low of the bar. |
To post a message in this thread, you need to log in with your Sierra Chart account: