How The London Whale Debacle Is Partly The Result Of An Error Using Excel
Over at The Baseline Scenario, law professor James Kwak, says that what has been generally under-reported about the London Whale debacle is how badly Excel failed as a financial modeling program.
It's all in JP Morgan's 129 page report on the $6 billion trading loss. In an appendix on page 127, the report talks about how one London-based quant was working on a new VaR (Value at Risk) model for the Chief Investment Office.
On top of not being tested correctly, the report states that the model suffered from some pretty standard Excel flaws.
During the review process, additional operational issues became apparent. For example, the model operated through a series of Excel spreadsheets, which had to be completed manually, by a process of copying and pasting data from one spreadsheet to another... in a January 23, 2012 e-mail to the modeler, the trader to whom the modeler reported wrote that he should “keep the pressure on our friends in Model Validation and [Quantitative Research].” There is some evidence the Model Review Group accelerated its review as a result of this pressure, and in so doing it may have been more willing to overlook the operational flaws apparent during the approval process.
There are some nuances about oversight and the analytic suite that the CIO was using, but the gist is this — volatility appeared lower than it should've because of issues with this model that can, in part, be traced back to how Excel was used.
Wall Street uses Excel for everything, so this is pretty troubling, but it shouldn't be surprising. Excel is just like any program — numbers can get lost, equations can get written over and a user might not even notice.
Kwak points out that when it comes to VaR models, if there's a mistake using Excel shows that there's more at risk than there actually is, banks will act. If a mistake using Excel shows that there's less at risk than there actually is, banks can run into a problem.
- Realme GT Neo 2 5G review: Great performance, fine display but camera needs work
- Cisco says a company 'leader' who encouraged TikTok followers to report strippers to the IRS is no longer employed at the company
- A half-mile installation just took 20,000 pounds of plastic out of the Pacific - proof that ocean garbage can be cleaned
- G7 leaders favour CBDCs provided they ‘support and do no harm’ to central banks
- India's farmers protest takes a gruesome turn with a chilling murder at the scene — here’s the sequence of events
- Bizarre! Shubhman Gill was brought back to bat after being declared out
- Ruturaj Gaikwad and Faf du Plessis — amazing data on how the two openers led CSK to IPL 2021 championship
- Budget and safety top criteria for Chennai households during festive season:LocalCircles