Graphing the efficient frontier for a two-stock portfolio in Excel
HTML-код
- Опубликовано: 29 авг 2024
- Shows how to download returns for two stocks, calculate mean, variance and standard deviations for various portfolios of the two stocks, and draw the efficient frontier in Excel.
Some good books on Excel and Finance:
Financial Modeling - by Benninga:
amzn.to/2tByGQ2
Principles of Finance with Excel - by Benninga:
amzn.to/2uaCyo6
This guy basically condenses a 3-hour Investment I had yesterday class into 12 minutes! Thank you!
رماده خلب مناخ الاستثمار فى مصر فى الفترة القادمة ستشهد من خلال الرابط التالي من قبل لا انام بس من غير حساب في كل من غاب عني و لا قوة إلا هو الحي القيوم و اتوب اليك من خلال الرابط التالي في هذه الدنيا سوى أن تكون في كل من قال قبل لا
ركلات الترجيح في هذه الحياة الدنيا وفي الآخرة حسنة و قنا عذاب الله يا مصر من أجل أن ذلك لم يكن من الممكن من كل شر يارب لا تحرمني من تعلقت به وهو لا يصلي في الحياة ٧ فقع في كل مكان و لا قوة إلا بالله العلي ف كل ٦٧٦٨ على أن يتم الانتهاء منه و ما ٨٦٨٦٨ في كل من قال ان يكون في
متتمتتمتانافتقاللتلتللتابالتلبناعمتغمنانم منتجة امواتنا واموات المسلمين من كل شر يارب يارب يارب لا تجعل الدنيا اكبر همنا من قال ان يكون في عون العبد في جوف صدري
this guy has explain in a very well and efficient manner as he was teaching and efficient curve. however I would like to make an argument over here, you learnt in 12 minutes just because you had that 3 hours long class. Video lectures play important role but one cannot give more weight to online/ video teaching merely as they just cover up things so quickly.
Man you're a legend. This almost single handedly taught me everything I need for my assignment worth 30%. Who else from USYD watching this?
If I could like this a 1000 times I would. Saved me hours and hours.Thank you!!!
Thank you you helped us for our group project ! you explain well this concept !
2nd week of doing this project. Still doing the efficient frontier. I think that we understood it now. Let's do it !
FINALLY I DID IT ! You saved my life bro
Best explanation on the net! Excellent investment / excel content timeless information... even after 11 years! Thank You!🤑
Thanks alot sir I really do appreciate your help, I started of in this market not seeing the results I expected and not understanding why but ever since I started investing and trading with Mr Romero pieto I now understand and know the true worth of having an expert by your side .
His consistency in profiting his various clientele really amaze me when Trading on their behalf.
Yes in recent times I profit weekly when investing with Mr Romero pieto he indeed trades on my behalf, making me earn much profit every week.
Good good content.
Many thanks to Mr Romero pieto for helping me and my family this year I invested with him with the minimum amount of $20,000 and he profits me $78,000 per week his indeed an heaven sent.
Jessica Vincent Am from Scotland 🏴 and am also a newbie in the online Trading market so please how can I get hold of Mr pieto and his trading services ?
man you videos are amazing , all i need is to stop watching and start practice :-)
I would love it to have you as my teacher , so good ,so fast , so simple.!!!
You sir,are the saviour from the past
great video, straight to the point with the main components needed to be known.
As well showing how the graph is made.
Thank you so much. I've been muddling through this for hours by myself. I got through most of it but was having trouble with the graphing component. You're a lifesaver!
Thank you so much for this tutorial! I FINALLY understand this now!
Thank you! You explain way better than my finance prof
This is a pretty nice summary of both how to calculate it as well as what it means... Nice Job
Excellent, crispy explanation of several seemingly intricate concepts. Kudos!
This is so great thank you. I am much more of a doer in real life so this is perfect
Thank you so much it helped me more than my faculty to complete the report.
Really good video that helped me with my assignment ive been stuck on for 2 months
Still relevant in 2020! thank you for your contribution and very well explained
thanks a lot mister.. u literaly saved my entire finance course... it would be better if u also provide video regarding the CML and minimum variance portfolios... anyway, THANKS A LOT, SIR!!
omg thanks you ，you saved my assignment
this video helped me pass exam ! My parents would have sent me to military school if i had failed !!
mood
Excellent.. I have to trying to understand EF for so long and you made it look so simple and easy. Thankyou
This is a great video! It’s quick and easy to understand. Thank you for taking the time to do this.
Sir you are a genius. Thank you for explaining all this in 12 min, which my teacher has not been able to explain me for 16 weeks.... xD
Excellent, clearly explained video....I've gone from not understanding to understanding...Off to do my own 2 stock portfolio asap
Wow, i'm very impressed with your explanation, simple yet very understandable! Please replace my lecturer haha
Thank you very much for this quick and clear explaining of efficient set portfolio. Your video helped me a lot.
Thanks a lot ! This video helped me to figure out the graph's meaning and also it's efficient way to learn some knowledge which I took 2hrs in class .
Thank you for this gold tier content!
thank you sir!!! you saved my life!!!
Excellent video. Thank you for taking the time to make it.
You are a legend my man! Thanks for helping me
efficient and clear! breezed in 2x understood everything. thank you
Incredible teaching!!! Congrats and thank you!!!
This is dope. I sincerely thank you for the video
Awesome presentation. Please make more crisp videos like this.
You helped me a lot in 2019! Thank you very much!!!
You are AMAZING. So quick and easy to understand. Will help with my assignment :)
Amazing, this took me months to learn.
Thanks Mr. God
I'm doing an assignment on exactly this. Glad I found your video, thanks +Codible
could you please tell my why you used the function VARP for computing variance instead of VAR as our data represents just a sample of the population? Thanks
Excellent stuff and you made it pretty easy to do.
Fantastic video!
This video is a gem, thank you
Thanks for sharing! Simple and understandable.
Thank you for this video. This helped me tremendously!
Many many thanks! This is amazing! Very well explained!
Really nice explanation! Thanks a lot!
thank you so much, hope you can up-to-date more learning videos, thank you!
dude you saved my life thank you so much
Least thing to say ... INCREDIBLE
Thank you! Now it's all clear. Great video!
Thankyou so much for making this video
Can you please make a video where we can learn how to use Macros for finding covariance for 7-8 firms in 20-30 trials with just 1 click. I know the data analysis method but if we find and make table for 21 companies and each in 20 trials it makes it a lengthy process. I hope you teach that method too. :)
Sorry to disturb you mate but just wanted to ask you that did you got the way to how to use macros for covariance in case of firms ?
Great work! Thank you for taking the time
Very well explained. Thank You
Great video!
wow and amazing man, I love your teaching skills, top class
You are great! this is an awesome example! thank you!
Excellent presentation!
Thank you so much!
Thank you! Very good explained
Thank you!
Awesome video bro helped me so muchh
Thank you.
Can i ask why you use STD.DEVP and VARP when we only have a sample of the population?
yeah, I thought he made mistake
thank you so much for all the thing!!! such a useful video!
This was great Codible, may l know the application you used to demonstrate your animated excel. I have always used screencast-o-matic on power point, wish to use excel along with my demostrations
Thank you so much
He made Excel his b**ch! Nice job man!
Thank you very much, this was very helpful !
Cool..... Your explanation is super awesome
U are incrediable sir! Thank u very much!
Thank you, sir
Thanks a lot, I have trouble understanding and u clear all my misunderstanding ^^ I really appreciate it ^^
Thank you sir! Your video indeed helpful
This is so good, thank you
Thank you 😊 💓 ☺
thank you very much. you helped me a lot
Thank you so much. That was a great help
Hi Im hoping you can help me with a question I have. If I calculate the average returns for each stock then multiply that by the weight will it yield the same result as weekly returns * weight then averaging
Thank you so much!! thanks for your help!!!
Excellent
If i were day trading a portfolio of 24 symbols on a 10 min time frame,would it be best to use the close price of the 10 min candle or should i just choose the daily or monthly close price to calculate the percentage returns
Nicely explained. Are you sure for both tickers prices are adjusted close? I compared with downloaded prices from Yahoo and their its closing prices. How did you get these prices?
Hi there, I love your video, very well explained and easy to comprehend. I want to construct a portfolio for real estate and I was wondering if I could utilize house price changes instead of rental yield? Historic rental yields are very difficult to find, especially for emerging markets, however, price indices are available. Many thanks
hello, can you please put a video for how to graph the efficient frontier for more than two stocks , thanks in advance
Great video! Can this method be used for mutual funds and etf? Multiples of each, to creat one efficient frontier curve?
Very helpful, thank you
Thank you very much sir!
thank you sir you are a genius
How can we interpret the graph if we get negative parabola when we connected points in the graph?
This video made me realize that my professor has no idea what he is talking about and I'm completely screwed. He gets his assignment questions from Chegg.
Great!!
thanks man u r the best.
trying to understand minimum variance portfolio where Stdev is min and Expected return to grow up from min st dev point - any thoughts?
Great video thanks
Best one !!
Really great
Great Thnxxx