Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 15:00:50 +0000

How to Post a Message for Support

Post From: Spreadsheet: special bars as doji and pin-less

[2020-02-15 00:02:59]
[Go To First Post]
User190501 - Posts: 92
=OR ( AND( ID0.SG4@3<ID0.SG1@3, ID0.SG4@4>ID0.SG1@4, ID0.SG4@3<= ID0.SG1@4, ID0.SG4@3>ID1.SG1@3, ID0.SG4@3>ID1.SG2@3) , AND( ID0.SG4@5>ID0.SG1@5, ID0.SG4@4<ID0.SG1@4, ID0.SG4@3<ID0.SG1@3, ID0.SG4@4>ID0.SG1@5, ID0.SG4@3>ID1.SG1@3, ID0.SG4@3>ID1.SG2@3) , OR (AND(CROSSFROMABOVE(ID0.SG4@3:ID0.SG4@4, ID1.SG1@3:ID1.SG1@4),OR( ID0.SG4@3>=ID1.SG2@3, ID0.SG4@3>=ID2.SG1@3)), AND(CROSSFROMABOVE(ID0.SG4@3:ID0.SG4@4, ID1.SG2@3:ID1.SG2@4), OR(ID0.SG4@3>=ID1.SG1@3, ID0.SG4@3>=ID2.SG1@3)), AND(CROSSFROMABOVE(ID0.SG4@3:ID0.SG4@4, ID2.SG1@3:ID2.SG1@4), OR(ID0.SG4@4>=ID1.SG1@4, ID0.SG4@4>=ID1.SG2@4)) ) )


My form is a bit long and not sure if you need to make each compare or > or < to change it to the absolute ? for instance ID0.SG4@3> ID1.SG1@3 to be ABS(ID0.SG4@3-ID1.SG1@3) >0.005 and apply this to all compare formulas , but what if we have a crossabove/below ?