writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 9:
Line 9: − + Line 15:
Line 15: − +
no edit summary
*'basis' is the type of day count basis to use.
*'basis' is the type of day count basis to use.
PRICE() calculates the price per $100 face value of security that pays periodic interest.
PRICE() calculates the price per <math>$100</math> face value of security that pays periodic interest.
== Description ==
== Description ==
PRICE(settlement, maturity, rate, yield, redemption, frequency, basis)
PRICE(settlement, maturity, rate, yield, redemption, frequency, basis)
*The function returns the price per '$100' face value of security that pays periodic interest.
*The function returns the price per <math>$100</math> face value of security that pays periodic interest.
*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
*If settlement date ≥ maturity date, Calci displays #N/A error message.
*If settlement date ≥ maturity date, Calci displays #N/A error message.