Login Page - Create Account

Support Board


Date/Time: Tue, 16 Sep 2025 06:36:50 +0000



Post From: Crossover For Multiple values - spreadsheet

[2021-11-12 04:16:31]
Sawtooth - Posts: 4263
The spreadsheet syntax for the CROSSOVER function is different than it is for Simple Alerts.
You must us a pair of ranges encompassing the current bar and a previous bar.
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#CROSSOVER_Function

To get a second pair of ranges, use the Horizontal Lines study for the 6 values, and reference their ID#.SG#s