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

Unite stewards urge members to back Owen Smith

In a letter to Unite members, the officials have called for a vote for the longshot candidate.

29 Unite officials have broken ranks and thrown their weight behind Owen Smith’s longshot bid for the Labour leadership in an open letter to their members.

The officials serve as stewards, conveners and negotiators in Britain’s aerospace and shipbuilding industries, and are believed in part to be driven by Jeremy Corbyn’s longstanding opposition to the nuclear deterrent and defence spending more generally.

In the letter to Unite members, who are believed to have been signed up in large numbers to vote in the Labour leadership race, the stewards highlight Smith’s support for extra funding in the NHS and his vision for an industrial strategy.

Corbyn was endorsed by Unite, Labour's largest affliated union and the largest trades union in the country, following votes by Unite's ruling executive committee and policy conference. 

Although few expect the intervention to have a decisive role in the Labour leadership, regarded as a formality for Corbyn, the opposition of Unite workers in these industries may prove significant in Len McCluskey’s bid to be re-elected as general secretary of Unite.

 

The full letter is below:

Britain needs a Labour Government to defend jobs, industry and skills and to promote strong trade unions. As convenors and shop stewards in the manufacturing, defence, aerospace and energy sectors we believe that Owen Smith is the best candidate to lead the Labour Party in opposition and in government.

Owen has made clear his support for the industries we work in. He has spelt out his vision for an industrial strategy which supports great British businesses: investing in infrastructure, research and development, skills and training. He has set out ways to back British industry with new procurement rules to protect jobs and contracts from being outsourced to the lowest bidder. He has demanded a seat at the table during the Brexit negotiations to defend trade union and workers’ rights. Defending manufacturing jobs threatened by Brexit must be at the forefront of the negotiations. He has called for the final deal to be put to the British people via a second referendum or at a general election.

But Owen has also talked about the issues which affect our families and our communities. Investing £60 billion extra over 5 years in the NHS funded through new taxes on the wealthiest. Building 300,000 new homes a year over 5 years, half of which should be social housing. Investing in Sure Start schemes by scrapping the charitable status of private schools. That’s why we are backing Owen.

The Labour Party is at a crossroads. We cannot ignore reality – we need to be radical but we also need to be credible – capable of winning the support of the British people. We need an effective Opposition and we need a Labour Government to put policies into practice that will defend our members’ and their families’ interests. That’s why we are backing Owen.

Steve Hibbert, Convenor Rolls Royce, Derby
Howard Turner, Senior Steward, Walter Frank & Sons Limited
Danny Coleman, Branch Secretary, GE Aviation, Wales
Karl Daly, Deputy Convenor, Rolls Royce, Derby
Nigel Stott, Convenor, BASSA, British Airways
John Brough, Works Convenor, Rolls Royce, Barnoldswick
John Bennett, Site Convenor, Babcock Marine, Devonport, Plymouth
Kevin Langford, Mechanical Convenor, Babcock, Devonport, Plymouth
John McAllister, Convenor, Vector Aerospace Helicopter Services
Garry Andrews, Works Convenor, Rolls Royce, Sunderland
Steve Froggatt, Deputy Convenor, Rolls Royce, Derby
Jim McGivern, Convenor, Rolls Royce, Derby
Alan Bird, Chairman & Senior Rep, Rolls Royce, Derby
Raymond Duguid, Convenor, Babcock, Rosyth
Steve Duke, Senior Staff Rep, Rolls Royce, Barnoldswick
Paul Welsh, Works Convenor, Brush Electrical Machines, Loughborough
Bob Holmes, Manual Convenor, BAE Systems, Warton, Lancs
Simon Hemmings, Staff Convenor, Rolls Royce, Derby
Mick Forbes, Works Convenor, GKN, Birmingham
Ian Bestwick, Chief Negotiator, Rolls Royce Submarines, Derby
Mark Barron, Senior Staff Rep, Pallion, Sunderland
Ian Hodgkison, Chief Negotiator, PCO, Rolls Royce
Joe O’Gorman, Convenor, BAE Systems, Maritime Services, Portsmouth
Azza Samms, Manual Workers Convenor, BAE Systems Submarines, Barrow
Dave Thompson, Staff Convenor, BAE Systems Submarines, Barrow
Tim Griffiths, Convenor, BAE Systems Submarines, Barrow
Paul Blake, Convenor, Princess Yachts, Plymouth
Steve Jones, Convenor, Rolls Royce, Bristol
Colin Gosling, Senior Rep, Siemens Traffic Solutions, Poole

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