Module 06 Excel Project - Connecting to the Web and Linking it all Together
rhariff74
Module4StockPortfoilo2.xlsxTitle
| Sharlene Portfolio |
Stock Portfolio
| ACCOUNT NAME | SYMNBOL | QUANTITY | DATE OF PURCHASE | PURCHASE PRICE | TOTAL | Current Price | Current Worth | Gain/Loss |
| American Airlines | NASDAQ:AAL | 13.00 | 7/1/18 | $37.12 | $ 482.56 | |||
| Broadcom Inc | NASDAQ:AVGO | 35.00 | 7/1/18 | $202.46 | $ 7,086.10 | |||
| CA Inc | NASDAQ: CA | 100.00 | 7/1/18 | $63.45 | $ 6,345.00 | |||
| Cisco System Inc | NASDAQ:CSCO | 44.00 | 7/1/18 | $41.78 | $ 1,838.32 | |||
| Freeport-McMoRan Inc | NYSE:FCX | 10.00 | 7/1/18 | $16.80 | $ 168.00 | |||
| Mattel Inc | NASDAQ:MAT | 200.00 | 7/1/18 | $16.46 | $ 3,292.00 | |||
| Netflix Inc | NASDAQ:NFLX | 25.00 | 7/1/18 | $395.80 | $ 9,895.00 | |||
| Starbucks Corp | NASDAQ:SBUX | 25.00 | 7/1/18 | $51.62 | $ 1,290.50 | |||
| Ulta Beauty Inc | NASDAQ:ULTA | 10.00 | 7/1/18 | $259.87 | $ 2,598.70 | |||
| Walgreens Boots Alliance | NASDAQ:WBA | 5.00 | 7/1/18 | $65.17 | $ 325.85 | |||
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
Resources
| Resources | ||
| Daily Stock Market Overview, Data Updates, Reports & News - Nasdaq_files | ||
| Daily Equity Trend Sample Reports_files | ||
| https://money.cnn.com/data/us_markets/ | ||
| Stock List - MarketWatch_files | Investing Basics_ Building A Portfolio_files | |
