Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 26 Apr 2024 03:48:58 +0000
[User Discussion] - Only want one alternating buy and sell in each direction. Please
View Count: 1554
| [2013-06-03 15:35:53] |
| Sawtooth - Posts: 3976 |
|
It is not clear what the % increase is of. Is it the difference of the differences before and after the crossover?
Date Time Of Last Edit: 2013-06-03 15:44:13
|
| [2013-06-03 17:57:09] |
| Sawtooth - Posts: 3976 |
|
Try these: K3: =AND(AC4>AA4,AA3>AC3,(((AA3-AA4)-(AC3-AC4))/(((AA3-AA4)+(AC3-AC4))/2))*100>=23) M3: =AND(AC4<AA4,AA3<AC3,(((AC4-AC3)-(AA4-AA3))/(((AC4-AC3)+(AA4-AA3))/2))*100<=-17) These assume the EMA10 is in column AA and the EMA21 is in column AC. The first portion finds the crossovers, the second calculates the % using your formula, and the third compares the % to your minimums when the crossover is TRUE. Nearly all of the % are > your minimums, and all are > than your minimums at the crossovers. Are you certain about the % formula? Date Time Of Last Edit: 2013-06-03 18:35:40
|
To post a message in this thread, you need to log in with your Sierra Chart account: