Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am trying to use solver in excel to find the max sharpe ratio for a portfolio of 5 stocks. I need to somehow set

I am trying to use solver in excel to find the max sharpe ratio for a portfolio of 5 stocks. I need to somehow set a constraint where the weights of all five stocks still add up to 1.

How would I set a constraint of this nature? I have been unable to enter weight1+weight2+weight3+weight4+weight5=1. Is there a way to do this? or another solution.

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

Fundamentals Of Multinational Finance

Authors: Michael H. Moffett, Arthur I. Stonehill, David K. Eiteman

3rd Edition

0321541642, 9780321541642

More Books

Students also viewed these Finance questions