Within the Definition Master, there is a Security Mappings section. This shows you all user-defined securities that have come in to Morningstar Office, either through the import or manual entry. In this section, you have the ability to map these user-defined securities to a Morningstar tracked security.
Click on Tools, Edit Definition Master, Security Mappings.
Scroll to the right until you find the Morningstar Security Name column. If this column is blank, the security has not been mapped to a Morningstar tracked security. If there is name in this column, the security has been mapped to a Morningstar tracked security.
Find the Use As Substitute column. If this column says No, you are still displaying the user-defined version of the security in your accounts. If this column says Yes, you are displaying the Morningstar tracked security in your accounts. (See below for more information on how the Use As Substitute column works)
Advantages of using a user-defined security
Customize the Security Name/Description
Customize the information on a security, which will pull through to reports
When you would use a user-defined security
If there is not a Morningstar security match
The information in the Morningstar tracked security does not match what your custodian uses
Advantages of having the User-defined security mapped to a Morningstar tracked security with Use As Substitute set to No
Gives you the ability to customize the security name/description
Access to Morningstar information for reports
Access to Morningstar Analytical reports
Access to Morningstar prices
When you would want the user-defined security mapped to a Morningstar tracked security with Use As Substitute set to No
If there is not a Morningstar tracked security with the same CUSIP/ticker, but there is a Morningstar tracked security to represent the user-defined security
If you want the name/CUSIP/ticker to display as the user-defined security on reports to match Custodian reports
How to map a user-defined security to a Morningstar tracked security with Use As Substitute set to No
This is a global change and will affect all accounts with this security. If you are not comfortable completing this action on your own, please call support at 1-866-215-2503.
Go to Tools, Edit Definition Master, Security Mappings.
Locate the security you want to map.
Scroll to the right to the Morningstar Ticker column.
Click on the magnifying glass and search for the Morningstar tracked security. Click OK.
Make sure the Use as Substitute column is set to No and then click Save.
Advantages of having the User-defined Security mapped to a Morningstar Security with Use As Substitute set to Yes
Note: Click here for instances when the use as substitute should never be set to Yes.
Security in your account is the Morningstar tracked security
Security displays with the Morningstar security name and ticker
Access to Morningstar information for reports
Access to Morningstar Analytical reports
Access to Morningstar prices
When you want the user-defined security mapped to a Morningstar tracked security with the Use As Substitute set to Yes
Note: Click here for instances when the use as substitute should never be set to Yes.
When there is a good Morningstar tracked security match
When you want the Morningstar security to display on reports
When you would rather your clients see the mainstream ticker on reports over the Custodian’s internal ticker
Example: Schwab uses internal tickers for some of their funds.
User-defined: COLUMBIA INTERMEDIATE BOND FD CL Z (SRB1Z)
Morningstar: Columbia Intermediate Bond Z (SRBFX)
How to map a user-defined security to a Morningstar tracked security with Use As Substitute set to Yes
Note: Click here for instances when the use as substitute should never be set to Yes.
This is a global change and will affect all accounts with this security. If you are not comfortable completing this action on your own, please call support at 1-866-215-2503.
Go to Tools, Edit Definition Master, Security Mappings.
Locate the security you want to map.
Scroll to the right to the Morningstar Ticker column.
Click on the magnifying glass and search for the Morningstar tracked security. Click OK.
Set the Use as Substitute column to Yes.
Click OK to the message that pops up confirming that you want to replace the security.
Click Save.
When the Use as Substitute should never be set to Yes
Note: The Use as Substitute should never be set to Yes with no Morningstar tracked security listed. If you see a failed reconciliation item that has a blank security name/ticker/CUSIP, you will want to check the security mapping for this case.
Note: You should never have Variable Annuities from DST mapped to a Morningstar tracked Security with the Use as Substitute set to Yes. This can cause issues with pricing.
See Also