I have everything set up the same way, but when I use solver it just sets my weights to 100% and 0% because it just selects the stock with the smaller variance and puts 100% of the weight in that. Any idea where I could be going wrong?
Don't know if it's still relevant, but it might be because the stocks you chose are highly correlated, so it's just better for Excel to only put the weight into the stock with the lowest idiosyncratic variance. If you specify a certain (higher) amount of expected portfolio return you want to generate and use that as a constraint in Solver, it might put more weight into other stocks too.
I'd like to say that even after 5 years, this video is still relevant and helpful. Thank You.
you are a very kind person sharing your knowledge with the world for free. Do you have an example of your series of videos with 3+ assets?
Yeah sir. I would like to watch it too :)
Thank you for teaching new concept of solver, It really reduce my lot of efforts.
Hey, the excel file is unavailable, can you please provide a new link?
I have tried to follow the exact steps using different stocks and a larger data set however the frontier is not curved what would you recommend I do.
thank you for your video. it really help me in completing my assignment. if you have extra time can you make a video on optimal risky portfolio?
dude...you are saving my ass with these videos
mine says that solver found a solution but the values in the boxes dont change from 50%?
how to do it with 4 stocks..?
hi can you help me make efficient frontier curve for 10 stocks
This is very helpful. Thank you
please continue share those awesome video .Thank you
Can Minimum Variance Portfolio be linear ?
Its the best video !!!!
I have everything set up the same way, but when I use solver it just sets my weights to 100% and 0% because it just selects the stock with the smaller variance and puts 100% of the weight in that. Any idea where I could be going wrong?
Andrew Raspolich I’m having the same issue, do you know how to fix?
Don't know if it's still relevant, but it might be because the stocks you chose are highly correlated, so it's just better for Excel to only put the weight into the stock with the lowest idiosyncratic variance. If you specify a certain (higher) amount of expected portfolio return you want to generate and use that as a constraint in Solver, it might put more weight into other stocks too.
Really helpful and really clear - thanks for the upload.
THANK YOU SO MUCH FOR THESE VIDEOS.
i dont onderstand the returns. why are they minus when theyre going up
thank you for the clear explanation.
Thank you!!
Thank you very much
Really helpful.
thank u, bless u!
Thank You :)