Support Board

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

Date/Time: Wed, 27 Nov 2024 08:38:54 +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: 4120
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 - 110 views