Results 1 to 11 of 11

SOLVER does not change inputs!

Threaded View

brunojacko SOLVER does not change inputs! 03-08-2017, 12:09 PM
MrShorty Re: SOLVER does not change... 03-08-2017, 12:40 PM
brunojacko Re: SOLVER does not change... 03-08-2017, 01:36 PM
Alf Re: SOLVER does not change... 03-08-2017, 01:45 PM
brunojacko Re: SOLVER does not change... 03-08-2017, 01:54 PM
MrShorty Re: SOLVER does not change... 03-08-2017, 01:46 PM
brunojacko Re: SOLVER does not change... 03-08-2017, 01:56 PM
brunojacko Re: SOLVER does not change... 03-08-2017, 02:22 PM
MrShorty Re: SOLVER does not change... 03-08-2017, 02:08 PM
MrShorty Re: SOLVER does not change... 03-08-2017, 02:26 PM
brunojacko Re: SOLVER does not change... 03-08-2017, 03:47 PM
  1. #1
    Registered User
    Join Date
    03-17-2016
    Location
    belgium
    MS-Off Ver
    2013
    Posts
    25

    SOLVER does not change inputs!

    Good day everyone.

    As part of a portfolio strategy, I need to determine the optimal weights in order to maximize the sharpe ratio.
    In order to do that, I want to make use of SOLVER.
    When I do this, the SOLVER acts like it's giving a solution but nothing changes to the portfolio weights.
    Does this have something to do with the "complexity" of some functions on which the sharpe ratio is based?
    These are partly based on IF functions.

    Please find my excel file attached.
    The sheet to look at is "Momentum Signals".
    There you can find the weights and sharpe ratio.
    What I did to maximize is:
    - set objective: $H$3
    - by changing variables cells: $C$3:$F$3
    No matter what solving method I choose, it does not solve!!

    I would greatly appreciate any help. Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change the Validation contents as per the given inputs
    By Sekars in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-10-2016, 11:41 PM
  2. [SOLVED] change triangle size by cell inputs
    By riz4u in forum Excel Charting & Pivots
    Replies: 17
    Last Post: 04-12-2016, 10:22 AM
  3. Change Input - Recalculate - Paste Results for all Inputs Separately
    By RiteshChaturvedi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2013, 09:57 AM
  4. Can't get Solver to work in a function (taking inputs and returning value)
    By VBAFinance in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2010, 04:06 PM
  5. Automation of Solver: Must inputs be derived from cells?
    By HammerTime in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-20-2010, 09:17 PM
  6. Replies: 8
    Last Post: 11-30-2009, 10:02 PM
  7. [SOLVED] Re-run solver when some inputs change
    By Bojana in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1