Is Excel the most dangerous piece of software in the world?

Microsoft's calculator is partially to blame for JPMorgan losing $9bn, and a lot more besides.

Is Excel the most dangerous piece of software in the world? Baseline Scenario's James Kwak reports on a little-mentioned aspect of the notorious "London Whale" debacle at JPMorgan, where Bruno Iksil headed a proprietary trading team which made losses of up to $9bn.

It turns out, Kwak writes, that Excel was partly to blame:

To summarize: JPMorgan’s Chief Investment Office needed a new value-at-risk (VaR) model for the synthetic credit portfolio (the one that blew up)… The new 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”… After the London Whale trade blew up, the Model Review Group discovered that the model had not been automated and found several other errors. Most spectacularly,

“After subtracting the old rate from the new rate, the spreadsheet divided by their sum instead of their average, as the modeler had intended. This error likely had the effect of muting volatility by a factor of two and of lowering the VaR…”

Kwak wonders if the very ease of use that Excel offers — allowing people with no programming experience to knock together what are, in effect, relatively advanced applets — also makes it dangerous to use in most sensitive situations. There's no debug, no audit trail, and no way to test why a spreadsheet returns the value it does. Similarly, training for Excel, where it exists, tends to ignore the importance of elegant and well-designed code, leading to legacy spreadsheets being used with internal workings which are opaque to all but their original creator, who may have left the company 20 years earlier.

The problem is, though, that Excel is the worst way to run a company's software other than all the other ways. The fact that it's capable of being programmed by the people who will end up using it means that it might enable hacked-together code, but it also prevents exactly the sort of corporate bloat which leads to people circumventing their company's software in the first place.

Bill Gates threatens the world with Microsoft Office in 2003. Photograph: Getty Images

Alex Hern is a technology reporter for the Guardian. He was formerly staff writer at the New Statesman. You should follow Alex on Twitter.

Getty
Show Hide image

Commons Confidential: What happened at Tom Watson's birthday party?

Finances, fair and foul – and why Keir Starmer is doing the time warp.

Keir Starmer’s comrades mutter that a London seat is an albatross around the neck of the ambitious shadow Brexit secretary. He has a decent political CV: he was named after Labour’s first MP, Keir Hardie; he has a working-class background; he was the legal champion of the McLibel Two; he had a stint as director of public prosecutions. The knighthood is trickier, which is presumably why he rarely uses the title.

The consensus is that Labour will seek a leader from the north or the Midlands when Islington’s Jeremy Corbyn jumps or is pushed under a bus. Starmer, a highly rated frontbencher, is phlegmatic as he navigates the treacherous Brexit waters. “I keep hoping we wake up and it’s January 2016,” he told a Westminster gathering, “and we can have another run. Don’t we all?” Perhaps not everybody. Labour Remoaners grumble that Corbyn and particularly John McDonnell sound increasingly Brexitastic.

To Tom Watson’s 50th birthday bash at the Rivoli Ballroom in south London, an intact 1950s barrel-vaulted hall generous with the velvet. Ed Balls choreographed the “Gangnam Style” moves, and the Brockley venue hadn’t welcomed so many politicos since Tony Blair’s final Clause IV rally 22 years ago. Corbyn was uninvited, as the boogying deputy leader put the “party” back into the Labour Party. The thirsty guests slurped the free bar, repaying Watson for 30 years of failing to buy a drink.

One of Westminster’s dining rooms was booked for a “Decent Chaps Lunch” by Labour’s Warley warrior, John Spellar. In another room, the Tory peer David Willetts hosted a Christmas reception on behalf of the National Centre for Universities and Business. In mid-January. That’s either very tardy or very, very early.

The Labour Party’s general secretary, Iain McNicol, is a financial maestro, having cleared the £25m debt that the party inherited from the Blair-Brown era. Now I hear that he has squirrelled away a £6m war chest as insurance against Theresa May gambling on an early election. Wisely, the party isn’t relying on Momentum’s fractious footsloggers.

The word in Strangers’ Bar is that the Welsh MP Stephen Kinnock held his own £200-a-head fundraiser in London. Either the financial future of the Aberavon Labour Party is assured, or he fancies a tilt at the top job.

Dry January helped me recall a Labour frontbencher explaining why he never goes into the Commons chamber after a skinful: “I was sitting alongside a colleague clearly refreshed by a liquid lunch. He intervened and made a perfectly sensible point without slurring. Unfortunately, he stood up 20 minutes later and repeated the same point, word for word.”

Kevin Maguire is the associate editor (politics) of the Daily Mirror

Kevin Maguire is Associate Editor (Politics) on the Daily Mirror and author of our Commons Confidential column on the high politics and low life in Westminster. An award-winning journalist, he is in frequent demand on television and radio and co-authored a book on great parliamentary scandals. He was formerly Chief Reporter on the Guardian and Labour Correspondent on the Daily Telegraph.

This article first appeared in the 19 January 2016 issue of the New Statesman, The Trump era