Excel Stock


 

BACKGROUND

You have an imaginary $100,000 to play the stock market. Your stock package will include 5 stocks chosen from the NYSE or NASDAQ using the closing price on the date outline on your course schedule (November 1 after 4pm).

INSTRUCTIONS

Go to the YAHOO Finance website and create a portfolio of your stocks. Use Excel to create a document to post here. Your stock package in Excel must have the name of the company, the ticker symbol, the closing price per share, the number of shares purchased and the total for each stock purchased, as well as a grand total for the package.  SUBMIT A COPY to me via Blackboard here on Sunday, November 3 by noon.  You may change each original stock twice during the semester.  When you make a change, you MUST send an e-mail to me immediately about your change and get a confirmation that I received your change.  Your change must state which stock you are selling, the selling price multiplied by the original number of purchased shares, and the total sale.  This total sale amount is what must be invested in your next stock purchase.

You should also have all the required information on the stock you are purchasing with the closing price divided by the total stock sale amount from the original stock.  You must save a copy of your stock package before changes and after changes and submit them to me. I must have copies of all transactions! Until you confirm it with me, you have not changed your stock package. Final choice date is November 17.  You must save a copy of your Yahoo Finance stock package with the calculated value of your stock at the December 1 2023 closing price, update your Excel file, and submit to me via Blackboard by noon on December 3, 2023. If the value of your stock is greater than $100,000, you get the extra dollars gained as extra points up to $50,000. 

SUBMISSION

Submit your Excel file containing the five selected stocks with complete information.

Another assignment will be added correlating to this one!!! Please use same information with some details are mention above.