Four Stock Portfolio and Graphing Efficient Portfolio Frontier

  Рет қаралды 94,047

Yong Jin Park

Yong Jin Park

Күн бұрын

Пікірлер: 31
@eumatheusmalheiros
@eumatheusmalheiros 11 ай бұрын
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!
@eegpas
@eegpas 2 жыл бұрын
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
@gantuyadorj6773
@gantuyadorj6773 3 жыл бұрын
THANK YOU SO MUCH!!! video was so easy to understand, and absolutely useful!!!
@mansionally
@mansionally Ай бұрын
Was the solution found, as I'm having same issue here@30:00. Please advise:)
@marajohnson1056
@marajohnson1056 9 ай бұрын
When I try to use the ctrl + shift + enter it only gives me #value! What do I do in this case?
@faizanadnan1870
@faizanadnan1870 3 ай бұрын
What is the meaning of getting negative sharp ratio?
@brooke5587
@brooke5587 2 ай бұрын
Love from Brazil 🇧🇷
@쉿-h3c
@쉿-h3c Жыл бұрын
3:40 아... 이 식을 벡터로 변환하는 거군여! 저의 교과서에는 리스크 방정식 설명이 없어서 이해하기 어려웠어요ㅠ 감사합니다!
@KajalMatheJaipuriaIndore
@KajalMatheJaipuriaIndore 3 ай бұрын
kindly drop the excel sheet
@suriyanarayananr9652
@suriyanarayananr9652 4 ай бұрын
@psycho.. Just 4 stocks uh..? Not 11. Serii.. adula max percentage perform panniruka top 4 eduthukava..?
@martinpule9616
@martinpule9616 11 ай бұрын
Good job, however, the video seems incomplete. Where can we get the next one?
@yongjinpark9991
@yongjinpark9991 11 ай бұрын
Thanks. Here is the link to the second part: kzbin.info/www/bejne/Y4eXnYmsnpqfgpI
@martinpule9616
@martinpule9616 11 ай бұрын
@@yongjinpark9991 thank you. where do we put the risk, the Y axis or the X axis?
@sjsphotog
@sjsphotog 6 ай бұрын
​​@@martinpule9616 - you need to put the risk on the horizontal x-axis and the return rate on the vertical y-axis
@donaldrocky296
@donaldrocky296 3 жыл бұрын
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?
@SolomonMumo
@SolomonMumo 3 жыл бұрын
Hey Donald, did you figure it out? I am facing a similar problem. Thanks
@devanshutayal4586
@devanshutayal4586 3 жыл бұрын
@@SolomonMumo Check your upper and lower average return of stocks, are they very close?
@jhevarnsurajpal6423
@jhevarnsurajpal6423 2 жыл бұрын
@@devanshutayal4586 hey man yes they are really close like 0.0004 off
@dontletmebrown
@dontletmebrown 2 жыл бұрын
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
@mansionally Ай бұрын
Was the solution found, as I'm having same issue here. Please advise:)
@silentkillz
@silentkillz 3 жыл бұрын
This is wrong as you are using weekly data and not annualised your returns nor the variance
@davidtuckwell5786
@davidtuckwell5786 2 жыл бұрын
Yeah this video is wrong.
@eyyubb
@eyyubb 2 жыл бұрын
Is it really necessary to annualize the returns and volatility?
@earningthomas4640
@earningthomas4640 2 жыл бұрын
Please explain why the data needs to be annualized
@lawrenceobioma
@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-wr5oc
@gamelover-wr5oc 11 ай бұрын
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.
@vivieriyantika8053
@vivieriyantika8053 3 жыл бұрын
7.00
@joaosantos5203
@joaosantos5203 Жыл бұрын
croca
@lukejackson5863
@lukejackson5863 Жыл бұрын
you never graphed the frontier my guy
@yongjinpark9991
@yongjinpark9991 11 ай бұрын
Here is the link to the second part: kzbin.info/www/bejne/Y4eXnYmsnpqfgpI
Efficient Frontier and Portfolio Optimization Explained | The Ultimate Guide
13:05
Ryan O'Connell, CFA, FRM
Рет қаралды 12 М.
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
Modern Portfolio Theory Explained!
16:31
QuantPy
Рет қаралды 88 М.
The Dome Paradox: A Loophole in Newton's Laws
22:59
Up and Atom
Рет қаралды 956 М.
Portfolio Optimization in Excel: Step by Step Tutorial
15:26
Ryan O'Connell, CFA, FRM
Рет қаралды 57 М.
Efficient Portfolio Frontier explained: Solver (Excel)
28:00
Efficient Frontier Explained in Excel: Plotting a 3-Security Portfolio
14:43
Ryan O'Connell, CFA, FRM
Рет қаралды 31 М.
The Power of Modern Portfolio Theory: From Risk To Reward
16:43
PensionCraft
Рет қаралды 28 М.
Portfolio Optimization using five stocks in excel | FIN-ED
17:36
Plotting Efficient Frontier for Four Securities in Excel
15:38
Ronald Moy, Ph.D., CFA, CFP
Рет қаралды 10 М.
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41