Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the Reuters EIKON terminal, download the daily historical prices ( adjusted for dividend payments and stock splits ) of two companies from the same

Using the Reuters EIKON terminal, download the daily historical prices (adjusted for dividend payments and stock splits) of two companies from the same country last five years (December,2018 November 2023). In an Microsoft Excel sheet,
a) Calculate the daily percentage returns (R =(P1 P0)/P0).
b) Calculate the daily logarithmic returns for each stock (R = log(P1/P0).
c) Calculate the standard deviation of daily returns (that you calculated in part b) for each stock.
d) Calculate the covariance and the correlation coefficient between these two stocks.
e) Form ten different portfolios using the following weights and the correlation coefficients that you have calculated in part d:
weight of the first stock ={1,0.9,0.8,0.7,0.6,0.5,0.4,0.3,0.2,0.1,0}
weight of the second stock ={0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1}
f) Plot the expected return and standard deviation of each portfolio that you have calculated in part f
g) Repeat the exercises in part e and f by assuming that the correlation between the two stocks is equal to 1
h) Repeat the exercises in part e and f by assuming that the correlation between the two stocks is equal to -1.
Make sure the graphs that you have constructed in part f, g, and h are on the same plot.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Futures And Options Market

Authors: John C. Hull

6th Edition

0132242265, 9780132242264

More Books

Students also viewed these Finance questions

Question

Describe five organizational development techniques.

Answered: 1 week ago

Question

Explain the two dimensions of an organizations culture.

Answered: 1 week ago

Question

State why people resist change and how to overcome resistance.

Answered: 1 week ago