Login Page - Create Account

Support Board


Date/Time: Sat, 21 Jul 2018 21:08:19 +0000



Post From: Price Cross from above a level from the past

[2017-12-13 19:55:11]
User252419 - Posts: 232
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,