Estimating Risk Measures (How to use VAR, ETL in Excel)
Writing in Financial Engineering News, Kevin Dowd explains how to use Excel to calculate VAR and other risk measures. This will be VERY HELPFUL in class!!!
For instance: “To estimate the daily VaR at, say, the 99 percent confidence level, we can use Excel’s Large command, which gives the kth largest value in an array. Thus, if our data are an array called ‘losses,’ we can … [ Read more ]
Content: Article | Author: Kevin Dowd | Source: Financial Engineering News | Subject: Finance