Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Tue, 15 Jul 2025 23:41:39 +0000

Post From: Spreadsheet syntax vs Alert syntax for price bar colors

[2023-08-31 16:20:19] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4244
This spreadsheet formula: =IF(OR(E3>B3,AND(B3>E4,B3=E3)),1, IF(OR(E3<B3,AND(B3<E4,B3=E3)),-1,T4)) taken from here: Spreadsheet Example Formulas and Usage: Formula that Matches the Coloring of Up and Down Price Bars correctly finds price bar colors. This same formula, converted to Alert syntax for use in the Spreadsheet Formula study, incorrectly gives the inverse color at doji price bars: =IF(OR(C>O,AND(O>C[-1],O=C)),1, IF(OR(C<O,AND(O<C[-1],O=C)),-1,ID1.SG1[-1])) where ID1 is this Spreadsheet Formula study. Can you offer an explanation why please? Date Time Of Last Edit: 2023-08-31 18:48:14
1x Thank you
Spreadsheet syntax vs Alert syntax.PNG / V - Attached On 2023-08-31 16:20:02 UTC - Size: 47.64 KB - 211 views