Morningstar Spotlight
In Practice

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.

Subscribe

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
Research Insights
The Predictive Power of Fees

Lower-cost funds generally have a greater chance of outperforming their more expensive peers. In this article, we provide evidence to show the predictive power of fees across most categories.
Read | 8 min read
The Big Picture
A huge week for markets

Trade is one of the few areas in which a president can make sweeping changes without congressional approval, but at this stage, we think the tariff proposals look more like pre-election bluster.
Read | 6 min read
Investing basics
Investors can’t ignore this predictor of managed fund returns

Fund managers often get bashed for failing to beat their index over long periods of time. This might be a key indicator of the returns investors can expect.
Read | 6 min read
Investing Trends
Which asset classes are a bargain now?
Periodically, I give an update on the valuations of key asset classes and how they compare. ....
Read | 8 min read
Back to top
Subscribe