The Importance and Criticality of Spreadsheets in the City of London

Abstract

Spreadsheets have been with us in their present form for over a quarter of a century. We have become so used to them that we forget that we are using them at all. It may serve us well to stand back for a moment to review where, when and how we use spreadsheets in the financial markets and elsewhere in order to inform research that may guide their future development. In this article I bring together the experiences of a number of senior practitioners who have spent much of their careers working with large spreadsheets that have been and continue to be used to support major financial transactions and manage large institutions in the City of London. The author suggests that the City of London is presently exposed to significant reputational risk through the continued uncontrolled use of critical spreadsheets in the financial markets and elsewhere.

arXiv comment11 pages, with references

References in corpus (5)

• Spreadsheet Errors: What We Know. What We Think We Can Do
• Spreadsheet Engineering: A Research Framework
• Reducing Overconfidence in Spreadsheet Development
• Interpretation as a factor in understanding flawed spreadsheets
• Spreadsheet Assurance by "Control Around" is a Viable Alternative to the Traditional Approach

Cited by in corpus (22)

• Does an awareness of differing types of spreadsheet errors aid end-users in identifying spreadsheets errors?
• Comparison of Characteristics and Practices amongst Spreadsheet Users with Different Levels of Experience
• BiEntropy - The Approximate Entropy of a Finite Binary String
• Investigating the Potential of Test-Driven Development for Spreadsheet Engineering
• Revisiting the Panko-Halverson Taxonomy of Spreadsheet Errors
• Controlling End User Computing Applications - a case study
• Effect of Range Naming Conventions on Reliability and Development Time for Simple Spreadsheet Formulas
• Evaluation of an Intelligent Assistive Technology for Voice Navigation of Spreadsheets
• In Pursuit of Spreadsheet Excellence
• Enterprise Spreadsheet Management: A Necessary Good
• Spreadsheet End-User Behaviour Analysis
• Reducing Spreadsheet Risk with FormulaDataSleuth
• A New Approach to Spreadsheet Analytics Management in Financial Markets
• ObjTables: structured spreadsheets that promote data quality, reuse, and integration
• Considering Functional Spreadsheet Operator Usage Suggests the Value of Example Driven Modelling for Decision Support Systems
• Why Task-Based Training is Superior to Traditional Training Methods
• EuSpRIG 2006 Commercial Spreadsheet Review
• Establishing and Measuring Standard Spreadsheet Practices for End-Users
• Defending the future: An MSc module in End User Computing Risk Management
• Embedded Spreadsheet Modelling
• Spreadsheets in Clinical Medicine
• Error Estimation in Large Spreadsheets using Bayesian Statistics