Manuals/calci/ODDFYIELD - Revision history

Devika: /* Related Videos */

2018-11-16T20:55:18Z

Devika at 21:36, 30 July 2018

2018-07-30T21:36:00Z

Devika at 21:35, 30 July 2018

2018-07-30T21:35:22Z

Jayaram at 11:06, 14 March 2017

2017-03-14T11:06:51Z

Swapna at 18:19, 19 July 2015

2015-07-19T18:19:25Z

Devika: /* References */

2015-05-13T17:54:32Z

References

Devika at 06:41, 26 March 2014

2014-03-26T06:41:22Z

Devika: /* Examples */

2014-03-26T06:39:55Z

Examples

Devika: /* See Also */

2014-03-26T06:38:26Z

Devika: /* Examples */

2014-03-26T06:36:57Z

Examples

@@ Line 95: / Line 95: @@
 ==Related Videos==
-{{#ev:youtube|pyzGOgnel70|280|center|ODDFYIELD}}
+{{#ev:youtube|v=jbxksJV0LxI|280|center|ODDFYIELD}}
 ==See Also==

@@ Line 1: / Line 1: @@
 <div style="font-size:23px">'''ODDFYIELD (SettlementDate,MaturityDate,IssueDate,FirstCouponDate,Rate,Price,Redemption,Frequency,Basis,Guess)
 '''</div><br/>
 *<math> SettlementDate </math> is the settlement.
 *<math> MaturityDate </math> is the maturity.

@@ 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.
+ODDFYIELD (SettlementDate,MaturityDate,IssueDate,FirstCouponDate,Rate,Price,Redemption,Frequency,Basis,Guess)
-*<math> iss </math> is the issue date.
-*<math> fc </math> is the first coupon date.
+*<math> SettlementDate </math> is the settlement.
-*<math> r </math> is the rate of interest.
+*<math> MaturityDate </math> is the maturity.
-*<math> pr </math> is the security's price.
+*<math> IssueDate</math> is the issue date.
-*<math> rdm </math> is the security's redemption.
+*<math> FirstCouponDate </math> is the first coupon date.
-*<math> f </math> is the frequency.
+*<math> Rate </math> is the rate of interest.
-*<math> b  </math> is the basis.
+*<math> Price </math> is the security's price.
 ==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.
 *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 50: @@
 *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==

← Older revision		Revision as of 11:06, 14 March 2017
Line 101:		Line 101:
	==References==		==References==
	*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ODDFYIELD_function Oddfyield]		*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ODDFYIELD_function Oddfyield]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 89: / Line 89: @@
 #=ODDFYIELD(B1,B2,B3,B4,B5,B6,B7,B8,B9)=0.09086257924
 #=ODDFYIELD(B1,B2,B3,B4,B5,B6,B7,4,2)=0.089941749932
 ==See Also==

← Older revision		Revision as of 17:54, 13 May 2015
Line 96:		Line 96:

	==References==		==References==
		+	*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ODDFYIELD_function Oddfyield]

← Older revision		Revision as of 06:41, 26 March 2014
Line 95:		Line 95:
	*[[Manuals/calci/ODDLYIELD \| ODDLYIELD ]]		*[[Manuals/calci/ODDLYIELD \| ODDLYIELD ]]

−	~~==References==~~
−
−	~~==See Also==~~
	==References==		==References==

@@ Line 53: / Line 53: @@
 ==Examples==
-#'''Example 1'''
 {| class="wikitable"
 |+Spreadsheet

@@ Line 91: / Line 91: @@
 ==See Also==
-*[[Manuals/calci/ODDFYIELD  | ODDFYIELD ]]
+*[[Manuals/calci/ODDFPRICE  | ODDFPRICE ]]
 *[[Manuals/calci/ODDLPRICE  | ODDLPRICE ]]
 *[[Manuals/calci/ODDLYIELD  | ODDLYIELD ]]