Part 3 Stock Challenge

1
Stock Challenge Directions Part 3 Shop For
StocksDo you feel lucky !!!

• Choose 5 companies from the stock market to
  invest your 10,000 gift. They must be publicly
  traded on NYSE.
• Use the link to the NYSE to search for company
  symbols.
• Use the links under Subsector to choose the
  types of businesses you would like to invest in.

2

• Use the Symbol column to get their call letters
  for your Excel chart and the Last Trade column
  for the price per share you will pay.

3

• In cells A5, A6, A7, A8, and A9 record the call
  letters for your 5 companies.
• In B5, B6, B7, B8, and B9 record todays date when
  you picked each company using the MM/DD/YYYY
  format.

4

• Record the Purchase price for each company
  shares in D5, D6, D7, D8, and D9 by going to the
  links where you found your company.

5

• In cells C5, C6, C7, C8, and C9 select the number
  of shares you would like to buy. Keep an eye on
  cell H1 as you do this. You may not let the
  number in that cell go below 0. Get as close to 0
  as possible by adjusting your shares. If it turns
  red, you must decrease your shares of stock until
  it is a positive number.
• Ignore what happens in H5 through H11 that will
  fix itself in the next directive.

6

• Retrieve External Data
• Select cell A14
• Under the DATA tab, in the Get External Data
  section select Existing Connections, MSN
  MoneyCentral Investor Stock Quotes.

7

• When the Import Data box appears, it should say
  A14
• If it does, click the Properties tab in the lower
  left and also check the Refresh Control section
  box for Refresh every and change the number from
  60 minutes to 1 minute. Then, click OK.

8

• When the Enter Parameter Value box appears, use
  your mouse to select cells A5 through A9.
• The formula Stocks!A5A9 should
  appear in the box (another way would be to type
  each companies symbols and separate each with a
  comma and a space.

• Check the box below it that says Use this value/
  reference for future refreshes, then click OK.

9
Your spreadsheet should now look something like
this.
10

• Select cell F5. Type the sign and then click
  the price for that company in the column that
  says Last in the chart that just appeared (now
  F5 should read D17 in the fx formula
  bar.

11

• If it does, smart copy and paste this formula
  from F6 through F9. Fix the fill colors that
  change as a result of this.

12
Dont forget to autosize your columns 1 last
time. You should now have a file that looks like
this
Save your file in your H drive Email to your
instructor. Be sure to follow business email
protocol.
Every once in a while, you might be curious and
want to open the file and see how your stocks are
doing. It is fully automated now and will give
you new totals every time you open it. On exam
day, lets see who made the most.