Support Board
Date/Time: Fri, 17 Jan 2025 15:22:45 +0000
Price Cross from above a level from the past
View Count: 1398
| [2017-12-13 19:55:11] |
| User252419 - Posts: 235 |
|
Using spreadsheet system I'm trying to give an entry when price crosses a level from the past (400 bars behind the actual price). I am using CROSSFROMABOVE/BELOW and CROSSOVER, but the signal does not appear when it actually crosses the level from the past. It only appears when crossing a level that's actually creating. The Ranges that I compare in the functions must have the same amount of cells CROSSOVER(B3:B400,AA3:AA400)? As I just want to compare the actual price, but compare actual price with a level that is 400 bars behind,could the amount of cells be different like this CROSSOVER(B3:B4,AA3:AA400)? I just want that when the price hits a past support/resistance level it buys or sells. Thank you, |
| [2017-12-13 20:46:02] |
| |
|
For what you want to do you cannot use the CROSSOVER function. The way you are doing this is not valid. You just have to write a formula to do the crossover comparison. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: