User Guide: Model Portfolio downloads from Morningstar Direct into Morningstar Portfolio X-ray tool.

Morningstar Team  |   26th May 2022  |   3 min read

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.

Empower your clients' success with access to Morningstar's trusted research, ratings & tools

Organise a time to speak to our team about Morningstar's range of adviser solutions

By clicking Submit, you agree to Morningstar’s Privacy Policy.

You might also like