Entity Setup
As the iBoxx TRS is booked using Eagle’s core TRS functionality, you should be familiar with the entity fields required to trade TRS. Before any trades can be booked, the target entity must be set up appropriately.
Entities trading swaps require a few specific pieces of data, which can be populated using Create/Edit Entity (V17) or Add/Change Entity (prior to V17).
Swap Accrual Method (1184): controls whether accruals are posted to
Income/Expense
orUnrealized
ledger accounts (has no effect on cash or valuation)Variable Rate Source (3301): specifies the source from which underlying floating rates will be pulled
If you receive an Expected number of underlying rates not found error, confirm the rates loaded to your underlying index match this source
Primary Amortization/Accretion Rule (3197): must be straight line (
DEFAULTSL
), straight line actual (DEFAULTSLA
), or none (DEFAULTNONE
)If it is set to anything else, a security-level amortization/accretion rule must be established specifying one of the three above
Accrual Convention Offset (12038): leave the default of
Settlement Date
for standard accrual processing, or set toSettlement Date + 1
to put accrual calculations on a one-day delay (common in Canada)When set to
Settlement Date + 1
, it can be overridden at trade time using Accrual Convention Offset Override (1604)
Swaps cannot be traded technical short even if Tech Short Eligible Indicator (57) is set to Yes
.
Reference Data
Storage & Configuration
Eagle has modeled iBoxx TRS security master files (SMFs) as three rows in Data Management, each with its own Security Alias (10), linked by a common Primary Asset ID (14). Eagle Accounting must be set up to allow duplicate IDs by following the steps in Allow Duplicate Cross Reference Identifiers Processing Notes.
Market Data
Return leg payments are generally paid out at maturity (bullet) and derived from underlying iBoxx indices which can be linked to the return leg by entering its ID in the Underlying Information section. While TRS are valued based on the underlying's price, the price must be entered directly to the return leg.
The finance leg of an iBoxx TRS accrues interest using an underlying floating rate index. The applicable rate for the Floating Leg in each IMM (International Monetary Market) quarter is determined by the index currency on which the TRS is traded. For example, a TRS on iBoxx USD Liquid High Yield would be funded with USD ICE Libor (3 month). Each index must be set up as an Index security using Issue Viewer, Security Reference Manager (SRM), or Reference Data Center (RDC).
Once the index has been set up, floating rates can be loaded using Add Variable Rate. Eagle Accounting will automatically pull the appropriate rates into the accrual process based on the finance leg’s First Rate Reset Date (10911), Reset Frequency (1788), and Reset Look-Back Days (10547).
Interest rates must be loaded to the underlying index back to Dated Date (or previous reset date if swap is traded off-cycle) and each subsequent reset date minus Reset Look-Back Days.
Security Data
TRS can be set up and maintained in Issue Viewer, SRM, or RDC. Most data is entered on the contract and propagated to the legs. Specific reset and accrual conventions are entered separately on each leg.
Contract
Processing Security Type (3931) =
SWCOTR (Total Return Swap Contract)
Price Multiplier (18): can be
0.01
or1.00
as the contract is not used for valuationSet to
1.00
when using RDC (the value will propagate down to the return leg, which requires a value of1.00
)
Quantity Scale (19) =
1.00
Notional Reset Type (4409): set to
Constant Notional
as the total return of the index referenced in the trade would be paid out at maturityMaturity Delay Days (3997): we recommend setting this to
1
to prevent the position from being automatically matured before the final reset price is receivedMaturity Delay Days Type (3998) =
B (Business)
Generate Swap Reset Schedule (2299, V17) =
No
A Swap Reset Schedule is only required to support automated corporate action processing, and iBoxx TRS are ineligible for corporate actions
Return Leg
Processing Security Type (3931) =
SWLXEQ (Swap Leg Total Rate Return on Equity)
Price Multiplier (18) =
1.00
Payment Frequency (2287) =
MAT (At Maturity)
Delay Days (1799):
3
per the Markit iBoxx TRS GuideDelay Days Type (5074) =
B (Business)
Finance Leg
Processing Security Type (3931) =
SWLEAC (Swap Interest Accrual Leg)
Coupon Day of Month (10551):
20
per the Markit iBoxx TRS GuideDelay Days (1799) =
0
Reset Look-Back Days (10547):
2
for USD/EUR,0
for GBP per the Markit iBoxx TRS GuideReset Look-Back Days Type (5075) =
B (Business)
Trade Processing
Open (event type: OPENSWAP)
Trades are entered using the Book Trade module once the entity and reference data have been configured. Enter the appropriate entity, security identifier, and trade (35)/settle (37) dates and click Submit to query for the security. Right-click and select Open > Open Swap Contract. If your workflow involves stacking multiple lots of the same iBoxx contract, please refer to https://eagledocs.atlassian.net/wiki/spaces/IE/pages/1658978705/Total+Return+Swaps+TRS+Best+Practices#Booking-Multiple-Open-Lots.
Starting in 2016, iBoxx TRS adopted the Full First Coupon Convention in which all floating coupon payments made by the index buyer to the index seller are for the entire quarterly coupon period. Therefore, OPENSWAP
trades will have traded interest on the finance leg that is calculated since last IMM date; this amount is the upfront payment made from the index seller to the index buyer to compensate for the full coupon that will be paid at the end of the quarterly period.
Contract
Traded Interest/Effective Date (2857): date to which traded interest is calculated; typically Trade Date or T+1
Swap Fee Local (7510): paid, received, or zero; represents the fee paid to enter the TRS (typically zero)
Broker (88)
Return Leg
Notional (7782): enter total notional of the swap
Shares (40) is calculated automatically after the price is entered
Price (45): initial price of the underlying return leg asset (i.e. price per share)
Commission (47) & Other Fee (3752): enter any commissions and/or fees; these are factored into the notional value calculation on the finance leg for the initial period, but not exchanged in cash
Local Net Amount (50): calculated automatically as Notional + Commission
This is used to establish the cost
Finance Leg
Shares (40): this represents the notional value and is calculated automatically as return leg Local Net Amount
Traded Interest Local (49): interest bought or sold, calculated from Dated Date or last coupon date
This initial payment is made by the index seller to the index buyer to compensate for the floating rate over payment that the index will make at the end of the initial period
Lot Level Dated Date (4411): optional; used to override Dated Date on a particular to suppress the calculation of traded interest
Setting this equal to Traded Interest/Effective Date will cause traded interest to be calculated as zero
First Period Coupon Rate (1360): optional; overrides the interest rate for the initial income accrual period
Eagle Accounting will automatically start using the appropriate interest rates after the next reset is processed
Close (event type: CLOSESWAP)
The Book Trade module should also be used to process both full and partial terminations. Enter the same information as the open to query for the security. Right-click it and select Close > Close Swap Contract. If your workflow involves stacking multiple lots of the same iBoxx contract, please refer to https://eagledocs.atlassian.net/wiki/spaces/IE/pages/1658978705/Total+Return+Swaps+TRS+Best+Practices#Booking-Closes-for-Multi-Lot-Positions.
Traded interest on the finance leg, if applicable, can either be entered manually or calculated by Eagle Accounting. This will be included in trade proceeds on the finance leg.
By default the legs will continue to accrue through Settlement Date - 1 (similar to a bond); to accrue through Trade Date, populate Accrual End Date (4412) with Trade Date + 1
Constant Notional: Similar to the open, constant notional TRS closes are entered based on notional value rather than # of shares.
Close Notional (7782, return leg): portion of notional being closed
This is pulled into finance leg Shares and the panel calculates the proportional number of Shares being closed
Return Leg Principal (165): number of Shares calculated by panel * Price
Gain/loss on the return leg is still equal to the return leg Principal - finance leg Shares
Mature/Expire
TRS will be picked up by the Global Process Center > Expirations > Mature process automatically on Maturity Date. The final reset that occurs on Maturity Date must be triggered to generate the final return payment prior to maturity (the maturity event itself will not trigger the final reset). The final coupon payment is dropped as part of the accrual process.
The final IMM period of the swap requires the finance leg to accrue from start date to end date inclusive
We recommend posting a miscellaneous income or expense entry for one additional day of accrued interest
In the final IMM period, the finance leg coupon should settle three business days after the final fixing date
This can be accommodated by setting Delay Days (1799) =
3
and Delay Days Type (5074) =B (Business)
on the finance leg after the penultimate coupon, but before the final couponIt is best to do this close to maturity because if you rollback earnings into the penultimate coupon period (or prior), the replayed coupon(s) will have the delay applied
For V17 and above, another option is to change the final Cash Payment Date (16411) in the finance leg's Swap Reset Schedule to the appropriate date
Note: there is currently an issue preventing this workflow, tracked as SDP-49439
For earlier releases, we recommend changing Settlement Date manually in Multiple Manual Settlements
You can also use this workaround in V17 with Run Multiple Settlements until the issue above is resolved or if you do not want to edit the Swap Reset Schedule
Cancel & Rebook
Faulty TRS transactions must be cancelled using Batch Cancel Trades, with the transaction rebooked using the Book Trade module. TRSs are not supported in the Cancel and Rebook Trade process or the Cancel Trade screen. Maturities must also be canceled using Batch Cancel Trades.
Accounting
Once an iBoxx TRS trade is booked, it will be picked up in Eagle's global workflow. Daily accruals and periodic resets are generated as part of the earnings process, Accounting valuation is calculated when posting unrealized gain/loss, and Data Management valuation is calculated in the STAR to PACE push. These can be scheduled or triggered manually.
V17 & Above: Accounting Center > Processing and Exceptions > Global Processes
Accruals: Earnings > Run Income Accruals
TRS Resets: Swaps > Reset Total Return Swap
Accounting Valuation: Unrealized Gain Loss Entries > Post Daily Fund Unrealized Gain Loss-Position
Data Management Valuation: Eagle STAR to Eagle PACE Direct Processing > Transfer Data - Batch
Prior to V17: Global Process Center
Accruals: Earnings > Accrue
TRS Resets: Total Return Swap Reset > Total Return Swap Reset
Accounting Valuation: Unrealized Gain Loss Entries > Post Daily Fund Unrealized Gain Loss-Position
Data Management Valuation: STAR to PACE Direct Processing > Transfer Data - Batch
Reset Processing
Refer to the https://eagledocs.atlassian.net/wiki/spaces/IE/pages/1658978705/Total+Return+Swaps+TRS+Best+Practices#Reset-Processing for details about the reset workflow, canceling resets, and rollback/replay.
Reporting
STAR to PACE (S2P)
Almost all reports in Eagle Accounting leverage data from Data Management, which is populated by the S2P process. This will be scheduled as part of the daily workflow, but can also be triggered manually as described in the Accounting section.
The S2P process creates three rows for each iBoxx TRS in the POSITION, POSITION_DETAIL, TRADE, and CASH_ACTIVITY tables. The MARKET_VALUE_INCOME column for each row captures a portion of the total market value.
Contract: always zero
Return Leg: market value due to unrealized gain/loss on underlying security
Finance Leg: market value due to period-to-date accrual payable/receivable
Accounting Reports
Eagle has a core set of accounting reports that can be used to review iBoxx TRS and other security information. These are designed to support the daily operational workflow for business users, allowing Grid Reports to be easily exported to Excel and customized to provide additional details as needed. Advanced Reports are intended to be client-facing and do not provide the same level of customization.
iBoxx TRSs are displayed as three separate rows. The contract and legs are intended to be displayed together, but may be broken into different areas depending on the report’s groupings (long/short, for example).
Data Management Reporting
General Reporting (Eagle OLAP)
OLAP reports provide the maximum level of customization, allowing any column in Data Management to be pulled into a report. These go beyond the Eagle Accounting Grid Reports because they are not limited by core queries, can support multiple sources and various types of calculations, and provide drill-down functionality based on user-defined groupings.
Performance
The performance toolkit calculates market value-based performance for TRSs at the return leg (price changes) and finance leg (accruals) levels using data supplied by the S2P process. However, this can be misleading because swaps use notional values and typically start with a market value of zero. Exposure-based analyses, which can be implemented using Eagle Enrichment, calculate more accurate returns. Refer to Total Return Swaps (TRS) Best Practices for details.
Add Comment