Open and Close Options Panel Options

The following are the options in the Open and Close Options panel, which you can use to book open/close trades for a future without variation margin. Note options may vary according to your selections. 

Option

Tag

Description

Option

Tag

Description

Entity Information

 

 

Entity ID

1163

Specifies the unique identifier of the entity.

Entity Name

1164

Specifies the name of the entity.

Base Currency

86

Displays the base currency of the entity.

Net Options Position

639

Indicates whether the position is processed in one net position. Options include:

  • Yes. The system nets the long and short positions into a single long position. You can only open and close the option long.

  • No. The system creates two separate long and short positions. You can open and close the option long or short.

Future Expense/Capitalize Flag

10705

Determines how the commissions and fees are treated. This field displays the value specified in the Expense & Capitalize Trans Costs for Opens & Closes field. for the trade's entity and accounting basis. If you did not specify a value at the accounting basis level, you can specify a value at the trade level. Valid options include:

  • Capital. Commissions and fees do not generate any cash movement and are rolled into cost for subsequent gain/loss calculations. Cost = (contracts * price) + commission + fees.

  • Expense. Commissions and fees are expensed, generating a cash disbursement. They are excluded from cost for subsequent gain/loss calculations. Cost = contracts * price.
    This field appears if you enter a trade for an option on a future where the security has the Premium Type field (tag 3302) set to Notional Cost and the Variation Margin field (tag 4533) set to No.

Issue Information

 

 

Trade Date

35

Specifies the effective date of the trade. The trade date cannot be greater than the post date, accounting date, or settlement date.

Accounting Date

36

Specifies the date the trade is reported and has an effect on the entity's holdings and cash balances. The accounting date must be greater than the trade date.

Monthly Accounting Date

4733

Displays the month end accounting date.

Settlement Date

37

Specifies the date the trade is settled.

Event Type

55

Specifies the business intent of the transaction.

Long/Short Indicator

15

Displays an L (long) or S (short) to indicate whether the position is long or short.

Cross Reference Type

1234

Specifies the cross reference type associated with the security.

Issue Name

961

Specifies the name of the security.

Ticker

13

Specifies the trade ticker of the security.

Cross Reference ID

1233

Specifies the cross reference identifier associated with the security.

Clearing Broker

1236

Specifies the name of the clearing broker, if different from the trade broker. When you book a trade for an entity that uses derivative segregation, you must specify the trade's clearing broker where available. If you use derivative segregation with cash segregation, the lookup shows clearing brokers associated with bank account relationships that have a relationship type of Entity & Clearing Broker Relationship. 

Clearing Broker Code

1237

Specifies the code for the clearing broker.

Instrument Type

11

Displays the instrument type.

Security Type

82

Displays the security type of the asset.

Issue Currency

85

Displays the local currency of the security.

Expiration Date

38

Displays the date on which the security matures.

Contract Size

19

Displays the amount of the underlying item covered by the contract.

Strike Price

67

Displays the price at which the option contract can be exercised. The call option buyer can buy the underlier or a put option buyer can sell the underlier.

Put/Call Flag

1350

Displays the type of option contract. For example, call or put.

Accounting Information

 

 

Position Contracts

122

Displays the current quantity of the position. The value in this field must be greater than zero.
This field appears for close trades.

Contracts

40

Specifies the current quantity of the trade. The value must be greater than zero.

Price Per Contract

45

Specifies the trade price per share. The value must be greater than zero.

Commission per Contract Local

971

Specifies the amount of the commission per trade in the local currency.

Commission Amount Local

47

Specifies the commission paid to the broker to execute the trade.

Tax Amount

46

Specifies the tax amount on the transaction.

SEC Fee

48

Specifies the SEC fee. The system calculates the SEC fee if certain criteria are met.

Stamp Duty Tax

51

Specifies the stamp duty amount on the transaction.

Other Fee

3752

Specifies any additional fees on the transaction.

Local Net Amount

50

Displays the net amount of the trade based on the following formula: Principal + Fees.

Settlement Currency

63

Displays the currency in which the security is settled.

Settlement Net Amount

64

Displays the actual settled amount of the trade. The value must be greater than zero.
If the trade's Settlement Currency field (tag 63) value differs from the security's asset currency displayed in the Issue Currency field (tag 85), you must specify the Settlement Net Amount field value.

Local to Base FX Rate

87

Displays the asset currency to portfolio base currency exchange rate. It is expressed as units of asset currency to one unit of portfolio base currency.

Base Net Amount

478

Displays the base amount of the trade. This amount is calculated based on the following formula: Local Net Amount / Local to Base FX Rate. The value must be greater than zero.

Lot Selection Method

27

Specifies the lot selection method the system uses to relieve (sell) lots of a security held by the entity. Options include:

  • First In First Out (FIFO). Lots acquired first are sold first. The oldest lot is sold first based on the holding date. If you set the accounting basis Cost Basis Covered Indicator field (tag 2818) to Y, unknown cost lots are relieved first. The oldest cost lot is sold first based on the holding date.

  • Last In First Out (LIFO). Lots acquired last are sold first. The most recent lot is sold first based on the holding date. If multiple lots share the same holding date, the lot with the greatest event sequence is relieved first. The event sequence, set internally by the system, indicates the processing order of transactions within the same position.

  • High Amortized Cost or High Cost (HCLOT). The lots with the highest current cost are sold first. The system uses current unit cost, which includes amortization for debt securities. This method relieves the lots that can generate the maximum loss or the minimal gain.

  • Low Amortized Cost or Low Cost (LCLOT). The lots with the lowest current cost are sold first. The system uses current unit cost, which includes amortization for debt securities. This method relieves the lots that can generate the minimal loss or the maximum gain.

  • High Original Cost (HORIG). The lots with the highest original cost are sold first. The system uses the original unit base cost of the open lots. It relieves the lots that can generate the maximum loss or the minimal gain.

  • Low Original Cost (LORIG). The lots with the lowest original cost are sold first. The system uses the original unit base cost of the open lots. It relieves the lots that can generate the minimal loss or the maximum gain.

  • Identified Lot (IDLOT). The specified lot or lots are sold first, which determines cost and tax implications. You can optimize this option to specific tax situations by selecting the specific lots to be sold.
    If you select this method, the lower pane in the panel displays lot details for each available lot, as determined by the entity's controlling basis. If no controlling basis exists, it displays lots for the primary basis. You must specify the quantity for one or more lots that you want to relieve. The total quantity you specify for the open lots must match the quantity entered for the total close.
    The close trade relieves the selected lots in each of the entity's accounting bases, and keeps the lot structures in sync. The system uses the lot's Orig Event ID field (tag 457) to match a single open lot in one basis to corresponding multiple open lots in another basis, as needed. This can occur for lots fractured as a result of wash sale processing.

  • Best Tax. The lots are selected and sold with the objective of taking losses first (short term then long term) and gains last (long term then short term). Lots are sold in the following order:

    1. Short term Losses. Lots that reflect a short term loss are sold first, beginning with lots that generate the greatest short term loss down to the least short term loss.

    2. Long term Losses. Lots that reflect a long term loss are sold, beginning with lots that generate the greatest long term loss down to the least long term loss.

    3. Short term No Gains or Losses. Short term lots that reflect no gain or loss.

    4. Long term No Gains or Losses. Long term lots that reflect no gain or loss.

    5. Long Term Gains. Lots that reflect a long term gain, beginning with lots that generate the least long term gain up to the greatest long term gain.

    6. Short Term Gains. Lots that reflect a short term gain, beginning with lots that generate the least short term gain up to the greatest short term gain.

  • Tax Advantage (TXADV). The lots with the lowest tax liability are sold first to minimize tax liability.

  • Versus Purchases (VSP). The lots are selected and sold based on lot purchase characteristics, such as the target purchase date and the target purchase price. This option must be specified at the trade level.

  • Pro Rata. The lots are selected and sold based on a proportionate allocation.

  • Tax Efficiency. The lots with the lowest tax liability are sold first to minimize tax liability. The system calculates the tax liability based on the manipulation of entity level tax factors for long and short term gains, long and short term losses, and currency gains. The system also incorporates the wash sale disallowance effect and considers the overall tax implications of closing each individual lot.

  • Modified FIFO (MFIFO). The open lots with the same original acquisition date (tag 216) as the close transaction are sold first, starting with the lots with the lowest unit cost local. If there are no open lots with the same acquisition date as the close transaction, or all same day lots have been sold, the oldest open lots are sold first based on the acquisition date. Within a single acquisition date, the lots with the lowest unit cost local are sold first.

Settlement Information

 

 

Auto Settle Trade Indicator

58

Indicates whether the system settles the trade, coupon, and miscellaneous income and expenses automatically. If the entity's Auto Settle Indicator field is set to Yes, as specified on the Create/Edit Entity or Create Master Fund panels, the system creates a settlement when the trade is processed. There is no trade to settle date gain/loss. This applies even if the settlement date is in the future. Eagle recommends that you set the Auto Settle Indicator field to No for the entity and trade panels. Options include:

  • Yes. The system automatically settles the trade, coupon, and miscellaneous income and expenses. The system retrieves the settle date FX rate if the local currency does not equal base and generates a trade to settle date gain/loss.

  • No. Default. The system does not automatically settle the trade, coupon, and miscellaneous income and expenses. You must schedule the settlement for these transactions using the Run Contract Cash global panel. Or, manually settle the transactions using the Run Multiple Settlements panel. If you use cash segregation based on actual cash settlements, you can schedule settlements using the Run Cash Auto Match panel and create settlements manually using Cash Matching. 

Broker

1235

Specifies the name of the primary broker.

Broker Code

88

Specifies the code that represents the broker.

Custodian Bank

1146

Specifies the name of the custodian bank responsible for the trade. If the trade applies to an entity where you use derivative segregation and cash segregation, the custodian fields do not appear.

NOTE: You must establish a relationship between the custodian bank and your entity prior to booking the trade.

Custodian Bank Code

1240

Specifies the code of the custodian bank.

Custody Bank Acct Number

1660

Specifies the custodian bank primary account number.

Custody Bank Subacct

1661

Displays the custodian bank subaccount number.

Exchange Name

2291

Specifies the marketplace in which the security is traded.

Exchange Code

17

Specifies the code of the marketplace in which the security is traded. It is also used with global tax withholding and tax reclaim processing.

Settle Instructions 1

1897

Allows you to add settlement notes.

Settle Instructions 2

1898

Allows you to add settlement notes.

Settle Instructions 3

1899

Allows you to add settlement notes.

Settle Instructions 4

1900

Allows you to add settlement notes.

Settle Location

43

Specifies the location in which the trade is settled.

Other Information

 

 

Derivative Elections

56

Specifies the type of derivative. Options include:

  • Hedging Effective

  • Hedging Other

  • Income Generation

  • Replication

  • Other

Trade Ticket Number

761

Contains the trade ticket identification number. The system uses it during processing. For example, IDLOT close or cancel events use this number to locate an open lot.

Pending Trade Flag

3695

Specifies whether the trade is eligible for pending trade processing prior to processing by the STAR accounting engine. If you use pending trade processing, the system can assign this value to incoming transactions that meet pending trade rule detail criteria. Or an incoming transaction can include this value. This field is hidden. Options include Y and N.

Pending Trade Status

3720

Specifies the trade's transaction status for pending trade processing prior to processing by the STAR accounting engine. If you use pending trade processing, the system can assign a value of Pending to incoming transactions that meet pending trade rule detail criteria. Or an incoming transaction can include a value of Pending or a custom pending transaction status value defined in the PEND_TRD_STATUS code category. The default status is Pending if no status is provided. This field is hidden.

Holding Term

9091

Specifies the holding term for the trade based on the number of days between the original acquisition date (tag 216) and the maturity date (tag 35) on the lot. If you use ledger reporting based on ledger granularity rules to break out accounts by holding term, the system uses this value to identify the holding term for trades related to bonds and preferred stocks. Eagle Accounting's core transaction processing calculates the holding term for you, but you can manually override the value displayed in this field. Eagle Insurance clients that use ledger granularity rules have the system calculate the holding term based on the schedule associated with a lot. Options include:

  • Short Term. Identifies a short term holding. If the Holding Term Method field (tag 11479) in the trade's accounting basis has a value of 90 days, a short term holding term is 91 days to a year. If the Holding Term Method field has a value of 3 months, a short term holding term is 3 full months to a year.

  • Cash Equivalent. Identifies a cash equivalent holding. If the Holding Term Method field (tag 11479) in the trade's accounting basis has a value of 90 days, a cash equivalent holding term is 90 days or less. If the Holding Term Method field has a value of 3 months, a cash equivalent holding term is 3 full months or less.

Regulatory Intent

8915

If you now hold the trade in an entity/accounting basis with the new International Financial Reporting Standards (IFRS) regulatory category of Fair Value Profit Loss (FVPL) but previously held the trade in an entity/accounting basis with the old regulatory category of Fair Value Option (FVO) or Held for Trading (HFT), you can identify the old regulatory category specified for the trade at the entity/accounting basis level. You can specify a value for reporting purposes only. Options include:

  • Fair Value Option. Indicates the trade was previously held in a regulatory category of Fair Value Option, used for instruments managed on a fair value basis.

  • Held for Trading. Indicates the trade was previously held in a regulatory category of Held for Trading, used for instruments held with the intent of selling them.

User Defined Priority

2862

Specifies the user generated number that determines the event sub priority. That is, after the system accounts for the event sequence and corporate action sequence.

Order Number

1092

Specifies the order number of the transaction. This can be the same for multiple lots.

Â