FlexCel.AddinFunctions Namespace
This is a namespace with commonly used Excel Addin functions that will be used by FlexCel when recalculating. While the functions defined here are not part of the Excel 2003 internal functions, they are often used as they are included in the default "addin packs" in Excel. They also might be built-in in newer Excel releases.
Classes
Name | Description |
---|---|
BaseBinHexImpl | Base conversion class for implementing Bin2Hex, Dec2Bin, etc. |
BaseBondsImpl | Implements the basics for Bond functions, like CoupDays, CoupDaysNC, CoupDayBS, CoupNCD, CoupNum, CoupPCD. |
BaseGCDLCM | A base implementation for both GCD and LCM |
BaseWorkDaysImpl | Implements the basis for WorkDays and NetWorkDays Excel functions. Look at Excel documentation for more information. |
Bin2DecImpl | Implements the Bin2Dec Excel function. Look at Excel documentation for more information. |
Bin2HexImpl | Implements the Bin2Hex Excel function. Look at Excel documentation for more information. |
Bin2OctImpl | Implements the Bin2Oct Excel function. Look at Excel documentation for more information. |
ConvertImpl | Implements the Convert Excel function. Look at Excel documentation for more information. |
CoupDaysBSImpl | Implements the CoupDaysBS Excel function. Look at Excel documentation for more information. |
CoupDaysImpl | Implements the CoupDays Excel function. Look at Excel documentation for more information. |
CoupDaysNCImpl | Implements the CoupDaysNC Excel function. Look at Excel documentation for more information. |
CoupNCDImpl | Implements the CoupNCD Excel function. Look at Excel documentation for more information. |
CoupNumImpl | Implements the CoupNum Excel function. Look at Excel documentation for more information. |
CoupPCDImpl | Implements the CoupPCD Excel function. Look at Excel documentation for more information. |
Dec2BinImpl | Implements the Dec2Bin Excel function. Look at Excel documentation for more information. |
Dec2HexImpl | Implements the Dec2Hex Excel function. Look at Excel documentation for more information. |
Dec2OctImpl | Implements the Dec2Oct Excel function. Look at Excel documentation for more information. |
DeltaImpl | Implements the Delta Excel function. Look at Excel documentation for more information. |
DollarDeImpl | Implements the DollarDe Excel function. Look at Excel documentation for more information. |
DollarFrImpl | Implements the DollarDe Excel function. Look at Excel documentation for more information. |
DurationImpl | Implements the Duration and MDuration addin functions. Returns the [modified] Macauley duration for a security with an assumed par value of $100. |
EDateImpl | 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. |
EffectImpl | Implements the Effect Excel function. Look at Excel documentation for more information. |
EOMonthImpl | Implements the EOMonth Excel function. Look at Excel documentation for more information. |
FactDoubleImpl | Implements the FactDouble Excel function. Look at Excel documentation for more information. |
GcdImpl | Implements the GCD Excel function. Look at Excel documentation for more information. |
GeStepImpl | Implements the GeStep Excel function. Look at Excel documentation for more information. |
Hex2BinImpl | Implements the Hex2Bin Excel function. Look at Excel documentation for more information. |
Hex2DecImpl | Implements the Hex2Dec Excel function. Look at Excel documentation for more information. |
Hex2OctImpl | Implements the Hex2Oct Excel function. Look at Excel documentation for more information. |
IsEvenImpl | Implements the IsEven Excel function. Look at Excel documentation for more information. |
IsOddImpl | Implements the IsOdd Excel function. Look at Excel documentation for more information. |
LcmImpl | Implements the LCM Excel function. Look at Excel documentation for more information. |
MRoundImpl | Implements the MRound Excel function. Look at Excel documentation for more information. |
MultinomialImpl | Implements the Multinomial Excel function. Look at Excel documentation for more information. |
NetWorkDaysImpl | Implements the NetWorkDays Excel function. Look at Excel documentation for more information. |
NominalImpl | Implements the Nominal Excel function. Look at Excel documentation for more information. |
Oct2BinImpl | Implements the Oct2Bin Excel function. Look at Excel documentation for more information. |
Oct2DecImpl | Implements the Oct2Dec Excel function. Look at Excel documentation for more information. |
Oct2HexImpl | Implements the Oct2Hex Excel function. Look at Excel documentation for more information. |
QuotientImpl | Implements the Quotient Excel function. Look at Excel documentation for more information. |
RandBetweenImpl | Implements the Quotient Excel function. Look at Excel documentation for more information. |
SeriesSumImpl | Implements the SeriesSum Excel function. Look at Excel documentation for more information. |
SqrtPiImpl | Implements the Quotient Excel function. Look at Excel documentation for more information. |
WeekNumImpl | Implements the Weeknum Excel function. Look at Excel documentation for more information. |
WorkDayImpl | Implements the WorkDay Excel function. Look at Excel documentation for more information. |
XIRRImpl | Implements the XIRR Excel function. Look at Excel documentation for more information. |
XNPVImpl | Implements the XNPV Excel function. Look at Excel documentation for more information. |
YearFracImpl | 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. |