Component 
Resolution  Bond Pricing 




Function Definition 
oBondES_Yield(CleanPrice, Settlement Date, DatedDate, FirstCpnDate, MaturityDate, FaceValue, CouponRate, OutputFlag) Calculates the bond yield using Spanish Government bond pricing conventions. Returns the bond's yield, dirty price, and accrued interest, as well as the risk statistics. 




Bond Types 
Spanish Government bonds (Bonos). 




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 < MatDate 

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 > DatedDate 

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. 

Enumerated Constant 

0  All eight outputs 








Copyright 2013 Hedgebook Ltd.