Investment Reports Overview

For Selection Reports, click on the Selection Reports Button in the Sidebar. For Performance Reports, first open the Investment Menu in the Sidebar. Then click on the arrow next to Reports, and select either Performance or Multi Period Performance.

Investment Reports Overview

There are two main areas of Investment Reports in Advisors Assistant - Selection Reports and Performance Reports.

The Selection Reports allow you to search your database for clients or investments that meet a specific set of criteria that you define. Then once you have found the list of clients or investments, you can print a variety of statement style reports, lists, graphs, and blotters. Additional information about using the Advisors Assistant Selection Reports is available in the Reports Chapter of the Help. These reports do not include performance.

The Performance Reports will print rates of return for the time periods that you specify in the report criteria. You can run performance reports for a single time period, or select the Multi Period Performance Reports. To print performance reports, first open the Investment Menu in the Sidebar. Then click on the arrow next to Reports, and select either Performance or Multi Period Performance.

The Securities Reports are designed to provide you with important information that is in the Security Record, such as Symbol, CUSIP, etc.

Three types of performance calculations are performed by Advisors Assistant. Click on the links below for more information on each method.

1.Time Weighted Performance
2.Dollar Weighted Performance
3.Percentage Gain or Return On Investment. This is also known as Return on Investment (ROI.)

Multi-Period Performance Reports

Multi-period Reports allow you to choose up to 4 periods in which to measure the returns.  All of the methods described above are available on any one report.  The periods can overlap.

Beginning of Day (BOD) vs End of Day (EOD) Values

Generally Advisors Assistant is reporting market values at the end of the day.  However, there are, by necessity, situations when we must use beginning of day values.

Beginning Values And Performance Reports

Beginning of day values must be used for performance reports for the Beginning Value.  The reason is that transactions can take place during the day that will affect the rate of return for the asset.

Example #1:

Your client opens an account on March 1st and purchases 100 shares of Asset A that morning for $10 per share.  Asset A closes that day at $12 per share.  When measuring performance from March 1 to June 30, the beginning value for Asset A must be shown as $0.  If the report used $1,200, then EOD value, the gain of $200 would not be taken into account.

Example #2

If you measure one month's performance, from March 1 to March 31, you cannot ignore what happened to the assets on March 1.  If you used the EOD value for March 1, you would not be measuring the entire month.

The BOD share price is actually the EOD share price for the previous business day.

Initializing Values

When you initialize values, you should enter the value based on the first reporting period you want to use.  If your first reporting period will be from March 1 to December 31, enter the initial value for the close of the day before.  Initialize the investment as of February 28 and use the EOD value.

Current Client Reports

If you need to print a quick statement or graph for the client you're currently viewing, just click the Current Client Report Button in the Sidebar, and the client data as well as all of their investments will be selected. You'll then have full access to all of the Selection Reports to choose your report format.

Indexes

We will generally use the word indexes vs indices.  You can place up to 4 indexes on any one performance report.  Indexes can be maintained in two ways:

Maintaining Index Values

When index values are written to Advisors Assistant, the percentage gains for those indexes are automatically calculated by Advisors Assistant and stored in your database.  You can update indexes by:

1.Click on Securities / Indexes | Indexes | Manually Update Values.  You can then select the index and enter the values one date at a time.  As you enter each value, the system will look back 30 days, 90 days, to the first business day of the calendar year, 1 full year, 3, 5, and 10 years and calculate the percentage gain.  This gain may or may not match published numbers, but will be very close.
 
Some indexes include dividends and some do not.  If you are comparing your index with a published index, be sure you are comparing equal indexes.
2.Click on Securities / Indexes | Retrieve Data From Sungard.  This is an optional service which is sold on a monthly subscription (3 months minimum.)  This service will allow you to retrieve data as far back as 10 years to be able to fill in the values.  This service is also covered by security, so you must have rights in Advisors Assistant to use the service.

See Also