Module 06 Excel Project - Connecting to the Web and Linking it all Together
Gladiola
gtyo_module4_portfolio.xlsxSheet1
| Stock Name | Symbol | No of Stock | Date Purchased | Purchase Price | Initial Price Paid | Current Price | Current Worth | Gain/Loss |
| Alibaba | BABA | 90 | September 9, 2014 | $93.81 | $8,442.90 | $191.50 | $17,235.00 | $8,792.10 |
| Amazon | AMZN | 58 | February 20, 2013 | $266.41 | $15,451.78 | $1,484.42 | $86,096.36 | $70,644.58 |
| FB | 48 | February 20, 2013 | $28.46 | $1,366.08 | $178.24 | $8,555.52 | $7,189.44 | |
| Ford | F | 18 | February 20, 2013 | $12.60 | $226.80 | $10.61 | $190.98 | ($35.82) |
| Gooogle | GOOGL | 44 | February 20, 2013 | $400.31 | $17,613.51 | $1,117.88 | $49,186.72 | $31,573.21 |
| Intel | INTC | 85 | February 20, 2013 | $20.73 | $1,762.05 | $46.44 | $3,947.40 | $2,185.35 |
| Mosaic | MOS | 70 | February 20, 2014 | $48.37 | $3,385.90 | $27.85 | $1,949.50 | ($1,436.40) |
| Netflix | NFLX | 77 | February 20, 2014 | $62.13 | $4,784.01 | $283.75 | $21,848.75 | $17,064.74 |
| Tesla | TSLA | 32 | February 20, 2013 | $38.54 | $1,233.28 | $334.77 | $10,712.64 | $9,479.36 |
| Walmart | WMT | 50 | February 20, 2014 | $73.52 | $3,676.00 | $92.90 | $4,645.00 | $969.00 |
| TOTAL | $57,942.31 | $204,367.87 | $146,425.56 |
Chart
Price per Stock
Initial Price Paid September 9, 2014 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2014 February 20, 2014 February 20, 2013 February 20, 2014 90 58 48 18 44 85 70 77 32 50 BABA AMZN FB F GOOGL INTC MOS NFLX TSLA WMT Alibaba Amazon Facebook Ford Gooogle Intel Mosaic Netflix Tesla Walmart 8442.9 15451.78 1366.08 226.79999999999998 17613.5124 1762.05 3385.8999999999996 4784.01 1233.28 3676 Current Worth September 9, 2014 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2014 February 20, 2014 February 20, 2013 February 20, 2014 90 58 48 18 44 85 70 77 32 50 BABA AMZN FB F GOOGL INTC MOS NFLX TSLA WMT Alibaba Amazon Facebook Ford Gooogle Intel Mosaic Netflix Tesla Walmart 17235 86096.36 8555.52 190.98 49186.724400000006 3947.3999999999996 1949.5 21848.75 10712.64 4645 Purchase Price September 9, 2014 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2014 February 20, 2014 February 20, 2013 February 20, 2014 90 58 48 18 44 85 70 77 32 50 BABA AMZN FB F GOOGL INTC MOS NFLX TSLA WMT Alibaba Amazon Facebook Ford Gooogle Intel Mosaic Netflix Tesla Walmart 93.81 266.41000000000003 28.46 12.6 400.30709999999999 20.73 48.37 62.13 38.54 73.52 Current Price September 9, 2014 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2014 February 20, 2014 February 20, 2013 February 20, 2014 90 58 48 18 44 85 70 77 32 50 BABA AMZN FB F GOOGL INTC MOS NFLX TSLA WMT Alibaba Amazon Facebook Ford Gooogle Intel Mosaic Netflix Tesla Walmart 191.5 1484.42 178.24 10.61 1117.8801000000001 46.44 27.85 283.75 334.77 92.9 Gain/Loss September 9, 2014 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2013 February 20, 2014 February 20, 2014 February 20, 2013 February 20, 2014 90 58 48 18 44 85 70 77 32 50 BABA AMZN FB F GOOGL INTC MOS NFLX TSLA WMT Alibaba Amazon Facebook Ford Gooogle Intel Mosaic Netflix Tesla Walmart 8792.1 70644.58 7189.4400000000005 -35.819999999999993 31573.212000000007 2185.3499999999995 -1436.3999999999996 17064.739999999998 9479.3599999999988 969
