Avoiding spreadsheet Hell
The JP Morgan Task Force Report into its Chief Investment Office’s $6 billion-plus loss found the bank’s Value at Risk was being calculated with an Excel spreadsheet that “required time-consuming manual inputs to entries and formulas, which increased the potential for errors”.