Home >> Support Board

Support Board

Date/Time: Fri, 19 Apr 2024 03:13:52 +0000

How to Post a Message for Support

[Programming Help] - Simplest way to distinguish between an Up bar vs Down bar

View Count: 858

[2020-02-07 17:58:30] #1 [Go To First Post]
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] #2 [Go To First Post]
Sawtooth - Posts: 3973
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] #3 [Go To First Post]
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 - 220 views

[2020-02-09 00:57:35] #4 [Go To First Post]
Sawtooth - Posts: 3973
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] #5 [Go To First Post]
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: