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

Ignored by the media, the Liberal Democrats are experiencing a revival

The crushed Liberals are doing particularly well in areas that voted Conservative in 2015 - and Remain in 2016. 

The Liberal Democrats had another good night last night, making big gains in by-elections. They won Adeyfield West, a seat they have never held in Dacorum, with a massive swing. They were up by close to the 20 points in the Derby seat of Allestree, beating Labour into second place. And they won a seat in the Cotswolds, which borders the vacant seat of Witney.

It’s worth noting that they also went backwards in a safe Labour ward in Blackpool and a safe Conservative seat in Northamptonshire.  But the overall pattern is clear, and it’s not merely confined to last night: the Liberal Democrats are enjoying a mini-revival, particularly in the south-east.

Of course, it doesn’t appear to be making itself felt in the Liberal Democrats’ poll share. “After Corbyn's election,” my colleague George tweeted recently, “Some predicted Lib Dems would rise like Lazarus. But poll ratings still stuck at 8 per cent.” Prior to the local elections, I was pessimistic that the so-called Liberal Democrat fightback could make itself felt at a national contest, when the party would have to fight on multiple fronts.

But the local elections – the first time since 1968 when every part of the mainland United Kingdom has had a vote on outside of a general election – proved that completely wrong. They  picked up 30 seats across England, though they had something of a nightmare in Stockport, and were reduced to just one seat in the Welsh Assembly. Their woes continued in Scotland, however, where they slipped to fifth place. They were even back to the third place had those votes been replicated on a national scale.

Polling has always been somewhat unkind to the Liberal Democrats outside of election campaigns, as the party has a low profile, particularly now it has just eight MPs. What appears to be happening at local by-elections and my expectation may be repeated at a general election is that when voters are presented with the option of a Liberal Democrat at the ballot box they find the idea surprisingly appealing.

Added to that, the Liberal Democrats’ happiest hunting grounds are clearly affluent, Conservative-leaning areas that voted for Remain in the referendum. All of which makes their hopes of a good second place in Witney – and a good night in the 2017 county councils – look rather less farfetched than you might expect. 

Stephen Bush is special correspondent at the New Statesman. He usually writes about politics.