Stock portfolio management
angel91
PortfolioManagementSpreadsheet.xlsxSheet1
| Stock Name | Total # of Shares | Market Value | % of Total Portfolio | ||
| Adobe (ADBE) | 449 | $68,735.17 | 5.65% | ||
| Microsoft (MSFT) | 897 | $68,387.19 | 11.29% | ||
| Facebook (FB) | 391 | $67,212.90 | 4.92% | ||
| Alphabet (GOOG) | 69 | $67,981.56 | 0.87% | ||
| Activision (ATVI) | 1048 | $64,011.84 | 13.19% | ||
| Electronic Arts (EA) | 565 | $65,489.15 | 7.11% | ||
| Technology | 3419 | $401,817.81 | 43.02% | 40 | |
| Starbucks (SBUX) | 1303 | $72,420.74 | 16.40% | ||
| Amazon (AMZN) | 69 | $68,292.06 | 0.87% | ||
| Priceline Group (PCLN) | 35 | $67,033.39 | 0.44% | ||
| Home Depot (HD) | 403 | $66,686.43 | 5.07% | ||
| Consumer Cyclical | 1810 | $274,432.62 | 22.78% | 16.5 | |
| HDFC Bank (HDB) | 708 | $66,091.87 | 8.91% | ||
| Visa (V) | 830 | $68,273.10 | 10.44% | ||
| Financial Services | 1538 | $134,364.97 | 19.35% | ||
| Boeing (BA) | 260 | $67,794.98 | 3.27% | ||
| Industrials | 260 | $67,794.98 | 3.27% | increase | 12.57 |
| Stryker (SYK) | 463 | $67,739.21 | 5.83% | ||
| Celgene (CELG) | 457 | $63,756.07 | 5.75% | ||
| Healthcare | 920 | $131,495.28 | 11.58% | ||
| Cash | |||||
| Totals | 7947 | $1,009,905.66 | 100.00% | ||
Oct. 21 Update
| Stock Name | Total # of Shares @ Initial Purchase (8/2) | Initial Cost | Market Value @ Initial Cost (8/2) | % of Ttl. Portfolio | Total # of Shares @ 8/21 | Price @ 8/21 | Market Value @ 8/21 (Shares*Price) | Market Value @ 8/21 (Stated on finviz) | % of Ttl. Portfolio | $ % of Portfolio | ||
| Adobe (ADBE) | 449 | $148.19 | $66,537.31 | 5.80% | 452 | $175.64 | $79,389.28 | $78,862.36 | 8.03% | 7.80% | ||
| Microsoft (MSFT) | 897 | $74.24 | $66,593.28 | 11.58% | 840 | $78.81 | $66,200.40 | $70,692.57 | 14.91% | 6.50% | ||
| Facebook (FB) | 391 | $170.09 | $66,505.19 | 5.05% | 391 | $174.98 | $68,417.18 | $68,417.18 | 6.94% | 6.72% | ||
| Alphabet (GOOG) | 69 | $956.02 | $65,965.38 | 0.89% | 160 | $988.20 | $158,112.00 | $68,185.80 | 2.84% | 15.53% | ||
| Activision (ATVI) | 1048 | $63.56 | $66,610.88 | 13.53% | 200 | $62.63 | $12,526.00 | $65,636.24 | 3.55% | 1.23% | ||
| Electronic Arts (EA) | 565 | $117.83 | $66,573.95 | 7.29% | 200 | $113.62 | $22,724.00 | $64,195.30 | 3.55% | 2.23% | ||
| Technology | 3419 | $398,785.99 | 44.13% | 2243 | $407,368.86 | $415,989.45 | 39.83% | 40.00% | 0.4 | $407,374.11 | ||
| Starbucks (SBUX) | 1303 | $54.05 | $70,427.15 | 16.82% | 550 | $54.57 | $30,013.50 | $71,104.71 | 9.77% | 2.95% | ||
| Amazon (AMZN) | 69 | $958.52 | $66,137.88 | 0.89% | 70 | $982.91 | $68,803.70 | $67,820.79 | 1.24% | 6.76% | ||
| Priceline Group (PCLN) | 35 | $1,860.32 | $65,111.20 | 0.45% | 42 | $1,942.11 | $81,568.62 | $67,973.85 | 0.75% | 8.01% | ||
| Home Depot (HD) | 403 | $165.09 | $66,531.27 | 5.20% | 200 | $163.43 | $32,686.00 | $65,862.29 | 3.55% | 3.21% | ||
| Consumer Cyclical | 1810 | $268,207.50 | 23.36% | 862 | $213,071.82 | $272,761.64 | 15.31% | 20.92% | 0.21 | $213,871.41 | ||
| HDFC Bank (HDB) | 708 | $94.12 | $66,636.96 | 9.14% | 760 | $96.00 | $72,960.00 | $67,968.00 | 13.49% | 7.16% | ||
| Visa (V) | 630 | $105.75 | $66,622.50 | 8.13% | 737 | $107.55 | $79,264.35 | $67,756.50 | 13.09% | 7.78% | ||
| Financial Services | 1338 | $133,259.46 | 17.27% | 1497 | $152,224.35 | $135,724.50 | 26.58% | 14.95% | 0.15 | $152,765.29 | ||
| Lockheed Martin Corp (LMT) | 167 | $320.00 | $53,440.00 | 2.97% | 5.25% | |||||||
| Boeing (BA) | 260 | $255.54 | $66,440.40 | 3.36% | 260 | $264.75 | $68,835.00 | $68,835.00 | 4.62% | 6.76% | ||
| Industrials | 260 | $66,440.40 | 3.36% | 260 | $122,275.00 | $68,835.00 | 4.62% | 12.01% | 0.12 | $122,212.23 | ||
| Boston Scientific Corp (BSX) | 250 | $29.69 | $7,422.50 | 4.44% | 0.73% | |||||||
| Illumina Inc (ILMN) | 100 | $209.88 | $20,988.00 | 1.78% | 2.06% | |||||||
| Stryker (SYK) | 463 | $143.75 | $66,556.25 | 5.98% | 470 | $150.49 | $70,730.30 | $69,676.87 | 8.35% | 6.95% | ||
| Celgene (CELG) | 457 | $145.82 | $66,639.74 | 5.90% | 200 | $121.33 | $24,266.00 | $55,447.81 | 3.55% | 2.38% | ||
| Healthcare | 920 | $133,195.99 | 11.88% | 770 | $123,406.80 | $125,124.68 | 13.67% | 12.12% | 0.12 | $122,212.23 | ||
| Stock Totals | 7747 | $999,889.34 | 100.00% | 5632 | $1,018,346.83 | $1,018,435.27 | 100.00% | 100.00% | 1 | 1018435.27 | ||
| Cash | $110.66 | $88.44 | ||||||||||
| Portfolio Totals | $1,000,000.00 | $1,018,346.83 | ||||||||||
| Gain @ 8/21 = $18545.93 |
Initial Purchase
| Stock Name | Total # of Shares @ Initial Purchase (8/2) | Initial Cost | Market Value @ Initial Cost (8/2) | % of Ttl. Portfolio | Total # of Shares @ 8/21 | Price @ 8/21 | Market Value @ 8/21 (Shares*Price) | Market Value @ 8/21 (Stated on finviz) | % of Ttl. Portfolio |
| Adobe (ADBE) | 449 | $148.19 | $66,537.31 | 5.80% | 449 | $175.64 | $78,862.36 | $78,862.36 | 5.80% |
| Microsoft (MSFT) | 897 | $74.24 | $66,593.28 | 11.58% | 897 | $78.81 | $70,692.57 | $70,692.57 | 11.58% |
| Facebook (FB) | 391 | $170.09 | $66,505.19 | 5.05% | 391 | $174.98 | $68,417.18 | $68,417.18 | 5.05% |
| Alphabet (GOOG) | 69 | $956.02 | $65,965.38 | 0.89% | 69 | $988.20 | $68,185.80 | $68,185.80 | 0.89% |
| Activision (ATVI) | 1048 | $63.56 | $66,610.88 | 13.53% | 1048 | $62.63 | $65,636.24 | $65,636.24 | 13.53% |
| Electronic Arts (EA) | 565 | $117.83 | $66,573.95 | 7.29% | 565 | $113.62 | $64,195.30 | $64,195.30 | 7.29% |
| Technology | 3419 | $398,785.99 | 44.13% | 3419 | $415,989.45 | $415,989.45 | 44.13% | ||
| Starbucks (SBUX) | 1303 | $54.05 | $70,427.15 | 16.82% | 1303 | $54.57 | $71,104.71 | $71,104.71 | 16.82% |
| Amazon (AMZN) | 69 | $958.52 | $66,137.88 | 0.89% | 69 | $982.91 | $67,820.79 | $67,820.79 | 0.89% |
| Priceline Group (PCLN) | 35 | $1,860.32 | $65,111.20 | 0.45% | 35 | $1,942.11 | $67,973.85 | $67,973.85 | 0.45% |
| Home Depot (HD) | 403 | $165.09 | $66,531.27 | 5.20% | 403 | $163.43 | $65,862.29 | $65,862.29 | 5.20% |
| Consumer Cyclical | 1810 | $268,207.50 | 23.36% | 1810 | $272,761.64 | $272,761.64 | 23.36% | ||
| HDFC Bank (HDB) | 708 | $94.12 | $66,636.96 | 9.14% | 708 | $96.00 | $67,968.00 | $67,968.00 | 9.14% |
| Visa (V) | 630 | $105.75 | $66,622.50 | 8.13% | 630 | $107.55 | $67,756.50 | $67,756.50 | 8.13% |
| Financial Services | 1338 | $133,259.46 | 17.27% | 1338 | $135,724.50 | $135,724.50 | 17.27% | ||
| Lockheed Martin Corp (LMT) | $320.00 | ||||||||
| Boeing (BA) | 260 | $255.54 | $66,440.40 | 3.36% | 260 | $264.75 | $68,835.00 | $68,835.00 | 3.36% |
| Industrials | 260 | $66,440.40 | 3.36% | 260 | $68,835.00 | $68,835.00 | 3.36% | ||
| Boston Scientific Corp (BSX) | $29.69 | ||||||||
| Illumina Inc (ILMN) | $209.88 | ||||||||
| Stryker (SYK) | 463 | $143.75 | $66,556.25 | 5.98% | 463 | $150.49 | $69,676.87 | $69,676.87 | 5.98% |
| Celgene (CELG) | 457 | $145.82 | $66,639.74 | 5.90% | 457 | $121.33 | $55,447.81 | $55,447.81 | 5.90% |
| Healthcare | 920 | $133,195.99 | 11.88% | 920 | $125,124.68 | $125,124.68 | 11.88% | ||
| Stock Totals | 7747 | $999,889.34 | 100.00% | 7747 | $1,018,435.27 | $1,018,435.27 | 100.00% | ||
| Cash | $110.66 | ||||||||
| Portfolio Totals | $1,000,000.00 | ||||||||
| Gain @ 8/21 = $18545.93 |
