Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Purpose of the homework: 1 . Students will learn the composition of Dow Jones Industrial Average ( DJIA ) 2 . Students can learn how
Purpose of the homework:
Students will learn the composition of Dow Jones Industrial Average DJIA
Students can learn how this bluechip stock index is calculated.
Assignment:
This is an easy warmup exercise. From the Market Lineup of the Wall Street Journal Page C you can find the Dow components. When you add up the net point change of the day and divide the sum by the Divisor as of you should get the change in the DJIA for that day. Please make sure that you use the current divisor in the calculation.
The assignment asks you to obtain the closing prices for two consecutive days for each stock in the Dow You then calculate the DJIA for each day by adding up the prices of all components and dividing the sum by the Divisor. Next, you calculate the price change for each stock and add up the price changes and divide the sum by the Divisor. The result should be the change in the DJIA for these two days. You also need to collect the actual closing DJIA for these two days and compare with the result of your calculation.
You should choose any two consecutive days. You are advised to use the sample spreadsheet for this assignment.
Information Source:
You can obtain the components and historical indices of the Dow DJIA from the Yahoo Finance website. To get the prices of the Dow components, you should go to the summary page of the Dow DJIA You can find the Components on the left menu. Once you are on the component page, you can download the prices of all components to a spreadsheet by clicking on the Download button. Remember to do it after the end of market so you can get the closing prices.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started