thank you so much for this class, instead of trying it with a 4 or less securities portfolio, i tried it with a 29 stocks portfolio and it worked!
@eegpas2 жыл бұрын
You didn't need to make each asset Percent >0 in constraints, there is a click box which is activated to avoid negative asset percentages
@gantuyadorj67733 жыл бұрын
THANK YOU SO MUCH!!! video was so easy to understand, and absolutely useful!!!
@mansionallyАй бұрын
Was the solution found, as I'm having same issue here@30:00. Please advise:)
@marajohnson10569 ай бұрын
When I try to use the ctrl + shift + enter it only gives me #value! What do I do in this case?
@faizanadnan18703 ай бұрын
What is the meaning of getting negative sharp ratio?
@brooke55872 ай бұрын
Love from Brazil 🇧🇷
@쉿-h3c Жыл бұрын
3:40 아... 이 식을 벡터로 변환하는 거군여! 저의 교과서에는 리스크 방정식 설명이 없어서 이해하기 어려웠어요ㅠ 감사합니다!
@KajalMatheJaipuriaIndore3 ай бұрын
kindly drop the excel sheet
@suriyanarayananr96524 ай бұрын
@psycho.. Just 4 stocks uh..? Not 11. Serii.. adula max percentage perform panniruka top 4 eduthukava..?
@martinpule961611 ай бұрын
Good job, however, the video seems incomplete. Where can we get the next one?
@yongjinpark999111 ай бұрын
Thanks. Here is the link to the second part: kzbin.info/www/bejne/Y4eXnYmsnpqfgpI
@martinpule961611 ай бұрын
@@yongjinpark9991 thank you. where do we put the risk, the Y axis or the X axis?
@sjsphotog6 ай бұрын
@@martinpule9616 - you need to put the risk on the horizontal x-axis and the return rate on the vertical y-axis
@donaldrocky2963 жыл бұрын
At the point in your video at around 32:00 I’m adding the constraint which increasing the increments while minimizing risk, but when I solve the Return, risk and Portfolio Std. Dev does not change. I have tried different combinations of increments and no luck. I am again using a portfolio of about 25 stocks. What could I be doing wrong?
@SolomonMumo3 жыл бұрын
Hey Donald, did you figure it out? I am facing a similar problem. Thanks
@devanshutayal45863 жыл бұрын
@@SolomonMumo Check your upper and lower average return of stocks, are they very close?
@jhevarnsurajpal64232 жыл бұрын
@@devanshutayal4586 hey man yes they are really close like 0.0004 off
@dontletmebrown2 жыл бұрын
When I try to add constraints he does at 29:45 I get an error saying solver could not find a feasible solution. Any fix for this?
@mansionallyАй бұрын
Was the solution found, as I'm having same issue here. Please advise:)
@silentkillz3 жыл бұрын
This is wrong as you are using weekly data and not annualised your returns nor the variance
@davidtuckwell57862 жыл бұрын
Yeah this video is wrong.
@eyyubb2 жыл бұрын
Is it really necessary to annualize the returns and volatility?
@earningthomas46402 жыл бұрын
Please explain why the data needs to be annualized
@lawrenceobioma Жыл бұрын
@@earningthomas4640 You do not need to annualize the returns, the calculation can be done on different timeframes and just has to be based off the calculation of that timeframe. Silentkills is wrong and the video creator is right.
@gamelover-wr5oc11 ай бұрын
the correct result is that if you use weekly return, you must use everything in weekly. in my view, you should better you daily, like daily return, daily variance, daily risk free rate.
@vivieriyantika80533 жыл бұрын
7.00
@joaosantos5203 Жыл бұрын
croca
@lukejackson5863 Жыл бұрын
you never graphed the frontier my guy
@yongjinpark999111 ай бұрын
Here is the link to the second part: kzbin.info/www/bejne/Y4eXnYmsnpqfgpI