CI's Portfolio Tracker with Google Sheets II

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1						*Must be a Computerized Investing subscriber to access
2	PORTFOLIO	Today's Date:	8/1/2026						benchmark:	IYY	iShares Dow Jones US ETF
3
4	Name	Ticker	Purchase Date	Commission	Purchase Price	Shares Purchased	Total Cost	Average Cost/Share	Market Value	Benchmark Price at Purchase	Current Benchmark Price	Holding Gain/Loss Since Purchase	Benchmark Gain/Loss Since Purchase	Current Price	Price Open	Intraday High	Intraday Low	Daily Change (%)	Volume (X)	52-Week High	52-Week Low	Price- Earnings Ratio (X)	Earnings Per Share ($ per shr)
5	Gilead Sciences, Inc	GILD	5/4/2012	$7.00	$65.70	100	$6,577.00	$65.77	$13,021.00	$85.00	$181.80	97.98%	113.88%	$130.21	$130.23	$130.89	$128.76	-0.82	6531645	$157.27	$108.46	17.71	7.35
6	Microsoft Corp	MSFT	3/6/2010	$7.00	$35.20	200	$7,047.00	$35.24	$92,944.00	$96.00	$181.80	1218.92%	89.38%	$464.72	$450.00	$466.84	$449.33	3.02	60845971	$553.72	$349.20	25.9	17.95
7	Micron Technology Inc	MU	6/26/2014	$7.00	$17.62	250	$4,412.00	$17.65	$205,757.50	$102.00	$181.80	4563.59%	78.24%	$823.03	$919.65	$930.88	$818.00	-5.9	54538600	$1,255.00	$103.38	18.63	44.17
8	Jazz Pharmaceuticals PLC	JAZZ	3/25/2009	$7.00	$100.06	400	$40,031.00	$100.08	$101,144.00	$76.00	$181.80	152.66%	139.21%	$252.86	$258.09	$259.06	$250.71	-2.14	572977	$261.30	$105.00	2377.84	0.11
9	Caterpillar Inc	CAT	2/15/2014	$7.00	$93.78	460	$43,145.80	$93.80	$374,812.60	$65.00	$181.80	768.71%	179.69%	$814.81	$843.39	$845.00	$807.31	0.7	2423575	$1,073.46	$405.46	40.54	20.1
10	Apple Inc	AAPL	2/16/2014	$7.00	$94.00	35	$3,297.00	$94.20	$10,811.85	$85.00	$181.80	227.93%	113.88%	$308.91	$304.81	$310.69	$300.00	-7.35	132489137	$344.57	$201.50	35.41	8.72
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100