Volatility calculation in Excel

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

Which data is this opening or closing

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

Thanks 🙏

Great. Thanks so much. A Very Great Piece.

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

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

Excellent

Thanks a lot!

How can I get annual exchange rate volatility

Brilliant!

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

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

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.

I found this to be helpful.

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

Thank You, this was very helpful

THANKS A LOT

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

that was brilliant.

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

What I'm saying is, don't even bother, because trading profitably is very, very hard, and very, very time-consuming. For most people, the effort required isn't worth the reward, because their "pot" is so small. Building a system that "auto-trades" profitably, is the holy grail. If Goldman Sachs haven't managed it, with legions of PhD computing and maths graduates working for them, your chances of managing it are pretty sliim. By all means go ahead and try, but just beware: it is very hard.

what do you mean?

Don't even bother.

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

@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?

Your calculations are wrong.