Go tohttps://ca.finance.yahoo.com/(Links to an external site.)

Download adjusted daily price data for any Canadian or U.S. stock that has at least 10 years of daily price data and calculate the VaR and CVaR for the stock at the 95%, 99% and 99.9% intervals.

In the worst-case scenario (CVaR 99.9) what would you lose of your investment in this stock in a single day?

AutoSave O Off) HD- - VaR and CVaR for For Stock Question - Template.xIsx - Excel O Search File Home Insert Page Layout Formulas Data Review View Developer Help K Cut Calibri 11 -AA = = ab Wrap Text General Norma Paste [G Copy E Merge & Center $ ~ % " Conditional Format as Calcul Format Painter Formatting * Table Clipboard Font Alignment Number L27 X V fx C D E F G H J K L M N O B 1 Date Adj Close Return Sorted Number Return 1 Total Count Var(95) CVar(95) 1D CO N CI UI A W N Var(99) CVar(99) Var(99.9) CVar(99.9) Var(95) Var(99) Var(99.9) Cvar(95) CVar(99) CVar(99.9) 28