Video

hi Ryan, first of all thanks for all these videos I'm an Italian finance student and I often find your videos much more interesting than the courses I'm studying. I would like to ask you if you have any advises on how to resolve this excel error, trying to build the covariance matrix excel says "Input range must be contiguous". I've copied your whole layout so i really don't understand. Thanks!!

Sir, think if I've 10 stock portfolio in excel, it'll get update for every 20mins, if I want to check how much of return has given such portfolio from past 1 year. How can I check it and how can I compare with index?

🎓 Tutor With Me: 1-On-1 Video Call Sessions Available ► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/

Dude, you are insane. Excellent video!

Ryan, I stumbled across your videos trying to understand WACC, and your content is excellent. I learn a lot more watching your videos compared to sitting in a lecture hall for more than 3 hours a week.

Hi sir

thank you Ryan! however i am still struggling to comprehend why I should use LN() for my portfolio if I bought 10k of spy at 400 and now is 500 my return is 0.25 not 0.2231435513 indeed I have 2.5k of capital gain (not 2.231) could you clarify when LN is appropriate? thank you

Great help really ...thanks a lot 👍

This explanation is very easy to understand 👍

Just noticed the check mark on Mark's hat is pretty hard to see. He should change the colour of the check mark, or the colour of the hat!

🎓 Tutor With Me: 1-On-1 Video Call Sessions Available ► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/

Thankyou mate Appreciate your work

Awesome❤

When i correct the mistake you mentioned in the comments, my total gain/loss in the stock portfolio dashboard changes to #VALUE!. I don't get why because my range from the VLOOKUP only goes to column D, the same as in the video. Do you have any idea how i can solve this issue ? Thanks in advance for your help!

Omg, you are very smart ❤

Iam studying MBA finance.CFA prepare best or not.

Iam studying MBA finance.CFA Prepare best or not

sir , can you show how to calculate annualised return of 10 stocks from realised return?

Superb, Dear can you help me out to have the Value of indian stock in Rupees.

When you say cash flow, as presented in your excel, is it the same with net cash flow?

Wonderful

@RyanOConnellCFA is that a daily VAR or what can you please clarify the conclusion of this calculation?

I think you should have insert VaR in the histogram and guide how to do this, that would be great instead of just clicking the bars that their 5% VaR lies.

Very clear and concise explanation! Thank you so much!!

But expected dividend payouts in forever in 100 years or more and payout every 3 months (not each year，） 😂

Hey. Great video. Just wondering why some sources calculate the up or down return using 1/n in the exponent where n is the number of periods? You calculated a cumulative return. Would the end ratio be the same?

Thank you sir for such wonderful video and explanation.

Hi is this applicable if all of my assets do not occupy the whole 100% of the portfolio value?

I have a question . umm, can I also use this same sheet for Mutual Funds instead?

can you explain why in gordon model we minus growth rate from the rate of return ???

Best explanation of convexity I've ever seen. Well done sir!

what's your favourite option strategy, do you yourself actually use any?

so, in terms of pricing vega is used akin to bootstrapping method for bond pricing? you just derive prices from intrinsic characteristics, so to speak?

Ryan, but where the greeks are derived from? what are the methods of calculating the greeks?

thank you, very clear explanation!

maybe it's not exactly your remit, but, in legal terms, would I have to enter separate contracts, as in 1) long stock + short call 2) covered call? or is it going to be a contract for buying stocks and entering into a contract to exercise options?

very easy to follow . thanks for sharing your knowledge.

most useful one yet

🎓 Tutor With Me: 1-On-1 Video Call Sessions Available ► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/ 💾 Download Free Excel File: ► Grab the file from this video here: ryanoconnellfinance.com/product/straddle-option-strategy-excel-calculator/

What part of the formula involves the gun?

Hey Ryan your formula for price per share started at 12:12 keeps giving me a value error. Any way you would know how to fix this?

How would you calculate the PV without the PV button on the calculator? Please show the steps of the formula

Thank you! that was really helpful

CFA is actually perfect for people who challenge formal education.

Hi, so how do I go about calculating the weekly returns Edit: you already answered it in a comment below. (basically instead of downloading the data for daily, I'll download for weekly and follow the video)