Login Page - Create Account

Support Board


Date/Time: Thu, 05 Feb 2026 03:45:24 +0000



Post From: Spreadsheet System for Trading Study - help request for formula

[2022-12-30 15:05:34]
Sawtooth - Posts: 4312
The simplest would be this:
=AND(C3>AA3,E3<AA3)

You could also require a crossover of the Close from the previous bar:
=AND(C3>AA3,CROSSFROMABOVE(E3:E4,AA3:AA4))