Functions by category

Function list (to be categorized) (Back to Analytica Reference)

See also: functions by category. Functions to be organized Rare and deprecated functions

Language, control, and syntax

Operators

• + - * / ^ : Arithmetic operators
• x^y : Exponentiation
• = < > <> <= >= : Comparison operators
• Logical operators: And, Or, Not
• x[I=x], x[@I=x]  : Subscript and slice operators
• \, #: Reference and dereference operators
• := : Assignment operator
• & : Text concatenation operator
• A.I: Dot operator, to access a local index of an array
• ... : Repeated parameter forwarding
• Index Position Operator: @I, @[I=x]  : Get the numeric position of index elements
• PositionInIndex

Constructs and loops

• expr1 ; expr2 : Expression Sequence Operator
• If-Then-Else, Ifall-Then-Else, Ifonly-Then-Else
• While..Do, For..Do
• If0, Ifpos

Declarations of local variables

• Using..Do
• Var..Do
• Index..Do

Mathematics

Basic math

• Abs, Sign, Mod, Round, Ceil, Floor
• Sqr, Sqrt, Exp, Ln, LogTen
• Factorial
• Degrees, Radians

=Trigonometry

• Sin, Cos, Tan
• Sinh, Cosh, Tanh
• ArcSin, ArcCos, ArcTan, ArcTan2
• ArcSinH, ArcCosH, ArcTanH

Complex numbers

• RealPart, ImPart
• ComplexDegrees, ComplexRadians

Probability distributions

Statistics

Return statistics from random samples:

• Median, Mean, SDeviation, Variance, Skewness, Kurtosis
• Statistics
• Probability
• GetFract, ProbBands
• Correlation, RankCorrel
• Cdf, Pdf
• Regression

Custom distribution functions

• CumDist, Fractiles
• ChanceDist, ProbDist, ProbTable
• Random

Discrete distribution functions

• Bernoulli, Binomial, NegativeBinomial
• Combinations, Permutations
• Geometric, HyperGeometric
• Certain

Continuous distribution functions

• Uniform, Normal, LogNormal, Beta, Triangular, Poisson
• Exponential, Gamma, StudentT, Weibull, Wilcoxon, Logistic
• BesselJ, BesselY, BesselI, BesselK, ChiSquared

Modifying distributions

• Mid, Sample, Truncate, Shuffle

Functions for distributions

• ProbWilcoxon
• Betafn
• BetaI
• BetaIaInv
• BetaIInv

• CumNormal
• CumNormalInv

SIP and SLURP

• SipDecode, SipEncode

Date and Time

Today, MakeDate, DateAdd, DatePart

Text functions

• SelectText, FindInText, TextReplace
• SplitText, JoinText
• Text Concatenation Operator: A&B : Concatenate two text strings
• TextLength
• TextLowerCase, TextUpperCase, TextSentenceCase
• TextTrim

Make an Index

• Sequence, Sequence Operator: first..last
• SortIndex, Split, SubIndex, Subset, Unique

• Size
• Reform

= Array reducing

• Sum, Product, Average
• Max Min
• ArgMin_and_ArgMax
• Condmax, Condmin
• Integrate, Area

Subscript, selection, lookup

• Slice, Subscript, StepInterp
• Slice Operator: [@I=n]

Array mapping

• Cumulate, Uncumulate, CumProduct, Normalize
• Rank

Tables and functions to make arrays

• Array
• Table, SubTable, MultiTable, DetermTable, ProbTable
• AddIndex
• Aggregate

Interpolation

• StepInterp, LinearInterp, CubicInterp, MonoCubicInterp

Matrix

• DotProduct, MatrixMultiply, Transpose, Invert, Determinant, Decompose, EigenDecomp, SingularValueDecomp

Other array functions

• Sort
• SortIndex
• Split
• SubIndex
• Subset
• Unique

• MdArrayToTable
• MdTable

Financial

• Pv, Fv, Npv, XNpv
• Rate, NPer
• Pmt, PPmt, IPmt, CumIPmt
• Irr, XIrr

User interaction and dialog

User input

• Choice, Checkbox

User dialog boxes

• MsgBox, Error
• AskMsgText, AskMsgChoice, AskMsgNumber
• ShowProgressBar

Types and type conversion

• Chr, Asc
• NumberToText, Coerce_to_Numeric (Flat file library.ana)
• ParseDate, ParseNumber
• TypeOf
• IsDateTime
• IsHandle
• IsNaN
• IsNotSpecified
• IsNull
• IsNumber
• IsRealNumber
• IsReference
• IsResultComputed
• IsText
• IsUndef

