FlexCel.AddinFunctions Namespace

The functions in this namespace are implementation of standard Addin functions included with FlexCel. They are used by the recalculating engine, and while you could use them on their own, they are designed to be called by FlexCel.

Classes

Name	Description
TBaseBinHexImpl	Base conversion class for implementing Bin2Hex, Dec2Bin, etc.
TBaseBondsImpl	Implements the basics for Bond functions, like CoupDays, CoupDaysNC, CoupDayBS, CoupNCD, CoupNum, CoupPCD.
TBaseGCDLCM	A base implementation for both GCD and LCM
TBaseWorkDaysImpl	Implements the basis for WorkDays and NetWorkDays Excel functions. Look at Excel documentation for more information.
TBin2DecImpl	Implements the Bin2Dec Excel function. Look at Excel documentation for more information.
TBin2HexImpl	Implements the Bin2Hex Excel function. Look at Excel documentation for more information.
TBin2OctImpl	Implements the Bin2Oct Excel function. Look at Excel documentation for more information.
TConvertImpl	Implements the Convert Excel function. Look at Excel documentation for more information.
TCoupDaysBSImpl	Implements the CoupDaysBS Excel function. Look at Excel documentation for more information.
TCoupDaysImpl	Implements the CoupDays Excel function. Look at Excel documentation for more information.
TCoupDaysNCImpl	Implements the CoupDaysNC Excel function. Look at Excel documentation for more information.
TCoupNCDImpl	Implements the CoupNCD Excel function. Look at Excel documentation for more information.
TCoupNumImpl	Implements the CoupNum Excel function. Look at Excel documentation for more information.
TCoupPCDImpl	Implements the CoupPCD Excel function. Look at Excel documentation for more information.
TDec2BinImpl	Implements the Dec2Bin Excel function. Look at Excel documentation for more information.
TDec2HexImpl	Implements the Dec2Hex Excel function. Look at Excel documentation for more information.
TDec2OctImpl	Implements the Dec2Oct Excel function. Look at Excel documentation for more information.
TDeltaImpl	Implements the Delta Excel function. Look at Excel documentation for more information.
TDollarDeImpl	Implements the DollarDe Excel function. Look at Excel documentation for more information.
TDollarFrImpl	Implements the DollarDe Excel function. Look at Excel documentation for more information.
TDurationImpl	Implements the Duration and MDuration addin functions. Returns the [modified] Macauley duration for a security with an assumed par value of $100.
TEDateImpl	Implements the EDate addin function. Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
TEffectImpl	Implements the Effect Excel function. Look at Excel documentation for more information.
TEOMonthImpl	Implements the EOMonth Excel function. Look at Excel documentation for more information.
TFactDoubleImpl	Implements the FactDouble Excel function. Look at Excel documentation for more information.
TGcdImpl	Implements the GCD Excel function. Look at Excel documentation for more information.
TGeStepImpl	Implements the GeStep Excel function. Look at Excel documentation for more information.
THex2BinImpl	Implements the Hex2Bin Excel function. Look at Excel documentation for more information.
THex2DecImpl	Implements the Hex2Dec Excel function. Look at Excel documentation for more information.
THex2OctImpl	Implements the Hex2Oct Excel function. Look at Excel documentation for more information.
TIsEvenImpl	Implements the IsEven Excel function. Look at Excel documentation for more information.
TIsOddImpl	Implements the IsOdd Excel function. Look at Excel documentation for more information.
TLcmImpl	Implements the LCM Excel function. Look at Excel documentation for more information.
TMRoundImpl	Implements the MRound Excel function. Look at Excel documentation for more information.
TMultinomialImpl	Implements the Multinomial Excel function. Look at Excel documentation for more information.
TNetWorkDaysImpl	Implements the NetWorkDays Excel function. Look at Excel documentation for more information.
TNominalImpl	Implements the Nominal Excel function. Look at Excel documentation for more information.
TOct2BinImpl	Implements the Oct2Bin Excel function. Look at Excel documentation for more information.
TOct2DecImpl	Implements the Oct2Dec Excel function. Look at Excel documentation for more information.
TOct2HexImpl	Implements the Oct2Hex Excel function. Look at Excel documentation for more information.
TQuotientImpl	Implements the Quotient Excel function. Look at Excel documentation for more information.
TRandBetweenImpl	Implements the RandBetween Excel function. Look at Excel documentation for more information.
TSeriesSumImpl	Implements the SeriesSum Excel function. Look at Excel documentation for more information.
TSqrtPiImpl	Implements the TSqrtPiImpl Excel function. Look at Excel documentation for more information.
TWeekNumImpl	Implements the Weeknum Excel function. Look at Excel documentation for more information.
TWorkDayImpl	Implements the WorkDay Excel function. Look at Excel documentation for more information.
TXIRRImpl	Implements the XIRR Excel function. Look at Excel documentation for more information.
TXNPVImpl	Implements the XNPV Excel function. Look at Excel documentation for more information.
TYearFracImpl	Implements the YearFrac Excel function. Look at Excel documentation for more information.

Enumerations

Name	Description
TDayCountBasis	Enumerates different Basis parameters for financial functions like Duration.