Support Board
Date/Time: Wed, 27 Nov 2024 17:56:25 +0000
Post From: Converting a Slope Study Alert into Buy/Exit
| [2014-03-15 17:28:23] |
| Sawtooth - Posts: 4120 |
|
I see that you have worked on zigzag reversal alerts. Can these alerts be incorporated into Spreadsheet System for trading?
Yes, but the zigzag direction change doesn't paint for n bars so its usefulness is limited as an autotrading signal. Try this: K3: =AND(O3,AA5>AA4,AA3>AA4,AA3<>0) M3: =AND(P3,AA5<AA4,AA3<AA4,AA3<>0) O3: =IF(AND(AG5>AG4,AG3>AG4),TRUE,IF(AND(AG5<AG4,AG3<AG4),FALSE,O4)) P3: =IF(AND(AG5<AG4,AG3<AG4),TRUE,IF(AND(AG5>AG4,AG3>AG4),FALSE,P4)) where AA is the Zigzag AG is the %K O3 and P3 will 'store' the %K direction change until it reverts. K3 and M3 will not go TRUE until the zigzag also changes direction. However, the arrows from K3 and M3 will not be historically accurate because of the ZZ repaint. |