Excel ODDLYIELD Function
The ODDLYIELD function returns the yield of a security with an odd (short or long) first period.
The ODDLYIELD function returns a numeric value.
- ODDLYIELD will return the #VALUE! error if last_interest, maturity or settlement is not a valid date.
- ODDLYIELD will return the #NUM! error if:
- rate < 0 or pr ≤ 0;
- redemption ≤ 0;
- frequency is not the number 1, 2, or 4;
- basis < 0 or basis > 4;
- maturity > last_interest > settlement is not satisfied;
- The interval between maturity and last_interest does not match the frequency interval.
- last_interest, settlement, maturity, frequency, and basis are truncated to integers.
- The result of the formula is a decimal. To convert it to a percent, please click here.
To get the yield of a security with the information as shown in the below table, please copy or enter the formula below in a blank cell, and press Enter to get the result:
If a security has the same information above except that the settlement date is June 15, 2021, you can add a DATE function to replace the C3 in the formula: