Vision Upload Format: AccountCompare

Vision Portfolio Management Application Layer: Application

| Headstart Applications

Application: AccountCompare
 

Summary:

The AccountCompare application is used to compare the holdings in a base account with one or more other accounts based on a user-specified grouping criteria. The percentage held by group is displayed in the summary version of this report. A detail option allows you see the individual holdings for a specific group or for all groups. Only equity holdings are included.

Inputs:

Position Form Id Description 
id  Id of the base account 
ids  Ids of one or more accounts to compare 
group  Grouping criteria (from menu) 
groupEntry  Override for group value (from input) 
Specific group to display 
details  Indicates if all details should be displayed 

Analysis:

  • The id must reference an existing Account instance. The ids must contain a comma-separated string of account ids.
  • If no ids are supplied and the base account refers to a CompositeAccount, the base account will be compared to each of its component accounts. If no ids are supplied and the base account refers to an AggAccount, the base account will be compared to each of its component portfolios.
  • If parameter 3 or the group field is supplied, it specifies the grouping criteria. If the groupEntry field is also supplied, it will be used as the criteria. The default grouping criteria is security company sector.
  • If parameter 4 is supplied, it indicates that details should be displayed for this group. If the details field contains the string Detail, details will be displayed for all groups.
  • The basic report displays groups as rows and accounts as columns. The percentage held by each group/account combination is displayed. If a specific group or "all" details is requested, the actual securities held in the group are also displayed.

Key Data Feeds:

Related Reports:

Sample Usage:

     Interface ApplicationWS runWith: "AccountCompare",
              "102", "003", "security company sector" ;

Sample Input:

Change Account Comparison
Account:  VS:  Group By:  Level: 

Summary: Detail: 
Date:
Currency:

Sample Output:

    --- Account Comparison Report ---

    102 vs 003

    Data As Of: 1/15/1999


    Summary by [security company industry sector]
    Id Name 102 003
       Total Market Value     17,912,721     93,972,586
       Total Cash Value        145,480        913,314
       Number of Holdings        57        59
       Effective Date 1/13/1999 1/13/1999
           
    5500 Cash      0.00      0.00
    1300 Commercial/industrial services      2.26      3.06
    100 Consumer non-durables     14.04     13.36
    300 Consumer services      9.00      7.60
    1200 Energy      1.41      2.04
    800 Financial services      4.44      5.33
    600 Health technology/services     20.17     21.26
    900 Insurance services      2.11      2.13
    1000 Producers/manufacturing      4.09      5.52
    400 Retail trade      6.46      6.27
    500 Technology     32.35     30.25
    1100 Transportation      0.00      0.66
    700 Utilities      3.68      2.51