With dozens of available metrics to choose from, this lesson shows the user how to access and customize reports across different time periods. Learn how to measure your portfolio performance against that of the S&P 500 index as we walk through both the report and benchmark creation process.
Here are some important concepts:
One is Report Types, there are two different types of PortfolioAnalyst reports:
The Snapshot is a one-page report that displays graphs and charts representing an account’s
return, Net Asset Value (NAV), asset allocation and distribution of returns.
A Detailed report is a more comprehensive PDF report that can include multiple individual
reports, including the Performance Attribution vs. the S&P 500 index which displays
contribution to return, allocation and selection effects.
Next, PortfolioAnalyst gives you a choice of two different performances:
- Time Weighted Return, or TWR – the percent return produced by your portfolio over time
independent of cash contributions or withdrawals
- Money Weighted Return, or MWR – the percent return produced by your portfolio over time influenced by the timing of cash contributions and withdrawals
It’s often important to compare your portfolio’s performance to an appropriate benchmark.
Choose from among 175 popular industry benchmarks, or you can even create custom
benchmarks and select them when creating Snapshot and Detailed reports.
Log in to Account Management, choose Reports and click on PortfolioAnalyst.
Locate the Reports area to the right of the screen. This area contains the set of Preconfigured reports
we discussed in an earlier lesson and any that you choose to build for yourself. Run reports by clicking
on the blue arrow icon to the right. To start creating a new report, click the Configuration gear icon in
the Reports field.
In the Custom Reports section, click on any of the existing reports to view their construct. Let’s build a
new Custom Report – Click the plus icon in the Reports area. Enter a name for your new report.
Next, choose your time period from the list of available time periods. Analysis results include data
available from January 2009 to the present. For this example, let’s select DAILY and pick a starting and
ending date. Select between Detailed and Snapshot for your report. For now I will select Detailed. Select
the type of report, which can be either PDF or CSV.
Now select your Performance Measure. I will choose Time Weighted Return. Decide whether to display
the account number or alias to appear on your report by clicking the Yes/No slider.
If you select Snapshot from the Report type dropdown menu, the Select Benchmarks section appears.
Start typing to see index selections appear. Click the green Add Benchmark button to move them to your
Click Continue to review your created report and click Create below. It will appear in the list of saved
You’ll see the report – click the run icon to run the report.
Here’s a sample Snapshot report. It’s a simple one-page summary of your portfolio’s performance in a
specific time period.
Next, let’s create a Detailed report. Click the Configure gear icon from the Reports area. Click the plus
icon to create a fresh report. Enter a name.
Now select a time period. Let’s select Quarterly and pick a starting and ending quarter.
Select the Detailed report type.
Select the output format for your report – CSV or PDF.
Choose a Performance Measure. I will leave the selection as Time Weighted return. Optionally you can
include a cover page and table of contents.
Select from the Report Pages as many choices as you like. If you select Historical Benchmark Comparison
the Benchmarks for Comparison field will appear below. Simply type the first few letters of the
benchmark you’re looking for, or symbol and the list jumps to the matching benchmark. I am going to
type in SPX and include that.
Review the available Report Pages items and simply click to include it in the report.
Here you may include Performance by Asset Class or Performance by Symbol. Users can choose
Projected Income to forecast dividend and bond yield payments ahead. Time period performance
statistics are also available and users may also include performance attribution versus the S&P 500 index
or performance by sector or by long and short positions.
A comprehensive description table is available in the PortfolioAnalyst user guide.
Click the Continue button when you have made your selections and chosen any required benchmarks.
Review the content of the newly created report and when ready, click the Create button below. Now
you’ll see that detailed report listed in your saved reports. Click the blue arrow icon to run it.
Here is an example of a Detailed report.
Finally, you can create your own custom benchmarks in PortfolioAnalyst.
This area is below the Custom Reports area. Any previously created benchmarks are listed here. To
create a new index, click the plus icon. Enter a name and abbreviation.
Select the first benchmark you would like to include, and then click Add Benchmark. You can type the
first few characters of the desired benchmark in the entry box above the list of benchmarks or type the
abbreviation of the desired benchmark. You can select multiple standard benchmarks at a time and add
them all at once to your custom benchmark.
When you have finished adding benchmarks, enter the weight of each benchmark in the field provided.
All benchmark weights must equal 100.
When you’re finished, click save. You will see the Custom Benchmark in the Custom reports listing. It will
also be available whenever you are selecting Benchmarks during report creation. Use the view icon to
display the composition of a selected benchmark and use the Edit button to change its construct. Delete
unwanted Custom Benchmarks from the list by clicking the X icon.
Disclosure: Interactive Brokers
The analysis in this material is provided for information only and is not and should not be construed as an offer to sell or the solicitation of an offer to buy any security. To the extent that this material discusses general market activity, industry or sector trends or other broad-based economic or political conditions, it should not be construed as research or investment advice. To the extent that it includes references to specific securities, commodities, currencies, or other instruments, those references do not constitute a recommendation by IBKR to buy, sell or hold such investments. This material does not and is not intended to take into account the particular financial conditions, investment objectives or requirements of individual customers. Before acting on this material, you should consider whether it is suitable for your particular circumstances and, as necessary, seek professional advice.
Supporting documentation for any claims and statistical information will be provided upon request.
Any stock, options or futures symbols displayed are for illustrative purposes only and are not intended to portray recommendations.