Difference between revisions of "Manuals/calci/ODDFYIELD"

Latest revision as of 14:55, 16 November 2018

ODDFYIELD (SettlementDate,MaturityDate,IssueDate,FirstCouponDate,Rate,Price,Redemption,Frequency,Basis,Guess)

$SettlementDate$ is the settlement.
$MaturityDate$ is the maturity.
$IssueDate$ is the issue date.
$FirstCouponDate$ is the first coupon date.
$Rate$ is the rate of interest.
$Price$ is the security's price.
$Redemption$ is the security's redemption.
$Frequency$ is the frequency.
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.
$ODDFYIELD(SettlementDate,MaturityDate,IssueDate,FirstCouponDate,Rate,Price,Redemption,Frequency,Basis,Guess)$ , $SettlementDate$ is the security's settlementDate. It is a Date or DateTime specifying when the security was purchased.
$MaturityDate$ is the security's maturity date. This date is after the settlement date specifying when the security matures.
$IssueDate$ is the date which is specifying when the security was issued.
$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.
$Rate$ is a non-negative number specifying the interest rate for the coupons that the security pays.
$Price$ is a non-negative number or currency specifying the security’s purchase price per $100 of face value.
$Redemption$ is a number or currency specifying the security’s value at redemption per $100 of face value.
$Frequency$ is is a number specifying the number of coupons per year.
The supported values are

 1 -annual payments
 2 -semiannual payments
 4 -quarterly.

$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 $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 $SettlementDate$ , $MaturityDate$ , $IssueDate$ , $FirstCouponDate$ and $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

=ODDFYIELD(A1,A2,A3,A4,A5,A6,A7,A8,A9)= 0.09758683535
=ODDFYIELD(B1,B2,B3,B4,B5,B6,B7,B8,B9)=0.09086257924
=ODDFYIELD(B1,B2,B3,B4,B5,B6,B7,4,2)=0.089941749932

References

Oddfyield

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''ODDFYIELD(s,m,iss,fc,r,pr,rdm,f,b)'''</div><br/>
+<div style="font-size:23px">'''ODDFYIELD (SettlementDate,MaturityDate,IssueDate,FirstCouponDate,Rate,Price,Redemption,Frequency,Basis,Guess)
-*<math> s </math> is the settlement.
+'''</div><br/>
-*<math> m </math> is the maturity.
+*<math> SettlementDate </math> is the settlement.
-*<math> iss </math> is the issue date.
+*<math> MaturityDate </math> is the maturity.
-*<math> fc </math> is the first coupon date.
+*<math> IssueDate</math> is the issue date.
-*<math> r </math> is the rate of interest.
+*<math> FirstCouponDate </math> is the first coupon date.
-*<math> pr </math> is the security's price.
+*<math> Rate </math> is the rate of interest.
-*<math> rdm </math> is the security's redemption.
+*<math> Price </math> is the security's price.
-*<math> f </math> is the frequency.
+*<math> Redemption</math> is the security's redemption.
-*<math> b  </math> is the basis.
+*<math> Frequency </math> is the frequency.
+*<math> Basis  </math> 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.
-*<math> ODDFYIELD(s,m,iss,fc,r,pr,rdm,f,b)</math>,<math> s </math> is the security's settlementDate. It  is a Date or DateTime specifying when the security was purchased.
+*<math> ODDFYIELD (SettlementDate,MaturityDate,IssueDate,FirstCouponDate,Rate,Price,Redemption,Frequency,Basis,Guess)
-*<math> m </math> is the security's maturity date. This date is  after the settlement date specifying when the security matures.
+</math>,<math> SettlementDate </math> is the security's settlementDate. It  is a Date or DateTime specifying when the security was purchased.
-*<math> iss </math> is the date which is specifying when the security was issued.
+*<math> MaturityDate </math> is the security's maturity date. This date is  after the settlement date specifying when the security matures.
-*<math> fc </math> 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.
+*<math> IssueDate </math> is the date which is specifying when the security was issued.
-*<math> r </math>  is a non-negative number specifying the interest rate for the coupons that the security pays.
+*<math> FirstCouponDate </math> 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.
-*<math> pr </math>  is a non-negative number or currency specifying the security’s purchase price per $100 of face value.
+*<math> Rate </math>  is a non-negative number specifying the interest rate for the coupons that the security pays.
-*<math> rdm </math>  is a number or currency specifying the security’s value at redemption per $100 of face value.
+*<math> Price </math>  is a non-negative number or currency specifying the security’s purchase price per $100 of face value.
-*<math> f </math> is  is a number specifying the number of coupons per year.
+*<math> Redemption </math>  is a number or currency specifying the security’s value at redemption per $100 of face value.
+*<math> Frequency </math> is  is a number specifying the number of coupons per year.
 *The supported values are
 -annual payments
 -semiannual payments
 -quarterly.
-*<math> b </math>  is an optional number specifying the day basis system to use.
+*<math> Basis </math>  is an optional number specifying the day basis system to use.
 *The following types are supported
 {| class="wikitable"
@@ Line 45: / Line 48: @@
 *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:
-     iss(issue)<s(settlement) <fc(first coupon) < m(maturity).
+     IssueDate<SettlementDate <FirstCouponDate < MaturityDate.
-*Also <math> s </math>, <math> m </math>,<math> iss </math>,<math> fc </math> and <math> b </math> are truncated in to integers.
+*Also <math> SettlementDate </math>, <math> MaturityDate </math>,<math> IssueDate </math>,<math> FirstCouponDate </math> and <math> Basis </math> are truncated in to integers.
 *This function gives the result as error when
-.The date arguments s,m and fc are not a valid date.
+.The date arguments SettlementDate,MaturityDate and FirstCouponDate are not a valid date.
-.r<0 or pr<=0
+.Rate<0 or Price<=0
-.b<0 or b>4
+.Basis<0 or Basis>4
 ==Examples==
+{| class="wikitable"
+|+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
+|}
+#=ODDFYIELD(A1,A2,A3,A4,A5,A6,A7,A8,A9)= 0.09758683535
+#=ODDFYIELD(B1,B2,B3,B4,B5,B6,B7,B8,B9)=0.09086257924
+#=ODDFYIELD(B1,B2,B3,B4,B5,B6,B7,4,2)=0.089941749932
+==Related Videos==
+{{#ev:youtube|v=jbxksJV0LxI|280|center|ODDFYIELD}}
 ==See Also==
+*[[Manuals/calci/ODDFPRICE  | ODDFPRICE ]]
+*[[Manuals/calci/ODDLPRICE  | ODDLPRICE ]]
+*[[Manuals/calci/ODDLYIELD  | ODDLYIELD ]]
 ==References==
+*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ODDFYIELD_function Oddfyield]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/ODDFYIELD"

Latest revision as of 14:55, 16 November 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search