Integration with other applications

• RunConsoleProcess

Reading data

• ReadFromUrl, OpenURL
• ReadImageFile
• ReadTextFile
• ShowPdfFile
• WriteTextFile

Spreadsheet access

• SpreadsheetOpen, SpreadsheetSave
• SpreadsheetCell, SpreadsheetRange
• SpreadsheetSetCell, SpreadsheetSetRange
• SpreadsheetInfo, SpreadsheetSetInfo

• OpenExcelFile -- depreciated: use SpreadsheetOpen

Database and ODBC access

• SqlDriverInfo
• DbLabels
• DbQuery
• DbTable
• DbTablenames
• DbWrite
• MdxQuery

COM API

• COMArray
• COMCallMethod
• COMCreateObject
• COMGetProperty

Error handling

• Error
• IgnoreWarnings
• Try, ReThrow

Set functions

• SetContains
• SetDifference
• SetEvaluationFlag
• SetIntersection
• SetUnion

• Discrete
• Dispatch

Objects and meta-inference

• ListOfHandles
• Dereference Operator: #R : Return the value pointed to by a reference R.
• IndexesOf, IndexNames
• GetVariableByName
• IndexValue
• AttribGet

Sensitivity analysis

• Dydx
• Elasticity
• WhatIf
• WhatIfAll

Special

• Dynamic

Evaluation

• Mid, Sample
• Evaluate
• EvaluateScript
• GetEvaluationContext

Analytica environment information

• AnalyticaLicenseInfo, GetProcessInfo
• GetRegistryValue
• MemoryInUseBy

Function parameter qualifiers

• Boolean, Integer

Functions still to be categorized

• Erf
• ErfInv
• FFT
• FFTInv

• Frequency
• FunctionOf
• Iterate
• FindPolynomialZeroes
• Join
• Index..Do

• Gamma_m_sd (Distribution Variations.ana)
• GammaFn
• GammaI
• GammaIInv
• Gaussian (Multivariate Distributions.ana)
• GCD (GCD function library.ana)
• GoalSeek (Optimization Functions.ana)
• Gradient (Optimization Functions.ana)

• Im (Complex Library.ana)
• Implied_volatility_c (Financial library.ana)
• Implied_volatility_p (Financial library.ana)

• InsertRecSql (ODBC Library.ana)

• InverseGaussian (Distribution Variations.ana)
• InvertedWishart (Distribution Variations.ana)
• InvLogit (Generalized Regression.ana)

• LDens_InvertedWishart (Distribution Densities.ana)
• LDens_Wishart (Distribution Densities.ana)
• LGamma

• LL_First (Linked List Library.ana)
• LL_Length (Linked List Library.ana)
• LL_Nth (Linked List Library.ana)
• LL_Push (Linked List Library.ana)
• LL_Remove_First (Linked List Library.ana)
• LL_To_Array (Linked List Library.ana)
• LL_to_RArray (Linked List Library.ana)

• Local Index Operator::A.I : Get an index (usually a local index) of an array
• Logistic_Regression (Generalized Regression.ana)
• Logit (Generalized Regression.ana)
• Lognormal_m_sd (Distribution variations.ana) - obsolete, use LogNormal (mean:m,stddev:sd)

• Lorenzian (Distribution variations.ana)

• Multinomial (Multivariate Distributions.ana)
• MultiNormal (Multivariate Distributions.ana)
• MultiUniform (Multivariate Distributions.ana)
• Normal_additive_gro (Multivariate Distributions.ana)
• Normal_compound_gro (Multivariate Distributions.ana)
• Normal_correl (Multivariate Distributions.ana)
• Normal_serial_correl (Multivariate Distributions.ana)
• NegBinomial (Distribution Variations.ana)

Optimizer functions

• OptEngineInfo
• OptFindIIS
• OptGuess
• OptInfo
• OptObjective
• OptObjectiveSa
• OptRead
• OptReducedCost
• OptRhsSa
• OptScalarToConstraint
• OptScalarToDecision
• OptShadow
• OptSlack
• OptSolution
• OptStatusNum
• OptStatusText
• OptWrite
• OptWriteIIS

• GroupedInteger

Obsolete optimizer

• LpDefine
• LpFindIIS
• LpObjSa
• LpOpt
• LpRead
• LpReducedCost
• LpRhsSa
• LpShadow
• LpSlack
• LpSolution
• LpStatusNum
• LpStatusText
• LpWrite
• LpWriteIIS
• NlpDefine