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: + - * / ^ Comparison: = < > <> <= >= Logical: And, Or, Not; Text concatenation: &; Subscript and slice: x[I=x], x[@I=x] :Assignment: :=, Reference: \, Dereference: #,

Conditional constructs: If-Then-Else, Ifall-Then-Else, Ifonly-Then-Else, If0, Ifpos

Loops: While..Do, For..Do

Grouped expressions: (expr; expr), BEGIN expr; expr END

Comments: { commented text }

Declaring local variables: Using x DO; Var x; Index i; MetaVar v; MetaIndex i; Alias a

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, Conj

Statistics and Probability distributions

Statistics: Median, Mean, SDeviation, Variance, Skewness, Kurtosis, Statistics, Probability, GetFract, ProbBands

• Correlation, RankCorrel, Regression
• Cdf, Pdf

Custom distributions: CumDist, Fractiles, ChanceDist, ProbDist, ProbTable, Random

Discrete distributions: 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, CumWilcoxon, CumWilcoxonInv, BetaI, BetaIInv, GammaI, GammaIInv, CumNormal, CumNormalInv

SIPs and SLURPs: SipDecode, SipEncode

Other types of data

Date and Time

Today, MakeDate, DateAdd, DatePart

Text functions: SelectText, FindInText, TextReplace, SplitText, JoinText, Text Concatenation: t1&t2 TextLength, TextLowerCase, TextUpperCase, TextSentenceCase, TextTrim

== Array functions == Make an Index: Sequence, Sequence Operator: first..last, SortIndex, SplitText, SubIndex, Subset, Unique

Array reducing: Sum, Product, Average, Max Min, ArgMin_and_ArgMax, JoinText, Condmax, Condmin, Area

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

Array mapping:

• Cumulate, Uncumulate, CumProduct, Normalize, Integrate
• Rank, Sort
• Aggregate

Tables and functions to make arrays: Array, Table, SubTable, MultiTable, DetermTable, ProbTable, AddIndex

Interpolation: StepInterp, LinearInterp, CubicInterp, MonoCubicInterp

Matrix: MatrixMultiply, Transpose, Invert, Determinant, Decompose, EigenDecomp, SingularValueDecomp Information about arrays: Size, IndexesOf, IndexNames, MemoryInUseBy

Relational tables: MdTable, MdArrayToTable

• Aggregate

Other array functions

Functions that make indexes: SortIndex, Split, SubIndex, Subset, Unique

Financial

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

User interaction and dialog

User input: Choice, Checkbox

Dialog boxes: MsgBox, Error, AskMsgText, AskMsgChoice, AskMsgNumber, ShowProgressBar

Types and type conversion

• Chr, Asc
• NumberToText, Coerce_to_Numeric (Flat file library.ana)
• ParseDate, ParseNumber
• IsNotSpecified

Get or test type: TypeOf, IsDateTime, IsHandle, IsNaN, IsNull, IsNumber, IsRealNumber, IsReference, IsText, IsUndef

• IsResultComputed

Integration with other applications

• RunConsoleProcess

Reading data: ReadFromUrl, OpenURL, ReadImageFile, ReadTextFile, WriteTextFile, ShowPdfFile

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

• Type: Boolean, Integer, Index, Variable, Handle
• Optional, Repeated
• Scalar, Vector, Array

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

Linked List Library.ana: LL_First, 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)

• Lorenzian (Distribution variations.ana)

Multivariate Distributions.ana: Multinomial, MultiNormal, MultiUniform, Normal_additive_gro, Normal_compound_gro, Normal_correl, Normal_serial_correl

• NegBinomial (Distribution Variations.ana)

Optimizer functions

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

• GroupedInteger

Obsolete optimizer

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