Jesus Christ I was having trouble doing my finance project and i cant tell u how much your video has helped me !! THANKS A LOT U ARE A GOOD MAN HAHA :)

Why not use COVARIANCE.S and VAR.S instead of .P (its a sample)?

bro 11 year video saved me in 2023 thank you.

Just use the =SLOPE(price of stock set, index set) function

my guy you just helped me so much. You LOVE to see it

Thank you so much, you saved my semester !!!

Very helpful and informative video. Thanks so much for a really well done explanation.

Nice demo - thanks v much. I was initially surprised by the way you worked out the ratios, until I realised that the most recent dates are at the TOP of the sheet (Doh !)

Apologies Robert one last question, how would you treat the formula if the previous price was zero? Dividing by zero is not possible

Thanks alot sir I really do appreciate your help with this video I started off 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 .

Thanks for the video sir.. I was looking for it desperately

Very helpful thanks for taking time to post this.

Thank you for your video sir!

Very helpful. Thanks for taking the time to do this.

That was really helpful

ty for such helpful nd clear videos... i appreciate👍

that SLOPE function is cool!

JUST WHAT I NEED.. THANKS !

Thanks for posting! This was super helpful :-)

Crystal Clear! Thanks mate.

thank you very much. Your video is really helpful!!!

Still very helpful in 2018. Thanks a lot, sir!

When we are going to find the return of close price over the recent days. Why do we have to take the logarithm like: type in ln(close price day 2/close price day 1). But here you are just simply dividing it. Do someone have an explanation?

Excellent, helped with a small project I am working on.

take LN (today / yesterday) for returns. LN stands for Natural Log

This is incorrect, you should use EXCESS market returns and EXCESS stock returns - corrected for the risk free rate.

Nice explanation

You my friend are a life saver. Thank You

Wow, that's so simple... Thanks

What you have just computed is the beta for weekly returns. How do you compute it for monthly, quarterly , semi-annually or yearly returns when you have weekly data?

Awesome...thank u very much for sharing the video..

Thank you very much for your video....it solved a lot of my queries

Very much useful sir. Thank you🙏🙏🙏

how did you calculate the returns? i mean what is that formula used? it is similar to calculating CAGR. Can you please explain why you used that formula?

shouldn't you take the log return?

hello first of all i want to thank you for this video my question is : in order to calculate the return why you have to (-1) ? thank you

yes, the slope function is easier to undertand, i still dont under the covariance , but thank you so much

Thank U very Much！！！ My question is what is the difference between Beta & Sharp Ration?

Very useful. Thank you very much

thank you very much sir

Great explanation! Thank you.

Thank you very much! You are a great teacher))

Hey just a short question since im new to this, what is the reason again for using 2 stock companies for computation?

Very informative and helpful. Thank you very much!! :)

very clearly explained! thanks.

thanks for this; do you need to involve a risk-free rate?

Thank you so much, very helpful :)

Great video! Thanks.

Really clear

Hi, How about if you are asked to find the stock beta for just S&P 500. How would you do this?

Thank you, that was just perfect!

Thank you so much, but i am just wondering what is the best time period we need to chose for calculate beta, is that 10 years?

I should say better than others since was in detail. non of the other videos start from how to get s&p 500. thankssss

my beta is coming as 20, is that right? I followed your steps, but I feel the beta is not accurate.

This video help me out, thank you so much! :D

Very helpful

thank you.... really useful

really well-explained and useful, thanks!!

For example if we need to find out beta as for today, can we use the date from like 1997 till 2018? Won’t this reduce our standard errors??

Thanks! Clear and helpful!

thanks. very useful for me that i have to do my project.

can i use returns as percentages from one close to another rather than as fractions in this formula?

Thanks a lot ,very useful

why s&p 500 and not russell 3000?

My return are not in percetage after calculation

Great tutorial!

Very helpful! Thanks!

thanks Kim, How about expected return? How would you calculate that? I want to determine whether a security is overpriced or not

hi, if i need to find the required rate of return on a ftse 350 company of my choice, so i use the s&p 500 historical prices on yahoo like you did or do I use the ftse 350 historical prices? thanks!

Really Helpful.. Thank you

Thanks a lot!

is the S & P 500 prices the average prices of all the stock that make up the S & P 500?

Thank you very much!!

Thank you so much

thanks! So in short my method was wrong?

Awesome...thanks for the help...

i have a question, can i use the following formula to calculate the returns : 100 - ((previousPrice/currentPrice) * 100) ?

slight error made in return formulae, =(p1-p0)/p0 and not (p0-p1)/p1=(p0/p1)-1

How to find a stock which is giving me max return in which month and in which year consistent where i have 20 years of data .... can some one help me out ....

when i divide c3/c4 i get a red c4 telling me its a error why is this?

@2:55 how are you selecting the array from the cell you are on?

Helped 😊

May I ask why you didn't use the excess return to calculate beta? My lecturer taught us to calculate the beta based upon the excess return rather than return.

Thank you for your Information

thank you for this video

Why did you take S&P share prices? What prices should be taken for Indian companies?

hi, I would like to know where to find the beta caracter in excel please?

Thank you very much!

Hello sir, When I download VESTAS' stock history data, I receive it in Danish currency. I want to know whether you can download it in euros? Also the S&P 500 is in $. I am interested in getting it in euros too.. do you know a website where I can download it that currency? And yea finally when I downloaded the sheet from yahoo finance, all the data was in the same column, so I had to separate it all manually, do you know the reason for why that happens? Look forward to hear from you, thx! :)

do i need to minus risk free rate???

Thanks Robert, it turned out that the shares did not start trading until a later date, using the example above if amazon had less days worth of closing prices and i was using linear regression slope to calculate the beta, from my understanding both x and y for the calculation of a slope must be of equal size. In my scenario would if be valid if i used the smallest size to calculate the slope?

Excellent sir

Great video man, My question is. Is the "Excess Returns for Market Portfolio" the same as "Returns"

Is this the asset beta or the equity beta?

Is this levered beta or un-levered beta?

How to do manual...?

=B2/B3-1 it says Value error! I tried on different sheets I know it says value cause the answer is negative ( etc -2.96 %). Instead of giving me the answer in % it just says Value! What should I do, please help?

thank you！

how to calculate equity risk premium

can you have a negative beta?