Module 06 Excel Project - Connecting to the Web and Linking it all Together

profileGladiola
Gtyo_Mdole2_SpreasheetPlanningandWebDataSources.xlsx
Home>Human Resource Management homework help>Module 06 Excel Project - Connecting to the Web and Linking it all Together

Sheet1

Stock Name Symbol No of Stock Date Purchased Purchase Price Initial Price Paid Current Price Current Worth Gain/Loss
Amazon AMZN 58 February 20, 2013 $266.41 $15,451.78 $1,484.42 $86,096.36 $70,644.58
Gooogle GOOGL 44 February 20, 2013 $400.31 $17,613.51 $1,117.88 $49,186.72 $31,573.21
Ford F 18 February 20, 2013 $12.60 $226.80 $10.61 $190.98 ($35.82)
Intel INTC 85 February 20, 2013 $20.73 $1,762.05 $46.44 $3,947.40 $2,185.35
Tesla TSLA 32 February 20, 2013 $38.54 $1,233.28 $334.77 $10,712.64 $9,479.36
Facebook FB 48 February 20, 2013 $28.46 $1,366.08 $178.24 $8,555.52 $7,189.44
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
Walmart WMT 50 February 20, 2014 $73.52 $3,676.00 $92.90 $4,645.00 $969.00
Alibaba BABA 90 September 9, 2014 $93.81 $8,442.90 $191.50 $17,235.00 $8,792.10
TOTAL $57,942.31 $204,367.87 $146,425.56

Sources

Web Data Sources
1 Stock Screener
https://finviz.com/
2 Historical Quotes
https://www.nasdaq.com/
3 Stock Market
http://finance.yahoo.com/
4 Finance
https://finance.google.com/
5 Stocks
https://www.zacks.com/
https://www.nasdaq.com/ https://www.nasdaq.com/symbol/mos/historical https://finance.google.com/ https://finviz.com/ https://www.zacks.com/