Difference between revisions of "Manuals/calci/ODDLPRICE"

Latest revision as of 14:52, 21 February 2019

ODDLPRICE (SettlementDate,MaturityDate,LastInterestDate,Rate,Yield,Redemption,Frequency,Basis)

$SettlementDate$ is the settlement date.
$MaturityDate$ is the maturity date.
$LastInterestDate$ is the last interest date.
$Rate$ is the rate of interest.
$Yield$ is the yield for annum.
$Redemption$ is the security's redemption value.
$Frequency$ is the frequency.
is the basis.
- ODDLPRICE(), returns the price per $100 face value of a security with an odd last period.

Description

This function gives the price of a security that pays interest periodically, but has an odd last coupon period.
The peroid can be shorter or longer compared with the other periods.
This function is inverse of the ODDLYIELD.
In $ODDLPRICE(SettlementDate,MaturityDate,LastInterestDate,Rate,Yield,Redemption,Frequency,Basis)$ , $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.
$LastInterestDate$ is the date which is specifying when the security has its last payment. This date must be before the settlementDate.
$Rate$ is a non-negative number specifying the interest rate for the coupons that the security pays.
$Yield$ is the security's yield for an annum which is a nonnegative number.
$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.

Basis	Day count basis
0 or omitted	American 30/360 (default)
1	actual/actual
2	actual/360
3	actual/365
4	European 30/360

The date arguments must satisfy the following conditions:

       SettlementDate < LastInterestDate < MaturityDate.

Also SettlementDate, MaturityDate, LastInterestDate,and Basis are truncated in to integers.
This function will give the result as error when

  1.The date arguments SettlementDate, MaturityDate and LastInterestDate are not a valid date.
  2.Rate<0 or Yield<0.
  3.Basis<0 or Basis>4.

Examples

	A	B
1	7/18/2006	10/12/2013
2	9/8/2007	3/14/14
3	4/20/2005	5/5/2012
4	3.75%	4.85%
5	5.25%	6.45%
6	110	150
7	2	1
8	0	0

=ODDLPRICE(A1,A2,A3,A4,A5,A6,A7,A8) = 107.560579
=ODDLPRICE(A1,A2,A3,A4,A5,A6,4,2) = 107.5383470
=ODDLPRICE(B1,B2,B3,B4,B5,B6,B7,B8) = 147.83213209
=ODDLPRICE(B1,B2,B3,B4,B5,B6,2,3) = 147.82713239

References

Oddlprice

List of Main Z Functions

Z3 home

@@ 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.
+*<math> Frequency </math> is the frequency.
+*<math> Basis  </math> is the basis.
+**ODDLPRICE(), returns the price per $100 face value of a security with an odd last period.
 ==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.
+*<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.
 {| 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==
@@ Line 85: / Line 89: @@
 ==Related Videos==
-{{#ev:youtube|bmOs9t__jsY|280|center|ODDFPRICE}}
+{{#ev:youtube|v=JpQ1ywuWz1U|280|center|ODDLPRICE}}
 ==See Also==
@@ Line 95: / Line 99: @@
 ==References==
 *[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ODDLPRICE_function Oddlprice]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/ODDLPRICE"

Latest revision as of 14:52, 21 February 2019

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search