Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 as they are an exchange both exchanges of two currencies at a certain rate as of a certain and 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 AddCreate/Change Edit Entity panel and Create Master Fund Setup panel determine how forwards are processed. These fields must be populated before you attempt to enter any forward transactions.

On this page

Table of Contents
maxLevel2
indent2 px

Option

Description

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.

Forward Close Eligible

Indicates whether the entity allows closes of forwards. Available options include:

  • Yes. Allows you to close forwards before the maturity date. To fully close a position, the non-Settlement Currency amount of the offsetting trade must exactly match the non-Settlement Currency amount from the original forward.

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

Panel
borderColor#9F9F9F
titleColor#F7F9F9
titleBGColor#B48436
borderStyledashed
titleContent on this page:
Table of ContentsmaxLevel2indent2 px

Book a Forward Transaction without a Forward Security Master Record

The Forward Security Exists field on the

Add

Create/

Change

Edit Entity panel and Create 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

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

without a forward security master record:

  1. In Accounting Center, in the left navigation pane, click Transactions > Trades Book Trade/Rebook Trade > Book Trade. 
    You see the Book Trade workspace.

  2. Complete the options in the Search Details pane and click Search.
    For example, select Primary Asset Identifier. 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. You see the securities that meet the search criteria.

       
Image Removed      Right
  1. Book Trade Search Details paneImage Added

  2. Do one of the following:
    - On the Book Trade tab, in the Actions group, click Action Rules, point to Book Foreign Exchange.
    - Right-click the cash security for which you are booking a forward transaction, and click Book Foreign Exchange, .
    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
  1.  If you select the Book Foreign Exchange option, you see additional options that allow you to buy or sell the USD currency

via
  1. using the forward transaction

.
Image Removed
  1. ,

  2. Select an option

from the shortcut menu.
  1. , such as:
    - Buy Currency - Forward Contract
    - Sell Currency - Forward Contract
    You see the Forward currency exchange trade panel.

  2. 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
  1. 20170114
    –  USD/GBP FWD

20150114Amt
  1. 20170114
    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:
    –  

Comm
  1. 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.

Image Removed
  1. Forward Currency Exchange panelImage Added

  2. Click Submit.

View Results of the Forward Transaction in Issue Viewer

You can view the results of

the

a forward transaction using Reference Data Center or the Issue Viewer tool. The example below in Issue Viewer shows a separate security for each leg of the forward.

Image Removed
Issue Viewer query results show separate security for each leg of forwardImage Added

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.

Image Removed
Position Viewer Cost object Open Lots tab shows sale of GBPImage Added

The other leg shows the buy of the USD.

Image Removed
Position Viewer Cost object Open Lots tab shows buy of USDImage Added

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

Image Removed
Cash Journal Report exampleImage Added

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.

Image Removed
Position Viewer Cost object Open Lots tab shows both legs brought to zeroImage Added

Add a Forward Security Master Record

The Forward Security Exists field on the Create/Edit Entity panel and Create Master Fund 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

You can use Reference Data Center to add the forward security master record

using the Issue Viewer tool:
  1. In Accounting Center, in the left navigation pane, click SetupSecurities > Manage Securities > Issue Viewer.
    You see the Issues Query window.
  2. From the Add button on the toolbar, select Derivatives and then click Forward Contract.
    You see the Forward Contract panel.
  3. Complete the fields on the Forward Contract panel.
    Image Removed
    Image Removed
  4. Click Submit.

. Or you can use Issue Viewer to add the forward security master record

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. In Accounting Center, in the left navigation pane, click Transactions > Trades Book Trade/Rebook Trade > Book Trade. 
    You see the Book Trade workspace.

  2. Complete the options in the Search Details pane and click Search.
    Search for the forward security as you would for any other type of security. You see the search results based on the criteria you selected.
    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
  1. because. In this example, the security master

example above,
  1. CAD was set up as the Sell Currency and USD was set up as the Buy Currency.


Image Removed
  1. Right-click the security row

and select 
  1. , click Book Foreign Exchange

/
  1. , and then click Sell Currency – Forward Contract.

Image Removed
  1. You see the Forward Contract panel.

  2. Complete the options 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
  1. .

Image Removed
  1. 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.

Image Removed
Position Viewer Cost object Open Lots tab for completed forward transactionImage Added