Process a Manual Forward Transaction

Owned by Tom Fahey (Unlicensed)
Last updated: Sept 28, 2016 by Former user (Deleted)
6 min read

The Book Trade tool supports the processing of forward transactions. A forward contract, or simply a forward, is a non-standardized contract between two parties to buy or sell an asset at a specified future time at a price agreed to today. This is in contrast to a spot, which is an agreement to buy or sell an asset today.

Set Up a Forward Transaction at the Entity Level

Forwards are similar to spots in that they are an exchange of two currencies at a certain rate as of a certain settlement date. However, spots are essentially real time cash exchanges. Forwards are processed as security transactions, which can be priced and calculate gains/losses.

The following fields in the Forward Fields section of the Add/Change Entity panel and Master Fund Setup panel determine how forwards are processed:

  • Forward Position by Broker. Indicates whether to use the broker code to distinguish forwards made with a different broker, but with the same two currencies and maturity date. Available options include:
    –  Yes. Use the broker code. If the broker is unique on each transaction, the system creates a new security master record for each forward with the same buy/sell currency and maturity date.
    –  No. Do not use the broker code and do not create a new security master record for each forward with the same buy/sell currency and maturity date.
Content on this page:

  • Forward Close Eligible. Indicates whether the entity allows closes of forwards. Available options include:
    –  Yes. Allows you to close forwards before the maturity date.
    –  No. Holds all forwards until the maturity date. The system records separate long and short positions for offsetting forwards.
  • Forward Settlement Currency. Specifies the settlement currency to use for closing a forward. The system creates receivable and payable records based on the value in this field.
  • Forward Security Exists. Indicates whether you must add the forward to the security master file prior to booking the forward transaction. Available options include:
    –  Yes. Requires you to add a forward security master record before booking the trade.
    –  No. Creates two security master records, one for each leg of the forward, when you book the trade.

Book a Forward Transaction without a Forward Security Master Record

The Forward Security Exists field on the Add/Change Entity panel and Master Fund Setup panel determines whether you must add the forward to the security master file prior to booking the forward transaction. If this field is set to No, you can book the forward using the Book Trade tool. The system creates two security master records, one for each leg of the forward, when you book the trade.

To book a Forward transaction using the Book Trade tool:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Book Trade in the Start Search text box.
  3. Click the Book Trade (Accounting Center) link to access the Book Trade tool.
    You see the Book Trade tool's Query window.
  4. Complete the options on the Query window.
    For example, select Primary Asset Identifier from the Query Based On field. Then, enter the Primary Asset Identifier for the currency for one side of the forward transaction. You must also enter the Entity ID/Entity Name and the Trade Date and Settle Date field values.
  5. Click Start Search.
    You see the securities that meet the search criteria.       
          
  6. Right click the cash security for which you are booking a forward transaction.
    For example, right click the USD cash security. You see a shortcut menu with a set of options that determine the actions you can perform for the security. If you select the Book Foreign Exchange option, you see additional options that allow you to buy or sell the USD currency via the forward transaction.
  7. Select an option from the shortcut menu.
    You see the Forward currency exchange trade panel.
  8. Complete the fields on the trade panel.
    For example, suppose you selected Buy Currency – Forward Contract. In addition to entering the entity and security identifier, you must enter a value for the following:
    –  Sell Currency Symbol. Specifies the offsetting sell currency code.
    –  Sell Quantity. Specifies the amount to be sold.
    –  Buy Quantity. Specifies the amount to be bought.
    The forward's issue name is a concatenation of Currency 1 + Currency 2 + Investment Type + Maturity Date + Broker Code, as follows:
    –  GBP/USD FWD 20150114
    –  USD/GBP FWD 20150114
    For a forward, the Settlement Date can be referred to as the Maturity Date.
    In the Transaction Fee Information section, you can enter commissions and other fees in the following fields. The commission and/or other fees create a traded cash record separate from the traded cash on close forward transactions. The commission or fee uses the Settlement Currency field (tag 63) as the commission or fee settlement currency, as follows:
    –  CommAmt L. Specifies the amount of the trade commission in the local currency.
    –  Other Fee Local. Specifies any additional fees on the transaction in the local currency.
    –  Fee Settlement Date. Specifies the fee settlement date associated with the commission and fee amount.
    Additionally, you must specify a broker code. Be aware of the entity's setting for the Forward Position By Broker field to ensure you enter the proper value. This field indicates whether to use the broker code to distinguish forwards made with a different broker, but with the same two currencies and maturity date.
  9. Click Submit.

View Results of the Forward Transaction in Issue Viewer

You can view the results of the forward transaction using the Issue Viewer tool. The example below shows a separate security for each leg of the forward.

You can also view the results of the forward transaction using the Position Viewer tool. In the example below, the Open Lots tab in the Cost object shows a record for each leg of the forward. One leg of the forward shows the sale of 100.000.00 GPB. Notice the negative sign for the Quantity and the Net Local Amount fields.

The other leg shows the buy of the USD.

The Cash Journal report shows the traded cash activity to both currencies.

When the forward settles, the position for both legs of the forward are brought to zero, leaving positive and negative cash amounts for the currencies that were processed as part of the forward.

Add a Forward Security Master Record

The Forward Security Exists field on the Add/Change Entity panel and Master Fund Setup panel determines whether you must add the forward to the security master file prior to booking the forward transaction. If this field is set to Yes, you must add the security master record using the Issue Viewer tool prior to booking the forward transaction.

To add a Forward security master record using the Issue Viewer tool:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Issue Viewer in the Start Search text box.
  3. Click the Issue Viewer link to access the Issue Viewer tool.
    You see the Issues Query window.
  4. From the Add button on the toolbar, select Derivatives and then click Forward Contract.
    You see the Forward Contract panel.
  5. Complete the fields on the Forward Contract panel.

  6. Click Submit.

Book a Forward Transaction with a Forward Security Master Record

To manually book an open trade for a forward transaction with a forward Security Master record:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Book Trade in the Start Search text box.
  3. Click the Book Trade (Accounting Center) link to access the Book Trade tool.
    You see the Book Trade tool's Query window.
  4. Query for the forward security as you would for any other type of security.

    NOTE: The query returned both legs of the previously set up forward contract. You can select either leg to complete the trade since, as shown in the security master example above, CAD was set up as the Sell Currency and USD was set up as the Buy Currency.
  5. Right click the security row and select Book Foreign Exchange/Sell Currency – Forward Contract from the shortcut menu.

    You see the Forward Contract panel.
  6. Complete the fields on the Forward Contract panel.
    Once you select the security, you only need to enter the Sell Quantity and Buy Quantity since the Currency Codes were set up when you created the security master record for the forward contract in the Issue Viewer tool.
  7. Click Submit to process the transaction.

View Results of the Forward Transaction in Position Viewer

Once the transaction is completed, the Position Viewer tool displays the forward transaction the same way as when the Forward Security Exists field is set to No.