ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
(FILE > Make A Copy)
Symbol		SharesAvg. Cost
Per Share		Current Share
Price		EquityMarket
Value		Capital
Gain		Percent
Growth		Annual
Dividend		Dividend
Yield		Yeild On
Cost		Per
Qtr		Annual
Income		Outstanding
Shares		Market Cap $
You Purchased at
2
AAPL1$50.00$274.03$50.00$274.03$224.03448.06%14.8B738.8B
3
TSLA1$70.00$427.36$70.00$427.36$357.36510.51%3.3B232.8B
4
QQQ1$200.00$613.80$200.00$613.80$413.80206.90%641.7M128.3B
5
BRK.B1$200.00$503.94$200.00$503.94$303.94151.97%1.4B274.6B
6
MSFT1$150.00$493.08$150.00$493.08$343.08228.72%7.4B1114.9B
7
BAC1$22.50$52.91$22.50$52.91$30.41135.16%7.3B164.3B
8
SPY1$300.00$675.28$300.00$675.28$375.28125.09%954.2M286.3B
9
BATS:FLOT1$50.00$50.98$50.00$50.98$0.981.96%#N/A#N/A
10
MUTF:VTMFX1$30.00$48.68$30.00$48.68$18.6862.27%#N/A#N/A
11
12
13
14
15
16
DepositedValueTotal GainsIncome / Year
Income / Month
Current YieldOnly Enter Numbers in the Gray Highlited Boxes
17
Account Gains$1,072.50$3,140.06$2,067.560$0.000.00%(Symbol, Shares, Avg Cost, & Income)
18
Dividend Income$26.00
19
LAST UPDATED: Jan 26th 2020
Gains:$2,093.56
Cost per $1 Dividend
Yield on Cost
20
#DIV/0!0.00%
21
22
23
24
25
26
MonthIncomeAverage
27
01/2019$0.00$0.00
28
02/2019$0.50$0.25
29
03/2019$3.00$1.63
30
04/2019$0.75$1.19
31
05/2019$1.00$1.09
32
06/2019$3.50$2.30
33
07/2019$1.25$1.77
34
08/2019$1.50$1.64
35
09/2019$4.00$2.82
36
10/2019$1.75$2.28
37
11/2019$2.00$2.14
38
12/2019$4.50$3.32
39
01/2020$2.25$2.79
40
02/2020
41
03/2020
42
04/2020
43
05/2020
44
06/2020
45
07/2020
46
08/2020
47
09/2020
48
10/2020
49
11/2020
50
12/2020
51
01/2021
52
02/2021
53
03/2021
54
04/2021
55
05/2021
56
06/2021
57
07/2021
58
08/2021
59
09/2021
60
10/2021
61
11/2021
62
12/2021
63
64
65
66
67
68
69
70
Special thanks to Michael Stricker for fixing the dividend formulas - PPCIAN Group Member
- these have been applied already, but are here for your viewing
71
Annual Dividend:
=IF(ISBLANK(A2)=true, "",IFERROR(IMPORTXML("http://finviz.com/quote.ashx?t="&A2,"/html/body/div[4]/div/table[2]/tbody/tr[7]/td[2]")))

Dividend Yield:
=IF(ISBLANK(A2)=true, "",IMPORTXML("http://finviz.com/quote.ashx?t="&A2,"/html/body/div[4]/div/table[2]/tbody/tr[8]/td[2]"))


Annual Dividend
=IF(ISBLANK(A31)=true, "",IFERROR(IMPORTXML("https://www.marketwatch.com/investing/fund/"&A31,"/html/body/div[3]/div[5]/div[3]/div[1]/div[1]/table/tbody/tr[1]/td[2]")*4))

Dividend Yield:
=IF(ISBLANK(A31)=true, "",IMPORTXML("https://www.marketwatch.com/investing/fund/"&A31,"/html/body/div[3]/div[5]/div[1]/div[1]/div/ul/li[5]/span[1]"))
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