Registered User
Joined: 11/20/2006
Posts: 4
|
Trying to determine the mid point (MP) of a candle body. Range (R) = (O - C). Thus MP = R / 2 + C. But if O > C, then to get around a <> #, one must use 'absolute' [ABS], But 1/2 R must now be added to O, not C.
Excel can handle this by using "IF" statements. Any way for Telechart to easily handle?
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The following form for the formula does not require using an absolute value.
(O + C) / 2
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|