Support Board

Date/Time: Wed, 05 Feb 2025 10:51:51 +0000

Post From: Determining slope of three EMA's

[2020-03-03 23:31:37] Link To Thread - Link To Post [Go To First Post]
tommartin321 - Posts: 74
Hello, I have three EMA's I need to determine the slope for. Right now I have each in a separate column(X,Y,Z). Is this the most efficient way? Is it possible to combine all three into one? =IF(OR(ID11.SG1@3>ID11.SG1@4,AND(ID11.SG1@5>=ID11.SG1@4,ID11.SG1@3>ID11.SG1@4)),1,IF(OR(ID11.SG1@3<ID11.SG1@4,AND(ID11.SG1@5<=ID11.SG1@4,ID11.SG1@3<ID11.SG1@4)),-1,X4)) =IF(OR(ID15.SG1@3>ID15.SG1@4,AND(ID15.SG1@5>=ID15.SG1@4,ID15.SG1@3>ID15.SG1@4)),1,IF(OR(ID15.SG1@3<ID15.SG1@4,AND(ID15.SG1@5<=ID15.SG1@4,ID15.SG1@3<ID15.SG1@4)),-1,Y4)) =IF(OR(ID12.SG1@3>ID12.SG1@4,AND(ID12.SG1@5>=ID12.SG1@4,ID12.SG1@3>ID12.SG1@4)),1,IF(OR(ID12.SG1@3<ID12.SG1@4,AND(ID12.SG1@5<=ID12.SG1@4,ID12.SG1@3<ID12.SG1@4)),-1,Z4)) Thanks, Tom