Support Board
Date/Time: Wed, 07 May 2025 16:23:35 +0000
Post From: Using ranges in a simple Spreadsheet Formula study
| [2024-11-25 17:44:23] |
| John - SC Support - Posts: 39675 |
|
If what you are wanting is to get a signal for all twelve bars when there is a crossover that occurs within those twelve bars, then there is not a way to do this. The CROSSOVER function is taking two ranges of data and comparing them to each other to find if there is a crossover of the data between these. If there is a crossing, then there the function gives a value of 1 or -1 (depending on the direction of the crossing). But it is just a notice at the particular location of the crossing. -- Also, there is no reason for your alert condition the way you have it. You are testing if the result is 1, then outputting 1, or if -1 then output -1 and otherwise 0. You are double testing for reason. Just use the following formula: =CROSSOVER(id65.sg1[-1:-12], 0.10) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |