you're a king mate. plain and simple. you have no idea how much this has helped me. was honestly having a melt down with my dissertation. subbed and liked. i'll forever support you. thank you so much
Hey Nata, correct me if I'm wrong. In my opinion, instead of using the return of each stock, excess return is the appropriate input, which derived by stock return minus risk-free rate.
Thanks, This is exactly what I've been looking for. Absolutely great video. Direct answer to my question and time saving. what a good one . Highly Appreciated
helpful vid man. im just getting exposed to regression analysis in my MS Finance class right now.....was never taught it in undergrad many yrs ago. Very helpful Nate.
Hey, I am so grateful I managed to calculate my beta. Thank you the tutorial was very clear to understand and your explanation is very organized. Bless you.
awesome video! I had no idea how to begin this type of assignment. You explained everything very clearly and I got a better understanding of the two ways to find beta. thanks!
Thanks man, helped me with the Linear Regression :) Though I am handling an excel with roughly 50 sheets so I use COVARIANCE.P(stock;index)/VAR.P(index) to count my betas. It should be all the same I guess.
Thank you for the detailed explanation, can you also share how to find the betas for multiple regression, or what are those more than 1 betas (b1,b2,b3,b4......) how those other betas are calculated.?
Hi Nate, I like the way you explain, and I would like to see if you can give me some advice, I am 15 years old and I want to study finance, what can you recommend me personally?
The slope i.e. beta won't change even if you subtract the risk free return from both Apple and S&P's return(Assuming the risk free rate hasn't changed over the period). As long as all X's are changed by the same amount in the same direction, and/or all the Y's are changed by the same amount in the same direction, the slope of the line does not change. Hence the beta would be the same.
Hi! you only considered stock, what if in my portfolio I chose some stocks, commodities, bonds ; Should I find beta for all of them? If yes then how should I find overall one final beta? Thanks for your answer in advance
Let me know if you have any future video requests!
CAPITAL SOLUTIONS this is jonathan man what's up!!!
do a video on how and where to buy dividend stocks of a company
CAPITAL SOLUTIONS use ad block lol
you're a king mate. plain and simple. you have no idea how much this has helped me. was honestly having a melt down with my dissertation. subbed and liked. i'll forever support you. thank you so much
GOD BLESS YOU, THANK YOU I NEEDED THIS FOR MY HW
Good luck
Hey Nata, correct me if I'm wrong. In my opinion, instead of using the return of each stock, excess return is the appropriate input, which derived by stock return minus risk-free rate.
Thanks, This is exactly what I've been looking for. Absolutely great video. Direct answer to my question and time saving. what a good one . Highly Appreciated
helpful vid man. im just getting exposed to regression analysis in my MS Finance class right now.....was never taught it in undergrad many yrs ago. Very helpful Nate.
I was just casually watching this vid learning stuff and this video was made by Nate ? what ? u made these kind of video back then ? lol amazing
You have no idea how helpful this was when I was ready to cry trying to calculate the beta regression for my WACC analysis! Thank you! Thank you!
Nate, you are so darn smart I could hug right now. The real MVP
Thanks!
Hey, I am so grateful I managed to calculate my beta. Thank you the tutorial was very clear to understand and your explanation is very organized. Bless you.
This video is saving my whole life right now!! PERFECT! Breaks it down in a common language, step by step!! PERFECT! Thank you so much!
Whenever I take a break from using excel, I always come back to this video for a quick and concise refresher. Thank you!
May I ask can I use multiple stocks for estimating the Beta?
Holy crap I learned all this in college and I’m so excited to use it as a new tool for investing
awesome video! I had no idea how to begin this type of assignment. You explained everything very clearly and I got a better understanding of the two ways to find beta. thanks!
This is so helpful. Thank you!
Excellent Briefing. Worth watching the video. Grateful for understanding the calculation of R square and Regression
Concise and genuine help. Big thank you. You will be blessed..!
Very helpful!!! Thanks for share it!!
Thanks a ton. This is the simplest explanation I found on youtube
This video is really helpful!
Thanks man, helped me with the Linear Regression :)
Though I am handling an excel with roughly 50 sheets so I use COVARIANCE.P(stock;index)/VAR.P(index) to count my betas. It should be all the same I guess.
@@neilcarvalho8349 too busy making Excels mans hahaha
thank you, u made my life easier
Super simplified, easy to understand and follow. Great video!
4year later your video saved my day. Thanks.
me too bro
You just saved me . Thank you soo much
Why can't you just use cov(Rp, Rm) /Var(Rm)
also possible but takes more time, your formula is basically the same for calculation ß1 in a Regression Analysis
slope is fasted way, then cov/var then regression
Thank you so much. It was very simple and clear. I learnt it. Thank you again.
oh very interesting thank you Nate help a lot & I always like your simplicity.
Thanks for the quick and clear explanation! Really helpful.
Thank you so much for this amazing video! So concise and informative.
Actually, your explanation is good.
Dude u r awesome! I found the p value with this way. Greetings from Chile!
Hey Nate! I really liked watching this very informative video!
Thank you very very much !!!!! This video was of a great help
this video really helped me in my exam thank you sir
Thank you! Very helpful, you have excellent teaching skills.
Super helpful & a life saver bro. Many thanks!
Very clear explanation, thanks a lot
Thanks bro. This was super helpful. You made it relatable and simple to follow!
Sub’ed
thanks you for your simple explanation mate. It's easy to understand 👌
Thanks so much! Very easy to understand.
Thanks man ☺️ you made my life easy
Thanks! Very clear instruction!
Thank you very much. Good explanation.
Thanks for sharing.
Thank you for making this
YOU SAVED MY ASS ! - thank you so much
New to this. Quality of video is quite good :)
Big thanks, been a life saver tutorial for my Master's dissertation!!
It makes me so happy to hear that someone has benefited from my video! Thank you for watching and good luck!
Thank you very much!
Fast and easy! Thank man.
excellent teaching!
You are a hero.Thanks a million
Thank you for the detailed explanation, can you also share how to find the betas for multiple regression, or what are those more than 1 betas (b1,b2,b3,b4......) how those other betas are calculated.?
Hi Nate, I like the way you explain, and I would like to see if you can give me some advice, I am 15 years old and I want to study finance, what can you recommend me personally?
Legend Mate. Thank you.
Excellent, Excellent Video!!! You save my life!!! :P
Thank you so much for this. I sooooooooo appreciate it!!!
u have saved me from a ton of trouble...I Love u bro
This saved my life! thank you
Thanks for checking out the video Liz, glad you found it helpful!
Hey Nate may I ask why you didn't subtract the risk-free rate from the return? Thanks for the video!
The slope i.e. beta won't change even if you subtract the risk free return from both Apple and S&P's return(Assuming the risk free rate hasn't changed over the period). As long as all X's are changed by the same amount in the same direction, and/or all the Y's are changed by the same amount in the same direction, the slope of the line does not change. Hence the beta would be the same.
Thank you thank you, helped me so much!!
can you explain the beta chart & explain how good the portfolio is
This is great!!!Thank you
You saved my life, thank you so much!!!
Legend bro
really helpful!!
you are a legend. thank you
My savior! thanks man
Thanks Nate!
Beautiful, thank you kind sir.
That was perfect, thx a lot Nate!
Glad I was able to help! Thanks for watching!
Awesome !! Thanks. I just had to do some data cleaning before regressing them as missing values were detected by Linest()
This video saved my life thank you
Glad it helped!!!! Makes me happy!
So helpful, thank you!
Thanks bro
Hi, Thank you for the video! it helped me a lot. I just want to ask how can we add the adjusted betas ?
You can also use "LINEST" to calculate Beta. And also, shouldn't you be using logarithmic rates of return?
REALLY HELPFUL!!!!
why can't i find historical data at S&P Futures???? help me
Great explaination! Can I do the same with S&P500 sectors, instead of a single company?
is this levered or unlevered beta? thank you
Very helpful if doing a master!
Hey thanks super helpful
Thanks! Glad to see someone found it useful!
Cool video
Thank you!
thank you very useful
thanks bro, but can you provide the next step to calculate the CAPM model using these data?
YOU ARE MY HERO
How can I download the historical data for the S&P 500 ? It does not give me the download option.
Hi sir this is realy helpfull pls show how to calculate daily beta value for intraday trading
Pls tell me why u don't include dividend into Apple's return? Thanks a lot, kina urgent for my assignment😭
Hi! you only considered stock, what if in my portfolio I chose some stocks, commodities, bonds ; Should I find beta for all of them? If yes then how should I find overall one final beta? Thanks for your answer in advance
I got different answers for beta when using slope as well as when using var and covar
Do you do S and P for each firm? so I have to do Ford, Dell and Kroger
Are you still taking on more questions on this topic ?
We could use log of return instead of return to calculate beta!
helpful video 👍
Excellent video. Concise and informative. Quick question though: Would alpha be the intercept under coefficients?