Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use real data at finance.yahoo.com. Choose assets that should have offered a good risk/return profile over the past three years when paired with a market

Use real data at finance.yahoo.com. Choose assets that should have offered a good risk/return profile over the past three years when paired with a market proxy, SPY. Then download 5 years of weekly data for each, and calculate the weekly returns, correlations, and weekly standard deviation of the two-asset portfolio, as well as the beta of the asset you chose. You can choose a 50/50 weighting, or else run various combinations in Excel to optimize.

Post your Excel sheet with your calculations and results, along with a short description:

  • What made you choose the asset you chose?
  • Did you find any challenges in downloading the data or performing the calculations?
  • What was the ratio of weekly returns to weekly standard deviation over the five-year period?

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

Step: 3

blur-text-image

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

Offshore Finance And State Power

Authors: Andrea Binder

1st Edition

0192870122, 978-0192870124

More Books

Students also viewed these Finance questions