COUPPCD

COUPPCD(settlement, maturity, frequency [,basis])

Returns the previous coupon date before the settlement date.

settlementThe settlement date of the security.
maturityThe maturity of the security.
frequencyThe number of coupon payments in a year:
1 = annual
2 = semi annual
4 = quarterly
basis(Optional) The type of day counting to use:
0 = 30/360 (default)
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = 30E/360

REMARKS
* "PCD" is an abbreviation for previous coupon date.
* The "settlement" is the date a buyer purchases a coupon, such as a bond.
* The "maturity" is the date when the security expires.
* Dates must be entered as text strings within quotation marks or as serial numbers.
* If "settlement" >= "maturity", then #NUM! is returned.
* If "settlement" is not an integer, it is truncated.
* If "settlement" is not a valid date, then #NUM! is returned.
* If "maturity" is not an integer, it is truncated.
* If "maturity" is not a valid date, then #NUM! is returned.
* If the "maturity" date has passed, then #VALUE! is returned.
* If "frequency" is not an integer, it is truncated.
* If "frequency" is any number other than 1, 2 or 4, then #NUM! is returned.
* If "basis" is left blank, then 0 is used.
* If "basis" is not an integer, it is truncated.
* If "basis" < 0, then #NUM! is returned.
* If "basis" > 4, then #NUM! is returned.
* You can use the COUPDAYBS function to return the number of days between the previous coupon date and the settlement date.
* You can use the COUPDAYS function to return the number of days between the coupon dates on either side of the settlement date.
* You can use the COUPDAYSNC function to return the number of days between the settlement date and the next coupon date.
* You can use the COUPNCD function to return the next coupon date after the settlement date.
* You can use the COUPNUM function to return the number of coupons between the settlement date and the maturity date.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=COUPPCD("25/1/2009", "15/11/2010", 2, 1) = 15/11/2008
2=COUPPCD("1/25/2008", "11/15/2010", 2, 1) = #VALUE!

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top