Calculate Risk And Return Of A Two-Asset Portfolio In Excel (Expected Return And Standard Deviation)

[@JSquiff]

Studying an MSc Finance and this was more useful and clear than the course content. Great video!

[@theexcelhub]

I'm very glad to hear that! Thank you!

[@lilyrosenbaum5908]

THIS VIDEO WAS SO HELPFUL!!! THANK YOU!!!!

[@MrVenkatesh25]

Thank you, your explaination is helped me understand great deal.

[@liamcoleman6196]

How do you find the correlation

[@sulav616]

thank you for your effort

[@simenandreasknudsen9272]

Thank you!

[@giovannibarbaro1]

Nice video, there is an extra Wb in the risk formula tho.

[@theexcelhub]

Well noticed, please ignore the second wb :)

[@gregbarry5875]

also the risk formula ends with standard deviation of B twice instead of SDA x SDB. You should make corrections or pull it down.

[@igorporoshin6218]

Thank you. Good explanation 👍 But i belive we must use covariance instead of correlation, isn't it?

[@theexcelhub]

Thanks. You can use either as Cov(a,b)=correl(a,b)*s.d(a)*s.d.(b).