How to calculate the annual volatility of a stock with VBA?

[Luu4466]

Good afternoon.
I would like to have a program where I select one ticker of a stock (ex: AAPL) and a period (from 01/01/2010 until 31/12/2019) and I obtain the annual volatility of this stock from 201O until 2019.
Do you know how to do this?
Thank you for your help.
Have good day

[MrShorty]

Are you required to use VBA for this? What is your algorithm for computing annual volatility?

A quick internet search found this tutorial (https://www.investopedia.com/ask/ans...lity-excel.asp ) that shows one way to calculate volatility in Excel that does not use VBA. Their formula seems simple enough that I see no reason to resort to VBA for this.

It sounds like you have a long data base to pull from. I expect that Excel's pivot table (https://www.excel-easy.com/data-****...ot-tables.html ) and/or filter (https://www.wikihow.com/Use-AutoFilter-in-MS-Excel ) tools will be easier to use for extracting a subset of the raw data for this analysis. Power Pivot or Power Query would probably be better tools for filtering the data than VBA, though I am not familiar with these tools.

Does that help, or are you required to use VBA to filter the data and calculate volatility?

[Luu4466]

Thank you for you answer @MrShorty but I need to calculate the volatility of 120 stocks. I will upload the file tomorrow with the 37 stocks (the file is too big with 120 stocks)
So I need a VBA to calculate with efficiency the volatility of each stock.