Difference between revisions of "Alphabetical Function List"
(TextCharacterEncode, TextDistance, Cell formating functions) |
(MakeJSON, ParseJSON) |
||
| Line 333: | Line 333: | ||
* [[MakeCSV]] | * [[MakeCSV]] | ||
* [[Date_Functions#MakeDate.28year.2C_month.2C_day.29| MakeDate]] | * [[Date_Functions#MakeDate.28year.2C_month.2C_day.29| MakeDate]] | ||
| + | * [[MakeJSON]] | ||
* [[MatrixMultiply]] | * [[MatrixMultiply]] | ||
* [[Functions_Min_and_Max| Max]] | * [[Functions_Min_and_Max| Max]] | ||
| Line 391: | Line 392: | ||
* [[ParsedExprFunction]] | * [[ParsedExprFunction]] | ||
* [[ParsedExprParameters]] | * [[ParsedExprParameters]] | ||
| + | * [[ParseJSON]] | ||
* [[ParseNum]] (Flat file library.ana - for Analytica 4.1) | * [[ParseNum]] (Flat file library.ana - for Analytica 4.1) | ||
* [[ParseNumber]] | * [[ParseNumber]] | ||
Revision as of 23:59, 9 March 2017
(Back to Analytica Reference)
See also Category: Functions and Functions by category.
- =,<,>,<>,<=,>= : Comparison operators
- [I=x] : Subscript operator
- [@I=x] : Slice operator
- \ : Reference operator
- # : Dereference operator
- @ : Index Position operator
- := : Assignment operator
- & : Text concatenation operator
- A.I : Dot operator, to access a local index of an array
- ... : Repeated parameter forwarding
- x^y : Exponentiation
- Abs
- AddIndex
- Aggregate
- AnalyticaLicenseInfo
- And
- ArcCos
- ArcCosH
- ArcSin
- ArcSinH
- ArcTan
- ArcTan2
- ArcTanH
- Area
- Argmax
- Argmin
- Array
- Asc
- AskMsgChoice
- AskMsgNumber
- AskMsgText
- Assignment Operator:: ::= : Assignment operator
- AttribGet
- Attrib of Obj
- Average
- Bernoulli
- BesselJ, BesselY, BesselI, BesselK
- Beta
- Beta_m_sd (Distribution variations.ana)
- Betafn
- BetaI
- BetaIaInv
- BetaIInv
- Binomial
- BiNormal (Multivariate distributions.ana)
- BitAnd
- BitCount
- BitNot
- BitOr
- BitShift
- BitXOr
- Boolean
- CAbs (Complex Library.ana)
- CAdjoint (Complex Library.ana)
- Calloption (Financial Library.ana)
- Capm (Financial Library.ana)
- CArcCos (Complex Library.ana)
- CArcSin (Complex Library.ana)
- CArcTan (Complex Library.ana)
- CCos (Complex Library.ana)
- CDeterminant (Complex Library.ana)
- Cdf
- CDiv (Complex Library.ana)
- Ceil
- CellAlignment
- CellBar
- CellBorder
- CellDefaults
- CellEntry
- CellFill
- CellFont
- CellFormats
- CellNumberFormat
- CellOnClick
- CellSpan
- Certain
- CExp (Complex Library.ana)
- ChanceDist
- Change_index (Expand Index.ana)
- ChangeNodeVisibility
- ChiSquared
- Choice
- CInverse (Complex Library.ana)
- Chr
- CLn (Complex Library.ana)
- CloseWindow
- CMatMult (Complex Library.ana)
- CMult (Complex Library.ana)
- Coerce_to_Numeric (Flat file library.ana)
- COMArray
- Combinations
- COMCallMethod
- COMCreateObject
- COMGetProperty
- Comparison Operators: =, <, >, <>, <=, >=
- Complex (Complex Library.ana)
- ComplexDegrees
- ComplexRadians
- CompressMemoryUsedBy
- ComputedBy
- COMPutProperty
- Concat
- Concat<N> (Concatenation UDFs.ana
- ConcatRows (Concatenation UDFs.ana)
- Condmax
- Condmin
- Continuous
- CopyIndex
- Correlate_Dists (Multivariate Distributions.ana)
- Correlate_With (Multivariate Distributions.ana)
- Correlation
- Cos
- Cosh
- CostCapme (Financial Library.ana)
- CostCapmm (Financial library.ana)
- CreateNewObject
- CRoots (Complex Library.ana)
- CSin (Complex Library.ana)
- CSqrt (Complex Library.ana)
- CTan (Complex Library.ana)
- CTheta (Complex Library.ana)
- CToPolar (Complex Library.ana)
- CubicInterp
- CumBinomial (Distribution Densities Library)
- CumBinomialInv (Distribution Densities Library)
- CumChiSquared (Distribution Densities Library)
- CumChiSquaredInv (Distribution Densities Library)
- CumDist
- CumExponential (Distribution Densities Library)
- CumExponentialInv (Distribution Densities Library)
- CumFDist (Distribution Densities Library)
- CumFDistInv (Distribution Densities Library)
- CumGeometric (Distribution Densities Library)
- CumGeometricInv (Distribution Densities Library)
- CumIPmt
- CumLogistic (Distribution Densities Library)
- CumLogisticInv (Distribution Densities Library)
- CumLogNormal (Distribution Densities Library)
- CumLogNormalInv (Distribution Densities Library)
- CumNegativeBinomial (Distribution Densities Library)
- CumNegativeBinomInv (Distribution Densities Library)
- CumNormal
- CumNormalInv
- CumPoisson (Distribution Densities Library)
- CumPoissonInv
- CumPrinc
- CumProduct
- CumStudentT (Distribution Densities Library)
- CumStudentTInv (Distribution Densities Library)
- CumTriangular (Distribution Densities Library)
- CumTriangularInv (Distribution Densities Library)
- CumWilcoxon
- CumWilcoxonInv
- Cumulate
- CumUniform (Distribution Densities Library)
- CumUniformInv (Distribution Densities Library)
- CumWeibull (Distribution Densities Library)
- CumWeibullInv (Distribution Densities Library)
- CurrentDataDirectory (Replaced with CurrentDataFolder as of Analytica 4.6)
- CurrentDataFolder
- CurrentModelDirector (Replaced with CurrentDataFolder as of Analytica 4.6)
- CurrentModelFolder
- DateAdd
- DatePart
- Dawson
- DbLabels
- DbQuery
- DbTable
- DbTablenames
- DbWrite
- Decompose
- Degrees
- Dens_Beta (Distribution Densities Library)
- Dens_ChiSquared (Distribution Densities Library)
- Dens_CumDist (Distribution Densities Library)
- Dens_Exponential (Distribution Densities Library)
- Dens_FDist (Distribution Densities Library)
- Dens_Gamma (Distribution Densities Library)
- Dens_Gaussian (Distribution Densities Library)
- Dens_Logistic (Distribution Densities Library)
- Dens_LogNormal (Distribution Densities Library)
- Dens_Normal (Distribution Densities Library)
- Dens_ProbDist (Distribution Densities Library)
- Dens_StudentT (Distribution Densities Library)
- Dens_Triangular (Distribution Densities Library)
- Dens_Uniform (Distribution Densities Library)
- Dens_Weibull (Distribution Densities Library)
- Dereference Operator: #R : Return the value pointed to by a reference R.
- Determinant
- DetermTable
- Dirichlet (Multivariate distributions.ana)
- Discrete
- Dispatch
- Dist_additive_growth (Multivariate distributions.ana)
- Dist_compound_growth (Multivariate distributions.ana)
- Dist_reshape (Multivariate distributions.ana)
- Dist_serial_correl (Multivariate distributions.ana)
- DomainAllowed
- DomainIntegerGroup
- DomainLowerBound
- DomainNullOk
- DomainType
- DomainUpperBound
- DotProduct
- Dydx
- Dynamic
- EigenDecomp
- Elasticity
- Erf
- ErfInv
- Erlang (Distribution variations.ana)
- Error
- Evaluate
- EvaluateScript
- Exp
- Exponential
- expr1 ; expr2 : Expression Sequence Operator
- Factorial
- Faddeeva
- FFT
- FFTInv
- FindInText
- FindObjects
- FindPolynomialZeroes
- Flatten
- Floor
- For..Do
- Fractiles
- Frequency
- FunctionOf
- Fv
- Gamma
- Gamma_m_sd (Distribution Variations.ana)
- GammaFn
- GammaI
- GammaIInv
- Gaussian (Multivariate Distributions.ana)
- GCD (GCD function library.ana)
- Geometric
- GetArrowsOnDiagram
- GetEvaluationContext
- GetFract
- GetProcessInfo
- GetRegistryValue
- GetVariableByName
- GoalSeek (Optimization Functions.ana)
- Gradient (Optimization Functions.ana)
- GroupedInteger
- HyperGeometric
- IdentPred
- If-Then-Else
- Ifall-Then-Else
- Ifonly-Then-Else
- If0
- Ifpos
- IgnoreWarnings
- Im (Complex Library.ana)
- ImageFromHex
- ImPart
- Implied_volatility_c (Financial library.ana)
- Implied_volatility_p (Financial library.ana)
- Index Position Operator: @I, @[I=x] : Get the numeric position of index elements
- IndexesOf
- Index..Do
- IndexLength
- IndexNames
- IndexValue
- InsertRecSql (ODBC Library.ana)
- Integer
- Integrate
- InvalidateResult
- InverseGaussian (Distribution Variations.ana)
- Invert
- InvertedWishart (Distribution Variations.ana)
- InvLogit (Generalized Regression.ana)
- IPmt
- Irr
- IsDateTime
- IsHandle
- IsNaN
- IsNotSpecified
- IsNull
- IsNumber
- IsRealNumber
- IsReference
- IsResultComputed
- IsText
- IsUndef
- Iterate
- Join
- JoinText
- Kurtosis
- LDens_InvertedWishart (Distribution Densities.ana)
- LDens_Wishart (Distribution Densities.ana)
- LGamma
- LinearInterp
- ListOfHandles
- 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)
- Ln
- Local Index Operator::A.I : Get an index (usually a local index) of an array
- Logistic
- Logistic_Regression (Generalized Regression.ana)
- Logit (Generalized Regression.ana)
- LogNormal
- Lognormal_m_sd (Distribution variations.ana) - obsolete, use LogNormal (mean:m,stddev:sd)
- LogTen
- Lorenzian (Distribution variations.ana)
- LpDefine
- LpFindIIS
- LpObjSa
- LpOpt
- LpRead
- LpReducedCost
- LpRhsSa
- LpShadow
- LpSlack
- LpSolution
- LpStatusNum
- LpStatusText
- LpWrite
- LpWriteIIS
- MakeCSV
- MakeDate
- MakeJSON
- MatrixMultiply
- Max
- MdArrayToTable
- MdTable
- MdxQuery
- Mean
- Median
- MemoryInUseBy
- Mid
- Min
- Mod
- MonoCubicInterp
- Move
- MsgBox
- Multinomial (Multivariate Distributions.ana)
- MultiNormal (Multivariate Distributions.ana)
- MultiTable
- MultiUniform (Multivariate Distributions.ana)
- NegBinomial (Distribution Variations.ana)
- NegativeBinomial
- NlpDefine
- Normal
- Normal_additive_gro (Multivariate Distributions.ana)
- Normal_compound_gro (Multivariate Distributions.ana)
- Normal_correl (Multivariate Distributions.ana)
- Normal_serial_correl (Multivariate Distributions.ana)
- Normalize
- Not
- NPer
- Npv
- NumberToText
- OpenExcelFile -- deprecated: use SpreadsheetOpen
- OpenModelFile
- OpenURL
- OptEngineInfo
- OptFindIIS
- OptGuess
- OptInfo
- OptObjective
- OptObjectiveSa
- OptRead
- OptReducedCost
- OptRhsSa
- OptScalarToConstraint
- OptScalarToDecision
- OptShadow
- OptSlack
- OptSolution
- OptStatusNum
- OptStatusText
- OptWrite
- OptWriteIIS
- Or
- Pareto (Distribution Variations.ana)
- ParseCSV
- ParseDate
- ParsedExprFunction
- ParsedExprParameters
- ParseJSON
- ParseNum (Flat file library.ana - for Analytica 4.1)
- ParseNumber
- Permutations
- Pert (Distribution Variations.ana)
- Pmt
- Poisson
- PolarToC (Complex Library.ana)
- Position Operator: @I, @[I=x] : Get the numeric position of index elements
- PositionInIndex
- PPmt
- Probability
- ProbBands
- ProbDist
- Probit_Regression (Generalized Regression.ana)
- ProbTable
- Prob_Bernoulli (Distribution Densities Library)
- Prob_Binomial (Distribution Densities Library)
- Prob_ChanceDist (Distribution Densities Library)
- Prob_Geometric (Distribution Densities Library)
- Prob_HyperGeometric (Distribution Densities Library)
- Prob_NegativeBinomia (Distribution Densities Library)
- Prob_Poisson (Distribution Densities Library)
- ProbWilcoxon
- Product
- ProductLog
- Putoption (Financial Library.ana)
- Pv
- Pvgperp (Financial Library.ana)
- Pvperp (Financial Library.ana)
- QpDefine
- Q_infromrec
- Q_makerect
- Q_squareinterp
- Radians
- Random
- Rank
- RankCorrel
- Rate
- Rayleigh (Distribution variations.ana)
- Re (Complex Library.ana)
- ReadBinaryFile
- ReadCsvFile (Flat File Library.ana)
- ReadFromUrl
- ReadImageFile
- ReadTextFile
- RealPart
- Reference Operator: \X : Return a reference to X
- Reform
- Regression
- RegressionDist (Multivariate Distributions.ana)
- RegressionFitProb (Multivariate Distributions.ana)
- RegressionNoise (Multivariate Distributions.ana)
- ReThrow
- Reverse
- Round
- RunConsoleProcess
- Sample
- SampleCorrelation (Multivariate Distributions.ana)
- SampleCovariance (Multivariate Distributions.ana)
- SaveExcelWorkbook -- deprecated: use SpreadsheetSave
- ScanAttFromModelFile
- SchedulePublish
- SDeviation
- SelectText
- Sequence
- Sequence Operator: first..last
- SetContains
- SetDifference
- SetEvaluationFlag
- SetIntersection
- SetUnion
- ShowAskAttribute
- ShowPdfFile
- ShowProgressBar
- ShowWindow
- Shuffle
- Sign
- Sin
- SingularValueDecomp
- Sinh
- SipDecode
- SipEncode
- Size
- Skewness
- Slice
- Slice Operator: [@I=n]
- Smooth_Fractile (Distribution variations.ana)
- SobolSequence
- Solve (Optimization Functions.ana)
- SolverInfo
- Sort
- SortIndex
- Split
- SplitText
- SpreadsheetCell
- SpreadsheetInfo
- SpreadsheetOpen
- SpreadsheetRange
- SpreadsheetSave
- SpreadsheetSetCell
- SpreadsheetSetInfo
- SpreadsheetSetRange
- SqlDriverInfo
- Sqr
- Sqrt
- Statistics
- StepInterp
- StringLength
- StringLowercase
- StringMixedCase
- StringReplace
- StringUpperCase
- StudentT
- SubFindString
- SubIndex
- Subscript
- Subscript Operator: [I=x]
- Subset
- SubString
- SubTable
- Sum
- Sys_coordindex
- Sys_localindex
- Table
- Tan
- Tanh
- TestHeapConsistency
- TextCharacterEncode
- Text Concatenation Operator: A&B : Concatenate two text strings
- TextDistance
- TextLength
- TextLowerCase
- TextReplace
- TextSentenceCase
- TextTrim
- TextUpperCase
- Today
- Transpose
- Triangular
- Triangular_10_50_90 (Distribution Variations.ana)
- Triangular_10_mode_90 (Distribution Variations.ana)
- Truncate
- Try
- TypeOf
- Uncumulate
- Unflatten
- Uniform
- UniformSpherical (Multivariate distributions.ana)
- Unique
- Using..Do
- Var..Do
- Variance
- VarTerm
- VectorCrossProduct
- Wacc (Financial Library.ana)
- Wald (Distribution Variations.ana)
- Warp_Dist (Distribution variations.ana)
- Weibull
- WhatIf
- WhatIfAll
- While..Do
- Wilcoxon
- Wishart (Distribution variations.ana)
- WorksheetCell -- deprecated: use SpreadsheetCell
- WorksheetRange -- deprecated: use SpreadsheetRange
- WriteBinaryFile
- WriteCsvFile (Flat file library.ana)
- WriteTableSql (ODBC Library.ana)
- WriteTextFile
- WriteWorksheetCell -- deprecated: use SpreadsheetSetCell
- WriteWorksheetRange -- deprecated: use SpreadsheetSetRange
- XIrr
- XNpv
- YearFrac
Comments
Enable comment auto-refresher