Skip to content

Data-List Function List

By Optuma Team · Updated 2015-08-20

The following table contains a list of all the pre-defined functions that return a TDataList available for use.

FunctionDescription
ADXAverage Directional Movement Index
AROONAroon
ATRAverage True Range
BARROSSWINGOVERLAYBarros Swing Chart Overlay
BBBollinger Bands
CLOSEClose
CCICommodity Channel Index
COICoppock Indicator
COMSCommodity Selection
DCCCombo Countdown
DROSCDerivative Oscillator
GANNSWINGOVERLAYGann Swing Chart Overlay
GMAGuppy Multiple Moving Average
HARTSWINGOVERLAYHart Swing Chart Overlay
HIGHHigh
HIGHERTIMEHigher Time Moving Average
HVHistorical Volatility
IchimokuCloudIchimoku Cloud
KCKeltner Channel
LOWLow
MAMoving Average
MABMoving Average Bands
MACDMACD
MFIMoney Flow Index
MIDASMidas
MKFMarket Facilitation Index
MomentumMomentum
MSIMidos SI
OBVOn Balance Volume
OBVPOn Balance Volume %
OIOpen Interest
OPENOpen
OSCOscillator
PINCPercentage Increase
PRPPrice Range Percentage
PSARParabolic Stop and Reverse
PZProfit Zones
RelCompRelComp
RIReturn of Interest
RICRelative Index Comparison
ROCRate Of Change
RSIRSI
RVIRelative Vigor Index
SeasonalDateGann Seasonal Dates
SQESequential Exhaustion
STDStandard Deviation
STLBStoller Bands
STOCHStochastic
SWINGINDEXSwing Index
TempTemperature
TOTurn Over
TRIXTRIX
VCValue Chart
VOLUMEVolume
WRWilliams %R
WRPCWilson Relative Price Channel
YearHighLowYear High Low Marker

Data-List Operators are the symbols that are used to specify the type of calculation that you want the formula to perform.

OperatorDescription
+Addition
-Subtraction
/Division
*Multiplied
>Greater Than
<Less Than
==Equal To
CrossesAboveCrosses from Below to Above a specified value
CrossesBelowCrosses from Above to Below a specified value
TurnsdownMoves from an upward trend, to a downward trend
TurnsupMoves from a downward trend, to an upward trend
AndUsed to perform a conjunction on two or more functions
NotThe negation of a function
OrUsed to include a supplementary parameter between two or more functions

Many general pascal/Delphi programming utility functions can be used in the Programming Module.

The specification for many of these functions can be found at http://www.delphibasics.co.uk/index.html and also http://delphi.about.com/od/beginners/l/blrtlmain.htm

Arithmetic routines The following table lists the arithmetic routines

RoutineDescription
AbsReturns an absolute value
CeilRounds variables up toward positive infinity
DivModReturns the result of an integer division, including the remainder
ExpReturns the exponential of X
FloorRounds variables toward negative infinity
FrexpSeparates the Mantissa and Exponent of X
IntReturns the integer part of a real number
IntPowerCalculates the integral power of a base value
IsInfiniteIndicates when a variable or expression represents an infinite value
IsNanIndicates when a variable or expression does not evaluate to a numeric value
IsZeroIndicates when a floating-point variable or expression evaluates to zero, or very close to zero
LdexpCalculates X times (2 to the power of P)
LnXP1Returns the natural log of (X+1)
Log10Calculates log base 10
Log2Calculates log base 2
LogNCalculates the log of X for a specified base
MaxReturns the greater of two numeric values (Delphi only)
MaxIntValueReturns the largest signed value in an integer array
MaxValueReturns the largest signed value in an array
MeanReturns the average of all values in an array
MinReturns the lesser of 2 numeric values (Delphi only)
MinIntValueReturns the smallest signed value in an integer array
MinValueReturns the smallest signed value in an array
OddReturns true if the argument is an odd number
PowerRaises Base to any power
RoundReturns the value of X rounded to the nearest whole number
RoundToRounds a floating-point value to a specified digit or power of 10 using “Banker’s rounding”
SignIndicates whether a numeric value is positive, negative, or zero
SimpleRoundToRounds a floating-point value to a specified digit or power of 10 using asymmetric arithmetic rounding
SqrReturns the square of a number
SqrtReturns the square root of X
SumReturns the sum of the elements in an array
SumIntReturns the sum of the elements in an integer array
SumOfSquaresReturns the sum of the squared values from a data array
SumsAndSquaresReturns the sum of the values and the sum of the squared values in an array
TruncTruncates a real number to an integer

The following table lists the trigonometric routines

RoutineDescription
ArcCosCalculates the inverse cosine of a given number
ArcCoshCalculates the inverse hyperbolic cosine of a given number
ArcCotCalculates the inverse cotangent of a given number
ArcCotHCalculates the inverse hyperbolic cotangent of a given number
ArcCscCalculates the inverse cosecant of a given number
ArcCscHCalculates the inverse hyperbolic cosecant of a given number
ArcSecCalculates the inverse secant of a given number
ArcSecHCalculates the inverse hyperbolic secant of a given number
ArcSinCalculates the inverse sine of a given number
ArcSinhCalculates the inverse hyperbolic sine of a given number
ArcTanCalculates the arc tangent of a given number
ArcTan2Calculates the arc tangent angle and quadrant of a given number
ArcTanhCalculates the inverse hyperbolic tangent of a given number
CosecantReturns the cosecant of an angle
CoshCalculates the hyperbolic cosine of an angle
CotCalculates the cotangent of an angle
CotanCalculates the cotangent of an angle
CotHCalculates the hyperbolic cotangent of an angle
CscReturns the cosecant of an angle
CscHReturns the hyperbolic cosecant of an angle
CycleToDegConverts an angle measurement from cycles to degrees
CycleToGradConverts an angle measurement from cycles to grads
CycleToRadConverts an angle measurement from cycles to radians
DegToCycleReturns the value of a degree measurement expressed in cycles
DegToGradReturns the value of a degree measurement expressed in grads
DegToRadReturns the value of a degree measurement expressed in radians
GradToCycleConverts grad measurements to cycles
GradToDegConverts grad measurements to degrees
GradToRadConverts grad measurements to radians
HypotCalculates the length of the hypotenuse
PiReturns 3.1415926535897932385
RadToCycleConverts radians to cycles
RadToDegConverts radians to degrees
RadToGradConverts radians to grads
SecCalculates the secant of an angle
SecantCalculates the secant of an angle
SecHCalculates the hyperbolic secant of an angle
SinReturns the sine of the angle in radians
SinCosReturns the sine and cosine of an angle
SinhReturns the hyperbolic sine of an angle
TanReturns the tangent of X
TanhReturns the hyperbolic tangent of X
TruncTruncates a real number to an integer

Forum Discussion

Choose which categories of cookies you allow. Strictly-necessary cookies are always on. You can change this any time via the "Cookie Settings" link in the footer.

  • Functional

    Remember preferences like dismissed banners and your dark-mode choice.

  • Analytics

    Help us understand how the site is used so we can improve it.

  • Marketing

    Measure our advertising and help us reach people who may be interested in Optuma.