Please complete assignment by making an EXCEL file

Step 1: Please select 3 currencies you are interested in and collect their historical data. The historical data covers the period from Nov. 1, 2021 to Oct. 26, 2022, and must include three types: 1. daily data, 2. weekly data, 3. monthly data. Step 2: Use the above three types of data to calculate the volatility of each currency. The volatility of each currency needs to include two types: non-annualized volatility and annualized volatility. Therefore, you need to make 18 volatilities in this assignment: 3 currencies x 3 frequencies (daily, weekly, monthly) x 2 types (non-annualized and annualized).