Login Page - Create Account

Support Board

Date/Time: Tue, 16 Jan 2018 07:58:58 +0000

Price Cross from above a level from the past

Support Request:
[2017-12-13 19:55:11]
User252419 - Posts: 187
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]
Sierra Chart Engineering - Posts: 56178
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. If possible please keep your questions brief and to the point. Please be aware of support policy:

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.

To post a message in this thread, you need to login with your Sierra Chart account:


Login Page - Create Account