Support Board
Date/Time: Tue, 04 Feb 2025 18:49:45 +0000
[Programming Help] - Simplest way to distinguish between an Up bar vs Down bar
View Count: 929
| [2020-02-07 17:58:30] |
| tommartin321 - Posts: 74 |
|
Hello, I'm currently distinguishing between an Up bar vs Down bar as shown below. I'm not concerned with doji bars. Up Bar: =E3 > B3 Down Bar: =E3 < B3 Is this the most efficient way to reference an Up vs Down bar? I was surprise I couldn't find a simple study for this. Thanks, Tom |
| [2020-02-07 19:29:37] |
| Sawtooth - Posts: 4166 |
|
Use this method: Spreadsheet Example Formulas and Usage: Formula that Matches the Coloring of Up and Down Price Bars |
| [2020-02-08 17:37:43] |
| tommartin321 - Posts: 74 |
|
Thanks Tom. I've placed the code in column T at row 3, but it only produces a 1/-1 for row 3. Shouldn't it generate a result (1, -1) for every row in column T? Thank you, Tom |
 Column T.png / V - Attached On 2020-02-08 17:34:09 UTC - Size: 8.69 KB - 245 views |
| [2020-02-09 00:57:35] |
| Sawtooth - Posts: 4166 |
|
Shouldn't it generate a result (1, -1) for every row in column T?
Use the Sheet# that matches the chart #,or set the Formula Source Sheet Number to Sheet1. |
| [2020-02-09 02:25:30] |
| tommartin321 - Posts: 74 |
|
That was it, thank you.
|
To post a message in this thread, you need to log in with your Sierra Chart account: