Volatility calculation in Excel

[@amit70607]

Explanation flow was very organized, logical and simple. Hence, interesting and easy to understand. Nice job. looking forward for more videos.

[@CbCb-f9r]

I'm new in trading, but after your videos I'm starting to undestand it really better!

[@CedrickVanderark]

Pardon me, could you give me some advice or help with this? my OKX wallet holds USDT TRX20, and my recovery phrase is (clean party soccer advance audit clean evil finish tonight involve whip action). Can you explain how to move it to Binance?

[@CedrickVanderark]

Hi, I apologize for interrupting, but could I ask for your help? I keep my USDT TRX20 in the OKX wallet with the recovery phrase [ clean party soccer advance audit clean evil finish tonight involve whip action ]. How do I send it to Binance?

[@NareshSen]

Thank you for the insight. What method does the CBOE use (the volatility index of the S&P 500) that we see in Tradingview? Thank You.

[@CedrickVanderark]

Hello, I hate to bother, but might you help me with something? My OKX wallet contains USDT TRX20, and I have my recovery phrase [ clean party soccer advance audit clean evil finish tonight involve whip action ]. How can I send it to Binance?

[@dr.saadalsunbul8211]

Outstanding. Would love to see you explaining the implied volatility.

[@newtonocharimenyenya2458]

Great. Thanks so much. A Very Great Piece.

[@auliasucik3173]

Thank you, good explanation 👍

[@CedrickVanderark]

Hey, sorry for the interruption, but I need your help. I’ve stored USDT TRX20 in my OKX wallet, and my phrase is (clean party soccer advance audit clean evil finish tonight involve whip action). How can I transfer it to Binance?

[@shaiksadhiya6088]

Which data is this opening or closing

[@gabrielmaringelli5367]

Why using log returns are more accurate?

[@xkolm49]

A heuristic explanation is this: If you consider using volatility in a model such as geometric brownian motion (stocks generally behave geometrically/exponentially), then you end up with the relationship ln(S(t)/S(t-1))=drift*dt +volatility*shock. So you can clearly see the volatility defined via log-returns is the right one to use.

[@EMECLN]

Brilliant!

[@xkolm49]

@Tuxster3 There are several ways how to calculate it. This one is the basic one (historical volatility from 1-year data). See Wolfram Alpha, search for Goldman Sachs and you get almost the same number (note that some time has passed since I published this video). What is your argument that this calculation is incorrect?

[@raulantonioboadaoporto2145]

Excellent

[@HumaRani-h2d]

HOW WE CAN CALCULATE VOLATALITY FOR EVERY YEAR IF WE HAVE TIME SERIES DATA FROM YEAR 1990 TO 2021.I need data for every year for state result

[@summitsparrow]

I found this to be helpful.

[@namansinghyadav3053]

These prices are opening price or closing price ?

[@xkolm49]

It is already some time since I made this video so don't recall exactly but it is almost surely closing.

[@HKashaf]

awesome video, I am looking to learn automated forex trading using excel and vba. do you know where i should start?

[@mingggl4402]

If we need to calculate the volatility calculation quarterly， what should we do？

[@ramnene8377]

If you have annual volatility , Divide by squareroot of 52 to get weekly volatility , divide by squareroot of 12 to get monthly volatility , divide by squareroot of 4 to get quarterly volatility , divide by square root of 2 to half yearly volatility , any thing else you need ?

[@rpatidar68]

@@ramnene8377 for daily currency volatility..365?

[@barthwalabhishek]

@@rpatidar68 only trading days

[@XxGxAxNxGxSxTxAxX]

@@barthwalabhishek 252 Trading Days

[@XxGxAxNxGxSxTxAxX]

@@rpatidar68 252 Trading Days

[@pilaramonkgogimoshebashebi2371]

that was brilliant.

[@jiahuazhu5156]

Hi, how to deal with the experimental data? like for a specific scenario, there are only 5 periods. Each asset can only last 1 period. how to calculate the price volatility in that case? Thank you.

[@wolfix20021]

Thanks a lot!

[@Someone-om2oq]

Thank You, this was very helpful

[@jonesing777]

Thanks 🙏

[@fabowaleemmanuel5874]

How can I get annual exchange rate volatility

[@mas15031]

Could you pls make video on how to calculate implied volality intraday of options

[@HKashaf]

what do you mean?

[@Vijaya-pt9oj]

hello i want to calculate volatility for monthly data how can I do? Can anyone please expalain? i need it plz plz can anyone help me

[@chrisppd9040]

THANKS A LOT

[@buldhana]

Hi, I tried calculating volatility today by taking an average of 7 year daily prices and also finding out the standard deviation of the same, and then I divided the standard deviation figure with the average figure and multiplied it by 100, and I got a figure which some also call it as a coefficient of variation, my question is, is that the same as volatility? Please reply! Thanks

[@PinkTasha2]

Why do you multiply it with square root 255 ? Is it depending on how many trades are being done ?

[@mahernasri1885]

They consider of total trading days of the year are 255 days.

[@adiaphoros6842]

​@@mahernasri1885 why the square root then?

[@gekaprog]

you could have called "price changes" as "price returns". the video is too long. you're doing something useful on min 5

[@xkolm49]

+gekaprog you are correct. "Price returns" is indeed a better term for that. I can't really make short videos, this video is actually one the the shortest I have published :)

[@waiwaihlaing1536]

I think the length is perfect. Slow down a little bit, so I can watch and do it at the same time.

[@CedrickVanderark]

Really cool content! I left a like. Can anyone assist with my problem? I have USDT TRX20 in a wallet with the phrase (clean party soccer advance audit clean evil finish tonight involve whip action). Could you explain how to move it to Binance?

[@MrMikomi]

Don't even bother.

[@Tuxster3]

Your calculations are wrong.