+ Reply to Thread
Results 1 to 4 of 4

solver problem with Stock portfolio- two constraints collides

  1. #1
    Registered User
    Join Date
    04-17-2021
    Location
    israel
    MS-Off Ver
    2016
    Posts
    2

    solver problem with Stock portfolio- two constraints collides

    Hi,
    I am trying to optimize the stock portfolio.
    I have 12 stocks and I need to choose between 4-8 stocks to the portfolio.
    But, The weights of the stocks will be between 0.1 to 0.4.

    How can I make the solver choose 4-8 stocks with the constraint of the weights will be at least 0.1 ? That it will be zeros in some wieghts who don't in the portfolio.

    I have the constraints:
    3. the constraints for choose between 4-8 socks with the binary variables.
    4.The sum of the variable represent the weights will be 1
    5. The variable represent the weights will be Small equal to the binary variables- I thought that will be help for fill zeros in the stocks that don't int the portfolio.

    Thank you for the help.
    Last edited by lirongr1996; 04-17-2021 at 04:43 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,884

    Re: solver problem with Stock portfolio

    This appears to be a homework assignment.

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    04-17-2021
    Location
    israel
    MS-Off Ver
    2016
    Posts
    2

    Re: solver problem with Stock portfolio

    Hi, I genuinely interesting in receive help in the form of tutoring or coaching, I don't want to cheat.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,884

    Re: solver problem with Stock portfolio- two constraints collides


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Solver problem. Portfolio Optimization.
    By Keltamustat in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 02-10-2019, 03:17 PM
  2. Markowitz Optimal Portfolio - Excel Solver problem
    By steve.nam in forum Excel General
    Replies: 1
    Last Post: 03-29-2015, 06:00 PM
  3. Solver: Optimal Portfolio
    By leviathan86 in forum Excel General
    Replies: 3
    Last Post: 11-20-2013, 06:20 PM
  4. Problem Using Solver with an optimization stock problem
    By Jagrubski in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2013, 03:41 AM
  5. Stock Portfolio Formula
    By WilsonsKM in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-18-2013, 12:56 PM
  6. Stock Portfolio Analysis
    By cgurr1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-27-2008, 09:06 PM
  7. Charting a stock portfolio
    By robertkbrown in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-12-2007, 03:07 PM

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