Graphing the efficient frontier for a two-stock portfolio in Excel

Поделиться
HTML-код
  • Опубликовано: 1 дек 2024

Комментарии • 151

  • @kyrios0307
    @kyrios0307 8 лет назад +102

    This guy basically condenses a 3-hour Investment I had yesterday class into 12 minutes! Thank you!

    • @aldamry6554
      @aldamry6554 4 года назад

      رماده خلب مناخ الاستثمار فى مصر فى الفترة القادمة ستشهد من خلال الرابط التالي من قبل لا انام بس من غير حساب في كل من غاب عني و لا قوة إلا هو الحي القيوم و اتوب اليك من خلال الرابط التالي في هذه الدنيا سوى أن تكون في كل من قال قبل لا

    • @aldamry6554
      @aldamry6554 4 года назад

      ركلات الترجيح في هذه الحياة الدنيا وفي الآخرة حسنة و قنا عذاب الله يا مصر من أجل أن ذلك لم يكن من الممكن من كل شر يارب لا تحرمني من تعلقت به وهو لا يصلي في الحياة ٧ فقع في كل مكان و لا قوة إلا بالله العلي ف كل ٦٧٦٨ على أن يتم الانتهاء منه و ما ٨٦٨٦٨ في كل من قال ان يكون في

    • @aldamry6554
      @aldamry6554 4 года назад

      متتمتتمتانافتقاللتلتللتابالتلبناعمتغمنانم منتجة امواتنا واموات المسلمين من كل شر يارب يارب يارب لا تجعل الدنيا اكبر همنا من قال ان يكون في عون العبد في جوف صدري

    • @chahsensaghirpk
      @chahsensaghirpk 3 года назад

      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.

  • @skuxx1er
    @skuxx1er 6 лет назад +9

    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?

  • @raymondbarata6912
    @raymondbarata6912 7 лет назад +6

    If I could like this a 1000 times I would. Saved me hours and hours.Thank you!!!

  • @nolwenn3400
    @nolwenn3400 Год назад +3

    Thank you you helped us for our group project ! you explain well this concept !

    • @nolwenn3400
      @nolwenn3400 Год назад +1

      2nd week of doing this project. Still doing the efficient frontier. I think that we understood it now. Let's do it !

    • @nolwenn3400
      @nolwenn3400 Год назад +1

      FINALLY I DID IT ! You saved my life bro

  • @contracocfilter-guerrillan7770
    @contracocfilter-guerrillan7770 4 года назад +1

    man you videos are amazing , all i need is to stop watching and start practice :-)

  • @edwinfrenly7118
    @edwinfrenly7118 2 года назад

    You sir,are the saviour from the past

  • @GeoffersonNewton
    @GeoffersonNewton 6 месяцев назад

    Best explanation on the net! Excellent investment / excel content timeless information... even after 11 years! Thank You!🤑

  • @vasylkravchuk7974
    @vasylkravchuk7974 8 лет назад +2

    I would love it to have you as my teacher , so good ,so fast , so simple.!!!

  • @vadlamaniravi6431
    @vadlamaniravi6431 4 года назад

    Excellent, crispy explanation of several seemingly intricate concepts. Kudos!

  • @justalittlelate7203
    @justalittlelate7203 4 года назад +1

    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!

  • @JohnMcLaughlinPlus
    @JohnMcLaughlinPlus 5 лет назад +1

    This is a pretty nice summary of both how to calculate it as well as what it means... Nice Job

  • @TheTheawe
    @TheTheawe 6 лет назад +2

    great video, straight to the point with the main components needed to be known.
    As well showing how the graph is made.

  • @caistuart2121
    @caistuart2121 9 лет назад +12

    Thank you! You explain way better than my finance prof

  • @madtoutou2381
    @madtoutou2381 Год назад +1

    this video helped me pass exam ! My parents would have sent me to military school if i had failed !!

  • @arsalanali5088
    @arsalanali5088 5 лет назад

    Excellent.. I have to trying to understand EF for so long and you made it look so simple and easy. Thankyou

  • @beagloopers2462
    @beagloopers2462 9 месяцев назад

    Thank you so much for this tutorial! I FINALLY understand this now!

  • @saifulislamsiam9139
    @saifulislamsiam9139 7 лет назад +1

    Thank you so much it helped me more than my faculty to complete the report.

  • @amandarodrigues9822
    @amandarodrigues9822 5 лет назад +1

    This is a great video! It’s quick and easy to understand. Thank you for taking the time to do this.

  • @shebame
    @shebame 5 лет назад

    Thank you very much for this quick and clear explaining of efficient set portfolio. Your video helped me a lot.

  • @duearklar5795
    @duearklar5795 5 лет назад

    Excellent, clearly explained video....I've gone from not understanding to understanding...Off to do my own 2 stock portfolio asap

  • @AngelBeatz92
    @AngelBeatz92 7 лет назад +1

    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

  • @muhammadnasarudinmohdrazal2319
    @muhammadnasarudinmohdrazal2319 6 лет назад +1

    Wow, i'm very impressed with your explanation, simple yet very understandable! Please replace my lecturer haha

  • @whisperxie4314
    @whisperxie4314 5 лет назад

    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 .

  • @Tom-ni8hs
    @Tom-ni8hs 9 лет назад +2

    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!!

  • @Bunjee77
    @Bunjee77 6 лет назад +3

    This is so great thank you. I am much more of a doer in real life so this is perfect

  • @kyley6657
    @kyley6657 3 года назад

    Thank you for this gold tier content!

  • @Stefan_vw
    @Stefan_vw 4 года назад

    You are a legend my man! Thanks for helping me

  • @andysunny90
    @andysunny90 7 лет назад

    Awesome presentation. Please make more crisp videos like this.

  • @josephanderson2018
    @josephanderson2018 2 года назад

    Excellent video. Thank you for taking the time to make it.

  • @theapplekid13
    @theapplekid13 4 года назад +2

    Really good video that helped me with my assignment ive been stuck on for 2 months

  • @aabcdefg2861
    @aabcdefg2861 4 года назад +1

    Still relevant in 2020! thank you for your contribution and very well explained

  • @shelleymason3697
    @shelleymason3697 6 лет назад

    You are AMAZING. So quick and easy to understand. Will help with my assignment :)

  • @yoganandannatrajan9404
    @yoganandannatrajan9404 3 года назад

    Amazing, this took me months to learn.

  • @SoGameplaySemComentarios
    @SoGameplaySemComentarios 3 года назад

    Incredible teaching!!! Congrats and thank you!!!

  • @chentang8143
    @chentang8143 7 лет назад

    Excellent stuff and you made it pretty easy to do.

  • @user-ow3be9te5o
    @user-ow3be9te5o 5 лет назад +1

    omg thanks you ,you saved my assignment

  • @henrikraymond5235
    @henrikraymond5235 3 года назад +45

    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 .

    • @harrisonwealth5641
      @harrisonwealth5641 3 года назад +2

      His consistency in profiting his various clientele really amaze me when Trading on their behalf.

    • @jessicavincent9097
      @jessicavincent9097 3 года назад +2

      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.

    • @anastaciajames6984
      @anastaciajames6984 3 года назад +2

      Good good content.

    • @waynefrank2818
      @waynefrank2818 3 года назад +2

      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.

    • @oliverbenito5614
      @oliverbenito5614 3 года назад +1

      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 ?

  • @jot3547
    @jot3547 3 года назад +2

    He made Excel his b**ch! Nice job man!

  • @인보이스-c5g
    @인보이스-c5g 5 лет назад +1

    You helped me a lot in 2019! Thank you very much!!!

  • @alkor3883
    @alkor3883 6 лет назад

    efficient and clear! breezed in 2x understood everything. thank you

  • @joonwoochung90
    @joonwoochung90 6 лет назад +1

    This is dope. I sincerely thank you for the video

  • @kislaciklii
    @kislaciklii 4 года назад

    Really nice explanation! Thanks a lot!

  • @dumisanimsipa3716
    @dumisanimsipa3716 8 лет назад +1

    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

  • @jangzterrizer9405
    @jangzterrizer9405 5 лет назад

    This video is a gem, thank you

  • @syedaafsheen555
    @syedaafsheen555 8 лет назад +3

    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. :)

    • @armanthakur4886
      @armanthakur4886 3 года назад

      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 ?

  • @kshin625
    @kshin625 10 лет назад +6

    thank you sir!!! you saved my life!!!

  • @HKNAGPAL7
    @HKNAGPAL7 5 лет назад +1

    Thanks Mr. God

  • @freakyfarooq
    @freakyfarooq 3 года назад

    Many many thanks! This is amazing! Very well explained!

  • @annmoore5775
    @annmoore5775 7 лет назад

    Thank you for this video. This helped me tremendously!

  • @TheYangsta7
    @TheYangsta7 9 лет назад +1

    I'm doing an assignment on exactly this. Glad I found your video, thanks +Codible

  • @katuskasvk21
    @katuskasvk21 8 лет назад +5

    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

  • @aaronhussein6182
    @aaronhussein6182 6 лет назад +6

    Can i ask why you use STD.DEVP and VARP when we only have a sample of the population?

    • @henrygu9725
      @henrygu9725 6 лет назад +1

      yeah, I thought he made mistake

  • @tableauvizwithvineet148
    @tableauvizwithvineet148 5 лет назад

    wow and amazing man, I love your teaching skills, top class

  • @catsinkuwait9566
    @catsinkuwait9566 7 лет назад +1

    dude you saved my life thank you so much

  • @anilvagvala1062
    @anilvagvala1062 7 лет назад

    Cool..... Your explanation is super awesome

  • @mohammedsaad923
    @mohammedsaad923 9 лет назад +1

    hello, can you please put a video for how to graph the efficient frontier for more than two stocks , thanks in advance

    • @howardjensen1799
      @howardjensen1799 5 лет назад

      Great video! Can this method be used for mutual funds and etf? Multiples of each, to creat one efficient frontier curve?

  • @almahdiamin
    @almahdiamin 6 лет назад

    Least thing to say ... INCREDIBLE

  • @cadusaboya1164
    @cadusaboya1164 4 года назад

    Fantastic video!

  • @olgao2269
    @olgao2269 5 лет назад

    Thank you! Now it's all clear. Great video!

  • @IndahYulianaPasaribuBondar
    @IndahYulianaPasaribuBondar 5 лет назад

    Thanks for sharing! Simple and understandable.

  • @stephenmuvea6378
    @stephenmuvea6378 2 месяца назад

    This is great explantion, Thank you sir.

  • @JoshMolina
    @JoshMolina 6 лет назад

    Great work! Thank you for taking the time

  • @TheMunishk
    @TheMunishk 4 года назад

    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?

  • @aryanchauhan6671
    @aryanchauhan6671 3 года назад

    Awesome video bro helped me so muchh

  • @mailmithunp
    @mailmithunp 8 лет назад

    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

  • @Dirtbiker4545
    @Dirtbiker4545 Год назад

    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

  • @tam0210
    @tam0210 5 лет назад

    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

  • @TheMunishk
    @TheMunishk 5 лет назад

    Very well explained. Thank You

  • @大红猫
    @大红猫 4 года назад

    thank you so much for all the thing!!! such a useful video!

  • @ericfurman5227
    @ericfurman5227 7 лет назад

    Excellent presentation!

  • @alekseikatruk8662
    @alekseikatruk8662 6 лет назад

    Thank you! Very good explained

  • @brilliantbeautifullife1186
    @brilliantbeautifullife1186 9 лет назад

    thank you so much, hope you can up-to-date more learning videos, thank you!

  • @Nikhil4raj
    @Nikhil4raj 2 года назад

    Great video!

  • @AnilKumar-qj8wf
    @AnilKumar-qj8wf 7 лет назад

    How can we interpret the graph if we get negative parabola when we connected points in the graph?

  • @sanzharbekmavlianov881
    @sanzharbekmavlianov881 7 лет назад

    trying to understand minimum variance portfolio where Stdev is min and Expected return to grow up from min st dev point - any thoughts?

  • @perrygogas
    @perrygogas 7 лет назад

    You are great! this is an awesome example! thank you!

  • @shockjockey5274
    @shockjockey5274 4 года назад

    This is so good, thank you

  • @paradox636
    @paradox636 3 года назад

    How do you do this for multiple stocks (three or more)?

  • @ayaanlebashir
    @ayaanlebashir 8 лет назад

    U are incrediable sir! Thank u very much!

  • @alfapha7
    @alfapha7 5 лет назад

    Thanks a lot, I have trouble understanding and u clear all my misunderstanding ^^ I really appreciate it ^^

  • @Milanca98
    @Milanca98 6 лет назад

    Is it possible to use this method for just a single stock?

  • @efilimone
    @efilimone 7 лет назад

    thank you very much. you helped me a lot

  • @analindansunda3108
    @analindansunda3108 9 лет назад

    Thank you so much. That was a great help

  • @winson3488
    @winson3488 7 лет назад

    Thank you sir! Your video indeed helpful

  • @Anthonyzhong
    @Anthonyzhong 7 лет назад

    Thank you so much!! thanks for your help!!!

  • @takshilkanekar8006
    @takshilkanekar8006 3 года назад

    can you show this for 4 stock portfolio?

  • @tulus94
    @tulus94 8 лет назад

    how can i graph my efficient frontier using CAPM returns?

  • @DrBre-zk7ge
    @DrBre-zk7ge 9 лет назад +2

    Can this be done with many shares??? Like 8-10??? I would really appreciate the reply

  • @alexlucas2420
    @alexlucas2420 7 лет назад

    Very good video 👌

  • @kaitlinaffleck9676
    @kaitlinaffleck9676 6 месяцев назад

    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.

  • @DSS0692
    @DSS0692 6 лет назад

    Excellent, thank you. This has been very helpful

  • @jkelleycz
    @jkelleycz 6 лет назад

    Very helpful, thank you

  • @dimitris4046
    @dimitris4046 8 лет назад

    Great video thanks

  • @fransiska2501
    @fransiska2501 4 года назад

    Thank you so much!

  • @deerajmalladi2450
    @deerajmalladi2450 5 лет назад

    Great Tutorial, saved hours of my Time _/\_ _/\_ _/\_

  • @achrafmezzine654
    @achrafmezzine654 7 лет назад

    thank you sir you are a genius

  • @guiseppeperceval4930
    @guiseppeperceval4930 5 лет назад +1

    Please note he's assuming a population not a sample in this as should be doing it with full - .S or .P at the end of the function. I made his mistake.

  • @albertmandari5687
    @albertmandari5687 7 лет назад

    thanks man u r the best.

  • @koreenalbertspeer9766
    @koreenalbertspeer9766 4 года назад +1

    this video made me think how idiot my lecture was teaching in class

  • @cosmichome626
    @cosmichome626 6 лет назад

    Спасибо, Codible! It's a pity, my excel can't use foreign data.