Support Board

Date/Time: Tue, 21 May 2024 03:48:02 +0000

Post From: Determining slope of three EMA's

[2020-03-04 15:26:10] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4002
I'm only interested in reading the slope when all three are sloping in the same direction. You could combine them with the AND function but the formula would be very long. If you have a spare Formula Column, you could use a 4th Formula Column to combine them, but you'll need a third condition when not all are sloped the same: =IF(AND(O3=1,P3=1,Q3=1),1,IF(AND(O3=-1,P3=-1,Q3=-1),-1,IF(OR(SUM(O3,P3,Q3)<>3,SUM(O3,P3,Q3)<>-3),0,R4))) This example goes in cell R3. If you want the slope in degrees, use the Study Angle study. Study Angle Date Time Of Last Edit: 2020-03-07 04:45:31