Support Board
Date/Time: Thu, 13 Feb 2025 14:22:43 +0000
Alert conditions using Number Bar Calculated Values
View Count: 831
| [2020-12-11 12:51:33] |
| User135370 - Posts: 162 |
|
Hi Can you help to write 2 formulas for the Number Bar Calculated Value I want to colour the bar if: I have this formula ID5.SG1=ID5.SG8 but I want it to be colour if ID5.SG1 (is greater than 90% of) ID5.SG8 How do I write "is greater than 90% of" The Ask Volume Percentage calculated Number bar values and I want it to color if the Ask Bid Percentage is more than 70% I'm writing it like this - ID5.SG17 > .70 is that correct because it doesn't seem to read it Would appreciate the help |
| [2020-12-11 15:54:17] |
| Sawtooth - Posts: 4173 |
|
Try these: =ID5.SG1 > ID5.SG8 *0.9 =ID5.SG17 > 0.7 Your second formula is valid, and works for me. |
| [2020-12-11 16:16:57] |
| John - SC Support - Posts: 37916 |
|
With regards to the second formula, be aware that if you are comparing to an actual Percentage value in the display, you will need to make a change to how the data is displayed. Refer to the following: Numbers Bars: Referencing Numbers Bars Calculated Values Subgraphs in Alert Formulas For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-12-11 18:04:27] |
| User135370 - Posts: 162 |
|
Thanks John much appreciated worked like a charm, can I bother you again with the following =AND(ID5.SG1> .99*ID5.SG8), OR([0] = ID13.SG2 , [-1]=ID13.SG2) The first part is correct but then I want to add to it the current or the previous candle condition I think my issue is with brackets |
| [2020-12-11 18:45:49] |
| User135370 - Posts: 162 |
|
Honestly don't know what I'm doing wrong here basically trying to combine the following: = AND(ID5.SG1> .90*ID5.SG8) which works on it's own =OR(ID13.SG2[-1],ID13.SG2[0]) which is now also working on it's own When I combine them after going through the documentation like so which seems correct I get the error message =OR(AND(ID13.SG2[-1],ID13.SG2[0], AND(ID5.SG1> .90*ID5.SG8)) Can you help, honestly I'm trying to do it on my own and only come to you when I'm stuck |
| [2020-12-11 19:09:03] |
| Ackin - Posts: 1865 |
|
I added a parenthesis, try, maybe that's it
|
| [2020-12-11 19:21:54] |
| User135370 - Posts: 162 |
|
Thanks Ackin, Something is not write with that it highlights more bars than just the one after and at the swing low, it should only give a signal at the swing low and the bar after hence 0 and -1 |
| [2020-12-11 19:41:40] |
| Ackin - Posts: 1865 |
|
=AND(ID5.SG1> .90*ID5.SG8,OR(ID13.SG2[-1],ID13.SG2))
|
| [2020-12-11 19:43:57] |
| User135370 - Posts: 162 |
|
Beautiful, thank you Ackin worked like a charm
|
To post a message in this thread, you need to log in with your Sierra Chart account: