Date/Time: Wed, 17 Oct 2018 21:53:30 +0000
Price Cross from above a level from the past
|User252419 - Posts: 234|
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.
Sierra Chart Engineering - Posts: 64930
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.
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: