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

« Previous Version 10 Next »

Overview

Eagle supports end-to-end processing of Options on Futures (Future Options). This document covers the full lifecycle including Accounting, Data Management, and Performance.

A Future Option is a contract giving the holder the right, but not the obligation, to buy (call Option) or sell (put Option) a stated number of Future contracts at a fixed price until a stated expiration date.

Some Future Options have a variation margin component. Similar to a Future, it is the daily cash settlement of gain/loss based on price fluctuations. However this variation margin is calculated based on the price of the Option, not the Future.

Pay special attention to underlined sections, as these highlight the most frequently encountered issues. Bold is used for navigation, modules, and screens. Italics are used for fields, tables, and errors. Fixed width indicates values for fields or code/text that should be entered. Tags are shown in parentheses (#) after field names.

Example reference data screens, trade screens, and reports are attached:


Content on this page:

Entity Setup

Before any trades can be booked, the target entity must be set up appropriately. Futures & Options with Margin Transaction Fees (3889) must be populated any time the Option or underlying Future has Variation Margin (4533) = Yes. The other Future-related fields are only required if the Option will be physically exercised into the underlying Future.

Note: Future Options are always processed as Identified cost regardless of an entity's Cost Method (22) setting.

Entities trading Options need two specific pieces of data, which can be populated using Create/Edit Entity.

  • Net Option Positions (639)

    • No: long and short positions in the same contract are held separately, with units always positive in Eagle Accounting

      • Short positions have negative units in Data Management

      • Transaction elections are Buy, Write, Sell, and BuytoCover

    • Yes: long and short positions in the same contract are netted together, allowing a trade to cross zero and bring the position from long to short or vice versa

      • Short positions are represented by negative units in both Eagle Accounting and Data Management

      • Transaction elections are Buy and Sell

  • Options and Futures Expiration Delay Days (12101): number of days to delay automatic expiration

    • When NULL or zero, Eagle Accounting will auto-expire the Option on expiration date 

    • When populated, the expiration event can only be processed on the adjusted date

      • Example: if Options and Futures Expiration Delay Days = 3 and expiration date = 2022-01-21, the expiration can only be processed on 2022-01-24

Entities trading Futures need three specific pieces of data, which can be populated using Create/Edit Entity or Add/Change Entity.

  • Lot Selection Method (27): multi-lot Future positions are often closed using Modified FIFO (MFIFO), which is a variation of FIFO that closes lowest cost lots first when relieving multiple open lots from a given date

    • If Futures are going to be comingled with other securities, you may have to set up a Mixed Cost Basis Rule to enforce MFIFO specifically for Futures, as described in Manage Mixed Cost Basis Rules

    • Regular FIFO only considers the Event Sequence (126) when relieving multiple open lots from a given date

    • Details about MFIFO and other lot relief methods are available in Understand Lot Selection Methods

  • Margin Price Source (18041): this price source is used for VM processing and can be different than the price sources used for URGL

    • If an entity has multiple bases, this must be the same across all bases; when adding a secondary basis it will default to the same value as the primary basis

  • Futures & Options with Margin Transaction Fees (3889): this only affects Futures with VM and allows the commission and fees to be either included or excluded in cost for gain/loss calculations

  • Net Futures Positions (632)

    • Yes: long and short trades are netted to a single long position (all trades are considered long, with negative units if a position or trade is short)

      • This is allowed even if Tech Short Eligible (57) = No, which would typically prevent negative units

    • No: long and short trades create two separate position rows (trades and positions are considered long or short, always with positive units)

  • Futures Clearing Broker (634): there can only be one Clearing Broker per futures trade

    • The trade panel will automatically default to this value, but it can be overridden if necessary

Some clients have a requirement to process the same Future with VM in certain funds and without VM in others. This can be accomplished by using a Variation Margin Override Rule. Refer to Override a Security's Variation Margin Setting for an Entity for details.

Reference Data

Storage & Configuration

Eagle has modeled Option security master files (SMFs) as single rows in Data Management. The underlying Future can be set up ahead of time and then linked to the Option via the Underlying Security fields. The Underlying Security fields are optional on the SMF, but are required for physical exercises or assignments.

Market Data

Future Option prices must be loaded directly to the contract (they will not be pulled from the underlying security).

Security Data

Options can be set up and maintained in Issue Viewer, Security Reference Manager (SRM), or Reference Data Center (RDC). The list below contains all fields required to configure a Future Option SMF.

  • Issue Name (961)
  • Primary Asset ID (14) & Type (1432)
  • Processing Security Type (3931) = OPOPCM (Future Option)
  • Contract Size (19): number of Futures that each Option is entitled to
  • Issue Country (1418)
  • Asset Currency (85)
  • Expiration Date (38): date when Accounting will automatically expire the Option, unless the entity-level Options and Futures Expiration Delay Days field has been populated
  • Strike Price (67): price at which the Option can be exercised or assigned
  • Option Type (1142)
    • American: Option can be exercised or assigned at any time until expiration, assuming the strike price has been reached
    • European: Option can be exercised or assigned on expiration date only
    • Bermudan: functions the same way as American in Accounting; this option exists for reference data purposes only
  • Premium Type (3302)
    • Cost: Option premium is settled to cash and valuation is the same as a vanilla equity option
    • Notional Cost: Option premium is not settled to cash, but instead held as a notional cost similar to Futures without variation margin (VM)
      • Variation Margin (4533, only if Premium Type = Notional Cost)
        • Yes: VM is calculated and settled to cash, resulting in a MV of zero on the Option
        • No: Accounting does not calculate VM, resulting in a MV on the Option equal to its URGL
      • Variation Margin Rule (2289, see the Valuation section for calculation details): defines how VM or unrealized gain/loss is calculated
        • Standard Life to Date: most US and foreign Future Options use this calculation
        • 10-Year Australian Government Bond (10Yr AUDGOVTBND): for Future Options on 10-year Australian government bonds; requires that Underlying Coupon Rate and Payment Frequency be populated as well
        • 3-Year Australian Government Bond (3Yr AUDGOVTBND): for Future Options on 3-year Australian government bond; requires that Underlying Coupon Rate and Payment Frequency be populated as well
        • Australian 90-Day Bank Bill (AUD 90 Day Bank Bill): for Future Options on Australian 90-day bank bills
        • US Treasury: for Options on US Treasury Futures
  • Put/Call Flag (1350)

Trade Processing

Trades are entered using the Book Trade module once 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 it and select Open. The list below contains all fields required to book a Future Option trade.

Net Option Positions = No

Open > Buy

This creates a long position (long with positive quantity).

  • Contracts (40): number of contracts being transacted
  • Price Per Contract (45): this is multiplied by Contracts and Contract size to calculate the premium
  • Commission Per Contract (971): this is multiplied by Contracts to calculate Commission Amount Local (47), which is factored into the net amount
  • Tax Amount (46), SEC Fee (48), Stamp Duty Tax (51), & Other Fee (3752): these are added to the premium and commission to generate the total net amount
    • These fields are only available when Variation Margin = No
  • Broker (88)
  • Clearing Broker (1237): only required when Variation Margin = Yes

Open > Write

This creates a short position (short with positive quantity), using the same fields as above.

Close > Sell

This closes (partially or fully) a previously established long position, using the same fields as above.

Close > Buy to Cover

This closes (partially or fully) a previously established short position, using the same fields as above.

Net Option Positions = Yes

Open > Buy

This creates a long position (long with positive quantity) or closes a previously established short position (long with negative quantity), using the same fields as above.

Close > Sell

This creates a short position (long with negative quantity) or closes a previously established long position (long with positive quantity), using the same fields as above.

Commission/Fees

Any commissions and fees involved in the transaction can be entered at trade time. For Future Option with Variation Margin = Yes, the entity-level Futures & Options with Margin Transaction Fees determines how commissions and fees are treated (the default election is Capital).

  • Capital: commission + fees are added to the notional amount used for calculating VM
    • They will be reflected in CASH when the VM process is run for Trade Date, Approved, and Settled
    • Notional Cost = (contracts * price) + commission + fees
  • Expense: commission + fees will be expensed and excluded from cost for subsequent gain/loss calculations
    • The commission + fees are still included in margin approval process and will be reflected in CASH when the VM process is run for Trade Date, Approved, and Settled
    • Notional Cost = Contracts * Price

Accounting

Once a Future Option position has been established it will be picked up in Eagle’s global workflow. Accounting valuation is calculated when posting unrealized gain/loss and Data Management valuation is calculated in STAR to PACE.

  • V17 & Above: Accounting Center > Processing and Exceptions > Global Processes

    • 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

    • Accounting Valuation: Unrealized Gain Loss Entries > Post Daily Fund Unrealized Gain Loss-Position

    • Data Management Valuation: STAR to PACE Direct Processing > Transfer Data - Batch

For Future Options with Variation Margin = Yes, the VM process must also be triggered. Refer to Futures (FUT) Best Practices for detailed information on the VM workflow.

Valuation

Future Option valuation varies depending on the reference data elections for Premium Type and Variation Margin (if applicable).

  • Premium Type = Cost
    • Market Value = # of Contracts * Contract Size * Price * Price Multiplier
  • Premium TypeNotional Cost
    • Variation Margin = No
      • Market Value = # of Contracts * Contract Size * (Market Price - Trade Price) * Price Multiplier
    • Variation Margin = Yes
      • Market Value = zero (VM settled to cash each day based on day-over-day price movement)

Note: refer to Futures (FUT) Best Practices for detailed information on valuation when using Notional Cost and the calculations behind each Variation Margin Rule.

Exercise/Assign

Exercises and assignments are processed using Book Trade > Other > Exercise. By definition, purchased Options are exercised and written Options are assigned, but they use the same process in Accounting.

Settlement

Options can be exercised or assigned using cash or physical settlement. Cash settlement has no effect on the underlying asset; it is simply an exchange of money based on the exercise price. Physical settlement results in either opening or closing a position in the underlying asset.

Cash Settlement

Price Per Contract (45): enter the exercise/assign price. This is informational only, as no cash payment or receipt is generated from the transaction.

Resulting activity depends on Variation Margin = Yes or No.

  • No: cash settlement simply closes the specified number of Option on a Future contracts with associated cost treated as realized loss (purchased) or proceeds as realized gain (written)
  • Yes: cash settlement closes the specified number of Future Option contracts
    • Purchased Call or Put: Gain (Loss) = # of contracts exercised * contract size * (exercise price - price per contract) * price multiplier
    • Written Call or Put: Gain (Loss) = # of contracts exercised * contract size * (price per contract - exercise price) * price multiplier
    • Note: realized gain/loss is not calculated based on initial price and exercise price

Physical Settlement

To Clearing Broker (5529): enter the clearing broker for the underlying Future (required even if underlying Future is without variation margin).

There is no cash movement when physically exercising an Option on a Future. Resulting activity depends on Variation Margin = Yes or No.

  • No: Option cost/premium allocated as URGL to underlying Future
  • Yes: Option gain or loss from VM allocated as URGL to underlying Future
    • Purchased Call: establishes long position
    • Written Call: reduces long position; does not occur if underlying future is without VM
    • Purchased Put: reduces long position; does not occur if underlying future is without VM
    • Written Put: establishes long position

Physical Short Settlement

Not supported for Future Options.

Exercise/Assign Events

Accounting will automatically move the Option’s cost to the underlying security when the contract is exercised, via these events in Accounting:

  • Close the Option contract
  • Open or close the underlying security position (long or short)
  • Allocate Option cost or premium to the underlying security position

Canceling Exercise/Assign Events

Canceling an exercise or assign event requires the use of the Batch Cancel Trades panel. Query for the appropriate date range, entity, and security, then set Choose Trade to Cancel (962) = the target exercise/assign event. This will roll back the exercise/assign event by removing the action on underlying shares and restoring the original position. Option trades can be canceled using the regular Cancel Trade panel or rebooked using the Cancel & Rebook Trades module.

Expire

If the contract is not closed prior, Eagle Accounting will expire the Option on expiration date plus the number of days defined in the entity’s Options and Futures Expiration Delay Days election.

Reporting

STAR to PACE (S2P)

Almost all reports in Eagle 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 a single row for each Future Option in the POSITION, POSITION_DETAIL, TRADE, and CASH_ACTIVITY tables. Cash activity is appropriately signed based on whether the Future Option is bought or written.

Accounting Reports

Eagle has a core set of accounting reports that can be used to review Future Option 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.

Insurance Reporting

To categorize derivatives for insurance reporting, such as the Schedule DB, Derivative Elections (56) must be set to Hedging Effective, Hedging Other, Income Generation, Replications, or Other on all trades. Leaving the default of Trade will prevent the transaction from appearing on insurance reports.

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 Future Options using data supplied by the S2P process. However, this can be misleading because traditional market values do not capture an Option’s true exposure. Exposure-based analyses, which can be implemented using Eagle Enrichment, calculate more accurate returns. The documentation and .egl files linked below as attachments are available for beta testing. Additional details are available in Exposure Reporting Best Practices and the Eagle Enrichment User Guide 2015

Automation

Future Option security master files (SMFs) and trades can be loaded through the standard Message Center streams. The SMF must be loaded prior to the trade (trades do not spawn SMFs). Refer to the Supported Generic Interfaces guide for more information.

Option SMFs and trades can be loaded through the standard Message Center (MC) streams. The SMF must be loaded prior to the trade (trades do not spawn SMFs). Refer to https://eagledocs.atlassian.net/wiki/spaces/GENERICINTER/overview for more information.

  • Net Option Positions = Yes: short positions are maintained using standard Buy and Sell transactions; set Event Type (55) = BUY or SELL

  • Net Option Positions = No: short positions are maintained using Write and BuytoCover transactions

    • Set Event Type = WRITE or BUYCVR to process these trades through Message Center

Below are the standard interfaces provided out-of-the-box for Message Center.

Variation Margin

Transaction Type

Default Message Center Stream

Sample Files

No

SMF Setup

eagle_default_in_csv_smf

OPFTXX_SMF.csv

Trade Open

eagle_default_in_csv_trades OR eagle_default_in_csv_all

OPFTXX_TC.csv

Partial/Full Close

eagle_default_in_csv_trades OR eagle_default_in_csv_all

OPFTXX_Partial_Close.csv

Yes

SMF Setup

eagle_default_in_csv_smf

OPFTXX_SMF_VM.csv

Trade Open

eagle_default_in_csv_trades OR eagle_default_in_csv_all

OPFTXX_TC_VM.csv

Partial/Full Close

eagle_default_in_csv_trades OR eagle_default_in_csv_all

OPFTXX_Partial_Close_VM.csv

  • No labels