Stock returns: average, variance, and standard deviation

No video

Stock returns: average, variance, and standard deviation

Рет қаралды 535,180

Күн бұрын

Shows how to download stock data from Yahoo Finance, and calculate daily stock returns, average stock returns, variance and standard deviation of stock returns
Some good books on Excel and Finance:
Financial Modeling - by Benninga:
amzn.to/2tByGQ2
Principles of Finance with Excel - by Benninga:
amzn.to/2uaCyo6

Пікірлер: 29

@JoshMolina 7 жыл бұрын

Thank you for your time explaining this. Your examples are relevant and to the point!

@A96847 7 жыл бұрын

Why do you use the formula (Pt-Pt+1)/Pt+1. When the adjusted close increases from T=1 to T=2, this will yield a negative return. Other sources use the following formula: (Pt-Pt-1)/Pt-1.

@matthewtopen3454 5 жыл бұрын

its because his dates are descending as opposed to ascending where you would do the opposite. depends how you download your data

@JoseGamarra-mt3jn 5 жыл бұрын

Look the Date the order is decreasing

@achille295 5 жыл бұрын

He has most recent date at the top, that's why.

@springnguyen9029 7 жыл бұрын

Thank you for this video. Very clear and easy to follow. You've added much help in my project for my Investment course.

@sheis.c4231 4 жыл бұрын

Was such a big help ! Simple and clear . Thank you !

@0069yj 6 жыл бұрын

What is the difference between stdev.p. and Stdev function?....,

@vietcongpornsurfers 7 жыл бұрын

Does anyone know if I can do this for a bunch of stocks at the same time?

@Ghostinthewall873 5 жыл бұрын

Thank you for this informative video--this was a big help to my securities statistical summary project!

@liubovpiano9573 4 жыл бұрын

i download prices and they are opened not in one cell. how to fix it?

@menaka9799 4 жыл бұрын

Do the date of the stocks need to be arranged according to the year ,for an example from 2013 to 2016 to get the average and variance?

@dayukim8815 8 жыл бұрын

thank you,it was incredibly helpful

@sarthakbiswas2201 8 жыл бұрын

@codible. Thanks! I was also wondering what is the timeline over which you select the data to calculate variance,mean,etc. For eg. if I am on the 9th of June today,2016 should I consider a year of past data? As in from 9th June 2015 to 9th June 2016 ? Additionally, could you post a video on how to calculate return on bonds as well? Thanks!

@annsiow3541 8 жыл бұрын

is this the same formula in calculating average monthly return ?

@lindokuhlengcamu519 5 жыл бұрын

Yes the formula is the same for any time frame

@nhuphuongpham834 7 жыл бұрын

Thank you. How can I find the multi-period binomial tree if I use the data of this situation?

@Kig_Ama 4 жыл бұрын

Why dont u use the logarithmic returns?

@brinciareid4346 6 жыл бұрын

Wonderful that's the only word i have to say to explain

@shakesdhlamini3483 7 жыл бұрын

Please help me, if you have possible profits such as 5 000 000 and the probability of 0.3, what is the expected return?

@pubrao 8 жыл бұрын

how to calculate continuous return instead of normal return

@Keymaster2022 7 жыл бұрын

Thanks for this.

@bigjayfitness 7 жыл бұрын

thank u good sir

@AdamELclon 6 жыл бұрын

thanks

@devez7 6 жыл бұрын

How to put the return in normal distribution curve?

@valuablememories5603 4 жыл бұрын

Hello! I got a question if you can help me? When I divide (=G2/G3-1) and press enter I always get #VALUE! error. I understand the value is negative but it won´t show me the -0.00777, just the value error. How do I avoid this? Please help me

@thatissurprising2368 4 жыл бұрын

cuz you dont need "(" before =

@menaka9799 4 жыл бұрын

=(G2/G3-1) Try with this