You are correct. Had it right in my function but documentation wrong so totally bungled the description. And yes, the ABS function must be used.
Earl -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Charles Mattson Sent: Sunday, January 28, 2007 9:05 PM To: [email protected] Subject: RE: [quotes-plus] True Range Function For some reason I think the ATR is * The current high less the current low. * The absolute value of: current high less the previous close. * The absolute value of: current low less the previous close. Your formula seems to be wrong Charles _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of EAdamy Sent: Sunday, January 28, 2007 9:15 PM To: [email protected] Subject: [quotes-plus] True Range Function Just finished doing True Range calculations in Excel which takes a very long formula. Certainly would be nice to have a True Range function: qp_TrueRange(day,symbol). True Range is the greatest of the following: Today's high - Today's low Today's high - Yesterday's low. Yesterday's close - Today's low Earl [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
