Login Page - Create Account

Support Board


Date/Time: Thu, 05 Feb 2026 11:25:33 +0000



Spreadsheet System For Trading: IF Candle@4 is Green and Candle@5 is Red, then.....

View Count: 8

[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.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account