oBondFR_EYield( ) - French Government Bond Equivalent Yield Function


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 2 - Yield
PriceOrYield		The clean price or the yield for the bond.	Double	PriceOrYield > 0
Settlement Date		Valuation date of the bond.	Date	SetDate < MatDate SetDate >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 > DatedDate F.C.D < P.C.D F.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
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 1 - Annual Yield 2 - Semi-Ann Yield 3 - Quarterly Yield 4 - Monthly Yield 5 - True Yield 6 - US Street Yield 7 - US Treasury Yield 8 - JGB Simple Yield 9 - MM actual/360 10 - MM actual/365