Support Board
Date/Time: Thu, 05 Feb 2026 11:24:41 +0000
Post From: Spreadsheet System For Trading: IF Candle@4 is Green and Candle@5 is Red, then.....
| [2026-02-05 06:22:03] |
| PeaceFrog - Posts: 116 |
|
Hello, In Spreadsheet System For Trading I'd like to create a formula with the condition that: IF(AND( the Heikin Ashi Candle (ID1) in Row 4 is Green (closed up), and the Heikin Ashi Candle (ID1) in Row 5 is Red (closed down) then) 1,0) Basically, if the candle before the current active candle is Green and the candle before that one is Red, then 1 I've searched but haven't found a way to do it. Thank you for your help. |