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

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

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?

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.