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:
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.
5) Your model portfolio will be displayed in the spreadsheet.
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.
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.
