Login Page - Create Account

Support Board


Date/Time: Sat, 20 Dec 2025 01:37:05 +0000



Post From: IF function with a look back of 4 bars

[2020-04-02 00:16:39]
tommartin321 - Posts: 78
Hello,

Working with the Spreadsheet System for Trading, I'm looking for two signals. Let's call them Sig01 and Sig02. I want to find the second signal (Sig02) first, and then look back a max of four bars for Sig01 .

My attempt below at the plain logic of the system.

(=IF Sig02 then go backwards looking for Sig01 anywhere within the last 4 bars)


Thank you,

Tom