Support Board
Date/Time: Sun, 22 Dec 2024 10:03:44 +0000
Post From: Crossover strategy
| [2015-02-14 15:27:03] |
| Sawtooth - Posts: 4141 |
|
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 |