Sample security definitions

Security setup examples

The following list shows how to set up securities with the types named. Note that only compulsory information is shown. For instance, if no credit rating is shown, the default of 'AAA' will be assigned.

Zero interest cash

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_CASH

AUD

Notes

Zero interest cash generates no interest return. It should therefore only be used to model futures offsets, outstanding settlements and other non-physical cash holdings.

Interest bearing cash

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_CASH

Interest(CURVE[0])

AUD

CURVE

Notes

Interest bearing cash generates income on each day it is held. The annual interest rate for each interval is calculated using the Interest risk function, and the interest rate used is the cash rate from curve CURVE. The cash rate is given by CURVE[0], which is the shortest point on the curve.

For all securities containing this asset type, an additional returns category called 'Interest' will be displayed on attribution reports.

Bank bill

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_BILL

AUD

CURVE

June 30, 2017

Bank bill future

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_BILL

0

AUD

CURVE

June 30, 2017

Notes

  • If no cash offset for the future is provided, the value of  must be set to 0. This ensures that the bill future will have zero exposure in FIA's risk and returns calculations.
  • Effective exposure

  • If a cash offset for the future is provided, the value of  can be set to 1 or left blank.
  • Effective exposure

Bond priced from a zero curve

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_BOND_ZERO_CURVE

AUD

CURVE

June 30, 2017
0.05
2

Notes

This example is for a bond priced off a zero coupon curve, with a maturity date of 30th June 2017, a annual coupon of 5%, paying two coupons per year.

A fixed coupon bond is a security that pays regular, fixed coupons at predetermined intervals up to and including the bond’s maturity date, at which time it also repays its principal. Coupon payments are typically made annually or semi-annually, although other payment frequencies are occasionally used.

The return of a bond is driven by accrued interest and the passage of time, by changes in the level of the yield curve, by changes in credit spread, and by a number of other smaller effects such as convexity and pull to par.

Some bonds have a non-standard first or last coupon. For instance, the usual interval between coupons may be a year, but for issuance reasons the time between the bond’s issuance and the first coupon payment may be set up to be more or less than a year. Although this changes the pricing and accrued interest calculations during this period, the returns of the bond are largely unaffected by such features, so they are ignored for attribution purposes.

Many bonds also have embedded options, allowing the issuer to call the bond and repay the capital earlier than the scheduled maturity date.

Bonds are priced as the sum of the various discounted cash flows generated by the security. Because coupon-paying bonds are ubiquitous within the fixed income markets, FIA provides specialised internal routines to price these securities to a very high degree of accuracy, using the relevant yield curve.

Bond priced from a YTM

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_BOND_YTM(BOND_ID[YTM])

AUD

CURVE

June 30, 2017
0.05
2

Notes

This example is for a bond priced off a supplied yield to maturity. The YTM must be available in column YTM in the weights and returns file for security BOND_ID.

Perpetual bond

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_PERPETUAL

AUD

CURVE

0.05
2

Notes

A perpetual bond has a coupon but no maturity date.

Bond future

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_BOND_ZERO_CURVE

0

AUD

CURVE

June 30, 2017
0.05
2

Notes

A bond future is set up with maturity date, coupon and coupon frequency of the future's cheapest-to-deliver (CTD) bond.

  • If no cash offset for the future is provided, the value of  must be set to 0. This ensures that the bond future will have zero exposure in FIA's risk and returns calculations.
  • Effective exposure

  • If a cash offset for the future is provided, the value of  can be set to 1 or left blank.
  • Effective exposure

Delayed start bond

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_BOND_ZERO_CURVE

AUD

CURVE

June 30, 2013
June 30, 2017
0.05
2

Notes

This example is for a bond priced off a zero coupon curve, with a maturity date of 30th June 2017, a annual coupon of 5%, paying two coupons per year. The bond started to pay coupons on 30th June 2013.

Inflation-linked bond

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_BOND_ZERO_CURVE

Inflation(AUD_CPI)

AUD

REAL_CURVE

January 15, 2030
0.04
2

Notes

This example is for an inflation-linked bond priced off a real coupon curve. The bond generates an additional inflation carry return, which is calculated from historical values of the AUD_CPI time series, recorded in the index file.

Floating rate note

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_FRN_ZERO_CURVE(LIBOR)

AUD

ZERO_CURVE

January 15, 2030
0.00025
12

Notes

This example is for a generic floating rate note, paying 12 coupons per year. The coupon is the most recently supplied value of LIBOR in the index file, plus a margin of 0.25% (the margin is supplied in the Coupon field).

