Support Board

Date/Time: Sat, 04 May 2024 05:35:08 +0000

Post From: Converting a Slope Study Alert into Buy/Exit

[2014-03-15 17:28:23] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
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.