Login Page - Create Account

Support Board


Date/Time: Tue, 18 Nov 2025 06:23:18 +0000



Post From: alert condition not updating on bar close

[2025-09-26 20:15:58]
daif1029 - Posts: 11
the study is meant to alert when the preceding candle closes above the current and vice versa for closure below, then i would use the subgraph/alert extension lines instead of color bars.
however this =AND(C < O, C[1] > O[1], C[1] > O) would not update in realtime becuase of the [1], so i want to ask what is the equivalent of this formula when inputed into a spreadsheet as spreadsheet does allow [1] i believe.