In this assignment you will
use the data that you collected for the Stock Market Project Part I
and you will
create charts depicting your portfolio’s performance during the tracking
weeks.
Use the following
directions as guidelines:
$Open
Stock Portfolio and create a line graph for each stock in your portfolio.
$Calculate
the Minimum and the Maximum price for each stock in your
portfolio.
$Calculate
the Average price for each stock in your portfolio.
$Next
to the Today’s Value column create a column that will state whether you
have a Gain or a Loss for each day of Trading.
$On
the Total’s Sheet create the following table: (do not write the prices,
write in the equal sign, select the worksheet point to the cell and hit
enter for both the initial investment and value at the time of sale)
|
|
|
|
|
|
|
$
|
$
|
$
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total
Amount of Gains/ Losses
|
|
|
|
$Under
the above table, create an additional table showing the following information:
(copy the data from the appropriate sheets from your portfolio)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$Create
a line graph, using the data above which will show all of your stocks performance
on the same graph.
$Decorate
and include appropriate clip art images or pictures from the Internet on
each of your pages.
$Use
a Template in Microsoft Word to write a Memo stating your learning
experiences throughout this project.Include
your thoughts on the stock market, new terminology that you learned, your
stocks, biggest winners or losers, how much money you made in total etc..
$Save
as Stock Portfolio and Print a copy of the following:
§Memo
§Sheets
1-5
§Totals
Sheet
§Formula
sheet for 1 of your stock sheets
§Formula
sheet for your Total’s page
§5
Initial printouts from the Internet showing the first day’s stock price