PT L20 The Black Litterman Model in Excel

[@hnguyenviet89]

nice work man...much easier to follow than reading through dozens of articles online...:)...

[@yueliu31]

Thanks man. Saved me from reading tedious journals.

[@Amanda-c2h]

Thank you. I don't know how to calculate z. Can you explain?

[@cyrilbedran425]

Shouldn't we calculate a post covariance matrix with the BL expected returns in order to compute the variance of the portfolio and then operate the mean-variance optimization?

[@ousmanesoumaoro4836]

Hello, in the case where the investor has no specific views, how do we build the P Matrix???

[@bayunugroho3232]

Thank you so much. However, I can't find the video about calculating the implied equilibrium excess returns. Pls show me the video link ? thx so much

[@norgaard9812]

When you calculate portfolio returns, is average monthly return or annual return?

[@pooriakhaledian2679]

hi phil thank you may i ask that what is z that you calculate in bl or capm? thanks alot

[@fd98279]

Good explanation, very helpful. Thanks.

[@ณัฐภัทรศิริพินทุ์]

i think the implied Equilibrium Excess Returns formula is Lambda * VCV * weight please check i read from A Step-BY-step to the BL model by Thomas M. Idzorek and The black litterman Model in Detail Jay Walter

[@pizzatheory]

Hi where did you get the variance-covariance matrix? thank you

[@ge00rge64]

Subscriber here for your great job with these tutorials. I have a question Phil, when considering not giving a view to a certain stock, does that necesarily has to strictly reflect on the same return between Implied Equilibrium Excess Return and B-L expected return on that stock, or it can be different ?, in case it could vary what will be caused by? Thank you in advance

[@DollFacePeter]

hey great video. I'm doing black litterman for one of my finance assignment and the first thing we're given is the daily market cap of 30 industry portfolios which together comprise the market. would the first step be to compute the daily return and then derive the historical covariance matrix?

[@alexandernewball3592]

Hi phil, I was wondering if it is still posible to get a copy of the spreadsheet? Thank you

[@SS18w4531g00]

Excellent video, thanks. Out of curiosity, why is there a scalar ( = 2 ) incorporated into the Implied Eq. Exc. Return formula? Is it used to adjust for the E(r) produced by the CAPM by using a data set coming of an executed aprior analysis? Thanks!

[@WommerZ]

How do you calculate implied equilibrium excess returns?

[@parthbajaj2176]

How did you calculate implied excess returns

[@whutusee]

it is very useful video. Does anyone know how to down load the excel?

[@mathurabhishake]

great video

[@sarthaksahu9440]

What is S in the formula

[@davies272]

The variance-covariance matrix

[@julianner3896]

Whats the definition of Z in the calculation?

[@bboymethodmkf]

Z is an envelope portfolio

[@jasongan5981]

thanks sir!

[@antonioacharomo2986]

Hello Phil , any chance you can share your spreadsheet? regards

[@davies272]

Send me you email address and I will sort something out.

[@antonioacharomo2986]

[e-mail]

[@mongolerta]

Did he sent you? Can you share with me pls! [e-mail]

[@rodrigobastosdasilva6606]

Phill, could you share with me your spreadsheet? BTW, great explanation! Thank you so much!

[@ferencvitai1710]

@@davies272 Hey Phil, Can you also share the excel file with me, please? I would be really thankful. My email is [e-mail]

[@camilotibochaolaya2480]

Hi, nice video, you can share the excel file please??

[@janretief6750]

Thanks for the video Phil, incredibly informative! Is there a chance that you can email the spreadsheets to me aswell? Regards

[@davies272]

Send me your email and I will add you to a shared folder

[@comeonjean]

@@davies272 hi, Phil, this is harlan, my email [e-mail]. please share the Excel

[@Bosscat23]

@@comeonjean Hi Phil, this is Emma, could you share the spreadsheet to me as well, many thanks! My email is [e-mail]

[@gersonjunior6182]

Dear Phil, Could you send me the spreadsheet too? [e-mail] Thank you.

[@sebramfu]

Hi Phil, thanks for the video... quite explanatoru... can i have the excel? Many thanks in advance

[@MissingGamer]

**Censored**