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.

Photo: Getty
Show Hide image

Theresa May is paying the price for mismanaging Boris Johnson

The Foreign Secretary's bruised ego may end up destroying Theresa May. 

And to think that Theresa May scheduled her big speech for this Friday to make sure that Conservative party conference wouldn’t be dominated by the matter of Brexit. Now, thanks to Boris Johnson, it won’t just be her conference, but Labour’s, which is overshadowed by Brexit in general and Tory in-fighting in particular. (One imagines that the Labour leadership will find a way to cope somehow.)

May is paying the price for mismanaging Johnson during her period of political hegemony after she became leader. After he was betrayed by Michael Gove and lacking any particular faction in the parliamentary party, she brought him back from the brink of political death by making him Foreign Secretary, but also used her strength and his weakness to shrink his empire.

The Foreign Office had its responsibility for negotiating Brexit hived off to the newly-created Department for Exiting the European Union (Dexeu) and for navigating post-Brexit trade deals to the Department of International Trade. Johnson was given control of one of the great offices of state, but with no responsibility at all for the greatest foreign policy challenge since the Second World War.

Adding to his discomfort, the new Foreign Secretary was regularly the subject of jokes from the Prime Minister and cabinet colleagues. May likened him to a dog that had to be put down. Philip Hammond quipped about him during his joke-fuelled 2017 Budget. All of which gave Johnson’s allies the impression that Johnson-hunting was a licensed sport as far as Downing Street was concerned. He was then shut out of the election campaign and has continued to be a marginalised figure even as the disappointing election result forced May to involve the wider cabinet in policymaking.

His sense of exclusion from the discussions around May’s Florence speech only added to his sense of isolation. May forgot that if you aren’t going to kill, don’t wound: now, thanks to her lost majority, she can’t afford to put any of the Brexiteers out in the cold, and Johnson is once again where he wants to be: centre-stage. 

Stephen Bush is special correspondent at the New Statesman. His daily briefing, Morning Call, provides a quick and essential guide to domestic and global politics.