Difference between revisions of "Functions by category"
m |
(columns) |
||
| Line 1: | Line 1: | ||
[[Category:Functions]](Back to [[Analytica Reference]]) | [[Category:Functions]](Back to [[Analytica Reference]]) | ||
| + | __TOC__ | ||
| + | <columns> | ||
== Language, control, and syntax == | == Language, control, and syntax == | ||
| − | '''[[Operators]]: '''[[Operators | + | '''[[Operators]]: '''[[Operators {{!}} Arithmetic: + - * / ^]] [[Comparison Operators {{!}}Comparison]]: = < > <> <= >= [[Logical Operators {{!}}Logical]]: [[And]], [[Or]], [[Not]]; [[Text Concatenation Operator: & {{!}}Text concatenation]]: &; [[Subscript/Slice Operator {{!}}Subscript and slice: x[I=x], x[@I=x] ]], [[Assignment Operator := {{!}}Assignment :=]], [[Reference Operator::\ {{!}}Reference \]], [[Dereference Operator {{!}}Dereference #]], |
'''Conditional constructs:''' [[If-Then-Else]], [[Ifall-Then-Else]], [[Ifonly-Then-Else]], [[If0]], [[Ifpos]] | '''Conditional constructs:''' [[If-Then-Else]], [[Ifall-Then-Else]], [[Ifonly-Then-Else]], [[If0]], [[Ifpos]] | ||
| Line 8: | Line 10: | ||
'''Loops:''' [[While..Do]], [[For..Do]] | '''Loops:''' [[While..Do]], [[For..Do]] | ||
| − | '''Grouped expressions:''' [[Begin-End for Grouping Expressions | + | '''Grouped expressions:''' [[Begin-End for Grouping Expressions {{!}}(expr; expr)]], [[Begin-End for Grouping Expressions {{!}}BEGIN expr; expr END]] |
'''Comments:''' { comment }, /* comment */ | '''Comments:''' { comment }, /* comment */ | ||
| − | '''Local variables:''' [[Var..Do | + | '''Local variables:''' [[Var..Do {{!}}VAR x]], [[Index..Do {{!}}Index i]]; [[MetaVar {{!}}MetaVar v]]; [[MetaIndex {{!}}MetaIndex i]]; [[Alias..Do {{!}}Alias a]], [[Local Index Operator::A.I]] |
'''Sensitivity analysis:''' [[Dydx]], [[Elasticity]], [[WhatIf]], [[WhatIfAll]] | '''Sensitivity analysis:''' [[Dydx]], [[Elasticity]], [[WhatIf]], [[WhatIfAll]] | ||
| Line 19: | Line 21: | ||
'''Basic math:''' [[Abs]], [[Sign]], [[Mod]], [[Round]], [[Ceil]], [[Floor]], [[Sqr]], [[Sqrt]], [[Exp]], [[Ln]], [[LogTen]], [[Factorial]], [[Degrees]], [[Radians]] | '''Basic math:''' [[Abs]], [[Sign]], [[Mod]], [[Round]], [[Ceil]], [[Floor]], [[Sqr]], [[Sqrt]], [[Exp]], [[Ln]], [[LogTen]], [[Factorial]], [[Degrees]], [[Radians]] | ||
| − | '''Trigonometry: '''[[Trig Functions | + | '''Trigonometry: '''[[Trig Functions {{!}} Sin, Cos, Tan]][[Trig Functions {{!}} Sinh, Cosh, Tanh]]; [[ArcSin]], [[ArcCos]], [[ArcTan]], [[ArcTan2]]; [[ArcSinH]], [[ArcCosH]], [[ArcTanH]] |
| − | '''[[Set Functions | + | '''[[Set Functions {{!}}Set functions]]: '''[[SetContains]], [[SetDifference]], [[SetEvaluationFlag]], [[SetIntersection]], [[SetUnion]] |
| − | '''[[Complex Numbers | + | '''[[Complex Numbers {{!}}Complex numbers]]:''' [[RealPart]], [[ImPart]], [[ComplexDegrees]], [[ComplexRadians]], [[Conj]] |
'''Signal processing:''' [[FFT]], [[FFTInv]] | '''Signal processing:''' [[FFT]], [[FFTInv]] | ||
==Dates, Text, Financial== | ==Dates, Text, Financial== | ||
| − | '''[[Date and Time Values | + | '''[[Date and Time Values {{!}}Date and Time]]:'''[[Date_Functions#MakeDate.28year.2C_month.2C_day.29 {{!}} MakeDate]], [[DateAdd]], [[DatePart]], [[Today]], [[ParseDate]], [[IsDateTime]] |
| − | [[Text values | + | [[Text values {{!}}'''Text''']]''': '''[[SelectText]], [[FindInText]], [[TextReplace]], [[SplitText]], [[JoinText]], [[Text Concatenation Operator: & {{!}}Text Concatenation: t1&t2]], [[TextLength]], [[TextLowerCase]], [[TextUpperCase]], [[TextSentenceCase]], [[TextTrim]] |
| − | '''[[:Category:Financial Functions | + | '''[[:Category:Financial Functions {{!}}Financial]]''': [[Pv]], [[Fv]], [[Npv]], [[XNpv]], [[Rate]], [[NPer]], [[Pmt]], [[PPmt]], [[IPmt]], [[CumIPmt]], [[Irr]], [[XIrr]] |
=== Array functions === | === Array functions === | ||
| − | '''Make an Index: '''[[Sequence]], [[Sequence Operator | + | '''Make an Index: '''[[Sequence]], [[Sequence Operator {{!}}Sequence Operator: first..last]], [[SortIndex]], [[SplitText]], [[SubIndex]], [[Subset]], [[Unique]] |
| − | '''[[:Category:Array-reducing functions | + | '''[[:Category:Array-reducing functions {{!}}Array reducing]]: '''[[Sum]], [[Product]], [[Average]],[[Functions_Min_and_Max {{!}}{{!}} Max]] [[Functions_Min_and_Max {{!}} Min]], [[ArgMin_and_ArgMax]], [[JoinText]], [[Functions_Min_and_Max {{!}} Condmax]], [[Functions_Min_and_Max {{!}} Condmin]], [[Area]] |
| − | '''Subscript, selection, lookup: '''[[Slice]], [[Subscript]], [[Subscript/Slice Operator | + | '''Subscript, selection, lookup: '''[[Slice]], [[Subscript]], [[Subscript/Slice Operator {{!}}Slice Operator: [@I=n]]], [[StepInterp]] |
'''Array mapping: '''[[Cumulate]], [[Uncumulate]], [[CumProduct]], [[Normalize]], [[Integrate]], [[Rank]], [[Sort]], [[Aggregate]] | '''Array mapping: '''[[Cumulate]], [[Uncumulate]], [[CumProduct]], [[Normalize]], [[Integrate]], [[Rank]], [[Sort]], [[Aggregate]] | ||
| Line 53: | Line 55: | ||
'''Other array functions: '''[[Aggregate]] | '''Other array functions: '''[[Aggregate]] | ||
| − | + | | | |
==Statistics and Probability distributions== | ==Statistics and Probability distributions== | ||
'''[[Statistics]]: '''[[Median]], [[Mean]], [[SDeviation]], [[Variance]], [[Skewness]], [[Kurtosis]], [[Statistics]], [[Probability]], [[GetFract]], [[ProbBands]], [[Correlation]], [[RankCorrel]], [[Regression]], [[Cdf]], [[Pdf]] | '''[[Statistics]]: '''[[Median]], [[Mean]], [[SDeviation]], [[Variance]], [[Skewness]], [[Kurtosis]], [[Statistics]], [[Probability]], [[GetFract]], [[ProbBands]], [[Correlation]], [[RankCorrel]], [[Regression]], [[Cdf]], [[Pdf]] | ||
| Line 73: | Line 75: | ||
'''Distributions from function libraries''' | '''Distributions from function libraries''' | ||
| − | '''Distribution Variations.ana:''' [[Gamma_m_sd | + | '''Distribution Variations.ana:''' [[Gamma_m_sd{{!}}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]] | '''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]][[Text Concatenation Operator: & | + | '''Distribution Densities.ana:''' [[LDens_InvertedWishart]], [[LDens_Wishart]], [[LGamma]][[Text Concatenation Operator: & {{!}}<nowiki/>]]<nowiki/>'''<nowiki/>''' |
== User interaction and dialog == | == User interaction and dialog == | ||
| − | '''User input:''' [[Choice | + | '''User input:''' [[Choice {{!}} Choice]], [[Checkbox]] |
'''Dialog boxes: '''[[MsgBox]], [[Error]], [[AskMsgText]], [[AskMsgChoice]], [[AskMsgNumber]], [[ShowProgressBar]] | '''Dialog boxes: '''[[MsgBox]], [[Error]], [[AskMsgText]], [[AskMsgChoice]], [[AskMsgNumber]], [[ShowProgressBar]] | ||
| Line 87: | Line 89: | ||
'''Convert type: '''[[Chr]], [[Asc]], [[NumberToText]], [[ParseDate]], [[ParseNumber]] | '''Convert type: '''[[Chr]], [[Asc]], [[NumberToText]], [[ParseDate]], [[ParseNumber]] | ||
| − | '''Get or test type:''' [[Data_Type_Functions#Function_TypeOf | + | '''Get or test type:''' [[Data_Type_Functions#Function_TypeOf {{!}} TypeOf]], [[IsDateTime]], [[IsHandle]], [[Data_Type_Functions#Function_IsNaN {{!}} IsNaN]], [[IsNull]],[[Data_Type_Functions#Function_IsNumber {{!}} IsNumber]], [[IsRealNumber]],[[Data_Type_Functions#Function_IsReference {{!}} IsReference]],[[Data_Type_Functions#Function_IsText {{!}} IsText]], [[Data_Type_Functions#Function_IsUndef {{!}} IsUndef]], [[IsResultComputed]], [[Data_Type_Functions#Function_IsNotSpecified {{!}}IsNotSpecified]] |
== Optimizer functions == | == Optimizer functions == | ||
DefineOptimization, [[OptInfo]], [[OptObjective]], [[OptSolution]], [[OptStatusNum]], [[OptStatusText]], [[OptEngineInfo]], [[GroupedInteger]], [[OptFindIIS]], [[OptWriteIIS]], [[OptGuess]] | DefineOptimization, [[OptInfo]], [[OptObjective]], [[OptSolution]], [[OptStatusNum]], [[OptStatusText]], [[OptEngineInfo]], [[GroupedInteger]], [[OptFindIIS]], [[OptWriteIIS]], [[OptGuess]] | ||
| Line 102: | Line 104: | ||
'''Run other applications:''' [[RunConsoleProcess]] | '''Run other applications:''' [[RunConsoleProcess]] | ||
| − | '''[[COM Integration | + | '''[[COM Integration{{!}}COM API]]: '''[[COMArray]], [[COMCallMethod]], [[COMCreateObject]], [[COMGetProperty]] |
=== Special functions === | === Special functions === | ||
[[Dynamic]], [[Iterate]], [[FindPolynomialZeroes]] | [[Dynamic]], [[Iterate]], [[FindPolynomialZeroes]] | ||
| − | [[Objects and meta-inference: | + | [[Objects and meta-inference: {{!}}'''Objects and meta-inference:''']] [[ListOfHandles]], [[Dereference Operator::# {{!}}Dereference Operator: #R]] [[VarTerm Functions#Function_IndexesOf {{!}} IndexesOf]], [[IndexNames]], [[VarTerm Functions#Function_GetVariableByName {{!}} GetVariableByName]], [[IndexValue]], [[AttribGet]] |
| − | '''[[Evaluation Modes | + | '''[[Evaluation Modes{{!}}Evaluation]]:''' [[Mid]], [[Sample]], [[Evaluate]], [[EvaluateScript]], [[GetEvaluationContext]] |
'''Error handling:''' [[Error]], [[IgnoreWarnings]], [[Try]], [[ReThrow]] | '''Error handling:''' [[Error]], [[IgnoreWarnings]], [[Try]], [[ReThrow]] | ||
| Line 115: | Line 117: | ||
'''Miscellaneous: '''[[Discrete]], [[Dispatch]], [[FunctionOf]] | '''Miscellaneous: '''[[Discrete]], [[Dispatch]], [[FunctionOf]] | ||
| − | [[Domain Expressions | + | [[Domain Expressions{{!}}'''Domain expressions''']]: [[Continuous]], [[Discrete]], [[Integer]], [[Boolean]] and [[Discrete]] |
| − | |||
| − | |||
| + | '''[[Domain Access Functions]]: '''[[Domain Access Functions {{!}}DomainType, DomainType, DomainLowerBound, DomainUpperBound, DomainIntegerGroup]] | ||
| + | | | ||
=== Attributes === | === Attributes === | ||
| Line 147: | Line 149: | ||
=== Functions libraries === | === Functions libraries === | ||
| − | [[media:GCD function library.ana | + | [[media:GCD function library.ana {{!}}'''GCD function library.ana''']]''':''' [[GCD]] |
'''Optimization Functions.ana:''' [[GoalSeek]], [[Gradient]] | '''Optimization Functions.ana:''' [[GoalSeek]], [[Gradient]] | ||
| Line 164: | Line 166: | ||
=== Other deprecated functions === | === Other deprecated functions === | ||
[[Join]] | [[Join]] | ||
| + | </columns> | ||
Revision as of 17:43, 10 February 2016
(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
Sensitivity analysis: Dydx, Elasticity, WhatIf, WhatIfAll
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, 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
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
Dynamic, Iterate, FindPolynomialZeroes
Objects and meta-inference: ListOfHandles, Dereference Operator: #R IndexesOf, IndexNames, GetVariableByName, IndexValue, AttribGet
Evaluation: Mid, Sample, Evaluate, EvaluateScript, GetEvaluationContext
Error handling: Error, IgnoreWarnings, Try, ReThrow
Miscellaneous: Discrete, Dispatch, FunctionOf
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 [add the rest]
Internal: Diagwindow, ObjectWindow ..... [add the rest]
System variables: Run, Time, AnalyticaLicenseInfo, GetProcessInfo, GetRegistryValue, MemoryInUseBy
Function parameter qualifiers
Type: Boolean, Integer, Index, Variable, Handle
Number of parameters: Optional, Repeated
Array qualifiers: Scalar, Vector, Array
[Add all qualifiers and links to them]
Functions still to be categorized
Functions libraries
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
Obsolete optimizer functions: [Move to a separate page of obsolete functions]
LpDefine, LpFindIIS, LpObjSa, LpOpt, LpRead, LpReducedCost, LpRhsSa, LpShadow, LpSlack, LpSolution, LpStatusNum, LpStatusText, LpWrite, LpWriteIIS, NlpDefine
Enable comment auto-refresher