ODDLYIELD

Formulas / ODDLYIELD
Calculate the yield of a security with an odd last period.
=ODDLYIELD(sd, md, ld, rate, pr, redem, freq, [basis], [na])
  • Basis - required argument for the basis of the yield
  • Frequency - required argument for the frequency of the yield
  • Redemption - required argument for the redemption of the yield
  • Issue - required argument for the issue of the yield
  • Maturity - required argument for the maturity of the yield
  • Settlement - required argument for the settlement of the yield
  • Pr - required argument for the price of the yield

Examples

  • =ODDLYIELD(DATE(2018,2,5),DATE(2018,6,15),DATE(2017,10,15),0.05,99.5,100,2,0)

    For example, to calculate the yield of a bond that was purchased on February 5, 2018, matures on June 15, 2018, was issued on October 15, 2017, has an interest rate of 5%, a price of 99.5, a redemption value of 100, pays interest twice a year, and uses a day count basis of 0, the formula would be the same as above. This example returns an answer of 6.32%.

Summary

The ODDLYIELD function is used to calculate the yield of a security with an odd last period. It requires settlement, maturity, last_interest, rate, pr, redemption, frequency, and basis arguments. It is an easy and reliable way to get the yield of a security with an odd last period.

  • The ODDLYIELD function returns the yield of a security with an odd last period as a percentage.
  • It can take an optional basis argument, which controls how days are counted.


Frequently Asked Questions

What is the ODDLYIELD function?
The ODDLYIELD function is a mathematical function that calculates the yield of a security with an odd last period.
What is the syntax of the ODDLYIELD function?
The syntax of the ODDLYIELD function is ODDLYIELD(settlement, maturity, issue, first_interest, rate, pr, basis).
What does each parameter of the ODDLYIELD function mean?
  • settlement - the security's settlement date
  • maturity - the security's maturity date
  • issue - the security's issue date
  • first_interest - the security's first interest date
  • rate - the security's coupon rate
  • pr - the security's price
  • basis - the security's day count basis
What is the output of the ODDLYIELD function?
The output of the ODDLYIELD function is the yield of a security with an odd last period.
What are some tips for using the ODDLYIELD function?
  • Make sure all dates and times are properly formatted.
  • Check the order of the parameters.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.