Support Board
Date/Time: Tue, 01 Jul 2025 14:07:29 +0000
Post From: Wanting to use crossfromabove twice
| [2019-09-21 00:29:23] |
| Sawtooth - Posts: 4231 |
|
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)) |