Back Home > Advisor View > Data Dictionary > S > Report Settings: Show Accounts Holding/Not Holding Any/All of These Securities
|
Back |
Home > Advisor View > Data Dictionary > S > Report Settings: Show Accounts Holding/Not Holding Any/All of These Securities
|
Report Settings: Show Accounts Holding/Not Holding Any/All of These Securities
|
|
| Applies to: | ||
|---|---|---|
| ✔ Dynamic |
✔ Client Portal |
|
The Security Cross-Reference report is often used to help advisors plan for making a change in investment strategy. For example, if an advisor wants to switch the firm away from investing in one specific fund family, the advisor can find all the accounts holding that particular fund family using these filters. Then the advisor can contact the clients to notify them as appropriate.
This setting allows you to choose if you want Advisor View to show accounts within the group or account set that are holding or not holding any or all of the security you specify. This setting is used in conjunction with the Add Security button, which allows you to select which securities will be used for the designated filtering.
If you have a capital call coming up, you want to find all the accounts holding that specific alternative asset on that day so you can communicate with them about that corporate action. You can set the report to display only that security and which accounts hold it, allowing you to quickly find which clients to communicate with.
This setting is only available for dynamic reports.
If you choose any, Advisor View will return results for all accounts holding one or more of the securities you specify.
If you choose all, Advisor View will only return results for accounts holding all of the securities you specify.
| Setting | Report Output |
|---|---|
| Show accounts holding any of these securities: MSFT |
In this example, only one account in the Abbey Reporting Group holds MSFT. Only the MSFT holdings in that account is displayed, while the other holdings and accounts are filtered out. |
| Show accounts not holding any of these securities: MSFT |
In this example, only one account in the Abbey Reporting Group holds MSFT. That account is excluded. The remaining accounts are shown, but because the report is set to display information about MSFT holdings, only the column showing the total account value is shown. The other columns are not displayed because there is no data for them. |
| Show accounts holding all of these securities: MSFT, AMZN |
In this example, only one account in the Abbey Reporting Group holds both MSFT and AMZN. Only the MSFT and AMZN holdings in that account are displayed, while the other holdings and accounts are filtered out. |
The following setting interacts with this setting:
