/

Expression Evaluator

[this page | pdf | back links]

---

Available functions: Abs Acos Add AddConstantToSeries AppendArray ApplyGeometricSpreadToSeries ApplyPriorityWaterfall ApplyPriorityWaterfall2 ArithmeticallySpacedArray ArrayAdd ArrayDivide ArrayMultiply ArraySubtract Asc Asin Atan Atan2 BaseNArrayToNonNegativeInteger BaseNArrayToString BaseNString2Dec Beta Beta4DistCdf Beta4DistPdf Beta4Inv BetaDistCdf BetaDistPdf BetaInv Bin2Dec BinaryNumerals BinomialCdf BinomialPmf BitAnd BitLShift BitOr BitRShift BitXor BivariateNormalDistribution BlendedPCAICA BoxCoxSeriesTransform BrowserFeatureDescriptions BSBinaryCallCharm BSBinaryCallColour BSBinaryCallDelta BSBinaryCallGamma BSBinaryCallPayoff BSBinaryCallPrice BSBinaryCallRhoDividend BSBinaryCallRhoInterest BSBinaryCallSpeed BSBinaryCallTheta BSBinaryCallVanna BSBinaryCallVega BSBinaryCallVolga BSBinaryPutCharm BSBinaryPutColour BSBinaryPutDelta BSBinaryPutGamma BSBinaryPutPayoff BSBinaryPutPrice BSBinaryPutRhoDividend BSBinaryPutRhoInterest BSBinaryPutSpeed BSBinaryPutTheta BSBinaryPutVanna BSBinaryPutVega BSBinaryPutVolga BSCall BSCallCharm BSCallColour BSCallDelta BSCallGamma BSCallPayoff BSCallPrice BSCallRhoDividend BSCallRhoInterest BSCallSpeed BSCallTheta BSCallVanna BSCallVega BSCallVolga BSPut BSPutCharm BSPutColour BSPutDelta BSPutGamma BSPutPayoff BSPutPrice BSPutRhoDividend BSPutRhoInterest BSPutSpeed BSPutTheta BSPutVanna BSPutVega BSPutVolga CAbs CAcos CAcosh CAcot CAcoth CAdd CArg CartesianToPolar CartesianToPolar2 CAsin CAsinh CAtan CAtanh CCCall CConjugate CCos CCosh CCot CCoth CCPut CCsc CDivide Ceiling CellFormulaA1StyleRangeConcatenate CellReferenceA1Style CExp CGamma ChiDist ChiInv ChiSqDistCdf ChiSqDistPdf ChiSqInv ChiSqTest ChiSqTestDoF ChiSqTestStatistic CholeskyDecomposition Chr CImag CLog CMultiply Concat Concatenate ConfidenceLevelKurtApproxIfNormal ConfidenceLevelSkewApproxIfNormal ConfidenceNorm ConfidenceT ConstrainedQuadraticOptimiser ConstrainedQuadraticPortfolioOptimiser Convert2dIndexArrayToLogRelativeReturns Convert2dIndexArrayToLogReturns Convert2dIndexArrayToRelativeReturns Convert2dIndexArrayToReturns ConvertDateArrayToDoubleArray ConvertDateToDouble ConvertDoubleArrayToDateArray ConvertDoubleToDate ConvertIntegerArrayToDoubleArray ConvertIntegerToDouble ConvertUnit ConvertUnitCompatibles ConvertUnitFromSI ConvertUnitGeneral ConvertUnitSIEquivalent ConvertUnitToSI ConvertUnitToSIExplanation ConvertUnitToSIFactor ConvertUnitType CornishFisher4 Correlation Correlations CorrespondingSpouseMortalityTableName Cos Cosh Cot Coth CountArray CountBooleanArray CountDateArray CountIntegerArray CountSetOfMembersOfArray CountSetOfMembersOfDateArray CountSetOfMembersOfIntegerArray CountSetOfMembersOfStringArray CountsOfArray CountsOfDateArray CountsOfIntegerArray CountsOfStringArray CountStringArray Covariance Covariances CPower CReal CreateArrayWithRepeatedElement CreateArrayWithRepeatingElements Csc Csch CSec CSin CSinh CSqrt CSubtract CTan CTanh CubeRoot CumulativeNormal CumulativeSeries DAAnovaOneAnalysis DAAnovaOneSummary DAAnovaTwoWithAnalysis DAAnovaTwoWithoutAnalysis DAAnovaTwoWithoutSummary DAAnovaTwoWithSummary DACorrelations DACovariances DAExponentialSmoothing DAFTest DAMovingAverage DateAdd DateAndTimeSerial DateDiff DateDiffFull DatePart DatePartFull DateSerial DateValue DATTestEqual DATTestPaired DATTestUnequal Day DAZTest Dec2BaseNString Dec2Bin Dec2Hex Dec2Oct DecimalNumerals DegreeToRadian DemoTSMC DemoTSMCSimGen DemoTSMCStrikes DemoTSMCTerms DemoTSMCUnderlyings DemoTSMCValueAnalytical DemoTSMCValueSim Desmooth_AR1 Desmooth_AR1_rho DevSq Digamma Divide DNSHostAddressList DNSHostName DoesArrayHaveMode E EigenvalueSpreadsForRandomMatrices EQ Erf Erfc ErgodicProbabilities ErrorFromValueWithBracketedError Evaluate EvaluateExpressions EvaluateExpressionsMultiValues EvaluateExpressionsUsing EvaluateMultiValues EvaluateUsing ExampleDataGMMandKMCDataSeries Exp ExperienceAnalysisSinglePeriodCounts ExponDistCdf ExponDistPdf Exponent ExtractFromArray ExtractFromBooleanArray ExtractFromDateArray ExtractFromIntegerArray ExtractFromStringArray Factorial FactorialDouble FDistCdf FDistPdf FFT Filter FinanceDDB FinanceFV FinanceIPmt FinanceIRR FinanceMIRR FinanceNPer FinanceNPV FinancePmt FinancePPmt FinancePV FinanceRate FinanceSLN FinanceSYD FInv Fisher FisherInv Floor Forecast Format FormatNumber FormatPercent Frequency FromImproperFraction FromProperFraction FromSexagesimal FTest FunctionExampleParameterString FunctionNumberOfParameters FunctionOutputArrayDimension FunctionOutputArrayType FunctionOutputType FunctionParameterArrayType FunctionParameterDescription FunctionParameterExample FunctionParameterName FunctionParameterType Gamma GammaDistCdf GammaDistPdf GammaInv GammaLn Gauss GaussianMixtureModellingSA GCD GCDExtended GeoMean GetChar GT GTE HaltonSequence HarMean HerfindahlHirschmanIndex Hex2Dec HexadecimalNumerals Hour Iif IncompleteBeta IncompleteGamma IndexNonBlankStringArray InsertIntoArray InStr InStrPart InStrRev InStrRevPart Int Intercept IntersectionOfDateSets IntersectionOfIntegerSets IntersectionOfSets IntersectionOfStringSets InverseNormal IsAlphabetic IsAlphanumeric IsEven IsOdd IsPowerOf2 IsRecognisedPhysicalUnit JohnsonSUMOMEstimates Join KendalTauCoefficient KendalTauCoefficients KMeansClusteringSA Kurt LCase LCM LeastSquaresGeneralisedCurveFit LeastSquaresPolynomialCurveFit Left Len LibraryVersion LibraryVersionMessage LinearInterpolation Log Log10 LogBaseN LogGamma LognormDistCdf LognormDistPdf LognormInv LogSeries LSet LT LTE LTrim Mantissa MatAntiSym MatDet MatInverse MatLT MatLUDecomposition MatLUDet MatLUEqnSolve MatLUIndexAndPerm MatLUInverse MatLUVecSolve MatProduct MatSym MatTrace MatUnit MatUT Max MaximumOfArray MaximumOfDateArray Mean MeanAbsDevVsMean MeanAbsDevVsMedian Median Mid Min MinimumOfArray MinimumOfDateArray Minus Minute ModeOfArray Month MonthNameEnglish MortalityTableMaxAge MortalityTableMinAge MortalityTableSex Multiply MultiplySeriesByConstant MultiplyTwoSeriesElementByElement MyBrowserFeature MyBrowserFeatures MyIPAddress MyIPRequestVariables MyProxyIPAddress NE NonNegativeIntegerToBaseNArray NormaliseArray NormaliseWeightedArray NormalMLFit NormalTailFit Now NthRoot NumberOfDaysInMonth Oct2Dec OctalNumerals OptimisedTrinomialLatticeProbs OrderOfArray OrderOfDateArray OrderOfIntegerArray OrderOfStringArray ParseBooleanArrayIntoString ParseDoubleArrayIntoString ParseIntegerArrayIntoString ParseStringArrayIntoString ParseStringInto2dBooleanArray ParseStringInto2dDateUKArray ParseStringInto2dDoubleArray ParseStringInto2dIntegerArray ParseStringInto2dStringArray ParseStringIntoBooleanArray ParseStringIntoDateUKArray ParseStringIntoDoubleArray ParseStringIntoIntegerArray ParseStringIntoStringArray Percent Percentile PercentileExc PFDecrementTable PFProjectBenefitsDepletedOutgoWoundUp PFProjectBenefitsOutgoWoundUp PFProjectBenefitsProbDefault PFProjectBenefitsPVSingleRun PgpmFundPercentileRank PgpmFundRank PgpmFundRet PgpmFundRetExists PgpmFundRets PgpmFundRetsExist PgpmFundVolatilityPopulation PgpmFundVolatilitySample PgpmMedianRet PgpmPercentileRet PgpmRelativeRet PgpmTrackingErrorPopulation PgpmTrackingErrorSample Pi PlotExpression PlotExpressions PlotQuadraticEfficientFrontier PlotQuadraticEfficientPortfolios PlotStandardisedQQ PlotStandardisedQQWithComparisons PlotStandardisedUpwards1dQQ PlotWeightedStandardisedQQ PlotXdateYLineChart PlotXYExpressionGeneral PlotXYLineChart PoissonCdf PoissonPmf PolarToCartesian PolarToCartesian2 PolyInterp PopulationCovariance PopulationCovariances PopulationKurt PopulationSkew PopulationStdev PopulationVariance Power PrincipalComponents PrincipalComponentsSizes PrincipalComponentsWeights ProbDistCdf ProbDistCtsBoundedLower ProbDistCtsBoundedUpper ProbDistCtsLowerBound ProbDistCtsUpperBound ProbDistHazardFunction ProbDistIsCts ProbDistKurt ProbDistLikelihood ProbDistLogLikelihood ProbDistMean ProbDistMLE ProbDistMLERestricted ProbDistPage ProbDistParamCount ProbDistParamNames ProbDistPdf ProbDistPlotCdf ProbDistPlotCdfs ProbDistPlotPdf ProbDistPlotPdfs ProbDistPlotPmf ProbDistPlotPmfs ProbDistPlotQQ ProbDistPlotQQs ProbDistPmf ProbDistPolyEval ProbDistQuantile ProbDistRand ProbDistRandArray ProbDistRandArrayEqSp ProbDistSkew ProbDistStd ProbDistTailValueAtRisk ProbDistTWLS ProbDistTWLSRestricted ProbDistTWMLE ProbDistTWMLERestricted ProbDistValueAtRisk ProbDistVar ProbDistWeightedLikelihood ProbDistWeightedLogLikelihood ProbDistWeightedMLE ProbDistWeightedMLERestricted Product Proper PVAnnuityCts PVSwapCts PVZero Quartile QuartileExc RadianToDegree Rand RandBetween RandomlySelectState RandomOrdering RandomPermutation RecognisedBrowserFeatures RecognisedChartLegendDockings RecognisedChartSeriesColors RecognisedChartSeriesLineStyles RecognisedChartSeriesTypes RecognisedMortalityTableNumberOfVariants RecognisedMortalityTables RecognisedMortalityTableVariants RecognisedPhysicalUnits RecognisedProbDists RecognisedSearchSpiders RegularisedIncompleteBeta RelativeVolUsingCorr RelativeVolUsingCov RemoveAllInstancesOfStringFromString ReorderSeries RepeatString Replace ResampledPortfolioOptimiser RestateYieldOrDiscount ReverseArray ReverseBooleanArray ReverseDateArray ReverseIntegerArray ReverseQuadraticPortfolioOptimiser ReverseStringArray Right RoundToNdp RoundToNsf RSet RSq RTrim SearchForSearchSpiders Sec Sech Second SeriesSum SessionIdExpires SetOfMembersOfArray SetOfMembersOfDateArray SetOfMembersOfIntegerArray SetOfMembersOfStringArray SIDimensionNames SIDimensionsOf Sign SimplifyFraction SimplifyFraction2 SimulateGaussianMixture Sin Sinh Skew Slice2dArray Slope SolvencyII_SCRSFCombineStresses SolvencyII_SCRSFLifeCorrs SolvencyII_SCRSFLifeStressNames SolvencyII_SCRSFMktCorrs SolvencyII_SCRSFMktStressNames SolvencyII_SCRSFNonLifeCorrs SolvencyII_SCRSFNonLifeStressNames SolvencyII_SCRSFOverallCorrs SolvencyII_SCRSFOverallStressNames SolvencyII_SCRSFStressSetNames SolvencyII_SCRSFTermStructureStressedRate SolvencyII_SCRSFTermStructureStressFactors SortedArray SortedDateArray SortedIntegerArray SortedIntersectionOfDateSets SortedIntersectionOfIntegerSets SortedIntersectionOfSets SortedIntersectionOfStringSets SortedSetOfMembersOfArray SortedSetOfMembersOfDateArray SortedSetOfMembersOfIntegerArray SortedSetOfMembersOfStringArray SortedStringArray SortedUnionOfDateSets SortedUnionOfIntegerSets SortedUnionOfSets SortedUnionOfStringSets Space SpearmanRankCorrelation SpearmanRankCorrelations Split Sqrt SqrtPi StandardisedNormalQuantiles StandardWeightedCubicQuantileFit StandardWeightedCubicQuantileFitInclEnds Stdev Str StrComp StringToBaseNArray StrReverse SudokuSolve Sum SumProduct SumSq SumX2MY2 SumX2PY2 SumXMY2 Tan Tanh TDistCdf TDistPdf TimeOfDay Timer TimeSerial TimeString TimeValue TInv Today ToSexagesimal TrailingVolatilityAdjustArray Trim Truncate UCase Uminus UnionOfDateSets UnionOfIntegerSets UnionOfSets UnionOfStringSets UnitNormalDensity UnivariatePolynomialMultiply Uplus Val ValidNematrianWebFunctions ValueFromValueWithBracketedError ValueOfAnnuity Variance WeightedCorrelation WeightedCorrelations WeightedCovariance WeightedCovariances WeightedDesmooth_AR1 WeightedDesmooth_AR1_rho WeightedMean WeightedMeanAbsDevVsMean WeightedMeanAbsDevVsMedian WeightedMedian WeightedPercentile WeightedPopulationCovariance WeightedPopulationCovariances WeightedPopulationKurt WeightedPopulationSkew WeightedPopulationStdev WeightedPopulationVariance WeightedSkew WeightedSpearmanRankCorrelation WeightedStdev WeightedVariance WeightOverlap Year Available operators: ^ * / \ + - True False And Or Xor Not & <= >= < > =
Format of this function or operator:
(where x represents a value or a sub-expression). For further details see: here

---

To use the expression evaluator enter the expression you wish to evaluate into the Input text box (and optionally a description of the calculation in the Calculation description text box) and then press the Calculate button. You can also enter the expression into the Search / Calculate text box at the top of the page and then press the + / button next to it. Expressions can include brackets, operators and calls to nearly all components of the Nematrian online function library. For further details, see here.

 

Important notice

 

If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement.

 

---

NAVIGATION LINKS
Contents | Prev | Next

---