Stock Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

Comment only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
CompanySymbolShares
Purchase Date
Purchase Price
Price
% of Portfolio
Cost basis
Market value
Gain
Gain %
Dividends
Total Gain
Total Gain %
2
AbbVie IncABBV173/29/2016$55.799$69.16#N/A$957.53$1,175.72$218.190 22.79%$72.590$290.780 30.37%
3
AbbVie IncABBV202/10/2017$60.500$69.16#N/A$1,216.95$1,383.20$166.250 13.66%$38.400$204.650 16.82%
4
Altria Group IncMO1510/2/2017$62.850$49.41#N/A$947.70$741.15($206.550)-21.79%$9.900($196.650)-20.75%
5
Amgen, IncAMGN710/28/2016$146.500$177.47#N/A$1,034.45$1,242.29$207.840 20.09%$39.200$247.040 23.88%
6
Amgen, IncAMGN812/21/2016$146.000$177.47#N/A$1,176.95$1,419.76$242.810 20.63%$36.800$279.610 23.76%
7
Anheuser Busch Inbev
BUD912/14/2017$110.800$88.01#N/A$1,002.15$792.09($210.060)-20.96%$0.000($210.060)-20.96%
8
AppleAAPL66/29/2015$126.090$204.50#N/A$765.49$1,227.00$461.510 60.29%$34.380$495.890 64.78%
9
AppleAAPL67/7/2015$124.360$204.50#N/A$755.11$1,227.00$471.890 62.49%$34.380$506.270 67.05%
10
AT&T Inc.T596/17/2014$34.987$33.58#N/A$2,073.18$1,981.22($91.963)-4.44%$394.120$302.157 14.57%
11
AT&T Inc.T2710/12/2017$36.850$33.58#N/A$999.90$906.66($93.240)-9.32%$0.000($93.240)-9.32%
12
Bank of Nova ScotiaBNS174/18/2017$57.370$53.08#N/A$980.24$902.36($77.880)-7.94%$17.636($60.244)-6.15%
13
Boeing CompanyBA79/24/2015$128.010$362.75#N/A$905.02$2,539.25$1,634.230 180.57%$76.650$1,710.880 189.04%
14
Boeing CompanyBA71/15/2016$126.100$362.75#N/A$891.65$2,539.25$1,647.600 184.78%$70.280$1,717.880 192.66%
15
BP plc (ADR)BP359/4/2014$45.087$40.21#N/A$1,587.00$1,407.35($179.645)-11.32%$273.000$93.355 5.88%
16
Cardinal Health IncCAH148/2/2017$70.000$46.79#N/A$984.95$655.06($329.890)-33.49%$12.947($316.943)-32.18%
17
Cardinal Health IncCAH1711/13/2017$58.100$46.79#N/A$992.65$795.43($197.220)-19.87%$7.861($189.359)-19.08%
18
Cisco Systems, Inc.CSCO2811/3/2015$28.569$57.62#N/A$808.88$1,613.36$804.478 99.46%$59.360$863.838 106.79%
19
Cisco Systems, Inc.CSCO394/29/2016$27.648$57.62#N/A$1,087.20$2,247.18$1,159.978 106.69%$64.350$1,224.328 112.61%
20
Coca-Cola CompanyKO248/16/2016$43.900$52.14#N/A$1,062.55$1,251.36$188.810 17.77%$52.320$241.130 22.69%
21
Coca-Cola CompanyKO2511/29/2016$41.170$52.14#N/A$1,038.20$1,303.50$265.300 25.55%$37.000$302.300 29.12%
22
Coca-Cola CompanyKO241/10/2017$41.100$52.14#N/A$995.35$1,251.36$256.010 25.72%$35.520$291.530 29.29%
23
ConocoPhillipsCOP2410/15/2014$64.600$59.75#N/A$1,559.35$1,434.00($125.350)-8.04%$120.000($5.350)-0.34%
24
CVS Health CorpCVS1312/30/2016$78.900$57.38#N/A$1,034.65$745.94($288.710)-27.90%$26.000($262.710)-25.39%
25
Diageo PLCDEO1012/15/2016$103.350$170.16#N/A$1,042.45$1,701.60$659.150 63.23%$31.996$691.146 66.30%
26
Dominion Energy IncD137/6/2017$75.600$77.48#N/A$987.75$1,007.24$19.490 1.97%$19.825$39.315 3.98%
27
DowDuPont IncDWDP172/11/2016$45.700#N/A#N/A$785.85#N/A#N/A#N/A$61.200#N/A#N/A
28
Emerson Electric Co.
EMR209/12/2016$51.080$66.24#N/A$1,030.55$1,324.80$294.250 28.55%$48.100$342.350 33.22%
29
Enterprise ProductsEPD362/8/2016$22.000$30.32#N/A$800.95$1,091.52$290.570 36.28%$103.230$393.800 49.17%
30
Exxon MobilXOM128/19/2016$88.000$75.93#N/A$1,064.95$911.16($153.790)-14.44%$45.720($108.070)-10.15%
31
Exxon MobilXOM121/10/2017$86.150$75.93#N/A$1,042.75$911.16($131.590)-12.62%$36.720($94.870)-9.10%
32
Exxon MobilXOM138/14/2017$78.400$75.93#N/A$1,024.15$987.09($37.060)-3.62%$10.010($27.050)-2.64%
33
Ford Motor Company
F853/23/2017$11.600$10.51#N/A$990.95$893.35($97.600)-9.85%$38.250($59.350)-5.99%
34
Ford Motor Company
F915/2/2017$10.975$10.51#N/A$1,003.68$956.41($47.265)-4.71%$27.300($19.965)-1.99%
35
General ElectricGE478/31/2015$24.609$10.38#N/A$1,165.57$487.86($677.713)-58.14%$99.170($578.543)-49.64%
36
General Mills, Inc.GIS169/26/2016$64.300$52.86#N/A$1,037.75$845.76($191.990)-18.50%$38.720($153.270)-14.77%
37
General MotorsGM322/3/2016$28.850$39.43#N/A$932.15$1,261.76$329.610 35.36%$97.280$426.890 45.80%
38
Gilead Sciences, Inc.
GILD146/25/2016$80.400$66.94#N/A$1,134.55$937.16($197.390)-17.40%$42.280($155.110)-13.67%
39
HP Inc.HPQ6812/3/2016$14.900$21.31#N/A$1,022.15$1,449.08$426.930 41.77%$36.543$463.473 45.34%
40
IBMIBM811/19/2014$161.500$143.53#N/A$1,300.95$1,148.24($152.710)-11.74%$131.200($21.510)-1.65%
41
IBMIBM78/18/2017$140.200$143.53#N/A$986.35$1,004.71$18.360 1.86%$10.500$28.860 2.93%
42
Intel CorporationINTC3012/2/2016$33.870$49.17#N/A$1,025.05$1,475.10$450.050 43.91%$32.325$482.375 47.06%
43
Johnson & JohnsonJNJ215/4/2015$100.229$132.50#N/A$2,113.76$2,782.50$668.741 31.64%$183.120$851.861 40.30%
44
Johnson & JohnsonJNJ118/31/2015$94.759$132.50#N/A$1,051.30$1,457.50$406.201 38.64%$79.420$485.621 46.19%
45
JPMorgan Chase & Co
JPM184/7/2016$57.900$115.12#N/A$1,051.15$2,072.16$1,021.010 97.13%$54.000$1,075.010 102.27%
46
Kimberly Clark CorpKMB89/1/2015$104.701$138.52#N/A$846.55$1,108.16$261.606 30.90%$74.560$336.166 39.71%
47
Kimberly Clark CorpKMB81/10/2018$114.400$138.52#N/A$920.15$1,108.16$188.010 20.43%$0.000$188.010 20.43%
48
Kinder MorganKMI368/12/2015$33.129$20.91#N/A$1,201.59$752.76($448.834)-37.35%$54.360($394.474)-32.83%
49
Kraft Heinz CoKHC128/10/2017$86.150$30.32#N/A$1,038.75$363.84($674.910)-64.97%$15.000($659.910)-63.53%
50
Kraft Heinz CoKHC139/19/2017$80.900$30.32#N/A$1,056.65$394.16($662.490)-62.70%$8.125($654.365)-61.93%
51
Kroger CoKR489/28/2017$20.400$21.96#N/A$984.15$1,054.08$69.930 7.11%$6.000$75.930 7.72%
52
Lockheed MartinLMT511/13/2015$213.267$365.35#N/A$1,075.29$1,826.75$751.465 69.89%$79.400$830.865 77.27%
53
Main Street Capital Corp
MAIN261/9/2018$38.800$42.32#N/A$1,013.75$1,100.32$86.570 8.54%$0.000$86.570 8.54%
54
McDonald's Corporation
MCD158/15/2014$94.000$213.72#N/A$1,418.95$3,205.80$1,786.850 125.93%$188.100$1,974.950 139.18%
55
MicrosoftMSFT1812/9/2015$55.600$137.08#N/A$1,009.75$2,467.44$1,457.690 144.36%$55.080$1,512.770 149.82%
56
NikeNKE1411/30/2015$66.429$88.60#N/A$938.95$1,240.40$301.451 32.11%$21.840$323.291 34.43%
57
Omega HealthcareOHI323/8/2017$31.500$36.78#N/A$1,012.95$1,176.96$164.010 16.19%$61.440$225.450 22.26%
58
PepsiCo Inc.PEP1212/17/2014$92.789$133.80#N/A$1,122.42$1,605.60$483.182 43.05%$106.686$589.868 52.55%
59
PfizerPFE301/11/2016$31.000$42.85#N/A$938.95$1,285.50$346.550 36.91%$74.400$420.950 44.83%
60
PfizerPFE3611/2/2016$30.600$42.85#N/A$1,110.55$1,542.60$432.050 38.90%$56.880$488.930 44.03%
61
Philip Morris Intl, Inc.
PM192/26/2015$82.659$81.58#N/A$1,579.47$1,550.02($29.451)-1.86%$235.220$205.769 13.03%
62
Principal Financial Group
PFG246/1/2016$44.250$58.99#N/A$1,070.95$1,415.76$344.810 32.20%$74.400$419.210 39.14%
63
Principal Financial Group
PFG286/10/2016$42.400$58.99#N/A$1,196.15$1,651.72$455.570 38.09%$75.880$531.450 44.43%
64
Proctor & GamblePG163/13/2015$81.530$115.89#N/A$1,313.43$1,854.24$540.810 41.18%$118.374$659.184 50.19%
65
QUALCOMM, Inc.QCOM179/8/2016$62.230$75.67#N/A$1,066.86$1,286.39$219.530 20.58%$47.090$266.620 24.99%
66
QUALCOMM, Inc.QCOM181/23/2017$55.600$75.67#N/A$1,009.75$1,362.06$352.310 34.89%$40.320$392.630 38.88%
67
Southern CoSO2211/23/2016$47.380$55.66#N/A$1,051.31$1,224.52$173.210 16.48%$50.600$223.810 21.29%
68
StarbucksSBUX1812/22/2015$59.400$90.08#N/A$1,078.15$1,621.44$543.290 50.39%$34.200$577.490 53.56%
69
Sysco CorporationSYY204/17/2017$51.950$72.65#N/A$1,043.95$1,453.00$409.050 39.18%$13.200$422.250 40.45%
70
T. Rowe Price Group Inc.
TROW151/26/2017$69.800$110.36#N/A$1,055.95$1,655.40$599.450 56.77%$34.200$633.650 60.01%
71
Target CorporationTGT1510/17/2016$67.370$88.31#N/A$1,019.50$1,324.65$305.150 29.93%$45.600$350.750 34.40%
72
Toronto-Dominion Bank
TD213/14/2017$49.620$58.66#N/A$1,046.97$1,231.86$184.890 17.66%$24.708$209.598 20.02%
73
Toyota Motor CorpTM93/15/2016$107.283$128.61#N/A$974.50$1,157.49$182.989 18.78%$61.160$244.149 25.05%
74
Travelers Companies Inc
TRV95/15/2017$120.790$154.59#N/A$1,092.06$1,391.31$299.250 27.40%$19.440$318.690 29.18%
75
Unilever PLCUL2611/18/2016$38.625$63.15#N/A$1,013.21$1,641.90$628.695 62.05%$40.615$669.309 66.06%
76
United Technologies Corp
UTX109/6/2017$109.500$133.19#N/A$1,099.95$1,331.90$231.950 21.09%$7.000$238.950 21.72%
77
VF CorpVFC201/18/2017$50.800$88.31#N/A$1,024.95$1,766.20$741.250 72.32%$34.400$775.650 75.68%
78
Valero Energy CorpVLO209/30/2016$52.200$84.21#N/A$1,052.95$1,684.20$631.250 59.95%$68.000$699.250 66.41%
79
Verizon Communications
VZ753/14/2014$46.000$57.41#N/A$3,458.95$4,305.75$846.800 24.48%$631.500$1,478.300 42.74%
80
Verizon Communications
VZ239/30/2015$43.779$57.41#N/A$1,015.87$1,320.43$304.563 29.98%$118.680$423.243 41.66%
81
Walt DisneyDIS108/21/2015$96.930$144.30#N/A$978.25$1,443.00$464.750 47.51%$38.200$502.950 51.41%
82
Wells Fargo & CoWFC311/15/2015$50.697$45.30#N/A$1,580.56$1,404.30($176.257)-11.15%$140.430($35.827)-2.27%
83
Western Digital Corp.
WDC96/5/2015$94.710$51.49#N/A$861.34$463.41($397.930)-46.20%$49.500($348.430)-40.45%
84
Williams-Sonoma, Inc
WSM226/15/2017$48.850$70.26#N/A$1,079.65$1,545.72$466.070 43.17%$17.160$483.230 44.76%
85
86
S&P 500.inx$3,004.04
87
88
Sold Stocks$412.110 $102.410$514.520
89
Stockpile Stocks#N/A$234.01$188.54($45.463)-19.43%$0.000($45.463)-19.43%
90
91
Amazon IncAMZN15/16/2017$906.060$2,009.90#N/A$906.06$2,009.90$1,103.840 121.83%$0.000$1,103.840 121.83%
92
Berkshire HathawayBRK.B29/13/2017$180.380$212.88#N/A$360.76$425.76$65.000 18.02%$0.000$65.000 18.02%
93
AlphabetGOOGL16/28/2017$893.130$1,153.46#N/A$893.13$1,153.46$260.330 29.15%$0.000$260.330 29.15%
94
Facebook IncFB1088/31/2012$18.500$203.84#N/A$1,998.00$22,014.72$20,016.720 1001.84%$0.000$20,016.720 1001.84%
95
Facebook IncFB7510/22/2013$53.000$203.84#N/A$3,983.95$15,288.00$11,304.050 283.74%$0.000$11,304.050 283.74%
96
Facebook IncFB172/11/2017$143.025$203.84#N/A$2,431.43$3,465.28$1,033.855 42.52%$0.000$1,033.855 42.52%
97
Netflix IncNFLX110/21/2017$197.400$365.99#N/A$197.40$365.99$168.590 85.41%$0.000$168.590 85.41%
98
Tesla IncTSLA28/25/2017$316.210$252.38#N/A$632.42$504.76($127.660)-20.19%$0.000($127.660)-20.19%
99
Alibaba, tencent
100
Loading...