Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Overview

Eagle Accounting provides a single integrated system to capture and process derivatives alongside other securities. Derivatives leverage many common processes, such as fixed income earnings, and thus use many of the same fields. However, due to the notional-based nature of derivatives, some fields do translate directly between traditional equities/fixed income and derivatives.

One example is "principal." This is an established concept for traditional securities, but it is up for interpretation when you consider derivatives. Some systems capture the full notional value in this field, but that can be misleading when viewing a report with both derivatives and traditional securities. Therefore principal is not populated in Eagle Data Management for several derivatives.

The critical components of a trade for each derivatives type are listed below, followed by our recommended location for sourcing this information in Eagle Data Management.

Content on this page:

Forwards

FieldTagDB.TABLE.COLUMNNotes
Sell Quantity366TRADESDBO.TRADE.PAR_OR_SHARES On sell side
Buy Quantity316TRADESDBO.TRADE.PAR_OR_SHARESOn buy side
Base Net Amount478TRADESDBO.TRADE.TRADE_BASE_AMOUNT
Commission Amount Local47TRADESDBO.TRADE.LOCAL_COMMISSION_AMOUNTOn whichever side matches the Settlement Currency (63)
Other Fee3752TRADESDBO.TRADE.SEC_FEESOn whichever side matches the Settlement Currency (63)

Futures & Options

With Variation Margin (VM)

FieldTagDB.TABLE.COLUMN
Contracts40TRADESDBO.TRADE.PAR_OR_SHARES
Price per Contract45TRADESDBO.TRADE.PRICE
Commission Amount Local47TRADESDBO.TRADE.LOCAL_COMMISSION_AMOUNT
Other Fee3752TRADESDBO.TRADE.SEC_FEES
Notional Amount Local7429TRADESDBO.TRADE.COST_LOCAL
Notional Amount Base7509TRADESDBO.TRADE.COST_BASE

No Variation Margin (VM)

FieldTagDB.TABLE.COLUMNNotes
Contracts40TRADESDBO.TRADE.PAR_OR_SHARES
Price per Contract45TRADESDBO.TRADE.PRICE
Tax Amount46TRADESDBO.TRADE.TAXES
Commission Amount Local47TRADESDBO.TRADE.LOCAL_COMMISSION_AMOUNT
SEC Fee48TRADESDBO.TRADE.EXCHANGE_FEE
Stamp Duty Tax51TRADESDBO.TRADE.OTHER_FEE
Other Fee3752TRADESDBO.TRADE.SEC_FEES
Local Net Amount50TRADESDBO.TRADE.NET_CASH
Settlement Net Amount64TRADESDBO.TRADE.SETTLEMENT_AMOUNTOptions only
Base Net Amount478TRADESDBO.TRADE.TRADE_BASE_AMOUNT

Swaps

Interest Rate (IRS) Currency (CCS), & Inflation (ILS)

FieldTagDB.TABLE.COLUMNNotes
Notional Principal Value40TRADESDBO.TRADE.PAR_OR_SHARES
Price45TRADESDBO.TRADE.PRICEContract only
Traded Interest Local49TRADESDBO.TRADE.ACCRUED_INTERESTLegs only
Principal165TRADESDBO.TRADE.PRINCIPALContract only
Commission Amount Local47TRADESDBO.TRADE.LOCAL_COMMISSION_AMOUNTContract only
Other Fee Local3752TRADESDBO.TRADE.SEC_FEESContract only
Local Net Amount50TRADESDBO.TRADE.NET_CASH
Settlement Net Amount64TRADESDBO.TRADE.SETTLEMENT_AMOUNT
Base Net Amount478TRADESDBO.TRADE.TRADE_BASE_AMOUNT
Initial Cash Receipt316CASHDBO.CASH_ACTIVITY.LOCAL_PRINCIPAL_FLOWLegs only
Initial Cash Payment366CASHDBO.CASH_ACTIVITY.LOCAL_PRINCIPAL_FLOWLegs only
Final Cash Payment8317CASHDBO.CASH_ACTIVITY.LOCAL_PRINCIPAL_FLOWLegs only, once position is closed/terminated
Final Cash Receipt8318CASHDBO.CASH_ACTIVITY.LOCAL_PRINCIPAL_FLOWLegs only, once position is closed/terminated

Total Return (TRS)

FieldTagDB.TABLE.COLUMNNotes
Shares40TRADESDBO.TRADE.PAR_OR_SHARESNumber of shares for contract and return leg, notional value for finance leg
Price45TRADESDBO.TRADE.PRICEReturn leg only
Traded Interest Local49TRADESDBO.TRADE.ACCRUED_INTERESTFinance leg only
Principal (contract)165TRADESDBO.TRADE.PRINCIPALOnly populated if Swap Fee Local (7510) is greater than zero
Principal (return leg)165TRADESDBO.TRADE.COST_LOCALTRADESDBO.TRADE.PRINCIPAL is not populated for return legs
Commission47TRADESDBO.TRADE.LOCAL_COMMISSION_AMOUNTReturn leg only
Other Fee3752TRADESDBO.TRADE.SEC_FEESReturn leg only
Local Net Amount50TRADESDBO.TRADE.NET_CASH
Settlement Net Amount64TRADESDBO.TRADE.SETTLEMENT_AMOUNTAlways zero on return leg
Base Net Amount478TRADESDBO.TRADE.TRADE_BASE_AMOUNT
  • No labels