Return Volatility Calculation

I’m trying to learn for my Excel class and I’m stuck. Can you help?

Download daily historical prices of Facebook (FB) from 1/1/2017 to 6/30/2018. Calculate its daily holding period returns. Estimate FB’s annualized volatility using

  1. the latest 90-day prices,
  2. the latest 180-day prices,
  3. all prices from 1/1/2017 to 6/30/2018.
M5 Assignment – Return Volatility Calculation Rubric
Download prices and calculate HPRs 2 pts
Estimate annualized volatility using 90-day data 1 pt
Estimate annualized volatility using 180-day data 1 pt
Estimate annualized volatility using all data 1 pt
Total 5 pts

i will upload an excel file might help you and it need to be excel no screenshot