Then select the download data link
Please remember to save this file with your last name in the file name. For example: FIN301 Module 3 SL
STOCK 2: PRICE/RETURNS SHOULD BE INVERSELY RELATED TO STOCK 1
Company Name:
Reason for Buying (Explain how you know this
stock's price or returns are inversely or
negatively related to the economic business
cycle. In other words, this stock does better
when the economy is in a slowdown or
recession; it does worse when the economy is
in an upturn or expansion):
ALL CELLS THAT ARE HIGHLIGHTED IN YELLOW |
---|
e with your last name in the file name. For example: FIN301 Module 3 SLP Template, Doe.doc
DIRECTIONS FOR MODULE 3 - QUESTION 4
Question 4: Calculate the mean and standard deviation of the daily stock price for TWO of your required stock purcha To do this, follow these steps:
1. Go to finance.yahoo.com.Copy and Paste the downloaded data for one stock here:
2/8/2019 | 96.34 | 96.69 | 95.14 | 95.58 | 95.58 |
|
---|---|---|---|---|---|---|
2/11/2019 | 95.65 | 96.35 | 95.64 | 96.2 | 96.2 | |
2/12/2019 | 96.82 | 97.17 | 96.5 | 96.97 | 96.97 | |
2/13/2019 | 97.3 | 98 | 97.09 | 97.94 | 97.94 | |
2/14/2019 | 97.68 | 99.2 | 97.02 | 98.52 | 98.52 | |
2/15/2019 | 98.98 | 100 | 98.86 | 99.99 | 99.99 |
|
2/19/2019 |
|
104.18 | 102.07 | 102.2 | ||
2/20/2019 | 101.81 102.3399 | 98.65 | 99.33 |
of the Yahoo! Finance page. Click the
al Data” tab:
Open | High | Low | Close |
|
---|
ION 4 - STOCK 1: |
|
Open | High | Low | Close |
---|
QUESTION 6: Given the risk, what can you say about the relative expected r
can you make any conclusions about the relative risk of the two stocks?