EquityRT Help
Mathematical Functions

You can find mathematical functions and detailed descriptions in this topic.

Name

Function

Description

AbsoluteValue

abs(Data_Array)

Calculates the absolute value of the Data Array.

ArcTangent

atan(Data_Array1, Data_Array2)

Calculates the arc tangent of Data_Array1/Data_Array2. The result is in degrees between 0 and 359.9.

Ceiling

ceiling(Data_Array)

Calculates the lowest integer that is greater than the Data Array.

Cosine

cos(Data_Array)

Calculates the cosine of the Data Array. Assumes that the Data Array values are in degrees. The result is in degrees. 

Exponent

exp(Data_Array)

Calculates e raised to the Data Array power.

Floor

Floor(Data_Array)

Calculates the highest integer that is less than the Data Array.

Logarithm

log(Data_Array)

Calculates the natural logarithm of the Data Array.

Maximum

max(Data_Array1, Data_Array2)

Returns the largest of the two Data Arrays.

Minimum

min(Data_Array1, Data_Array2)

Returns the smallest of the two Data Arrays.

Modulus

mod(Data_Array1, Data_Array2)

Calculates the fractional portion the Data Array1 divided by Data Array2.  Division by "0" produces "0" result.

Power

power(Data_Array, Power)

Calculates the Data Array raised to the Power power.  A negative Data Array value raised to a non-integer Powercauses an error message to be displayed.

Precision

prec(Data_Array, Precision)

Truncates the Data Array value to precision decimal places.

Round

round(Data_Array)

Rounds the Data Array value to the nearest integer.

Sin

sin(Data_Array)

Calculates the sine of the Data Array. Assumes that the Data Array values are in degrees. The result is in degrees.

SquareRoot

sqrt(Data_Array)

Calculates the square root of the Data Array. The square root of a negative number always returns a "0" result.