When I was working in the financial risk industry, I noticed quantitative work (e,g. risk modelling, risk estimation) was first done in software like SAS/R/Matlab and the results then copy-and-pasted into Excel to be shared with stakeholders (e.g. managers, decision makers, regulators). Oftentimes, stakeholders would like to see what happens if a parameter is changed. But since the quantitative work wasn't done in Excel, it's impossible to give an answer "live" on the spot. QRS Toolbox for Excel changes all that. It adds a collection of custom functions for quantitative risk calculations to Excel. There are functions for estimating value-at-risk and expected shortfall, performing linear and logistic regression, generating random numbers for Monte Carlo simulation, and more. For example, you can perform logistic regression with stepwise selection using only a formula, so when you change a parameter, your stakeholders can see its impact live. Some functions are free. Premium functions are available for free trials. Do give it a try.

QRS Toolbox for Excel

Custom functions for quantitative risk calculations in Excel

Custom functions for quantitative risk calculations in Excel