Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 15:56:32 +0000

How to Post a Message for Support

Post From: Wanting to use crossfromabove twice

[2019-09-21 00:29:23]
[Go To First Post]
Sawtooth - Posts: 4000
For a spreadsheet study, this is the correct syntax, including corrections:
=AND(CROSSFROMABOVE(ID2.SG1@3:ID2.SG1@4,ID2.SG3@3:ID2.SG3@4),CROSSFROMABOVE(ID3.SG1@3:ID3.SG1@4,ID3.SG3@3:ID3.SG3@4))

However, this will only be TRUE once, and only if both %Ks cross their Line 1 in the same bar, which is unlikely.

You probably want to use OR instead of AND:
=OR(CROSSFROMABOVE(ID2.SG1@3:ID2.SG1@4,ID2.SG3@3:ID2.SG3@4),CROSSFROMABOVE(ID3.SG1@3:ID3.SG1@4,ID3.SG3@3:ID3.SG3@4))