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 firstname.lastname@example.org if you have any questions.
Click to jump to each Expert Tip:
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”.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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: