Login Page - Create Account

Support Board


Date/Time: Thu, 26 Jun 2025 16:25:41 +0000



Post From: Crossover For Multiple values - spreadsheet

[2021-11-12 04:16:31]
Sawtooth - Posts: 4231
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