Previous Topic

Next Topic

oFRNstd_Price( ) - Standard FRN Price Function

Component

Resolution - Bond Pricing

 

 

Function Definition

oFRNstd_Price(Model, DiscountMargin, ValuationDate, SettlementDate, EffectiveDate, MaturityDate, ResetFreq, QuotedMargin, NotionalAmount, LastResetRate, ForecastResetRate, DiscountRate, AccrualBasis, BusDayConvention, HolidaySchedule, OutputFlag)

Returns the instrument's clean price, dirty price, accrued interest, and the risk statistics.

 

 

Bond Types

Floating rate note instruments, which have no odd first or last coupon periods, no ex-dividend period, a reset frequency equal to the coupon frequency, a reset cycle that is computed backwards from maturity, and a constant face value over the life of the deal. Unable to value FRN's with different coupon rates / exact coupon periods.

 

 

Function Parameters

 

Parameters

Description

 

Parameter Type

 

Restrictions

.

Model

 

Valuation model of the instrument.

see FRN Pricing

 

Enumerated Constant

1 - Equal/Equal
2 - Equal/Exact

DiscountMargin

 

The margin over the reference rate, expressed in basis points.

 

Double

 

DiscountMargin >= 0

ValuationDate

 

The valuation date of the instrument.

 

Date

 

ValDate < SettleDate

SettlementDate

 

The date on which the trade will settle. This is typically 1-3 business days after the trade.

 

Date

 

SettleDate < MatDate

EffectiveDate

 

The first date from which interest begins to accrue.

 

Date

 

EffDate < MatDate

MaturityDate

 

The maturity date of the instrument.

 

Date

 

As above.

ResetFreq

 

The rate reset frequency of the instrument.

Enumerated Constant

 

1 - Annual
2 - Semi-Annual
3 - Quarterly
4 - Monthly
5 - Bi-Weekly
6 - Weekly

QuotedMargin

The margin, in basis points, that is added to each rate reset.

 

Double

QuotedMargin >= 0

NotionalAmount

 

Redemption value for the instrument paid at each rate reset date.

 

Double

 

FaceValue >= 0

LastResetRate

 

The rate observed at the rate reset date immediately before the valuation date.

 

Double

 

LastResetRate >= 0

ForecastResetRate

 

The constant forecasted rate at each of the instrument's reset dates.

 

Double

 

ForecastReset >=0

DiscountRate

 

The discount rate of the instrument, expressed as a decimal.

 

Double

 

DiscountRate >= 0

AccrualBasis

 

Convention used to determine projected cash flow amounts.

 

see Day Count Conventions

 

Enumerated Constant

 

1 - Act/Act (actual)
2 - Act/Act (bond)
3 - Act/360
4 - Act/365
5 - Act/365 ISDA
6 - Act/365 JGB (NL)
7 - 30/360 ISDA
8 - 30/360 PSA
9 - 30E/360
10 - 30E+/360
11 - Act/365L

BusDayConvention

 

Business day convention for coupon payments dates. Used to determine the start and end date of each payment date.


see Business Day Conventions

 

Enumerated Constant

 

1 - No Adjustment
2 - Previous
3 - Following
4 - Mod Previous
5 - Mod Following
6 - EOM No Adjust
7 - EOM previous
8 - EOM following

HolidaySchedule

 

Schedule of non-business days (excluding weekends)

 

Date Range

 

Leave blank if not applicable

OutputFlag

 

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: Discount Margin, Clean Price, Accrued Interest, Dirty Price, Macaulay Duration, Modified Duration, Convexity, and Price Value of a Basis Point. Entering a 4 will output: Macaulay Duration, Modified Duration, Convexity, and Price Value of a Basis Point.

 

Enumerated Constant

 

0 - All eight outputs
1 - Clean Price 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

FRN Function Parameters

oFRNctm_Price( ) - Custom FRN Price Function

oFRNctm2_Price( ) - Custom2 FRN Price Function

oFRNstd_DM( ) - Standard FRN Discount Method Function

oFRNstd_CFM( ) - Standard FRN Cash Flow Map Function

Return to www.derivativepricing.com website

Copyright 2013 Hedgebook Ltd.