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.

Jeremy Corbyn, Labour leader. Getty
Show Hide image

Can Jeremy Corbyn win the 2017 general election?

Does the Labour leader have a chance of becoming prime minister?

 

After less than two years as Labour leader, Jeremy Corbyn is leading the party into a snap general election. This isn’t the first vote of national significance since his election, however, since he was in office during the 2016 EU referendum.

It’s also not his first serious challenge: after the Brexit vote, his MPs voted “no confidence” in him and Owen Smith challenged him for the leadership. Corbyn saw off that threat to his position convincingly, so can he pull out another electoral triumph and become prime minister?

Can Jeremy Corbyn become prime minister? The polls

Since May 2015, the Conservative Party has consistently led in the polls. The latest polls gives Labour ratings in the mid-20s, while the Conservatives are on the mid-40s – numbers which, if borne out at the polls, would give Labour its worst result since 1935.

But should we believe the general election polls? Glen O’Hara, professor of modern and contemporary history at Oxford Brookes University, points out that the polls have been wrong before, and could be overstating Labour’s collapse. However, a 20-point gap is far outside the margin of error. A Corbyn win would be an unprecedented upset.

Can Jeremy Corbyn become prime minister? Electoral record

At the 2016 local elections, Labour did not gain any councils and lost 18 seats and 4% of the vote. James Schneider, the co-founder of Momentum who is now Corbyn’s head of strategic communications, said this showed Labour was on the right trajectory, but it’s a disappointment for an opposition to make no gains. And at the Copeland by-election this February, Labour lost the seat to the Tories – the first government gain in a by-election since 1982.

Can  Jeremy Corbyn become prime minister? The verdict

Jeremy Corbyn’s path to power would be one of the greatest surprises in British politics. But unlikely doesn’t mean impossible. It would take some extraordinary events, but it could happen. Check out the latest odds to see how the markets rate his chances.

0800 7318496