Support Board

Date/Time: Sat, 18 May 2024 15:40:24 +0000

Post From: Crossover strategy

[2015-02-14 15:27:03] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
Your formulas will occasionally give subsequent signals of the same direction. This is to be expected when there is an offset. If you want to ignore subsequent signals of the same direction, try this: O3: =IF(AND(CROSSFROMBELOW(C3:C4,D3:D4),C3>(D3+0.2)),TRUE,IF(AND(CROSSFROMABOVE(C3:C4,D3:D4),D3>(C3+0.2)),FALSE,O4)) this goes TRUE at the first cross from below, and stays TRUE until the first cross from above. P3: =IF(AND(CROSSFROMABOVE(C3:C4,D3:D4), D3>(C3+0.2)),TRUE,IF(AND(CROSSFROMBELOW(C3:C4,D3:D4),C3>(D3+0.2)),FALSE,P4)) this goes TRUE at the first cross from above, and stays TRUE until the first cross from below. K3: =AND(O3,O4=FALSE) this finds the first cross from below TRUE M3: =AND(P3,P4=FALSE) this finds the first cross from above TRUE