← Back

Expert Tips - August 1, 2019

Expert Tips: Model Portfolios

Expert Tips are designed to help you get the most out of your YCharts subscription. Hone your skills, practice new ones, or email hello@ycharts.com if you have any questions.

Click to jump to each Expert Tip:

Upload Portfolio Holdings from Excel

Export Model Portfolio Data

Customizable PDF Reports for Model Portfolios

Explain the Effects of Rebalancing

Portfolio Holdings Drift

Model Portfolio Drawdown

4 More Ways To Analyze Model Portfolios

Model Portfolio Watchlists

Model Portfolios – Edit Comparables

Comparing Model Portfolios

Model Portfolios

Tracking Error

________________________________________________________

 
 

Upload Portfolio Holdings from Excel

Create a Model Portfolio in seconds by uploading portfolio tickers and weights in a .csv or .xlsx file format. To get started, download the template to ensure the most seamless upload, or drag-and-drop any Excel file with two adjacent columns titled “Symbol” and “Target Weight”.

model portfolio csv upload

________________________________________________________

 

 

Export Model Portfolio Data

Just like any other security on YCharts, to export Model Portfolio data, click the “Data” tab then type-search for the valuation, performance, or risk metric you’re interested in. Click “Export” to download an Excel-friendly .csv file. The chart on the Data tab updates with each search for quick historic visualizations.

model portfolio data export

________________________________________________________

 

Customizable PDF Reports for Model Portfolios

Generate PDF reports, on-demand, from any Model Portfolio quote page. Reports can be customized with your firm’s logo and color scheme, plus 17 different modules that cover returns, performance, exposures, risk, composition, and holdings. Reach out to your Support Contact to get access and start building your own Custom PDF Reports.

model portfolios pdf reports
 

________________________________________________________

 

Explain the Effects of Rebalancing

Model Portfolios supports four rebalancing frequencies: Annually, Quarterly, Monthly, and Never. Show how rebalancing affects risk and returns by duplicating a portfolio then updating the rebalance frequency to “Never” and comparing the two in Fundamental Charts.

never rebal chart comparison
 

________________________________________________________

 

Portfolio Holdings Drift

The “Current Weight” and “Holding Drift” metrics show how your portfolio holdings have strayed from its target allocations. In Model Portfolios, Current Weight and Holding Drift are shown on both the Quote and Holdings pages. Current Weights will revert to your target allocations at the interval your Model Portfolio is set to rebalance.

 

portfolio drift
 

________________________________________________________

 

Model Portfolio Drawdown

Drawdown charts illustrate to clients how your model strategies have performed during periods of volatility. In Fundamental Charts, add your Model Portfolios as securities, then select “Percent Off High” under “Data Format” to compare and contrast drawdowns across your various model portfolios.

model portfolio drawdown
 

________________________________________________________

 

4 More Ways To Analyze Model Portfolios

From a Model Portfolios Watchlist, click “Options”, “View In”, then any of the following:

1. Fundamental Charts: Visually compare Model Portfolios performance over various time periods.

2. Comp Tables: Add Metric Sets to evaluate exposures, risk, performance, and more.

3. Timeseries Analysis: Compare portfolios across historical figures, format to your choosing, and export to Excel.

4. News: Access the latest news for every portfolio’s holdings.

MP in fun charts
 

________________________________________________________

 

Model Portfolio Watchlists

Monitor your Model Portfolios by adding them to your Dashboard. Click “+ Create a New Watchlist” then select the “Model Portfolio” option. Name your Watchlist then type-search for Model Portfolios you’ve created. Then click “Data” to further customize what metrics are shown.

MP watchlist 3
 

________________________________________________________

 

Model Portfolios – Edit Comparables

Navigate to a Model Portfolio’s “Performance” tab and click “Edit Comparables” to customize your portfolio’s comp set. Choose from benchmarks, indices, other Model Portfolios, or create a custom blended benchmark to track your strategy’s performance.

 

MP edit comps
 

________________________________________________________

 

Comparing Model Portfolios

Using Comp Tables, compare your Model Portfolios against benchmarks and each other across various metrics. Additionally, Model Portfolios are fully integrated with Fundamental Charts, your Dashboard, and Email Reports.

MP in comp tables

 

________________________________________________________

 

Model Portfolios

Leverage Model Portfolios to visualize portfolio analysis, share ideation with clients and prospects, and monitor portfolio performance on an ongoing basis. Compare models to benchmarks, macro indicators, and even other Model Portfolios.

model portfolios

 

________________________________________________________

 

Tracking Error

Many fund managers have an objective to duplicate the performance of a benchmark while others aim to outperform it. Utilize this metric to quickly grasp the effectiveness of a portfolio manager:

Tracking_Error

Stay up to date,
subscribe to the YCharts blog