Support Board

Date/Time: Sat, 18 May 2024 04:37:22 +0000

Post From: Color Bar Based on Alert on PNF Chart

[2023-07-21 14:43:30] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
You can use the Spreadsheet Formula study to find up and down bars, using this formula in its Formula field: =IF(OR(C>O,AND(O>C[-1],O=C)),1,IF(OR(C<O,AND(O<C[-1],O=C)),-1,ID5.SG1[-1])) where ID5 is this Spreadsheet Formula study. Up bars will return 1, down bars will return -1. This is an Alert syntax conversion from this spreadsheet syntax: Spreadsheet Example Formulas and Usage: Formula that Matches the Coloring of Up and Down Price Bars