Excel errors: JP Morgan’s whale-sized classic
A financial journalist delved into the causes for a major trading scandal at US investment bank JP Morgan - and guess what he discovered?
Last year, the supposedly robust and fortress-like JP Morgan surprised regulators and the market by reporting that an employee in its chief investment office had racked up trading losses of $6.2bn. The culprit Bruno Iksil became known as the “London Whale” because of the scale of his trading.
As usual, the episode set off a whelter of internal and external investigations culminating in hearings before the US senate this week.
ExcelZone picked up the trail from Smurf on Spreadsheets and followed it to Zerohedge.com, where Tyler Durden looked at the background in more detail. One of the initial warning signs was a huge leap in the bank’s VaR figures in the first quarter of 2012.
According to the bank’s SEC 10-Q filing, “The increase in CIO average VaR was due to changes in the synthetic credit portfolio held by CIO as part of its management of structural and other risks arising from the Firm's on-going business activities.”
Durden urged readers to keep that last statement in mind as he delved into an internal task force report that explained the circumstances behind the VaR reporting discrepancy. Previously, the bank had relied on a Basel II.5-based spreadsheet model for the CIO’s VaR reporting, but stopped doing so in 2012 after errors were discovered in the model, including an operational error in the calculation of the relative changes in hazard rates and correlation estimates.