Manuals/calci/ODDLYIELD - Revision history

Devika: /* Related Videos */

2019-02-21T20:52:49Z

Devika: /* Related Videos */

2018-11-16T20:58:24Z

Devika at 22:12, 30 July 2018

2018-07-30T22:12:27Z

Jayaram at 11:07, 14 March 2017

2017-03-14T11:07:36Z

Devika: /* Examples */

2015-10-26T05:17:19Z

Examples

Devika at 08:16, 8 October 2015

2015-10-08T08:16:44Z

Swapna at 18:20, 19 July 2015

2015-07-19T18:20:38Z

Devika: /* References */

2015-05-13T18:05:28Z

References

Devika at 09:14, 4 April 2014

2014-04-04T09:14:50Z

Abin: /* Description */

2014-03-06T11:05:19Z

Description

@@ Line 72: / Line 72: @@
 ==Related Videos==
-{{#ev:youtube|v=0LCEFrmItC0|280|center|ODDFYIELD}}
+{{#ev:youtube|v=0LCEFrmItC0|280|center|ODDLYIELD}}
 ==See Also==

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

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''ODDLYIELD(s,m,lt,r,pr,rdm,f,b)'''</div><br/>
+<div style="font-size:23px">'''ODDLYIELD (SettlementDate,MaturityDate,LastInterestDate,Rate,Price,Redemption,Frequency,Basis)
-*<math> s </math> is the settlement.
+'''</div><br/>
-*<math> m </math> is the maturity.
-*<math> lt </math> is the last 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> LastInterestDate </math> is the last coupon date.
-*<math> rdm </math> is the security's redemption.
+*<math> Rate </math> is the rate of interest.
-*<math> f </math> is the frequency.
+*<math> Price </math> is the security's price.
-*<math> b  </math> is the basis.
+*<math> Redemption </math> is the security's redemption.
 ==Description==
 *This function gives  the yield of a security that pays interest periodically but has an odd last period.
 *This function is the inverse function of the  OddLPrice function.
-*In <math>ODDLYIELD(s,m,lt,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.
+*In <math>ODDLYIELD (SettlementDate,MaturityDate,LastInterestDate,Rate,Price,Redemption,Frequency,Basis)
-*<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> lt </math> is the date which is specifying when the security has its last payment. This date must be before the settlementDate.
+*<math> MaturityDate </math> is the security's maturity date. This date is  after the settlement date specifying when the security matures.
-*<math> r </math>  is a non-negative number specifying the interest rate for the coupons that the security pays.
+*<math> LastInterestDate </math> is the date which is specifying when the security has its last payment. This date must be before the settlementDate.
-*<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 52: / Line 56: @@
 *<math>NL_i</math> = normal length in days of the ith, or last, quasi-coupon period within odd coupon period.
 *The date arguments must satisfy the following conditions:
-         s(settlement) <lt(last interest) < m(maturity).
+         SettlementDate <LastInterestDate < MaturityDate.
-*Also <math> s</math>, <math>m </math>, <math>lt</math>,and <math> b </math> are truncated in to integers.
+*Also <math> SettlementDate </math>, <math>MaturityDate </math>, <math>LastInterestDate</math>,and <math> Basis </math> are truncated in to integers.
 *This function gives the result as error when
-.The date arguments s,m and lt are not a valid date.
+.The date arguments SettlementDate, MaturityDate and LastInterestDate 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:07, 14 March 2017
Line 78:		Line 78:
	==References==		==References==
	*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ODDLYIELD_function Oddlyield]		*[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ODDLYIELD_function Oddlyield]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 60: / Line 60: @@
 ==Examples==
-#=ODDLYIELD(10-May-1998,28-Sep-1998,5-Mar-1998,4.05%,125,50,4,0)= -1.523902561320
+#=ODDLYIELD("10/May/1998","28/Sep/1998","5/Mar/1998",4.05%,125,50,4,0)= -1.523902561320
-#ODDLYIELD(10-May-1998,28-Sep-1998,5-Mar-1998,4.05%,125,50,1,1) = -1.5119336294351
+#=ODDLYIELD("10/May/1998","28/Sep/1998","5/Mar/1998",4.05%,125,50,1,1) = -1.5119336294351
 #=ODDLYIELD("5/10/1998","9/28/1998","3/5/1998",4.05%,125,50,2,2)= -1.49066037101320
-#=ODDLYIELD(10-May-1998,28-Sep-1998,5-Mar-1998,4.05%,125,50,2,3)= -1.5119336294351
+#=ODDLYIELD("10/May/1998","28/Sep/1998","5/Mar/1998",4.05%,125,50,2,3)= -1.5119336294351
-#=ODDLYIELD(10-May-1998,28-Sep-1998,5-Mar-1998,4.05%,125,50,2,4) = -1.5239025613
+#=ODDLYIELD("10/May/1998","28/Sep/1998","5/Mar/1998",4.05%,125,50,2,4) = -1.5239025613
 ==Related Videos==

← Older revision		Revision as of 18:20, 19 July 2015
Line 66:		Line 66:
	#=ODDLYIELD(10-May-1998,28-Sep-1998,5-Mar-1998,4.05%,125,50,2,4) = -1.5239025613		#=ODDLYIELD(10-May-1998,28-Sep-1998,5-Mar-1998,4.05%,125,50,2,4) = -1.5239025613

		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|pyzGOgnel70\|280\|center\|ODDFYIELD}}

	==See Also==		==See Also==

← Older revision		Revision as of 18:05, 13 May 2015
Line 74:		Line 74:

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

@@ Line 43: / Line 43: @@
 *<math> ODDLYIELD </math> is calculated as follows:
-<math> ODDLYIELD = \left [\dfrac{\left (redemption + \left (\left(\sum_{i=1}^{NC}\frac{DC_i}{NL_i}\right )*\frac{100*rate}{frequency}\right )\right )-\left (par + \left ( \left (\sum_{i=1}^{NC}\frac{A_i}{NL_i}\right )*\frac{100*rate}{frequency}\right )\right )} {par + \left ( \left (\sum_{i=1}^{NC}\frac{A_i}{NL_i}\right )*\frac{100*rate}{frequency}\right )}\right ]
+<math> \left [\dfrac{\left (redemption + \left (\left(\sum_{i=1}^{NC}\frac{DC_i}{NL_i}\right )*\frac{100*rate}{frequency}\right )\right )-\left (par + \left ( \left (\sum_{i=1}^{NC}\frac{A_i}{NL_i}\right )*\frac{100*rate}{frequency}\right )\right )} {par + \left ( \left (\sum_{i=1}^{NC}\frac{A_i}{NL_i}\right )*\frac{100*rate}{frequency}\right )}\right ]
+*
 \left [\frac{frequency}{\left(\sum_{i=1}^{NC}\frac{DSC_i}{NL_i}\right )}\right ]</math>