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$336.64$50.00$336.64$286.64573.28%14.6B729.7B
3
TSLA1$70.00$382.70$70.00$382.70$312.70446.71%3.9B276.5B
4
QQQ1$200.00$751.27$200.00$751.27$551.27275.64%673.7M134.7B
5
BRK.B1$200.00$515.62$200.00$515.62$315.62157.81%1.4B279.7B
6
MSFT1$150.00$535.07$150.00$535.07$385.07256.71%7.4B1113.8B
7
BAC1$22.50$54.32$22.50$54.32$31.82141.42%7.0B157.3B
8
SPY1$300.00$778.57$300.00$778.57$478.57159.52%954.2M286.3B
9
BATS:FLOT1$50.00$50.96$50.00$50.96$0.961.92%#N/A#N/A
10
MUTF:VTMFX1$30.00$50.93$30.00$50.93$20.9369.77%#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,456.08$2,383.580$0.000.00%(Symbol, Shares, Avg Cost, & Income)
18
Dividend Income$26.00
19
LAST UPDATED: Jan 26th 2020
Gains:$2,409.58
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