1 / 31

STOCK MARKET GAME

STOCK MARKET GAME. CREATING YOUR STOCK MARKET GRAPHS. Building Your Graphs with Excel. Log on to the SMG using your User Name and Password. Click on the Investor Research link in the blue TRADING menu. Type in the Ticker for the Stock you are interested in looking up and click GO.

marva
Download Presentation

STOCK MARKET GAME

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. STOCK MARKET GAME CREATING YOUR STOCK MARKET GRAPHS

  2. Building Your Graphs with Excel • Log on to the SMG using your User Name and Password

  3. Click on the Investor Research link in the blue TRADING menu.

  4. Type in the Ticker for the Stock you are interested in looking up and click GO

  5. Double Click on the Graph to enlarge.

  6. Change the Time Frame to 2 months so you can view the weeks of the SMG 10/2/06 – 12/08/06. • Change the Frequency to weekly.

  7. READING THE GRAPH • Looking at the first bar on the graph (Oct), move your finger up to find the X axis of the graph. • Then move your finger across to the right to find the close price located on the right. (This price is the Y axis for 10/6/06.) • Follow this same procedure for each bar to fill in your Excel Spreadsheet for 10/2/06 – 12/08/06.

  8. MAKING YOUR GRAPH IN EXCELAfter you fill in all of your closing prices, you will need to create your graph. • Click on the first close price. • While having this selected, hold down shift and click on your last close price which will highlight/select all of your closing prices. • Then click on insert chart. • Click on the Line chart type. • Click Next.

  9. Click on the Series tab. • Click on the right side of the Name box. • Click on the cell that has the name of your stock. • Click on the right side of the Source Data: Name to return back to your graph.

  10. Click to the right of the Category (X) axis labels. • Click on week 1, hold down the Shift key, and then select week 9 to select weeks 1-9.

  11. Click on the right of the Chart Wizard – Step 2 of 4 – Chart Source Data – Category (X) to return back to your graph.

  12. Click Next • Type in the Chart Title • Johnson & Johnson (JNJ) 10/02/06 – 12/08/06 • Type in the Category (X) axis: • Week # • Type in the Value (Y) axis: • Closing Prices

  13. Click Next. • Click Finish.

  14. Click File and Click Save As • Click on your H drive • Change the File Name to: SMG Graphs • Save • Click on your graph to select. • Click File and Click Print • Create a cover sheet in Word with the name of your group members. • Staple your Cover Sheet and all of your graphs together and turn in!

More Related