Login Page - Create Account

Support Board


Date/Time: Mon, 22 Apr 2024 21:36:40 +0000



Post From: CROSSFROMABOVE, CROSSFROMBELOW function

[2016-01-04 01:37:53]
User87521 - Posts: 81
Thanks very much Tom. I did some work on this. Will this work with multiple pivot points? I ask because of the following:

My spreadsheet is structured like this:

MA last cell - AE3 (most up to date MA value)

Pivot point cells - AI3 to AX3 (from horizontal line study)
Cells are also populated from AI3 to AI "xx", AJ3 to AJ "xx"- etc.

My formula for the Buy Entry is as follows:


=OR(AND(AI4>AE4,AE3>AI3),AND(AJ4>AE4,AE3>AJ3),AND(AK4>AE4,AE3>AK3),AND(AL4>AE4,AE3>AL3),AND(AM4>AE4,AE3>AM3),AND(AN4>AE4,AE3>AN3),AND(AO4>AE4,AE3>AO3),AND(AP4>AE4,AE3>AP3),AND(AQ4>AE4,AE3>AQ3),AND(AR4>AE4,AE3>AR3),AND(AS4>AE4,AE3>AS3),AND(AT4>AE4,AE3>AT3),AND(AU4>AE4,AE3>AU3),AND(AV4>AE4,AE3>AV3),AND(AW4>AE4,AE3>AW3),AND(AX4>AE4,AE3>AX3))


And for the Buy Exit:

=OR(AND(AI4<AE4,AE3<AI3),AND(AJ4<AE4,AE3<AJ3),AND(AK4<AE4,AE3<AK3),AND(AL4<AE4,AE3<AL3),AND(AM4<AE4,AE3<AM3),AND(AN4<AE4,AE3<AN3),AND(AO4<AE4,AE3<AO3),AND(AP4<AE4,AE3<AP3),AND(AQ4<AE4,AE3<AQ3),AND(AR4<AE4,AE3<AR3),AND(AS4<AE4,AE3<AS3),AND(AT4<AE4,AE3<AT3),AND(AU4<AE4,AE3<AU3),AND(AV4<AE4,AE3<AV3),AND(AW4<AE4,AE3<AW3),AND(AX4<AE4,AE3<AX3))


No syntax errors recognized.

Both the buy entry and the buy exit register "FALSE". Currently, the Buy Exit should register "TRUE".