Query Position Data for All Portfolios

Owned by Tom Fahey (Unlicensed)
Last updated: Jul 27, 2016 by Former user (Deleted)
4 min read

To query position data for all portfolios:

  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. 
     
  4. From the Query Based On field, select All Portfolios.
  5. Complete the options on the Query Positions window. See the Query Positions Window Options - Query Based On All Portfolios section.
  6. Click Search.

Query Positions Window Options - Query Based on All Portfolios

The following are the options for a query based on all portfolios in Position Viewer:

  • Query Based On. Determines the scope of position data to return. Select One Portfolio - One Security to view a single position for a fund.
  • Src name. Specifies the name of the interface source. You can accept the default based on the Entity Name and Entity ID.
  • As of Start Date. Specifies the As Of start date.
  • Bypass Cost Recalculation. Indicates whether to bypass cost recalculation. Available options include Yes and No.
  • Issue: Query Based On. Determines the type of security identifier you use in the query. Available options include:
    –  Issue Name. Descriptive name of the security.
    –  Primary Asset ID. Primary industry standard identifier such as CUSIP and ISIN.
    –  Xref ID. Security cross reference.
  • Issue Name. Specifies the name of the security. This field appears if the query is based on issue name.
  • Primary Asset ID. Specifies the primary industry standard identifier, such as CUSIP and ISIN. This field appears if the query is based on primary asset ID.
  • Xref Type. Specifies the cross reference security type, such as SEDOL, CUSIP, and so on. This field appears if the query is based on security cross reference.
  • Xref ID. Specifies the cross reference security identifier. This field appears if the query is based on security cross reference.
  • Asset ID. Specifies the unique Eagle security identifier assigned by the system.
  • DB Partition. Specifies the database partition to query. The default is 1 (ESTAR). You can add additional values if your environment uses partitioning.
  • 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 Balances. 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 you want 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 console, 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.