When creating a new Activity Flex Query or Trade Confirmation Flex Query, you can now specify the date format, time format and date/separator. In the Date Configuration section of a Flex Query, the following options have been added:
Existing Flex Queries will use the default values.
You now have the option to display either your Account ID or your Account Alias on your Snapshot and Detailed PortfolioAnalyst reports. When you set up your report in PortfolioAnalyst, simply select Use Account Number or Use Account Alias.
Advisors who have created models in Trader Workstation can include model information in their Activity Flex Queries. In the Models section of the Activity Flex Query page in Account Management, select one of these options:
The Model field is also now available in all other sections in Activity Flex Queries.
A new section, Complex Position Summary, has been added to Activity Statements and Activity Flex Queries. The Complex Position Summary displays summary and detail information about the complex positions in your account in the period of the statement. This section is not included in consolidated statements. A complex position is a combination order with multiple legs. When setting up a Flex Query, The section is called Complex Positions on the Activity Flex Query setup screen in Account Management.
In Activity Statements, you can expand each complex position by clicking the plus (+) sign to display the details. The summary record is a summary of all positions included in the complex position. Detail records are the individual positions included in the complex position.
Beginning with this release, you can now save your Detailed Reports in CSV (comma-separated values) format. CSV-formatted reports are ideal for opening your PortfolioAnalyst reports in Microsoft Excel or similar programs. When you run a CSV-formatted Detailed Report, you will be prompted to save the file to your computer.
Beginning with this release, our Reporting Integration Tool, the reporting data feed from the IB generic reporting interface for clients who want to integrate that data with third-party software, has been updated with the following new fields in the Account File, beginning with Version 1.92:
For details about our Reporting Integration Tool, see the Reporting Integration Tool Developer's Guide.
In the Positions and Mark-to-Mark Profit and Loss section of the MTM Summary Statement, positions can be expanded to show buys and sells. Beginning with this release, if there are more than 10,000 trades, buys and sells are summarized by report date.
PortfolioAnalyst has been updated with the following enhancements:
For details about PortfolioAnalyst, see the Reporting Guide.
In addition to the new features described above, we have also added field descriptions for all PortfolioAnalyst reports to the Report Reference section of the Reporting Guide. Click here to to view this information.
Beginning with this release, you can now create your own custom benchmarks and then select those benchmarks for comparison in a Detailed report. Custom benchmarks allow you to combine existing benchmarks already available in PortfolioAnalyst, the combined weight of which must equal 100%. When you select benchmarks for a specific benchmark comparison report, you can choose up to three existing benchmarks including any of your own custom benchmarks.
For details, see the Reporting Guide.
This section will display the tax amounts withheld from dividends and tax withheld conversions (for example, if the dividend is paid in USD, IB will convert that amount into EUR for the broker) from broker clients. Currently, this section is enabled only for brokers in Portugal. For details, see the Reporting Guide.
We've added a new field, Type, to the Corporate Actions section in Activity Flex Queries. This field contains a two-letter code that indicates the type of corporate action. For details, see the Reporting Guide.
We've updated the format in which prices are displayed in Activity Statements. Prices will now be displayed with a minimum of four decimal places to a maximum of seven decimal places. Sections that display price include Trades and Open Positions.
Institutional account Master users (Advisor Masters, Broker Masters, Fund Investment Managers and Proprietary Trading Group Masters) can create and save synopses, which are text-based cover letters, and then assign them to PortfolioAnalyst reports. Beginning with this release, you now create, save, edit or delete Synopses from the Synopses tab, and you can access this tab from the PortfolioAnalyst main screen. Previously, you could only access the Synopses tab from the report creation screen.
Models provide an efficient method for advisors to manage multiple trading strategies for their clients without requiring them to open multiple accounts. Client investments are allocated among instruments in the Model based on the Model's allocation ratios as defined by the advisor. Advisors, Money Managers and Advisor clients can view Model Statements in Account Management on the Models page, provided models have been created in Trader Workstation.
Beginning with this release, we've updated the Models page and our Model Statements with the following options:
For more information about the Models page, see Models in the Reporting Guide. This section of the Reporting Guide also includes a sample Model Statement and a sample Model Summary.
Beginning with this release, we've updated PortfolioAnalyst with the following enhancements:
The Reporting Guide has been updated with Commodity Regulatory Statement and Commodity Regulatory Margin Report samples and field descriptions. Use the following links to find this updated information in the Reporting Guide.
Beginning with this release, a new report, Allocation By Region, is available for Detailed PDF reports. The Allocation By Region report includes two color-coded pie charts and accompanying tables. One pie chart shows the percentage and amount of the portfolio’s positions allocated to assets in those regions. The second pie chart shows the five countries with the highest percentage and amount of position allocation to assets, plus Other, which represents your allocation in all other countries.
If you trade futures or futures options, you now have access to a new default Activity Statement, the Commodities Regulatory statement, and a new Margin report, the Commodities Regulatory Margin report. These reports break out domestic (US) and foreign cash/holdings for the Commodities segment of your account (required by the CME Group).
We've increased the online availability of Activity Statements, Trade Confirmation reports and Activity Flex Queries as follows:
You can now select the following dates for Activity Flex Queries and Trade Confirmation Flex Queries:
Beginning with this release, you can now select one of the following default statements when creating a customized statement:
You can use any one of these default statements as the basis for your own customized statement by selecting the statement from the Create New/Select to Edit drop-down list in the Customize Statements section of the Activity Statements page.
We've updated available fields in the Account Information section of Activity Flex Queries:
Beginning with this release, Advisors, Money Managers and Brokers and their account users with reporting access rights now have access to client-only consolidated and concatenated Activity Statements, Trade Confirmation Reports, Activity Flex Queries and Trade Confirmation Flex Queries.
These new options become available when you select your own Master account in the Account Selector.
We've updated Activity Statements and Activity Flex Queries with the following enhancements:
Beginning with this release, the P/L Markup Summary, our summary report for Advisors that displays client profit and loss (P/L) used to determine quarterly and annual performance fees paid to the Advisor, has been updated with a new column, High Water Mark Losses. This column shows the total amount of high water mark losses for the period of the report.
Beginning with this release, our Reporting Integration Tool, the reporting data feed from the IB generic reporting interface for clients who want to integrate that data with third-party software, has been updated with the following new fields beginning with Version 1.9:
For detailed information, see the Reporting Integration Tool Developer's Guide.
Beginning with this release, the statement section Investments with Outside Hedge Funds, which displays investment information for accounts investing Hedge Funds as part of our Hedge Fund Investor Site, will be included in statements with any time period. Previously, this section was only available in monthly statements.
We have added the following enhancements to PortfolioAnalyst:.
Beginning with this release, Activity Statements have been updated to support Forex Mark-to-Market profit and loss. Forex MTM is available from January 2014 forward.
In addition, the following change has been made:
Beginning with this release, Activity Statements have been updated with the following changes::
We've made the following changes to Default Statements:
Beginning with this release, a new report, Breakdown of Accounts, is available for Detailed PDF reports. This report is only available to multi-account structures, including institutional accounts and account holders with multiple linked accounts, who have selected multiple accounts and the Consolidate option. Consolidated reports include a single set of data from all of the accounts that you have selected.
The Breakdown of Accounts report shows the Beginning and Ending NAV, Return, and the total amounts of Deposits, Withdrawals, Dividends, Interest and Fees for each selected account. This new report is also included in the default consolidated PortfolioAnalyst reports.
Beginning with this release,the returns for indices selected as benchmarks now include dividends.
You can now configure columns for the Summary Analysis table, detailed tables, Outlier Analysis tables and Order Details table. Configurable columns lets you add and remove columns from any of the tables listed above by clicking the Configure Columns link located above and to the right of each table. Note that the Summary and detail tables share configured columns.
PortfolioAnalyst now allows Advisors, Money Managers, Brokers, Proprietary Trading Group STL Account Masters and users with multiple linked accounts to create consolidated Detailed reports. With multiple client accounts selected, a Consolidated check box appears. Click this check box to consolidate data from all selected accounts into a single set of data in your Detailed report. PortfolioAnalyst is accessible from the Reports menu in Account Management.
The following new default reports are also available:
Note that the Historical Performance and Historical Performance Benchmark Comparison reports are not available for consolidated reports.
On the Delivery Settings page for PortfolioAnalyst, Advisors, Money Managers, Brokers Proprietary Trading Group STL Account Masters and linked accounts can set their preferred delivery mode for consolidated default reports and their own saved consolidated reports with YTD and MTD time periods. Click Reports > Settings > Delivery > PortfolioAnalyst to access the Delivery Settings page for PortfolioAnalyst.
We have changed the way the Current Active Filters display works in the Transaction Cost Analysis, our dynamic and interactive analysis of trades marked to various benchmarks grouped in different categories or on a per-order basis. Transaction Cost Analysis lets you drill down to view more detailed data by instrument type and marketability by clicking different categories of data. The Current Active Filters display shows you which categories, or filters, are currently being used.
Beginning with this release, you can now remove any individual filter in any order at any time in by clicking an X icon next to a filter link in the Current Active Filters display. The report data refreshes to reflect the change in the Current Active Filters. We have also added a Remove All item to the Current Active Filter display, which when clicked returns your results to the original Summary Analysis table. To choose a different date range, you now click Change Date Range (next to the Print link) in the upper right corner of the page.
Previously, you could not remove filters in any order and there were no X icons.
The Default Summary has been renamed to Multi-Account Summary and redesigned to be consistent with our other default statements. The Multi-Account Summary is only available for customers with linked accounts or multiple account structures.
The new Multi-Account Summary contains the following sections: