Functions by category
(Back to Analytica Reference)
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
Grouped expressions: (expr; expr), BEGIN expr; expr END
Comments: { comment }, /* comment */
Local variables: VAR x, Index i; MetaVar v; MetaIndex i; Alias a, Local Index Operator::A.I
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
Set functions: SetContains, SetDifference, SetEvaluationFlag, SetIntersection, SetUnion
Complex numbers: RealPart, ImPart, ComplexDegrees, ComplexRadians, Conj
Signal processing: FFT, FFTInv
Dates, Text, Financial
Date and Time: MakeDate, DateAdd, DatePart, Today, ParseDate, IsDateTime
Text: SelectText, FindInText, TextReplace, SplitText, JoinText, Text Concatenation: t1&t2, TextLength, TextLowerCase, TextUpperCase, TextSentenceCase, TextTrim
Financial: Pv, Fv, Npv, XNpv, Rate, NPer, Pmt, PPmt, IPmt, CumIPmt, Irr, XIrr
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, Slice Operator: [@I=n], StepInterp
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
Other array functions: Aggregate
Statistics and Probability distributions
Statistics: Median, Mean, SDeviation, Variance, Skewness, Kurtosis, Statistics, Probability, Frequency, 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
Sensitivity analysis: Dydx, Elasticity, WhatIf, WhatIfAll , Tornado charts, X-Y plots, Scatter plots
Functions for distributions: ProbWilcoxon, CumWilcoxon, CumWilcoxonInv, BetaI, BetaIInv, GammaI, GammaIInv, CumNormal, CumNormalInv, Erf, ErfInv
SIPs and SLURPs: SipDecode, SipEncode
Distributions from function libraries
Distribution Variations.ana: Gamma_m_sd, GammaFn, GammaI, GammaIInv, InverseGaussian, InvertedWishart, Lorenzian, NegBinomial
Multivariate Distributions.ana: Gaussian, Multinomial, MultiNormal, MultiUniform, Normal_additive_gro, Normal_compound_gro, Normal_correl, Normal_serial_correl
Distribution Densities.ana: LDens_InvertedWishart, LDens_Wishart, LGamma
User interaction and dialog
Dialog boxes: MsgBox, Error, AskMsgText, AskMsgChoice, AskMsgNumber, ShowProgressBar
Types and type conversion
Convert type: Chr, Asc, NumberToText, ParseDate, ParseNumber
Get or test type: TypeOf, IsDateTime, IsHandle, IsNaN, IsNull, IsNumber, IsRealNumber, IsReference, IsText, IsUndef, IsResultComputed, IsNotSpecified
Optimizer functions
DefineOptimization, OptInfo, OptObjective, OptSolution, OptStatusNum, OptStatusText, OptEngineInfo, GroupedInteger, OptFindIIS, OptWriteIIS, OptGuess
OptObjectiveSa, OptRead, OptWrite, OptReducedCost, OptRhsSa, OptScalarToConstraint, OptScalarToDecision, OptShadow, OptSlack
Integration with other applications
Reading and writing data: ReadFromUrl, OpenURL, ReadImageFile, ReadTextFile, WriteTextFile, ShowPdfFile
Spreadsheet access: SpreadsheetOpen, SpreadsheetCell, SpreadsheetRange, SpreadsheetSetCell, SpreadsheetSetRange,SpreadsheetSave,, SpreadsheetInfo, SpreadsheetSetInfo
Database and ODBC access: SqlDriverInfo, DbLabels, DbQuery, DbTable, DbTablenames, DbWrite, MdxQuery
Run other applications: RunConsoleProcess
COM API: COMArray, COMCallMethod, COMCreateObject, COMGetProperty
Special functions
Meta-inference: Handle, HandleFromIdentifier, ListOfHandles, FindObjects, Dereference Operator: #R IndexesOf, IndexNames, GetVariableByName, IndexValue, AttribGet
Evaluation: Mid, Sample, Evaluate, EvaluateScript, GetEvaluationContext
Error handling: Error, IgnoreWarnings, Try, ReThrow
'Miscellaneous: Discrete, Dispatch, FunctionOf, Dynamic, Iterate, FindPolynomialZeroes
Domain expressions: Continuous, Discrete, Integer, Boolean and Discrete
Domain Access Functions: DomainType, DomainType, DomainLowerBound, DomainUpperBound, DomainIntegerGroup
Attributes
User editable for variables: Class, Identifier, Title, Units, Description, Definition, Domain, MetaIndex, User-defined attributes
User editable for Functions: Parameters
User editable for Models, Modules, and Libraries: Author, Savedate, Filename
Computed: Value, Probvalue, Inputs, Outputs
Internal: Diagwindow, ObjectWindow .....
System variables: Run, Time, AnalyticaLicenseInfo, GetProcessInfo, GetRegistryValue, MemoryInUseBy
Function parameter qualifiers
Data types: Number, Text, Positive, NonNegative, Ascending, Descending, Reference, Handle, Coerce <type>
Object class: Index, Variable, Object
Optional and repeated parameters: Optional, Default, Repeated parameters (...)
Arrays: Atom or scalar, Vector, Array, Reduced
Libraries
Standard libraries, Extra libraries, GCD function library.ana: GCD
Optimization Functions.ana: GoalSeek, Gradient
Financial library.ana: Implied_volatility_c, Implied_volatility_p
ODBC Library.ana: InsertRecSql,
Generalized Regression.ana: InvLogit, Logistic_Regression, Logit
Linked List Library.ana: LL_First, LL_Length, LL_Nth, LL_Push, LL_Remove_First, LL_To_Array, LL_to_RArray
Enable comment auto-refresher