Manuals/calci/ODDLPRICE - Revision history

Devika: /* Related Videos */

2019-02-21T20:52:17Z

Devika: /* Related Videos */

2018-11-16T20:57:12Z

Devika at 21:50, 30 July 2018

2018-07-30T21:50:38Z

Jayaram at 11:07, 14 March 2017

2017-03-14T11:07:05Z

Swapna at 18:17, 19 July 2015

2015-07-19T18:17:37Z

Devika: /* References */

2015-05-13T18:04:04Z

References

Devika at 09:17, 4 April 2014

2014-04-04T09:17:50Z

Devika at 09:14, 4 April 2014

2014-04-04T09:14:13Z

Show changes

Abin: /* Description */

2014-02-28T09:33:59Z

Description

Abin: /* Description */

2014-02-28T09:28:10Z

Description

@@ Line 89: / Line 89: @@
 ==Related Videos==
-{{#ev:youtube|v=JpQ1ywuWz1U|280|center|ODDFPRICE}}
+{{#ev:youtube|v=JpQ1ywuWz1U|280|center|ODDLPRICE}}
 ==See Also==

@@ Line 89: / Line 89: @@
 ==Related Videos==
-{{#ev:youtube|bmOs9t__jsY|280|center|ODDFPRICE}}
+{{#ev:youtube|v=JpQ1ywuWz1U|280|center|ODDFPRICE}}
 ==See Also==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''ODDLPRICE(st,m,lt,r,yld,rdm,f,b)'''</div><br/>
+<div style="font-size:23px">'''ODDLPRICE (SettlementDate,MaturityDate,LastInterestDate,Rate,Yield,Redemption,Frequency,Basis)
-*<math> st </math> is the settlement date.
+'''</div><br/>
-*<math> m </math> is the maturity date.
-*<math> lt </math> is the last interest date.
+*<math> SettlementDate </math> is the settlement date.
-*<math> r </math> is the rate of interest.
+*<math> MaturityDate </math> is the maturity date.
-*<math> yld </math> is the yield for annum.
+*<math> LastInterestDate </math> is the last interest date.
-*<math> rdm </math> is the security's redemption value.
+*<math> Rate </math> is the rate of interest.
-*<math> f </math> is the frequency.
+*<math> Yield </math> is the yield for annum.
-*<math> b  </math> is the basis.
+*<math> Redemption </math> is the security's redemption value.
 ==Description==
@@ Line 13: / Line 16: @@
 *The peroid can be shorter or longer compared with the other periods.
 *This function is inverse of the ODDLYIELD.
-*In <math>ODDLPRICE(st,m,lt,r,yld,rdm,f,b)</math>, <math>st</math> is the security's settlementDate. It  is a Date or DateTime specifying when the security was purchased.
+*In <math>ODDLPRICE (SettlementDate,MaturityDate,LastInterestDate,Rate,Yield,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>yld</math> is the security's yield for an annum which is a nonnegative number.
+*<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>Yield</math> is the security's yield for an annum which is a nonnegative number.
-*<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.
 {| class="wikitable"
 |-
@@ Line 41: / Line 45: @@
 |}
 *The date arguments must satisfy the following conditions:
-         s(settlement) <lt(last interest) < m(maturity).
+         SettlementDate < LastInterestDate < MaturityDate.
-*Also s, m, lt,and b are truncated in to integers.
+*Also SettlementDate, MaturityDate, LastInterestDate,and Basis are truncated in to integers.
 *This function will give 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 yld<0.
+.Rate<0 or Yield<0.
-.b<0 or b>4.
+.Basis<0 or Basis>4.
 ==Examples==

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

@@ Line 82: / Line 82: @@
 #=ODDLPRICE(B1,B2,B3,B4,B5,B6,B7,B8) = 147.83213209
 #=ODDLPRICE(B1,B2,B3,B4,B5,B6,2,3) = 147.82713239
 ==See Also==

← Older revision		Revision as of 18:04, 13 May 2015
Line 90:		Line 90:

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

@@ Line 54: / Line 54: @@
 |-
 ! 1
-| 7/18/2006 || 12-Oct-2013
+| 7/18/2006 || 10/12/2013
 |-
 ! 2
-| 9/8/2007 || 14-Mar-14
+| 9/8/2007 || 3/14/14
 |-
 !3
-| 4/20/2005 || 05-May-2012
+| 4/20/2005 || 5/5/2012
 |-
 ! 4

@@ Line 14: / Line 14: @@
 *This function computes the price per $100 face value of a security having an odd last coupon period.
 *ODDLPRICE shows the error value when
-  Settle, M, I, or FC is not a valid date
+.Settle, M, I, or FC is not a valid date
-  R or Yield< 0.
+.R or Yield< 0.
-  Basis must between 0 and 4.
+.Basis must between 0 and 4.
-  M > settle > LI
+.M > settle > LI
 ==Example==