Previous Topic

Next Topic

oBondFR_Yield( ) - French Government Bond Yield Function


Resolution - Bond Pricing



Function Definition

oBondFR_Yield(CleanPrice, Settlement Date, DatedDate, FirstCpnDate, MaturityDate, FaceValue, CouponRate, OutputFlag)

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



Bond Types

French Government bonds (OAT's).



Function Parameters





Parameter Type





Clean price per 100 (PPH) of the bond.



CleanPrice >= 0

Settlement Date


Valuation date of the bond.


SetDate < MatDate
SetDate >DatedDate

Dated Date


Date on which the bond begins to accrue interest.





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.




F.C.D > DatedDate
< P.C.D
F.C.D < MatDate

Maturity Date


Maturity date of the bond.





Face Value


Redemption value for the bond paid at maturity.




FaceValue >= 0

Coupon Rate


Coupon rate of the bond, expressed as a decimal.


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
1 - Yield only
2 - Acc Interest only
3 - Dirty Price only
4 - Risk Statistics
5 - Mac Duration
6 - Mod Duration
7 - Convexity only
8 - PVBP only








See Also

Parameter Types

French (OAT's) Bond Pricing Conventions

oBondFR_Price( ) - French Government Bond Price Function

oBond3_Yield( ) - Generic Bond Yield Function 3

oBondFR_CFM( ) - French Government Bond Cash Flow Map Function

oBondFR_EYield( ) - French Government Bond Equivalent Yield Function

Return to website

Copyright 2013 Hedgebook Ltd.