Support Board

Date/Time: Sat, 27 Jul 2024 01:45:26 +0000

Post From: CROSSFROMABOVE, CROSSFROMBELOW function

[2016-01-04 01:37:53] Link To Thread - Link To Post [Go To First Post]
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".