Vision Upload Format: HoldingsForSecurity

Vision Portfolio Management Application Layer: Application

| Headstart Applications | 

---

Application: HoldingsForSecurity

 

Summary:

The HoldingsForSecurity application is used to display the portfolios that hold a security as of a date.

Inputs:

Position	Form Id	Description
1	id	Id of the security
2	-	global date override
3	-	Sorting criteria

Analysis:

• The id must reference an existing Security instance.
• If parameter 3 is supplied, it specifies the sorting criteria. By default, the report is sorted from highest to lowest shares.
• This report is restricted to Portfolios that own the security. No other Account subclasses are included.
• The basic report displays portfolios as rows and the following columns:

Portfolio Id

Portfolio Name

Shares held in Portfolio

Total market value of holding

Percent of portfolio in this security

• If no global currency has been specified, the portfolio market values are expressed in the security's base currency.

Key Data Feeds:

• HoldingsFeed

Related Reports:

• SecurityProfile
• AccountProfile
• HoldingsHistoryForSecurity

Sample Usage:

Interface ApplicationWS runWith: "HoldingsForSecurity", "DELL" ;

Sample Input:

Enter Security:

Date:

Currency: Local United States Dollar Argentine Peso Australian Dollar Austrian Schilling Belgian Franc Brazilian Real British Pound Canadian Dollar Chilean Peso Chinese (yuan) Renmin Columbian Peso Czechoslovakian Korun Danish Krone Egyptian Pound Euro Dollar Finnish Markka French Franc German Deutschmark Greek Drachma Hong Kong Dollar Hungarian Forint Indian Rupee Indonesian Rupiah Irish Pound Israeli Shekel Italian Lira Jamaican Dollar Japanese Yen Jordanian Dinar Kenyan Shilling Luxembourg Franc Malaysian Ringgit Moroccan Dirham Netherlands Guilder New Mexican Peso New Zealand Dollar Nigerian Naira Norwegian Krone Pakistani Rupee Peruvian new Sol Philippine Peso Polish Zloty Portugese Escudo Singapore Dollar South African Rand South Korean Won Spanish Peseta Sri Lankan Rupee Swedish Krona Swiss Franc Taiwan Dollar Thailand Baht Turkish Lira Venezuelan Bolivar Zimbabwe Dollar

Sample Output:

--- Holdings in DELL COMPUTER CORP COM ---

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

Latest Price: 79.3125

---

(sorted by shares ; restricted to Portfolios)
Code	Account Name	Shares	Market Value	% of Port
	Total for Security:	2,876,150	227,716,359
