ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
TickerDay Change $$Day Change %Net Day $$ ChangeCurrent PriceSharesMarket ValueNet Gain/LossPurchase PriceShares PurchasedMoney SpentCurrent vs Purchased Stock PriceTotal Shares Gained:Added Dividend ValueYieldApprox Dividend Payout per FreqApprox Shares To Be AddedFrequency:
Bi-Annual
Quarterly
Monthly		Next Dividend Payout DateEarnings DatePurchase DateDays Owned$ per dayMarket Value2020 Account Value Compounding Interest2025 Account Value Compounding Interest2030 Account Value Compounding Interest2040 Account Value Compounding Interest2050 Account Value Compounding Interest
2
t$0.582.46%$1.16$23.582$47.16-$59.79$50.002$106.95-$26.420$0.00#N/A#N/A#N/A2#N/A#N/A3/30/163728-$0.02$47.16#N/A#N/A#N/A#N/A#N/A
3
AAPL-$4.50-1.55%-$9.07$291.132.0156$586.80$279.85$150.002$306.95$141.130.0156$4.54#N/A#N/A#N/A2#N/A#N/A6/13/173288$0.09$586.80#N/A#N/A#N/A#N/A#N/A
4
5
Total-$7.91$633.96$220.06$413.90$4.54
6
7
^^
Update when dividend payout takes place.
Column T will approximate how many shares will be reinvested
^^
Update		^^
Update		#N/A^^
Update
2 = Bi-Annual
4 = Quarterly
12 = Monthly		^^
Update
8
#N/A
9
10
11
Stackoverflow:
check column R as well
12
#N/A
=INDEX(IMPORTHTML("https://finance.yahoo.com/quote/PSEC/key-statistics", "table", 10), 2, 2)
13
#N/A
=INDEX(IMPORTHTML("https://finance.yahoo.com/quote/PSEC/key-statistics", "table", 10), 2, 2)
14
15
#N/A
=INDEX(IMPORTHTML("https://finance.yahoo.com/quote/O/key-statistics", "table", 10), 2, 2)
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