Wherever possible CALC 1 functions follow the spreadsheet functions of the same name.
Function | Description | Example | Result |
---|---|---|---|
accrint(issue, first, settle, annualRate, par, frequency, dayBasis) | Calculates the accrued interest for a security with periodic interest payments. | c1.accrint( 19870501, 19871101, 19870810, 0.0675, 100, 2, dbactact) | 1.85 |
accrintm(issue, settle, annualRate, par, dayBasis) | Calculates the accrued interest for a security that pays at maturity. | c1.accrintm( 20080501, 20120229, 0.0675, 100, dbact360) | 26.23 |
accrintprice(settle, maturity, annualRate, annualYield, redemption, frequency, dayBasis) | Calculates the accrued interest for a security with periodic interest payments, using argument for the price function. This is used to allow a calculator to calculate price and accrued interest with the same arguments. | c1.accrintprice( 20040428, 20180604, 0.0675, 0.0825, 100, 2, db30360) | 2.7 |
disc(settle, maturity, price, redemption, dayBasis) | The discount rate of a security. | c1.disc(19930207, 19930606, 97.98, 100, db30360) | 0.06 |
effective(nomRate, num) | The effective compounded interest rate given a nominal interest rate. | c1.effective(0.05, 365) | 0.05 |
intrate(settle, maturity, investAmount, redemption, dayBasis) | The equivalent annual interest rate for an investment bought at one price and sold at another. | c1.intrate(19930207, 19930606, 97.975347, 100, dbact360) | 0.06 |
nominal(effectiveRate, periodsPerYear) | Returns a nominal interest rate given the effective compounded interest rate. | c1.nominal( 0.05127, 365) | 0.05 |
price(settle, maturity, annualRate, annualYield, redemption, frequency, dayBasis) | Calculates a quoted price for an interest paying security, per 100 currency units par value. | c1.price(19930225, 20041215, 0.05875, 0.0646, 100, 2, db30360) | 95.21 |
pricedisc(settle, maturity, annualYield, redemption, dayBasis) | Calculates a price for a non-interest paying discounted bond. | c1.pricedisc( 19920207, 19920301, 0.0535, 100, db30360) | 99.64 |
pricef7(a, dsc, e, m, n, r, rv, y) | Calculates a quoted price for an interest paying security, per 100 currency units par value using formula 7. | c1.pricef7( 70, 110, 180, 2, 24, 0.05875, 100, 0.0646) | 95.21 |
yield(settle, maturity, annualRate, price, redemption, frequency, dayBasis) | Calculates the yield for an interest paying security. | c1.yield (20080501, 20120229, 0.0675, 94.84, 100, 2, db30360) | 0.08 |
Reference:
Bond (finance) - From Wikipedia, the free encyclopedia