732	Insyte Test 732	693,700	55,019,081	4.37
982	Insyte Test 982	247,600	19,637,775	4.57
387	Insyte Test 387	191,800	15,212,138	1.99
179	Insyte Test 179	90,700	7,193,644	4.76
593	Insyte Test 593	86,300	6,844,669	4.97
923	Insyte Test 923	82,000	6,503,625	5.09
968	Insyte Test 968	67,800	5,377,388	5.21
051	Insyte Test 051	59,700	4,734,956	2.00
003	Insyte Test 003	58,800	4,663,575	4.96
959	Insyte Test 959	58,200	4,615,988	4.88
207	Insyte Test 207	49,800	3,949,762	1.54
343	Insyte Test 343	49,800	3,949,762	2.26
722	Insyte Test 722	45,800	3,632,512	4.73
909	Insyte Test 909	45,300	3,592,856	4.62
088	Insyte Test 088	39,400	3,124,912	4.73
678	Insyte Test 678	39,000	3,093,188	5.06
323	Insyte Test 323	37,700	2,990,081	4.75
844	Insyte Test 844	36,300	2,879,044	4.25
099	Insyte Test 099	35,400	2,807,662	4.82
213	Insyte Test 213	31,600	2,506,275	1.96
263	Insyte Test 263	31,600	2,506,275	4.61
132	Insyte Test 132	31,400	2,490,412	5.42
002	Insyte Test 002	30,900	2,450,756	5.06
124	Insyte Test 124	26,200	2,077,988	5.06
119	Insyte Test 119	25,700	2,038,331	5.08
332	Insyte Test 332	25,400	2,014,538	4.87
602	Insyte Test 602	21,900	1,736,944	4.70
019	Insyte Test 019	20,000	1,277,500	4.24
892	Insyte Test 892	19,000	1,506,938	4.35
532	Insyte Test 532	18,600	1,475,212	5.24
369	Insyte Test 369	15,800	1,253,138	4.79
638	Insyte Test 638	15,600	1,237,275	4.61
474	Insyte Test 474	15,300	1,213,481	5.10
679	Insyte Test 679	15,000	1,189,688	4.74
963	Insyte Test 963	14,600	1,157,962	4.98
729	Insyte Test 729	14,600	1,157,962	2.61
033	Insyte Test 033	13,600	1,078,650	2.77
232	Insyte Test 232	12,500	991,406	3.28
753	Insyte Test 753	12,500	991,406	5.26
728	Insyte Test 728	12,500	991,406	2.68
863	Insyte Test 863	12,500	991,406	4.40
133	Insyte Test 133	12,300	975,544	4.99
022	Insyte Test 022	12,100	959,681	4.58
102	Insyte Test 102	11,400	904,162	5.05
473	Insyte Test 473	10,700	848,644	4.83
669	Insyte Test 669	10,700	848,644	3.07
872	Insyte Test 872	10,400	824,850	5.33
082	Insyte Test 082	10,200	808,988	4.79
538	Insyte Test 538	10,200	808,988	4.63
779	Insyte Test 779	10,200	808,988	5.54
314	Insyte Test 314	10,000	793,125	4.74
374	Insyte Test 374	9,600	761,400	5.07
953	Insyte Test 953	9,400	745,538	4.78
472	Insyte Test 472	9,400	745,538	3.51
244	Insyte Test 244	9,200	729,675	5.08
893	Insyte Test 893	9,100	721,744	5.03
169	Insyte Test 169	8,700	690,019	4.60
759	Insyte Test 759	8,700	690,019	4.66
382	Insyte Test 382	8,600	682,088	4.31
873	Insyte Test 873	8,600	682,088	4.64
899	Insyte Test 899	8,600	682,088	2.90
444	Insyte Test 444	8,400	666,225	5.09
303	Insyte Test 303	7,100	563,119	4.75
744	Insyte Test 744	7,000	555,188	4.42
714	Insyte Test 714	6,800	539,325	4.33
063	Insyte Test 063	6,700	531,394	2.27
572	Insyte Test 572	6,700	531,394	1.55
978	Insyte Test 978	6,600	523,462	5.52
412	Insyte Test 412	6,100	483,806	2.32
644	Insyte Test 644	6,100	483,806	4.47
353	Insyte Test 353	6,100	483,806	4.81
059	Insyte Test 059	5,900	467,944	4.31
553	Insyte Test 553	5,800	460,012	5.02
522	Insyte Test 522	5,800	460,012	2.13
964	Insyte Test 964	5,800	370,475	2.34
874	Insyte Test 874	5,800	460,012	5.18
813	Insyte Test 813	5,600	444,150	2.55
363	Insyte Test 363	5,600	444,150	4.88
944	Insyte Test 944	5,600	444,150	4.50
579	Insyte Test 579	5,600	444,150	2.07
573	Insyte Test 573	5,600	444,150	4.75
163	Insyte Test 163	5,500	436,219	4.95
992	Insyte Test 992	5,500	436,219	3.05
223	Insyte Test 223	5,500	436,219	4.85
834	Insyte Test 834	5,200	412,425	5.13
699	Insyte Test 699	4,800	380,700	4.94
544	Insyte Test 544	4,800	380,700	5.22
682	Insyte Test 682	4,400	348,975	3.31
093	Insyte Test 093	4,400	348,975	2.10
393	Insyte Test 393	4,400	348,975	4.73
734	Insyte Test 734	4,400	348,975	5.04
674	Insyte Test 674	4,200	333,112	4.80
912	Insyte Test 912	4,000	317,250	2.59
543	Insyte Test 543	3,700	293,456	2.43
317	Insyte Test 317	3,700	293,456	1.79
622	Insyte Test 622	3,600	285,525	3.09
653	Insyte Test 653	3,600	285,525	5.02
773	Insyte Test 773	3,400	269,662	5.26
689	Insyte Test 689	3,400	269,662	3.30
904	Insyte Test 904	2,900	230,006	5.11
043	Insyte Test 043	2,600	206,212	2.35
962	Insyte Test 962	2,600	206,212	1.59
524	Insyte Test 524	2,400	190,350	4.79
224	Insyte Test 224	2,400	190,350	2.99
243	Insyte Test 243	2,100	166,556	2.26
172	Insyte Test 172	2,100	166,556	1.52
143	Insyte Test 143	1,500	118,969	2.31
072	Insyte Test 072	1,500	118,969	1.56
603	Insyte Test 603	1,200	95,175	2.78
254	Insyte Test 254	1,000	79,312	1.74
424	Insyte Test 424	650	51,553	4.19

---