Stock Risk-Return Calculations | Collecting Stock Price Data | Excel | MBA | Self Learning

Learn how to download the stock price from Yahoo Finance Database and compute the Average Return, Variance, Standard Deviation and Coefficient of Variation for stocks using MS-Excel

[@arepallibhavanishreemba7454]

very good

[@seekingalpha_]

sir i beg of you to put more such practical videos. So easily explain!!

[@bhavanipriya8118]

thank you sir this is very useful

[@charmainegeee]

Thank you so much!!! Very helpful!

[@LawrenceEbowKoomson]

Please for the Returns, is it right to use the natural log function let's say =LN(current adj. close / previous adj. close)?

[@user-bx3hh4cf9h]

Thank you

[@harinisrinivasan9600]

Sir could you please explain in detail why you have taken adjusted closing price ?

[@kiranshetty5338]

Sir standard deviation represent what type of risk.
And how we can judge which stock is less risk and which is more

[@kavindijayakody7034]

Thank you soo much sir. This was very helpful ❤🎉

[@jerishacaubo5984]

Sir can you please let me know how to calculate the probability for this stocks because we have to calculate the expected return

[@ahmednur1405]

Sir there is wrong formula in Annual Variance. you used STD instead of Variance

[@kirankumarkv858]

Yes. Should use the monthly variance cell and multiply by 12. Thanks