GURUF User Portfolio Template

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1						1. If you do not have GuruFocus Tools installed, please install the add-on at https://www.gurufocus.com/google-sheets-add-on
2						2. You can download this template at https://drive.google.com/drive/folders/1f-uK_5VJvLffk1fXJqE7oxeDulMVkOAY
3						3. Make sure you click File -> Make A Copy of this template into your Google Drive before using.
4						4. This template allows you to track your portfolio and add key statistics.
5						Enter the portfolio name in Cell A17.
6						Enter the tickers in Column A. Do not change the formulas in other cells.
7	User Portfolio Template					Add transactions, net dividends and commissions below Row 36. For sell transactions, enter a negative number in "Shares Bought / Sold".
8						You can add additional rows by right clicking a row in the table and clicking "Insert 1 Row Above" or "Insert 1 Row Below."
9						Key statistics include market cap, GF Score and Predictability. You can read more about the terms below:
10						https://www.gurufocus.com/term/mktcap/NAS:AAPL/Market-Cap/Apple
11						https://www.gurufocus.com/term/gf_score/NAS:AAPL/GF-Score/Apple
12						https://www.gurufocus.com/term/predictability_rank/NAS:AAPL/Predictability-Rank/Apple
13						5. You can add additional columns to the "Key Statistics" section by appending the columns to the right of the table.
14
15
16
17	Portfolio 1													Key Statistics
18	Ticker	Date Bought	Cost per share bought	Cost per share sold	Dividends earned less commissions	Current Price	Gain	Annualized Gain	# of shares bought	# of shares sold	Net # of shares	Value	Gain ($)	Market Cap	GF Score	Predictability
19	AAPL	2022-01-04	167.88	0.00	305.00	#LOGIN!	#VALUE!	#VALUE!	440	0	440	#VALUE!	-73120.4	#LOGIN!	#LOGIN!	#LOGIN!
20	WMT	2022-01-04	144.65	0.00	510.00	#LOGIN!	#VALUE!	#VALUE!	250	0	250	#VALUE!	-35402.5	#LOGIN!	#LOGIN!	#LOGIN!
21	BAC	2022-01-07	49.18	0.00	122.00	#LOGIN!	#VALUE!	#VALUE!	200	0	200	#VALUE!	-9514	#LOGIN!	#LOGIN!	#LOGIN!
22	JNJ	2022-01-06	171.63	0.00	1,296.00	#LOGIN!	#VALUE!	#VALUE!	300	0	300	#VALUE!	-49893	#LOGIN!	#LOGIN!	#LOGIN!
23	IBM	2022-01-24	128.82	0.00	863.00	#LOGIN!	#VALUE!	#VALUE!	140	0	140	#VALUE!	-17031.8	#LOGIN!	#LOGIN!	#LOGIN!
24	AMGN	2022-01-05	225.14	0.00	3,002.00	#LOGIN!	#VALUE!	#VALUE!	400	0	400	#VALUE!	-86654	#LOGIN!	#LOGIN!	#LOGIN!
25	BABA	2022-01-24	120.37	119.34	-200.00	#LOGIN!	#VALUE!	#VALUE!	280	-280	0	#VALUE!	-488.4	#LOGIN!	#LOGIN!	#LOGIN!
26	HD	2022-01-05	308.53	0.00	1,733.00	#LOGIN!	#VALUE!	#VALUE!	240	0	240	#VALUE!	-72074.2	#LOGIN!	#LOGIN!	#LOGIN!
27	MSFT	2022-01-20	301.60	0.00	371.00	#LOGIN!	#VALUE!	#VALUE!	150	0	150	#VALUE!	-44719	#LOGIN!	#LOGIN!	#LOGIN!
28	KO	2022-01-05	60.79	0.00	466.00	#LOGIN!	#VALUE!	#VALUE!	300	0	300	#VALUE!	-17471	#LOGIN!	#LOGIN!	#LOGIN!
29	TSLA	2022-01-06	354.90	0.00	-20.00	#LOGIN!	#VALUE!	#VALUE!	280	0	280	#VALUE!	-99112	#LOGIN!	#LOGIN!	#LOGIN!
30	BRK.B	2022-01-04	308.53	0.00	-100.00	#LOGIN!	#VALUE!	#VALUE!	180	0	180	#VALUE!	-55455.4	#LOGIN!	#LOGIN!	#LOGIN!
31	INTC	2022-01-04	53.14	51.94	78.00	#LOGIN!	#VALUE!	#VALUE!	280	-210	70	#VALUE!	-3823.8	#LOGIN!	#LOGIN!	#LOGIN!
32	TSM	2022-01-06	407.24	0.00	286.00	#LOGIN!	#VALUE!	#VALUE!	200	0	200	#VALUE!	-80962	#LOGIN!	#LOGIN!	#LOGIN!
33	V	2022-01-21	205.93	0.00	241.00	#LOGIN!	#VALUE!	#VALUE!	170	0	170	#VALUE!	-34597.1	#LOGIN!	#LOGIN!	#LOGIN!
34	Cash	100000							Total Value			#VALUE!	-680318.6
35
36	Add your portfolio transactions below.
37	Ticker	Date of transaction	Shares bought / sold	Buy price / sell price	Net dividends	Total commission
38	AAPL	2022-01-04	180	179.7	405	50
39	INTC	2022-01-04	280	53.14	103	25
40	INTC	2022-01-25	-210	51.94	0	0
41	WMT	2022-01-04	250	144.65	560	50
42	BAC	2022-01-07	200	49.18	172	50
43	JNJ	2022-01-06	300	171.63	1316	20
44	AMGN	2022-01-05	400	225.14	3032	30
45	KO	2022-01-05	300	60.79	516	50
46	TSLA	2022-01-06	280	354.9	0	20
47	HD	2022-01-05	240	308.53	1753	20
48	BRK.B	2022-01-04	180	308.53	0	100
49	TSM	2022-01-06	200	407.24	366	80
50	AAPL	2022-01-26	260	159.69	0	50
51	IBM	2022-01-24	140	128.82	913	50
52	BABA	2022-01-24	280	120.37	0	100
53	BABA	2023-01-23	-280	119.34	0	100
54	MSFT	2022-01-20	150	301.6	396	25
55	V	2022-01-21	170	205.93	266	25
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