Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 21 May 2024 03:49:13 +0000
Post From: Determining slope of three EMA's
| [2020-03-03 23:31:37] |
| 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 |