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

Who will win the Copeland by-election?

Labour face a tricky task in holding onto the seat. 

What’s the Copeland by-election about? That’s the question that will decide who wins it.

The Conservatives want it to be about the nuclear industry, which is the seat’s biggest employer, and Jeremy Corbyn’s long history of opposition to nuclear power.

Labour want it to be about the difficulties of the NHS in Cumbria in general and the future of West Cumberland Hospital in particular.

Who’s winning? Neither party is confident of victory but both sides think it will be close. That Theresa May has visited is a sign of the confidence in Conservative headquarters that, win or lose, Labour will not increase its majority from the six-point lead it held over the Conservatives in May 2015. (It’s always more instructive to talk about vote share rather than raw numbers, in by-elections in particular.)

But her visit may have been counterproductive. Yes, she is the most popular politician in Britain according to all the polls, but in visiting she has added fuel to the fire of Labour’s message that the Conservatives are keeping an anxious eye on the outcome.

Labour strategists feared that “the oxygen” would come out of the campaign if May used her visit to offer a guarantee about West Cumberland Hospital. Instead, she refused to answer, merely hyping up the issue further.

The party is nervous that opposition to Corbyn is going to supress turnout among their voters, but on the Conservative side, there is considerable irritation that May’s visit has made their task harder, too.

Voters know the difference between a by-election and a general election and my hunch is that people will get they can have a free hit on the health question without risking the future of the nuclear factory. That Corbyn has U-Turned on nuclear power only helps.

I said last week that if I knew what the local paper would look like between now and then I would be able to call the outcome. Today the West Cumbria News & Star leads with Downing Street’s refusal to answer questions about West Cumberland Hospital. All the signs favour Labour. 

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