Component |
Resolution - Bond Pricing |
||||||||
|
|
||||||||
Function Definition |
oBondFR_EYield(PriceMethod, PriceOrYield, SettlementDate, DatedDate, FirstCpnDate, MaturityDate, FaceValue, CouponRate, HolidaySchedule, OutputFlag) Calculates equivalent yield(s) using French Government bond pricing conventions. Returns a number of equivalent yields. |
||||||||
|
|
||||||||
Bond Types |
French Government bonds (OAT's). |
||||||||
|
|
||||||||
Function Parameters |
|||||||||
|
|||||||||
Parameters |
Description |
|
Parameter Type |
|
Restrictions |
||||
. |
|||||||||
Price Method |
|
Indicates whether the PriceOrYield argument contains the clean price or the yield. |
|
Enumerated Constant |
|
1 - Clean Price |
|||
PriceOrYield |
The clean price or the yield for the bond. |
|
Double |
|
PriceOrYield > 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 |
|||
Holiday Schedule |
|
Schedule of non-business days (excluding weekends). |
|
Date Range |
|
Leave blank if not applicable |
|||
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 Domestic Yield, followed by all other equivalent yields (1-10). |
|
Enumerated Constant |
|
0 - All Equiv Yields |
|||
|
|
|
|
|
|
|
Copyright 2013 Hedgebook Ltd.