The Trade Table Query allows you to research trades processed by STAR to PACE Direct based on data stored in the TRADE and TRADE_DETAILS tables in the TRADES database in Eagle PACE. For information about special logic used by STAR to PACE Direct when processing forward contracts, see About Deriving Trade Fields for Forwards.
To view trades in Eagle PACE:
- In Accounting Center, in the left navigation pane, click Reports > System Queries > STAR to PACE Direct > Trade Table Query.
You see the Trade Table Query panel. - Complete the options on the Trade Table Query panel.
- Under Result Options, in the Format area, click Grid or Advanced Report for the report view you want.
- In the Location area, click Show results after submit. Or, you can click Send results to Scheduler for optimum performance when submitting ad hoc reports that involve a significant amount of data.
- Click Submit.
The report appears on your desktop for the view selected.
Trade Table Query Panel Options
The following table lists the fields and field descriptions for the Trade Table Query panel.
Option | Description |
|---|---|
Optional Parameters | |
Query Based On | Allows you to qualify your query result. Options include:
|
Entity ID | Specifies the entity identifier for a portfolio, sector portfolio, composite portfolio, or Master Fund. |
Entity Name | Specifies the entity by the name of the entity. |
Entity Type | Displays the entity type. |
Event Type | Displays the event type value TRD_QUERY. |
Start Date | Specifies the start date for your query results. The default is today's date. |
End Date | Specifies the end date for your query results. The default is today's date. |
Search Criteria | |
Source Name | Specifies the source to use for qualifying the query. |
Date type | Specifies the type of date to use for qualifying the query. Options include:
|
0 Comments