Charts Worksheet

The Charts Worksheet provides analysis and direct comparison.  Select the portfolios to compare at the top of the worksheet.  The Portfolio 1 drop down menu offers either the optimal or investable portfolios on the Michaud Resampled Efficient Frontier™.  Use the Portfolio Control Slider to select the particular portfolio; the rank of the selected portfolio along the efficient frontier appears to the right.  (The rankings depend on the number of frontier portfolios you have set.)  Optionally, select another portfolio for contrast in the Portfolio 2 drop down menu and slider.  For reference portfolios, utilize the drop down menu that appears to select the specific reference portfolio.  The initial and benchmark portfolios are static.  Stored results and filtered portfolios can also be analyzed.

As soon as two portfolios are selected, the Charts Worksheet populates for the selected portfolio(s).  The risk, return, information ratio, and yield for the two selected portfolios populate the top of the worksheet.  The rebalance probability appears when applicable.  If non-normal resampling is enabled, the skewness and kurtosis appear there as well.  A table at the bottom of the worksheet compares the asset weights of the two selected portfolios, accompanied by an iteration of the assets' returns, standard deviations, standard errors, and information ratios.  If you used the basic tax optimization method, these numbers are tax-adjusted. If the Add Quadratic Risk Penalty to Risk option has been selected in the Display>>Charts Menu, standard deviations will be calculated to include the quadratic risk penalty. At the very bottom of the worksheet, a table splits the assets by group.  To the side of this table, the Asset Ranges Table indicates the significance of each asset allocation.  The Percentile Field similarly indicates significance.

Select the following charts from the Chart Type drop down menu:

• Portfolio Weights Comparison

  • Bar Graphs

  • Stack Chart (formerly the Portfolio Comparison Area)

  • Pie Chart

  • Doughnut Chart (formerly the Portfolio Allocations Chart)

• Portfolio Bounds Line Graph

• Efficient Frontier Chart

• Portfolios Composition Maps

• Rebalance Probability Chart

• Portfolio Risk Contribution Map and Bar Chart

• Simulated Proof Chart

You can edit all of these charts using Excel functionality.  To view the numbers used to produce the charts, access the Data Worksheets.