Amortizing bond

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_SINKER_ZERO_CURVE

AUD

ZERO_CURVE

January 15, 2030
0.03
2
8.5

Notes

This example is for a generic sinking security, paying 2 coupons per year, with a term of 8.5 years.

Credit-default swap (CDS)

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_CDS

AUD

ZERO_CURVE

January 15, 2030
0.03
2

Notes

Credit default swaps direct all their return to a special category called CDS.

Mortgage-backed security (MBS) using the PSA prepayment model

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_MBS_PSA

Paydown

AUD

ZERO_CURVE

January 15, 2030
0.03
2
1

Notes

This function models a mortgage-backed security where the prepayments are modelled using the PSA function. In this example, the PSA rate is set to 1 (100%).

Paydown return is modelled by the Paydown function.

Mortgage-backed security (MBS) using supplied sinking schedule

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_SINKER_SCHEDULE(MBS_SINKING_SCHEDULE)

Paydown_s(MBS_SINKING_SCHEDULE)

AUD

ZERO_CURVE

January 15, 2030
0.03
2
1

Notes

This function models a mortgage-backed security where the prepayments are modelled using a supplied sinking schedule, recorded as MBS_SINKING_SCHEDULE in the index file.

Paydown return is modelled by the Paydown_s function.

Equity

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_Equity

AUD

Notes

This function models an equity that has no yield curve dependencies of any type. All of its return will be assigned to Residual.

Forward

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_CASH

AUD

Forward

Notes

FX forwards generate return due to interest rate differentials. The simplest way to model such securities is to assign them the type FT_CASH and to direct all their return to a custom residual category such as 'Forward'. If the forward has been used for FX hedging, its return can be compared to the return from the hedged currency.

Option

UNDER CONSTRUCTION

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

FT_CASH

AUD

Option

Notes

Perturbational security

Untitled

Security IDNameSectorEffective datePricing functionRisk functionCredit ratingEffective exposureCurrencyResidual bucketYield curvesStart dateMaturityCouponCoupon frequencyStrikeTermPSAPaydown
ID

Name

AUD

AUD_CURVE

Notes

This function models a security that uses the perturbational model for attribution. For these securities, the value of field Pricing function is left blank. In addition, values of yield to maturity (column 7) and modified duration (column 8) must be supplied in the weights and returns file. Maturity, coupon and frequency are not used by the attribution calculation, but may be required for reporting.

The perturbational approach does not require any information about the cash-flow structure of the security. Instead, the user supplies a set of risk numbers (yield to maturity, modified duration, convexity) that describe how the security’s return is affected by the passage of time and by changes in the yield curve. In other words, risk numbers are used as a proxy for an explicit pricing model that represents the relationship between interest rate changes and return.

The return over a given interval is calculated using the following expression1:

<math>r = y \cdot \delta T - MD \cdot \delta y\,</math>

where

<math>r\,</math> is the return of the security over the interval;

<math>\delta T\,</math> is the elapsed time over the interval, expressed as a fraction of a year;

<math>y\,</math> is the yield to maturity of the security;

<math>MD\,</math> is the modified duration of the security, expressed in years;

<math>\delta y\,</math> is the change in the security’s zero coupon yield at the maturity date.

The perturbational security type may be used to model any type of security whose price is driven by the underlying market’s term structure. In practice, this means virtually all fixed income securities, including money market instruments (bills, FRNs, forwards) and longer-dated securities (bonds, MBS, inflation-linked securities).

However, there are some tradeoffs required in using this security type for attribution. Although no pricing model need be specified, more data is needed to use the perturbational model, and the results may not be as accurate, particularly when cash flows are not concentrated in a single bullet payment but are instead spread out over the security’s lifetime. This is because the perturbational approach implicitly assumes that the security’s price is determined by a single cash flow at some point during its lifetime.

The perturbational approach gives the most accurate results for securities with a single large cashflow, although it typically works well for the majority of coupon-paying bonds. However, the user can also use it in other cases, such as for securities where the cash flows are unknown but we have a good estimate of its interest rate sensitivity, or for complex securitized bonds.

For mortgage-backed securities (MBS) and securitized pools of MBS, it may be preferable to used effective duration as a measure of interest-rate sensitivity than the modified duration, which includes the effects of optionality and other security-specific effects.

Perturbational attribution can even be used for entire portfolios or benchmarks, if aggregate risk data is available.

Effective dating