Query Position Data for One Portfolio

To query position data for one portfolio:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Position Viewer in the Start Search text box.
  3. Click the Position Viewer (Accounting Center) link to access the Position Viewer.
    You see the Query Positions window. The Query Based On field displays One Portfolio by default. 
     
  4. Complete the options on the Query Positions window. See the Query Positions Window Options - Query Based on One Portfolio section.
  5. Click Search.

Query Positions Window Options - Query Based on One Portfolio

The following are the options for a query based on one portfolio in Position Viewer:

  • Query Based On. Determines the scope of position data to return. One Portfolio is displayed by default. Returns position data based on a single account.
  • Entity Name. Specifies the unique account description for the entity to query.
  • Entity ID. Specifies the unique account identifier for the entity to query. This is the primary key to the Entity table.
  • Src Name. Specifies the name of the interface source. You can accept the default based on the Entity Name and Entity ID field values.
  • Cash Balance. Specifies the cash balance as of date. Available options include:
    –  Settlement Date. Returns cash balances as of the settlement date.
    –  Trade Date. Returns cash balances as of the trade date.
  • Position Type. Allows you to view position information for the current day or as of a point in time. Available options include:
    –  Current. Allows you to view all positions as of the current day.
    –  As Of. Allows you to view positions for a specified date. When using this option, select a date and select As Of Summary.
  • Account Basis. Specifies the accounting basis used by the entity. If there are multiple bases, select a basis from the drop down list.
  • Base Currency. Displays the currency that the entity uses for accounting purposes.
  • Cash Balance Date Type. Indicates the date type of cash balance record you want to view. Options include:
    –  Posting date (Default)
    –  Trade date
    –  Accounting date
    –  Contractual settlement date
    –  Month end date
  • Display Zero Cash Balance. Indicates whether to include zero cash balances. A zero cash balance is a valid balance. Options include:
    –  Yes. Default. The results include zero cash balance records for the specified cash position and asset currency.
    –  No. The results exclude zero cash balances.
  • Rejection/Corporate Actions Begin Date. Specifies the begin date for which you want to view rejection and corporate action activity. If you specify a range, you exclude activity that occurred outside this date range from the Rejections and Corporate Action detail tabs in the Cost object.
  • Rejection/Corporate Actions End Date. Specifies the end date for which you want to view rejection and corporate action activity.
  • Trade Activity Start Date. Specifies the begin date for which you want to view trade activity. If you specify a range, you exclude trade activity that occurred outside this date range from the Trade Activity detail tab in the Cost object.
  • Trade Activity End Date. Specifies the end date for which you want to view trade activity.
  • Include Zero Holdings. Determines whether zero holdings appear in the query result. Available options include:
    –  No. Do not include these holdings in the query result.
    –  Yes. Include these holdings in the query result.
  • Select Date Range for Income History Query. Indicates whether to enter a date range to view income activity. If you specify a range, you exclude income activity that occurred outside this date range from the Income object.
  • Income Report Start Date. Specifies the begin date to view income activity. Displayed when you select Yes in the Select Date Range for Income History Query field.
  • Income Report End Date. Specifies the end date to view income activity. Displayed when you select Yes in the Select Date Range for Income History Query field.
  • Max Items Composite. Specifies the maximum number of rows of data to return.
  • Page Rows. Specifies the number of rows to return on the Query Result window, up to the maximum specified in the Max Items Composite field.
  • Search. Executes the query based on the current query parameters. Returns data from the database in the Query Result view.
  • Resubmit. Resubmits a query after you change some query parameters.
  • Cancel. Stops the query that is currently executing.
  • Clear Query. Clears the current query criteria from the query fields. This button is located both in the main toolbar and halfway down the right side.
  • AutoSave Requests. Automatically saves queries for future use as you execute them.
  • Save Query. Saves a query for use in future sessions of Position Viewer.
  • Save as Default Query. Saves a query as the default query. The default query automatically runs each time you open Position Viewer.
  • Delete. Permanently deletes the selected query.
  • Clear. Permanently deletes all queries from the Position Viewer query list for your user ID. This includes the default query, which will no longer be available when you access Position Viewer.
  • Properties. Opens the Query Properties dialog box where you can review the query parameters and enter a custom caption for the query.