Instructions for final day of Stock Market Activity

Today we will finish out our Stock Market Activity.  You should have 6-7 day of prices to create a trend of your 10 chosen stocks.  Today we will complete day 6-7 of new prices, net worth, and profit or loss. 

Today we will insert 4 graphs that will hopefully show you a trend of what your stock prices did over a period of time.  You will insert 2 line graphs, a column graph, and a bar chart.

The first graph will be a Stack line chart with Markers.  You will choose two of your stocks and create a line chart that shows their price trend over your 6-7 days of data.  To do this you click on the first stock you want and then hold down the CONTROL  key and click on each days price going across your data (from the original price to your last days price) and then do the same thing for your second choice.  This should highlight all of the information for those two stocks.  You will title this chart Seven Day Price Trend.

Your next graph will be a 2D or 3D bar chart.    In this graph you will Highlight all 10 of your stocks then hold the control key down and then highlight each of the price columns from top to bottom.  Then insert a 2D or 3D graph and change the name to Seven Day Price Trend.

Your next graph will be a Column Graph.  You will follow the same instructions as the bar chart for this graph.

The final graph will be a line chart that show the trend of your profit or loss.  You will click on the Word Total in col B then hold down the control key and click on each of your profit or loss totals and insert the graph below the first three.  Title this loss Profit/Loss Trend.

Turn in lesson on Google Classroom under Assignment title Final Stock Market Activity.