The following user guide is for Morningstar Direct users to be able to download their model portfolios that can be easily imported into Morningstar’s Portfolio X-ray tool on Adviser Research
Centre and AdviserLogic.

1) Ensure you have installed the Morningstar Excel Add-In. If not already downloaded, please go to Home module of Morningstar Direct, click Excel Add-In and click download latest
version. (as below)

Follow the Setup Wizard prompts in Excel.

2) To log in to the Morningstar Excel Add-In, create a connection with Morningstar Direct:

• In Excel, select the Morningstar tab.
• If Morningstar Add-In dialog box does not open: click Profile, then select Direct.
• If applicable, enter your login details for Morningstar Direct.
• For any further troubleshooting of accessing the Morningstar Add-In, please go to the Morningstar Excel Add-In user guide that is available in Downloads section. (as above image)

3) Ensure your model portfolios are saved via the Portfolio Management tool.

To create a spreadsheet of your model portfolio, open excel, click Morningstar and then the Investments icon.

4) In the navigation pane, under Portfolio Management tab, select Holdings.

• Change Object to Model Portfolio and select your Model Portfolio name under Accounts.
• Change Position ID to Ticker. Then click Add.
• Finally click Submit.

5) Your model portfolio will be displayed in the spreadsheet.

• Save your new spreadsheet as CSV.
• Delete the column “Name”. To leave Ticker and Weights only.
• You now have the complete model portfolio exported from Morningstar Direct that can be imported into Portfolio X-Ray.

6) Import your saved spreadsheet into Morningstar’s Portfolio X-ray tool.

The tool will automatically upload with the balances saved from the spreadsheet.

7) Bonus step:

Users of Adviser Research Centre can import the same spreadsheet into My Watchlists using the import feature. This will add the investments to the selected portfolio, or you can create a new watchlist and import to, providing easy access to the latest research reports for each asset.