To work with the tool in Foresight Analytics Platform 10, use the new interface.
The function wizard for the OddfPrice function looks as follows:
OddfPrice(Settlement, Maturity, Issue, FirstCouponDate, Rate, YieldP, Redemption, Frequency, Basis)
Settlement. The settlement date on securities (the date of securities sell to the buyer is later than the securities issue date).
Maturity. The security's maturity date. The maturity date is the date when the security expires.
Issue. The security's issue date.
FirstCouponDate. The date of the first coupon payment on securities.
Rate. The security's interest rate. Parameter value must be greater than or equal to zero.
YieldP. The annual income on securities. Parameter value must be greater than or equal to zero.
Redemption. The security's redemption value per $100 face value.
Frequency. The annual number of coupon payments. The parameter may take the following values:
1. Annual payments.
2. Semi-annual payments.
4. Quarterly payments.
Basis. The day calculation method used. Select a value from 0 to 4:
0. The day calculation method - American. 360 days (NSAD method). Default value.
1. Day calculation method - Actual/actual.
2. Day calculation method - Actual/360 days.
3. Day calculation method - Actual/365 days.
4. Day calculation method - European 30/360 days.
Optional parameter.
NOTE. To determine the parameter, it is available to specify either the parameter value or the cell address where it is located.
It returns the price per $100 face value of securities for an odd: short or long first period.
The value of the Settlement parameter must be less than value of the Maturity parameter.
The value of the Maturity parameter must be greater that value of the FirstCouponDate parameter.
The FirstCouponDate parameter value must be greater than the Settlement parameter value.
This function is calculated with the following formulas:
Formula | Result | Description |
=OddfPrice("11.11.2008", "01.03.2021", "15.10.2008", "01.03.2009", 0.1275, 0.1025, 200, 4, 3) | 146.11 rub. | The price per $100 face value of securities for an odd first period on the following conditions:
|
=OddfPrice(A1, A2, A3, A4, 0.0785, 0.0625, 100, 2, 1) | 113.60 rub. | The price per $100 face value of securities for an odd first period on the following conditions:
|
See also: