Overview

The Eagle Suite provides rich functionality to model and process Physically Held Commodities such as precious metals (gold, silver, platinum). This document assumes that physically held commodities are valued and priced similarly to equities (in units of 1.00).

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.

Reference Data

Physically Held Commodities are modeled as equities in Accounting. Equity security master records can be created using Issue Viewer, Security Reference Manager, or Reference Data Center (RDC). The list below contains all fields required to configure a Physically Held Commodity security master file (SMF).

On this page

Issue Name (961)
Primary Asset ID Type (1432)
Primary Asset ID (14)
Processing Security Type (3931) = EQCSCS (Common stock)
Issue Country (1418)
Asset Currency (85)
Settlement Currency (63)
Income Currency (1186)
Issue Tax Type (668)
Primary Exchange (17)

Example Security Setup

Entity Setup

There are no special entity configurations required to trade Physically Held Commodities modeled as equities.

Trade Processing

Physically Held Commodity buy and sell trades can be processed manually using the Book Trade module. The only required fields for buy transactions are:

Shares (40)
Price Per Share (45)
Broker (88)

Accounting

Once a Physically Held Commodity position has been established follow all core Eagle accounting processes.

Valuation

Market Value = Units * Price * Price Multiplier * Quantity Scale

Reporting

STAR to PACE (S2P)

Almost all reports in Eagle Accounting 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 Physically Held Commodity in the POSITION, POSITION_DETAIL, TRADE, and CASH_ACTIVITY tables. The MARKET_VALUE_INCOME column captures the total market value.

Accounting Reports

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

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 has full functionality to calculate market value-based performance for Physically Held Commodities using data supplied by the S2P process. Risk and performance attribution features are available to analyze Fixed-to-Float Bond performance.

Automation

Eagle supports loading Physically Held Commodity SMFs and trades through standard Message Center streams. The SMF must be loaded prior to the trade (trades will not automatically spawn SMF records). Refer to https://eagledocs.atlassian.net/wiki/spaces/GENERICINTER/overview for more information.

Physically Held Commodities Best Practices