Finance
Spreadsheet functions for finance — conformant with Google Sheets and Excel.
Functions commonly used in finance:
- ACCRINT
- ACCRINTM
- AMORLINC
- AVERAGE
- AVERAGE.WEIGHTED
- AVERAGEIF
- AVERAGEIFS
- CORREL
- COUNT
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVAR
- COVARIANCE.P
- COVARIANCE.S
- CUMIPMT
- CUMPRINC
- DATE
- DAY
- DAYS360
- DB
- DDB
- DISC
- DOLLARDE
- DOLLARFR
- DURATION
- EDATE
- EFFECT
- EOMONTH
- FV
- FVSCHEDULE
- GEOMEAN
- INTRATE
- IPMT
- IRR
- ISPMT
- ISZONED
- KURT
- LARGE
- LOGINV
- LOGNORM.DIST
- LOGNORM.INV
- LOGNORMDIST
- MAX
- MAXIFS
- MDURATION
- MEDIAN
- MINIFS
- MIRR
- MONTH
- NOMINAL
- NORM.INV
- NORMINV
- NPER
- NPV
- PDURATION
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RANK
- RATE
- RECEIVED
- RRI
- SKEW
- SLN
- SLOPE
- STDEV
- SYD
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TODAY
- TZADD
- TZBOARD
- TZCONVERT
- TZDIFF
- TZINWINDOW
- TZISDST
- TZLOCALIZE
- TZOFFSET
- TZSERIAL
- VDB
- XIRR
- XNPV
- YEAR
- YEARFRAC
- YIELD
- YIELDDISC
- YIELDMAT