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 5 Next »

Overview

Eagle supports end-to-end processing of Options on Currency (FX Options) in the Eagle product suite. This document covers the full lifecycle including Accounting, Data Management, and Performance.

An FX Option is a contract giving the holder the right, but not the obligation, to buy (call option) or sell (put option) one currency in exchange for another currency at a pre-arranged exchange rate on a specified future date. The payouts are as follows:

  • The writer (seller) of an FX Option receives a premium based on the trade price
  • The buyer of a call is betting that the FX rate between the two underlying currencies will rise above the strike rate/price, allowing the Option to be exercised
  • Conversely, the buyer of a put is betting that the FX rate between the two underlying currencies will fall below the strike rate/price, allowing the Option to be exercised
  • In either case, the writer is betting that the FX Option will not be exercised and therefore expire worthless, allowing the premium to be recorded as a gain

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.

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

Reference Data

Storage & Configuration

Eagle has modeled FX Option security master files (SMFs) as single rows in Data Management.

Market Data

Because they are exchange-traded, FX Option prices are readily available from a number of vendors.

Security Data

FX 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 an FX Option SMF.

  • Issue Name (961)
  • Primary Asset ID (14) & Type (1432)
  • Processing Security Type (3931) = OPOPCR
  • Contract Size (19): units of currency to which each contract is entitled
  • Issue Country (1418)
  • Asset Currency (85)
  • Expiration Date (38): date when Accounting will automatically expire the FX Option, unless the entity-level Options and Futures Expiration Delay Days field has been populated
  • Strike Price (67): FX rate/price at which the contract can be exercised or assigned
  • Option Type (1142)
    • American: contract can be exercised or assigned at any time until expiration, assuming the strike price has been reached
    • European: contract 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
  • Put/Call Flag (1350)
  • Pay Currency (1356)
  • Receive Currency (1357)

Trade Processing

Trades are entered using Book Trade once the entity and reference data have been configured. Enter the appropriate entity, security identifier, and trade/settle dates and click Submit to query for the security. Right-click it and select Open or Close. The submenus depend on your entity election for Net Option Positions. The lists below contains all fields required to book an FX Option trade, which are the same for both opens and closes.

  • Contracts (40): number of contracts being transacted
  • Price Per Contract (45): multiplied by Contracts, Contract Size, and Price Multiplier to calculate the premium
  • Commission Per Contract (971): this is multiplied by Contracts to calculate Commission Amount Local, 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
  • Broker (88)

If an FX Option’s trade premium settles in a currency that differs from its Asset Currency, Settlement Currency (tag 63) on the trade must be changed to the appropriate currency.

Net Option Positions = No

Open

  • Buy: creates a long position (long with positive quantity)
  • Write: creates a short position (short with positive quantity)

Close

  • Sell: closes (partially or fully) a previously established long position
  • Buy to Cover: closes (partially or fully) a previously established short position

Net Option Positions = Yes

Open

  • Buy: creates a long position (long with positive quantity) or closes a previously established short position (long with negative quantity)

Close

  • Sell: creates a short position (long with negative quantity) or closes a previously established long position (long with positive quantity)

Accounting

Once an FX Option trade is booked, 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. These can be scheduled or triggered manually.

  • 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

Valuation

FX Options are valued using unit prices. The market value formula is:

  • Market Value = # of Contracts * Contract Size * Price * Price Multiplier

Exercise/Assign

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

Settlement

FX Options can be exercised or assigned using cash or physical settlement. Cash settlement is simply an exchange of money based on the exercise price. Physical settlement results in spot transactions against the underlying pay and receive currencies.

Cash Settlement

Purchased (Long) Call or Put

  • Cash Receipt = # of contracts exercised * exercise price * Contract Size * Price Multiplier
  • Gain (Loss) = # of contracts exercised * (exercise price - open price per contract) * Contract Size * Price Multiplier

Written (Short) Call or Put

  • Cash Disbursement = # of contracts exercised * exercise price * Contract Size * Price Multiplier
  • Gain (Loss) = # of contracts exercised * (open price per contract - exercise price) * Contract Size * Price Multiplier

Physical Settlement Cash Flows

Purchased (Long) Call or Put

  • Sell Currency: Pay Currency from SMF, a disbursement will be created for this amount
    • Disbursement = # of contracts exercised * Contract Size * Price Multiplier
  • Buy Currency: Receive Currency from SMF, a receipt will be created for this amount
    • Receipt = (# of contracts exercised * Contract Size * Price Multiplier) / Strike Price
    • Set Buy to Base FX Rate (9) to the inverse of Strike Price from the SMF
      • Example: if the strike price is 1.25, then Buy to Base FX Rate would be 1.00 / 1.25 = 0.8
      • This will result in the Sell to Buy FX Rate (7) calculation being equal to Strike Price from the SMF

Written (Short) Call or Put

  • Sell Currency: Receive Currency from SMF, a disbursement will be created for this amount  
    •  Disbursement = # of contracts assigned * Contract Size * Price Multiplier
  • Buy Currency: Pay Currency from SMF, a receipt will be created for this amount   
    • Receipt = (# of contracts assigned * Contract Size * Price Multiplier) / Strike Price
    • Set Buy to Base FX Rate (9) to the inverse of Strike Price from the SMF
      • Example: if the strike price is 1.25, then Buy to Base FX Rate would be 1.00 / 1.25 = 0.8
      • This will result in the Sell to Buy FX Rate (7) calculation being equal to Strike Price from the SMF


Canceling Exercise/Assign Events

Canceling an exercise or assign event requires the use of Batch Cancel Trades. 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 actions on underlying currencies and restoring the original position. FX Option trades can be canceled using the regular Cancel Trade panel or rebooked using Cancel & Rebook Trade.

Expire

If the contract is not closed prior, Accounting will expire the FX 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 FX Option in the POSITION, POSITION_DETAIL, TRADE, and CASH_ACTIVITY tables. Cash activity is appropriately signed based on whether the Cap/Floor is bought or written.

Accounting Reports

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

FX 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.

  • When Net Option Positions is set to Yes, short positions are maintained using standard Buy and Sell transactions
  • When Net Option Positions is set to No, short positions are maintained using Write and BuytoCover transactions
    • To process such trades through Message Center, the Event Type (55) must set to WRITE or BUYCVR

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

Instrument

Transaction Type

Default Message Center Stream

Sample Files

FX Option

FX OP - SMF Setup

eagle_default_in_csv_smf

OPFX_SMF.csv

FX OP - Trade Open

eagle_default_in_csv_trades OR eagle_default_in_csv_all

OPFX_TC.csv

FX OP - Partial/Full Close

eagle_default_in_csv_trades OR eagle_default_in_csv_all

OPFX_Partial_Close.csv

  • No labels