BEST PRACTICES GUIDE
BNY Mellon Data and Analytics Solutions
Instrument Engineering Team
Last Update:
...
OVERVIEW
...
...
...
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
...
Required Fields
...
Field Name
...
Tag #
...
Issue Name
...
(RDC). The list below contains all fields required to configure a Physically Held Commodity security master file (SMF).
Issue Name (961)
Primary Asset ID Type
...
(1432)
Primary Asset ID
...
(14)
Processing Security Type
...
3931
...
Issue Country Code
...
1418
...
Asset Currency
...
85
...
Settlement Currency
...
63
...
Income Currency
...
(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)
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 the Supported Generic Interfaces guide for more information.
ACCOUNTING
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
...
- The market_value_income column on the Physically Held Commodity will capture the market value plus any accrued interest payable or receivable
Similar to other instruments, STAR to PACE creates data in position, position_detail, trade, and cash_activity tables.
OPERATIONAL REPORTING
Physically Held Commodities will appear on all core Eagle reports. The operational reports were specifically designed to support daily workflow. They are used to quickly identify differences and provide the necessary level of detail in order to resolve any discrepancies that may exist. The reports are primarily driven off of Data Management with data updated by the STAR to PACE Direct events. Eagle recommends following current best practices of using these core queries and building custom result profiles that fit your business needs.
INVESTMENT REPORTING
The STAR to PACE process moves position, cash activity, and trade data to PACE. This enables users to take advantage of all of the PACE OLAP reporting capabilities:
- Single/multi period lot, aggregate, and position reporting
- Trade activity reporting
- Cash activity reporting
- Exposure reporting with full analytics integration; some data must be augmented to achieve complete exposure reporting
...
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
| Include Page | ||||
|---|---|---|---|---|
|
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 for more information.