Financial Markets and Institutions (2-downloads)

14

Part 1 Introduction

W E B   E X E R C I S E S

Working with Financial Market Data

1. In this exercise we will practice collecting data from

the Web and graphing it using Excel. Use the exam-

ple on pages 10–12 as a guide. Go to 

www.forecasts

.org/data/index.htm

, click on “Data” at the top of the

page, click on “Stock Index Data,” and choose the

“U.S. Stock Indices—Monthly” option. Finally, choose

the “Dow Jones Industrial Average” option.

a. Using the method presented in this chapter, move

the data into an Excel spreadsheet.

b. Using the data from step a, prepare a chart. Use

the Chart Wizard to properly label your axes.

2. In Web Exercise 1 you collected and graphed the Dow

Jones Industrial Average. This same site reports fore-

cast values of the DJIA. Go to