oBondDK_Yield( ) - Danish Government Bond Yield Function

Calculates the bond yield using Danish Government bond pricing conventions. Returns the bond's yield, dirty price, and accrued interest, as well as the risk statistics.

Bond Types

Danish Government bonds (DGB's).

Function Parameters

Parameters

Description

Parameter Type

Restrictions

.

CleanPrice

Clean price per 100 (PPH) of the bond.

Double

CleanPrice >= 0

Settlement Date

Valuation date of the bond.

Date

SetDate < MatDateSetDate >DatedDate

Dated Date

Date on which the bond begins to accrue interest.

Date

DatedDate<MatDate

First CpnDate

Date that the first coupon is paid. Only required if bond has an odd first coupon period. If not required, leave either blank or enter 0 as the date.

Date

F.C.D > DatedDateF.C.D < P.C.DF.C.D < MatDate

Maturity Date

Maturity date of the bond.

Date

MatDate>DatedDate

Face Value

Redemption value for the bond paid at maturity.

Double

FaceValue >= 0

Coupon Rate

Coupon rate of the bond, expressed as a decimal.

Double

Coupon Rate >= 0

Output Flag

Indicates which result, or set of results, will be displayed in the worksheet. When returning more than one value, the function must be entered as an array function. Entering a 0 will output: Yield, Clean Price, Accrued Interest, Dirty Price, Macaulay Duration, Modified Duration, Convexity, and Present Value of a Basis Point. Entering a 4 will output: Macaulay Duration, Modified Duration, Convexity, and Present Value of a Basis Point.