FinShiksha - Calculating Annualized Standard Deviation from Stock Prices

  Рет қаралды 157,858

FinShiksha

FinShiksha

Күн бұрын

Пікірлер: 57
@kaustavsen
@kaustavsen 3 жыл бұрын
9 years later, still serving students across the globe. Thanks a ton for the on point video.
@jeenthomas8147
@jeenthomas8147 8 жыл бұрын
Thanks a million for this precise, to the point video. You're a life saver!
@nunolopes3910
@nunolopes3910 3 жыл бұрын
That was really hellpfull, finally understood something that has been bugging me for a while. Thank you.
@KennTollens
@KennTollens Жыл бұрын
Thank you for the very simple step by step explanation to get volatility. I am trying to get the Sharpe Ratio and everyone else glosses over how to get this number.
@laurentiu375
@laurentiu375 7 жыл бұрын
Useful, correct but too long. There's a shortcut - i.e. you can avoid the variance calculation by simply multiplying the Daily Standard Deviation with the square root of time period. So in above example just take the StDev of 2.2% and multiply it with SQRT of 250 and you'll get the same result for annualized StDev of 35%. Similarly to get the annualized StDev from a monthly series, you compute the monthly StDev as shown in the video and then multiply it with Sqrt of 12 (as there are 12 months in an year, doh). Cheers!
@TheAnde2lumut
@TheAnde2lumut 9 жыл бұрын
Very Helpful, simple and comprehensive! Thank you!
@TradingHeroes
@TradingHeroes 8 жыл бұрын
Very useful and to the point. Thanks!
@keysky22
@keysky22 11 жыл бұрын
Thank you,bro !!! solving my project problem!!!
@FinShiksha
@FinShiksha 11 жыл бұрын
Thanks Yuwen. Glad to be of help.
@managedbywhitney
@managedbywhitney 4 жыл бұрын
1:28 start here: standard deviation moving into daily variance
@ramamoorthyh
@ramamoorthyh 7 ай бұрын
Thank you for the explanation.
@FinShiksha
@FinShiksha 6 ай бұрын
Glad it was helpful!
@gasher2000
@gasher2000 3 жыл бұрын
Excellent. To the point and accurate.
@joshuaofomaja
@joshuaofomaja 3 жыл бұрын
Thank you! Just straight to the point
@gorandamchevski
@gorandamchevski 2 жыл бұрын
Great video, thank you!
@MrDbigballs
@MrDbigballs 10 жыл бұрын
Thank you! Really clear and straight forward.
@FinShiksha
@FinShiksha 10 жыл бұрын
Thanks Drew!!
@manute7891
@manute7891 10 жыл бұрын
Brilliant!! you just made my day.
@FinShiksha
@FinShiksha 10 жыл бұрын
Glad to be of help
@zes3813
@zes3813 5 жыл бұрын
wr
@afca-thfc1661
@afca-thfc1661 2 жыл бұрын
Thank you sir
@andreaboul3
@andreaboul3 10 жыл бұрын
if you were calculating 2 year annualized volatility, when performing the calculations would you simply double the number of trading days from 250 to 500?
@soulfulll
@soulfulll 10 жыл бұрын
You're a lifesaver.
@FinShiksha
@FinShiksha 10 жыл бұрын
:)
@santamkafle3569
@santamkafle3569 8 жыл бұрын
thank you. this helped me to do my research
@heshanpalliyaguruge6333
@heshanpalliyaguruge6333 Жыл бұрын
Thank you so much sir
@Atinderbal
@Atinderbal 10 жыл бұрын
Thanks for the video. I have a question! If the given data is monthly for 2 year, what will be annualized variance? is it Square of Monthly Standard Deviation X Number of months (12) X Number of years (2)? Also any video tutorials to Annualizing Monthly Returns?
@saintrroy
@saintrroy 6 жыл бұрын
That is incorrect. Check your reasoning. You already have the month standard deviation from the data, so whether that was derived from 1 year data or 2 years or n years is irrelevant. If the data is monthly, then you can now figure out how to deduce the annualized standard deviation, and therefore the annualized variance. What you wrote above is wrong.
@gokuvegeta9500
@gokuvegeta9500 Жыл бұрын
​@@saintrroy Thank you 👍
@javierloa9197
@javierloa9197 3 жыл бұрын
If you wanted to annualize the average daily return, would you raise by 365 (like most books) or use 252 trading days?
@solipsist100
@solipsist100 9 жыл бұрын
can the same be done for monthly returns?
@kwcykelvin
@kwcykelvin Жыл бұрын
thanks
@nathancortez92
@nathancortez92 8 жыл бұрын
thank you very much!!!
@atmanirbhartrader9725
@atmanirbhartrader9725 4 жыл бұрын
hi, video is good but I've a doubt. where does this 35% fit in 1 standard deviation and 2 standard deviations, i.e 68.3 and 95% respectively. how to interpret that.
@firstnamelastname890
@firstnamelastname890 5 жыл бұрын
Sir I have annual return of 10 years calculated and it's standard deviation, I want to calculate pearson correlation coefficient, so can I just divide the std deviation by 10 and use it as x score for each year to calculate correlation?
@kim_yeorum
@kim_yeorum 10 жыл бұрын
thanks alot ! :)))))) chukreya bayya
@hasanejaz7547
@hasanejaz7547 3 жыл бұрын
PLEASE HOW DO we calculate average annual return from monthly returns?/
@meerathomas4734
@meerathomas4734 6 жыл бұрын
If the data is of more than 1 year say for example 5 years what should be done??!!.....someone please explain...
@FinShiksha
@FinShiksha 6 жыл бұрын
If it is daily data, it does not matter. It will give you daily standard deviation. You can them annualize it.
@1ddenis1
@1ddenis1 6 жыл бұрын
Hey, if i calculate daily volatility using like 10 years of data....when i get standard deviation is this average daily volatility over period of 10 years then ? If i get for example 5%, do I say that the average daily volatily over period of 10 years is 5 % or do i just say it without "average", just that daily volatility over period of 10 years is 5%. I want to calcualte average daily volatility and i don't know if thats the same. Thanks
@chelseaf.5561
@chelseaf.5561 9 жыл бұрын
Does this work if I only have data for about one month? I have stock prices from Februaury 2nd-March 27th of the same year, so is it okay for me to find the standard deviation the same way you did in the video?
@googlerreviewer4368
@googlerreviewer4368 4 жыл бұрын
yea but you would multiple by the number of tradings days of your data instead of the 250 days.
@nityekhoobchandani8201
@nityekhoobchandani8201 4 жыл бұрын
Using the formula for returns my value doesn't comes in percent
@anonnochowdhury12h44
@anonnochowdhury12h44 9 ай бұрын
Seriously 12years ago!!!
@lurtsify
@lurtsify 10 жыл бұрын
This is incorrect. It creates a rough approximation of the annualized standard deviation. If a rough approximation is sufficient, you can simply take the daily value and multiple it by the square root of 250. There is no need to convert to variance, multiply, and convert back. The correct method would notice that annual returns are a product (multiplication) of the daily returns rather than a summation of them.
@hoanglan4714
@hoanglan4714 10 жыл бұрын
hello thanks for your comment, yup agree that we can just take the daily SD multiplied by sqrt(250) to find the annualized SD. I'm curious what would be the method to find the exact annualized SD? And also to find annual returns, I'm not sure it would be the product of daily returns (let's say daily return is 1.5% every trading day, so the product will be (1.5%)^250 which is super small). I think we find the geometric mean of daily return and multiply by 250, or (1+mean daily return)^250 - 1. I'm not sure which one is more used in practice though
@FinShiksha
@FinShiksha 10 жыл бұрын
Hi Lurtsify, thanks for your comment. Well this annualizing is obviously an approximation using daily data, and is useful if you do not have multiple years of data available, which is an issue with most stocks and indices. If you have around 30-40 years of annual data, you can use that directly. All these calculations also assume that the returns of stocks are not on continuous compounding. It that is your assumption, the calculation will change further. But if you do not have data available for multiple years, this is a correct method for annualizing it.
@lurtsify
@lurtsify 10 жыл бұрын
FinShiksha I figured it should be pointed out because in my experience actually using this data on projects related to CAPM and redefining the efficient frontier the difference in the computed standard deviation could be as large as 15 to 25% of the value. When looking at efficient frontiers a difference in the deviation of 15 to 25% is fairly significant. I appreciate the effort to educate students though. This is certainly much better than what most students will get from their education.
@lurtsify
@lurtsify 10 жыл бұрын
Hoang Lan Your return formula is using 1.5%, but that is the same as using .015 in your calculations. In order to correct compounding you would need to use 1.015. Test the value for 1.015^250 and you'll find it is much much larger. When I started looking at the formulas I was actually quite confused and had to find a piece by a CFA charterholder that gave the entire formula. When looking at the formulas actually in use at successful hedge funds, they will all use my more complicated math. Ironically, a few of them will post the rough estimate method, which is faster by hand but once you program the equation into a computer you can rapidly apply it to thousands of scenarios so the advantage of the simple method is substantially reduced unless the amount of data being processed was so enormous it could actually substantially slow down the processors, but if that was the case you'd need to switch over to using data lakes (see new concept from GE) to enhance the speed of analysis.
@PRIYANKASINGH-ij7vz
@PRIYANKASINGH-ij7vz 3 жыл бұрын
Return kese calculate krte h
@SweetAlexMore
@SweetAlexMore 8 жыл бұрын
Then what does the 25% represent??? What does it mean? Is that a good thing?
@DavidVas0032
@DavidVas0032 7 жыл бұрын
It was actually 35% and what it means is essentially how much the annualized return will vary from it's average annualized return. So something with a small Standard Deviation (SD) and Annualized Return (AR) of 10% will generally have a value really close to 10% every year. And take for example something with a SD of 50% and a AR of 15%, then it could be expected (about 66% chance) that that years AR will range from -35% to +65%. But this type of consideration should only be taken heavily when investing over short periods of time i.e. ranging from a few months to a few years. If you are investing for long periods of time like 15+ years, then the return you will get will be just about the same as the average AR so it is nowhere near as risky if you are investing in the long run.
@sanjayjoshius
@sanjayjoshius 3 жыл бұрын
Itne fast bataya kuch samja nahi.. Bhai plse ek naya step by step Wala video banao
@vinodaxisful
@vinodaxisful 6 жыл бұрын
volatility scales with the square root of time and not with time. The calculation is wrong.
@FinShiksha
@FinShiksha 6 жыл бұрын
That is why the calculation has been done on variance, and then the overall square root has been taken. You could also directly multiple the standard deviation with root of 250. You will get the same answer.
@joywithneetuofficial
@joywithneetuofficial 5 жыл бұрын
I did not understand anything sir
FinShiksha - Conditional Formatting of data using Excel
3:34
FinShiksha
Рет қаралды 1,9 М.
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 30 МЛН
99.9% IMPOSSIBLE
00:24
STORROR
Рет қаралды 31 МЛН
How I input data in Financial Models - in less than 30 minutes
28:07
Mastering Multi-Asset Portfolio Analysis: Standard Deviation & Returns in Excel
14:34
Calculating Expected Portfolio Returns and Portfolio Variances
12:55
Calculate Annualized Returns for Investments in Excel
5:15
Six Minutes. Smarter.
Рет қаралды 199 М.
Standard Deviation Explained | Options Trading Concepts
11:24
tastylive
Рет қаралды 117 М.
Calculating beta in Excel / Analyzing stock returns / Episode 6
14:13
Initial Return
Рет қаралды 14 М.
Standard deviation (simply explained)
7:49
DATAtab
Рет қаралды 1 МЛН
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19