Support Board
Date/Time: Wed, 27 Nov 2024 18:54:30 +0000
Post From: Color Bar Based on Alert on PNF Chart
| [2023-07-21 14:43:30] |
| Sawtooth - Posts: 4120 |
|
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 |