Return Volatility Calculation (Excel)

Return Volatility Calculation Download daily historical prices of Facebook (FB) for the most recent calendar year fusing 1Y as time period on Yahoo firuncel. Calculate Fars daily holding period returns during our sample period, Estimate FB's annualized volatility using 1. the latest 90 -day prices. 2. the btest 180 -day prices. 3. all prices in our sample period. You can use any methodolozy introfuced in the video lectures. Download daily historical prices of a gold ETF; SPDR Gold Shares (Ticker GL.D) for the most recent calendar year fuing iY as time period on Yahoo firancel Calculate GLD i daly holding period returns during our sample period. Estimate GLO's annalized volatilly uting 1. the latest 90 -day prices, 2. the latest 180 -day prices. 3. all prices in our sample period. You can use any methodology introduced in class