Module 06 Excel Project - Connecting to the Web and Linking it all Together
rhariff74
Module6StockPortfoilo21.xlsxTitle
| Sharlene Portfolio |
Stock Portfolio
| ACCOUNT NAME | SYMBOL | QUANTITY | DATE OF PURCHASE | PURCHASE PRICE | TOTAL | Current Price (7 August 2018) | Current Total | Gain/Loss |
| American Airlines | NASDAQ:AAL | 13.00 | 7/1/18 | $37.12 | $ 482.56 | $ 38.26 | $497.38 | $14.82 |
| Broadcom Inc | NASDAQ:AVGO | 35.00 | 7/1/18 | $202.46 | $ 7,086.10 | $220.31 | $7,710.85 | $624.75 |
| CA Inc | NASDAQ: CA | 100.00 | 7/1/18 | $63.45 | $ 6,345.00 | $43.80 | $4,380.00 | -$1,965.00 |
| Cisco System Inc | NASDAQ:CSCO | 44.00 | 7/1/18 | $41.78 | $ 1,838.32 | $43.48 | $1,913.12 | $74.80 |
| Freeport-McMoRan Inc | NYSE:FCX | 10.00 | 7/1/18 | $16.80 | $ 168.00 | $15.40 | $154.00 | -$14.00 |
| Mattel Inc | NASDAQ:MAT | 200.00 | 7/1/18 | $16.46 | $ 3,292.00 | $15.94 | $3,188.00 | -$104.00 |
| Netflix Inc | NASDAQ:NFLX | 25.00 | 7/1/18 | $395.80 | $ 9,895.00 | $350.92 | $8,773.00 | -$1,122.00 |
| Starbucks Corp | NASDAQ:SBUX | 25.00 | 7/1/18 | $51.62 | $ 1,290.50 | $52.07 | $1,301.75 | $11.25 |
| Ulta Beauty Inc | NASDAQ:ULTA | 10.00 | 7/1/18 | $259.87 | $ 2,598.70 | $236.10 | $2,361.00 | -$237.70 |
| Walgreens Boots Alliance | NASDAQ:WBA | 5.00 | 7/1/18 | $65.17 | $ 325.85 | $67.05 | $335.25 | $9.40 |
QUANTITY
NASDAQ:AAL NASDAQ:AVGO NASDAQ: CA NASDAQ:CSCO NYSE:FCX NASDAQ:MAT NASDAQ:NFLX NASDAQ:SBUX NASDAQ:ULTA NASDAQ:WBA 13 35 100 44 10 200 25 25 10 5
TOTAL
7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 13.00 35.00 100.00 44.00 10.00 200.00 25.00 25.00 10.00 5.00 NASDAQ:AAL NASDAQ:AVGO NASDAQ: CA NASDAQ:CSCO NYSE:FCX NASDAQ:MAT NASDAQ:NFLX NASDAQ:SBUX NASDAQ:ULTA NASDAQ:WBA 482.55999999999995 7086.1 6345 1838.3200000000002 168 3292 9895 1290.5 2598.6999999999998 325.85000000000002 PURCHASE PRICE
7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 13.00 35.00 100.00 44.00 10.00 200.00 25.00 25.00 10.00 5.00 NASDAQ:AAL NASDAQ:AVGO NASDAQ: CA NASDAQ:CSCO NYSE:FCX NASDAQ:MAT NASDAQ:NFLX NASDAQ:SBUX NASDAQ:ULTA NASDAQ:WBA 37.119999999999997 202.46 63.45 41.78 16.8 16.46 395.8 51.62 259.87 65.17
Gain/Loss
7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 13.00 35.00 100.00 44.00 10.00 200.00 25.00 25.00 10.00 5.00 NASDAQ:AAL NASDAQ:AVGO NASDAQ: CA NAS DAQ:CSCO NYSE:FCX NASDAQ:MAT NASDAQ:NFLX NASDAQ:SBUX NASDAQ:ULTA NASDAQ:WBA 14.82000000000005 624.75 -1965 74.799999999999727 -14 -104 -1122 11.25 -237.69999999999982 9.3999999999999773 TOTAL
7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 7/1/2018 13.00 35.00 100.00 44.00 10.00 200.00 25.00 25.00 10.00 5.00 NASDAQ:AAL NASDAQ:AVGO NASDAQ: CA NASDAQ:CSCO NYSE:FCX NASDAQ:MAT NASDAQ:NFLX NASDAQ:SBUX NASDAQ:ULTA NASDAQ:WBA 482.55999999999995 7086.1 6345 1838.3200000000002 168 3292 9895 1290.5 2598.6999999999998 325.85000000000002
Current Prices
| Stock | Current Price |
| American Airlines | $ 38.26 |
Web Sources
| Resources | |
| Marketwatch | https://www.marketwatch.com/investing/stock/aal |
| Marketwatch | https://www.marketwatch.com/investing/stock/AVGO |
| Marketwatch | https://www.marketwatch.com/investing/stock/CA |
| Marketwatch | https://www.marketwatch.com/investing/stock/CSCO |
| Marketwatch | https://www.marketwatch.com/investing/stock/FCX |
| Marketwatch | https://www.marketwatch.com/investing/stock/MAT |
| Marketwatch | https://www.marketwatch.com/investing/stock/NFLX |
| Marketwatch | https://www.marketwatch.com/investing/stock/SBUX |
| Marketwatch | https://www.marketwatch.com/investing/stock/ULTA |
| Marketwatch | https://www.marketwatch.com/investing/stock/WBA |
| Kaufman Signals | https://kaufmansignals.com/trend/daily-equity-trend-sample-reports/ |
| CNN Money | https://money.cnn.com/data/us_markets/ |
| Forbes | https://www.forbes.com/sites/mitchelltuchman/2014/02/14/investing-basics-building-a-portfolio/#28b8b88353b0 |
