Support Board
Date/Time: Mon, 03 Feb 2025 09:53:27 +0000
Post From: Wanting to use crossfromabove twice
| [2019-09-21 00:29:23] |
| Sawtooth - Posts: 4164 |
|
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)) |