Component 
Resolution  Bond Pricing 




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




Bond Types 
Spanish Government bonds (Bonos). 




Function Parameters 



Parameters 
Description 

Parameter Type 

Restrictions 

. 

Yield 

The redemption yield for the bond. 

Double 

Yield >= 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.