Support Board
Date/Time: Fri, 31 Oct 2025 21:20:31 +0000
[Programming Help] - This formula doesn't seem to work
View Count: 1459
| [2018-05-06 19:02:03] |
| User240019 - Posts: 112 |
|
I'm trying to do a simeple true/false condition so that I can color the bar that meets the following condition and this doesn't seem to be working. I'm try to ask - is the bars range longer than 6ticks & is the number of trades associated with that bar equal to or more than 350. What do I need to do? |
 Problems_with_Spreadsheet_Fomulas.png / V - Attached On 2018-05-06 19:00:33 UTC - Size: 133.76 KB - 400 views |
| [2018-05-07 01:30:30] |
| Sawtooth - Posts: 4281 |
|
In a spreadsheet Formula Column's row 3, try this: =AND(G3>=350,(C3-D3)/$J$21>6) You can also do this with the Color Bar Based On Alert Condition study, using the Simple Alert syntax: =AND(NT>=350,(H-L)/TICKSIZE>6) |
| [2018-05-07 12:23:41] |
| User240019 - Posts: 112 |
|
thank you! How can I get the code that references various studies? For instance, you show NT = Number of Trades, where is this documented? |
| [2018-05-07 13:05:29] |
| Sawtooth - Posts: 4281 |
|
Study/Chart Alerts And Scanning Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables Spreadsheet Example Formulas and Usage |
To post a message in this thread, you need to log in with your Sierra Chart account: