Manuals/calci/ODDFYIELD

From ZCubes Wiki
Jump to navigation Jump to search
ODDFYIELD (SettlementDate,MaturityDate,IssueDate,FirstCouponDate,Rate,Price,Redemption,Frequency,Basis,Guess)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SettlementDate } is the settlement.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MaturityDate } is the maturity.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle IssueDate} is the issue date.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FirstCouponDate } is the first coupon date.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate } is the rate of interest.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Price } is the security's price.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Redemption} is the security's redemption.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Frequency } is the frequency.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis } is the basis.
    • ODDFYIELD(),returns the yield of a security with an odd first period.

Description

  • This function gives the yield of a security that pays interest periodically but has an odd first period.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ODDFYIELD (SettlementDate,MaturityDate,IssueDate,FirstCouponDate,Rate,Price,Redemption,Frequency,Basis,Guess) } ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SettlementDate } is the security's settlementDate. It is a Date or DateTime specifying when the security was purchased.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MaturityDate } is the security's maturity date. This date is after the settlement date specifying when the security matures.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle IssueDate } is the date which is specifying when the security was issued.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FirstCouponDate } is the date which is specifying when the security has its first interest payment. This date must be after the settlement date but before the maturity date.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate } is a non-negative number specifying the interest rate for the coupons that the security pays.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Price } is a non-negative number or currency specifying the security’s purchase price per $100 of face value.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Redemption } is a number or currency specifying the security’s value at redemption per $100 of face value.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Frequency } is is a number specifying the number of coupons per year.
  • The supported values are
 1 -annual payments
 2 -semiannual payments
 4 -quarterly.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis } is an optional number specifying the day basis system to use.
  • The following types are supported
Basis Day count basis
0 or omitted American 30/360 (default)
1 actual/actual
2 actual/360
3 actual/365
4 European 30/360
  • To find the value of a Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle ODDFYIELD} we are using the iterative technique.
  • The value is changed through 100 iterations until the estimated price with the given value is near to the price.
  • The date arguments must satisfy the following conditions:
   IssueDate<SettlementDate <FirstCouponDate < MaturityDate.
  • Also Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SettlementDate } , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MaturityDate } ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle IssueDate } ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FirstCouponDate } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Basis } are truncated in to integers.
  • This function gives the result as error when
  1.The date arguments SettlementDate,MaturityDate and FirstCouponDate are not a valid date.
  2.Rate<0 or Price<=0
  3.Basis<0 or Basis>4

Examples

Spreadsheet
A B
1 9/17/2006 7/15/2000
2 4/1/2020 8/10/2025
3 7/2/2006 2/28/2000
4 11/5/2010 11/1/2002
5 7.5% 8.25%
6 78.55 93.1
7 100 125
8 2 1
9 0 0
  1. =ODDFYIELD(A1,A2,A3,A4,A5,A6,A7,A8,A9)= 0.09758683535
  2. =ODDFYIELD(B1,B2,B3,B4,B5,B6,B7,B8,B9)=0.09086257924
  3. =ODDFYIELD(B1,B2,B3,B4,B5,B6,B7,4,2)=0.089941749932

Related Videos

ODDFYIELD

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/ODDFYIELD&oldid=211348"