Question: Can one calculate weekly returns without adj close values. I am given an excel file with date and bunch of data. The title of each

Can one calculate weekly returns without adj close values. I am given an excel file with date and bunch of data. The title of each column is date, and 1 till 30. Normally for to calculate any returns , we should have open, high, low, close, adj close and volume. However in this case, I was only given date and some data with headings from 1 till 30

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

MINICASE 1 You need to show your working notes in excel for credit. You must submit your work using excel files (with .xls or .xlsx for credit). This assignment will require you to analyze time...

Q:

This assignment will require you to analyze time series of monthly returns. Start by retrieving MONTHLY data for the period of 01/01/2015 - 12/31/2017 from Yahoo website for S&P 500 Index (ticker:...

Q:

This assignment will require you to analyze time series of monthly returns. Start by retrieving MONTHLY data for the period of 01/01/2015 - 12/31/2017 from Yahoo website for S&P 500 Index (ticker:...

Q:

This assignment will require you to analyze time series of monthly returns. Start by retrieving MONTHLY data for the period of 08/01/2015 08/31/2019 from Yahoo website for S&P 500 Index (ticker:...

Q:

his assignment will require you to analyze time series of monthly returns. Start by retrieving MONTHLY data for the period of 01/01/2015 08/31/2018 from Yahoo website for S&P 500 Index (ticker:...

Q:

Download the monthly Adjusted Closing Price for Target Corp. (Ticker = TGT) and S&P 500 (ticker = ^GSPC) from Yahoo website from January 1,2014 to December 31, 2017 and calculate following: Average...

Q:

This assignment will require you to analyze time series of monthly returns.Start by retrieving MONTHLY data for the period of 08/01/2015 - 08/31/2019 from Yahoo website for S&P 500 Index (ticker:...

Q:

Download the monthly Adjusted Closing Price for Target Corp. (Ticker = TGT) and S&P 500 (ticker = ^GSPC) from Yahoo website from January 1, 2014 to December 31, 2017 and calculate following: Average...

Q:

Download the monthly Adjusted Closing Price for Target Corp. (Ticker = TGT) and S&P 500 (ticker = ^GSPC) from Yahoo website from January 1, 2014 to December 31, 2017 and calculate following: Average...

Q:

Download the monthly Adjusted Closing Price for Target Corp. (Ticker = TGT) and S&P 500 (ticker = ^GSPC) from Yahoo website from January 1, 2014 to December 31, 2017 and calculate following: Average...

Q:

3) Please briefly compare elaborated and restricted codes. Support your discussion with relevant examples. (Min. 150 words) 30 pts.

Q:

(a) If you have a fever, is the wavelength of the radiation component of maximum intensity emitted by your body (1) greater, (2) the same, or (3) smaller as compared with its value when your...

Q:

4. Find the unknown value in each of the following pairs of similar solids. (a) 6 cm 48 cm' 2 cm. (b) (c) (d) a cm 16 cm 6 cm 54 cm bcm 80 m cm 7 m 10 m dm 20 m 15 m 540 m

Q:

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

Q:

List the main decision areas and concepts in employee compensation management. page 457

Q:

Describe the major administrative tools used to manage employee compensation. page 461

Q:

Explain where the United States stands from an international perspective on pay issues. page 477