Vision Upload Format: AccountHoldings

Vision Portfolio Management Application Layer: Application

| Headstart Applications | 

Application: AccountHoldings

 

Summary:

The AccountHoldings application is used to display the holdings in an account as of a particular date.

Inputs:

Position Form Id Description 
1  id  Id of the account 
2  -  Global date override 
3  -  Sorting criteria 

Analysis:

  • The id must reference an existing Account instance.
  • If parameter 3 is supplied, it specifies the sorting criteria. By default, the report is sorted from highest total market value to lowest.
  • The basic report displays securities as rows and the following columns:
    • Security Id
    Security Name
    Shares held of Security
    Total market value of security
    Percent of account total market value

Key Data Feeds:

Related Reports:

Sample Usage:

     Interface ApplicationWS runWith: "AccountHoldings", "003" ;

Sample Input:

Enter Account: 
Date: 
Currency: 

Sample Output:

--- Holdings in Insyte Test 003 ---

Data As Of: 1/13/1999 --- Currency: United States Dollar

(sorted by totalMarketValue)
Code Security Name Shares Market Value % of Port
   Total for Account       93,972,586  
   Total Equity       93,059,272      99.03
   Total Fixed Income                0       0.00
   Total Cash          913,314       0.97
         
INTC INTEL CORP COM         36,800      5,115,200       5.44
DELL DELL COMPUTER CORP COM         58,800      4,663,575       4.96
AOL AMERICA ONLINE INC DEL COM         31,500      4,591,125       4.89
MSFT MICROSOFT CORP COM         28,100      4,041,131       4.30
SGP SCHERING PLOUGH CORP COM         72,700      3,716,788       3.96
ATI AIRTOUCH COMMUNICATNS COM         36,900      2,850,525       3.03
TYC TYCO INTL LTD NEW COM         39,200      2,812,600       2.99
FNM FEDERAL NATL MTG ASSN COM         38,800      2,735,400       2.91
LU LUCENT TECHNOLOGIES INC COM         26,000      2,710,500       2.88
UTX UNITED TECHNOLOGIES CORP COM         24,300      2,694,262       2.87
DH DAYTON HUDSON CORP COM         45,600      2,465,250       2.62
PG PROCTER & GAMBLE CO COM         28,000      2,464,000       2.62
AMGN AMGEN INC COM         21,400      2,332,600       2.48
CSCO CISCO SYS INC COM         22,450      2,152,394       2.29
WLP WELLPOINT HEALTH NETWORK NE COM         27,800      2,137,125       2.27
MRK MERCK & CO INC COM         13,700      2,019,038       2.15
MCK MCKESSON CORP NEW COM         22,600      1,923,825       2.05
HBOC HBO & CO COM         60,200      1,851,150       1.97
PEP PEPSICO INC COM         45,800      1,843,450       1.96
OAT QUAKER OATS CO COM         29,200      1,739,225       1.85
ALL ALLSTATE CORP COM         42,500      1,625,625       1.73
HON HONEYWELL INC COM         20,600      1,543,712       1.64
MO PHILIP MORRIS COS COM         28,200      1,528,088       1.63
VFC V F CORP COM         36,000      1,505,250       1.60
GE GENERAL ELEC CO COM         15,200      1,467,750       1.56
NYT NEW YORK TIMES CO CL A         41,000      1,342,750       1.43
T AT&T CORP COM         15,500      1,313,625       1.40
LLY LILLY ELI & CO COM         16,200      1,307,138       1.39
SLE SARA LEE CORP COM         49,600      1,286,500       1.37
GDT GUIDANT CORP COM         11,900      1,273,300       1.35
HD HOME DEPOT INC COM         23,400      1,264,514       1.35
PFE PFIZER INC COM         10,400      1,213,550       1.29
DIS DISNEY WALT COMPANY COM         31,400      1,134,325       1.21
CMA COMERICA INC COM         17,400      1,132,088       1.20
SNS SUNDSTRAND CORP COM         23,000      1,122,688       1.19
BMY BRISTOL-MYERS SQUIBB COM          8,600      1,081,988       1.15
FPC FLORIDA PROGRESS CORP COM         23,700      1,022,062       1.09
MRO USX-MARATHON GROUP COM NEW         33,900        957,675       1.02
XON EXXON CORP COM         13,400        944,700       1.01
WLA WARNER LAMBERT CO COM         13,300        926,844       0.99
CashUS CashUS        913,314        913,314       0.97
CPQ COMPAQ COMPUTER CORP COM         19,900        912,912       0.97
CVS CVS CORP COM         17,800        897,788       0.96
G GILLETTE CO COM         16,400        856,900       0.91
HNZ HEINZ H J CO COM         15,400        813,312       0.87
EMC E M C CORP MASS COM          8,600        793,888       0.84
CPWR COMPUWARE CORP COM         11,500        784,875       0.84
XRX XEROX CORP COM          5,411        618,207       0.66
TJX TJX COS INC NEW COM         21,600        616,950       0.66
BNI BURLINGTON NORTHN SANTA FE COM         18,400        612,950       0.65
SUNW SUN MICROSYSTEMS INC COM          6,300        609,919       0.65
AFS ASSOCIATES FIRST CAP CORP CL A         14,624        604,154       0.64
GPS GAP INC DEL COM         10,050        592,322       0.63
DOW DOW CHEMICAL COMPANY COM          6,200        569,238       0.61
KRB MBNA CORP COM         19,800        487,575       0.52
CL COLGATE-PALMOLIVE CO COM          5,100        399,712       0.43
BMCS BMC SOFTWARE INC COM          9,800        388,325       0.41
LNC LINCOLN NATL CORP IND COM          4,500        358,031       0.38
AVY AVERY DENNISON CORP COM          7,100        288,881       0.31