Definition. This function returns the price (as a percentage, that is, based on a nominal value) of a security that has a simple interest yield in arrears (no compound interest).
Settlement (required) The date when the ownership of the security changes.
Maturity (required) The maturity date of the security.
Issue (required) The date of the emission of the security.
Rate (required) The agreed-upon nominal interest rate of the security based on an entire year.
Yield (required) The current market interest rate or the expected yield of the security (as an interest rate based on an entire year).
Basis (optional) The method you want to use for determining the days in the year ...