A dozen ways to avoid that $617bn 'fat finger' moment

October 10, 2014 by Nick Dalton, The Conversation
Ooops - that’s my bad. Credit: Rehan Khan/EPA

Have you ever ordered too many items online – say, buying 20 courgettes when you meant two? Then you might feel a little sorry for the anonymous broker in Japan who lost US$617 billion to a trading typo error.

Perhaps what's surprising is not so much that these mistakes are made, but that they happen so often traders have a name for it: a "fat finger" error, when someone enters a number they hadn't intended, perhaps wrong by several , and generally to the bank's loss.

This US$617 billion typo isn't the first time such errors have been made, but it's probably the largest. In 2009, another Japanese trader ordered £22 billion worth of shares in Capcom when he intended to buy £220,000. In 2002 a New York trader caused the Dow Jones index to plunge 100 points when he accidentally inflated his US$4m order to US$4 billion. In 2001 a trader at Lehman Brothers who intended to sell £3m of BP and AstraZeneca stocks added two zeros, selling £300m. The list of shame goes on, but there are probably far more smaller mistakes made every day.

You don't need to be using online trading systems to lose big money. Mistyping numbers into a spreadsheet has proven equally problematic. An investigation into JP Morgan's US$5.8 billion loss in 2012, the so-called "London Whale" trading debacle, blamed the amount of data entry needed to use a mathematical model developed in Excel.

Data-entry mistakes don't just exist in banking, either. A US study by Kenneth Laudon for the Office of Technology Assessment in 1986 found that only 26% of the records sent by the FBI's identification division were "complete, accurate and unambiguous". In medicine the results can be fatal – a single zero or decimal out of place can be the difference between the correct dose or a fatal one. "Computer error" was the fourth-highest cause of mistakes, accounting for 13% of medication errors in 2003.

Aviation also has its moments, for example Air Inter Flight 148 crashed in 1992 killing 96 people; the crew wanted to set the angle of descent to 3.3 degrees but in error set it to descend at 3,300 feet per minute and the aircraft hit a mountain.

12 ways to avoid a fat finger moment

Some ways to avoid your fat finger moment, then, hopefully when the stakes are not as high as death or bankruptcy.

  1. Stress is known to affect visual attention, which means taking a deep breath and taking your time when entering data.
  2. Repetitive data entry can lead to fatigue and what is known as familiarity blindness. If your hands get used to typing in the same number over and over, muscle memory might ensure they continue to do so, regardless of what you meant to type.
  3. Remind yourself you're never an expert, because with greater skill comes greater unconscious automation of your actions, which means paying less attention to the display.
  4. Pay attention to the units. Ask yourself, is the computer using the same units as I am? Different countries teach different styles of number formatting in schools. For example 81,234.56 can be written as 81.234,56 (Denmark) or 81'234.56 (Switzerland) or 81 8234,56 (France) or 81,234/56 (Iran) or 81.234'56 (some parts of Spain) or 8,1234.56 (China). To further confuse, most software tends to default to US-style number (and date) formats. Remember to set everything up as you intend, rather than as you find it.
  5. In one study, double entry worked really well. This is why many websites prompt you to type your email addresses or passwords twice. If you can't enter the numbers twice on the screen, enter a duplicate into a notepad. One study found visual checking resulted in 2,958% – that's not a typing error – more data entry errors than double entry.
  6. Change modes. Try speaking the number out loud before pressing enter. Using cursor keys to select digits was found to be more accurate than typing in the numbers directly.
  7. Look after the decimal point. Most transposition errors (such as typing 53 instead of 35) occur after the decimal point.
  8. If you're entering numbers into Excel try using the data validation features. It's a pain to set up, but it could be better than losing your job or your money.
  9. If you can't set limits in advance, one feature to try is the automatic cell background colour change, where numbers of different orders of magnitude switch to different colours.
  10. If you're feeling extravagant, EEG can detect errors efficiently, but if working with electrodes attached to your head doesn't appeal there are alternatives.
  11. If using an in-house data entry system, pressure the programmers to add some kind of checking behaviour, such as the colour-changing feature mentioned above, or double entry. After all, an error that undoes the company will put their jobs at risk too.
  12. Never buy anything that doesn't have a proper Undo feature. The sort of "Are you sure?" dialogue doesn't work because people get habituated to clicking it without thinking.

In one study it was found that data entry errors could be big enough to change the finding for a scientific experiment. In this era of big data, we tend to respect the numbers that come out of computers far more than we should. Without independent checks we should be careful about using any numbers too uncritically.

Errors come in all sizes – and not all of them can be solved by doubling up on courgette soup.

Explore further: Scientists track quantum errors in real time

Related Stories

Scientists track quantum errors in real time

July 14, 2014

(Phys.org) —Scientists at Yale University have demonstrated the ability to track real quantum errors as they occur, a major step in the development of reliable quantum computers. They report their results in the journal ...

Fingers detect typos even when conscious brain doesn't

October 28, 2010

Expert typists are able to zoom across the keyboard without ever thinking about which fingers are pressing the keys. New research from Vanderbilt University reveals that this skill is managed by an autopilot, one that is ...

Research shows how brain can tell magnitude of errors

September 10, 2014

(Medical Xpress)—University of Pennsylvania researchers have made another advance in understanding how the brain detects errors caused by unexpected sensory events. This type of error detection is what allows the brain ...

Insiders seen most at fault in data breaches

October 7, 2014

A new study says that most breaches of personal data in Europe over the past decade were due to errors and abuse committed by an organization's employees, not hackers.

Recommended for you

Activating tooth regeneration in mice

February 20, 2019

Most reptiles and fish have multiple sets of teeth during their lifetime. However, most mammals, such as humans, have only one set of replacement teeth and some mammals, like mice, have only a single set with no replacement. ...

1 comment

Adjust slider to filter visible comments by rank

Display comments: newest first

not rated yet Oct 11, 2014
Aviation also has its moments, for example Air Inter Flight 148 crashed in 1992 killing 96 people; the crew wanted to set the angle of descent to 3.3 degrees but in error set it to descend at 3,300 feet per minute and the aircraft hit a mountain.

That was not a "fat fingers" mistake. The computer was set in the wrong mode, and had no proper indication about which mode it was in. The readout in angles would say "3.3" while in feet it would say "3 3" to indicate 3,300 and the pilots didn't notice the missing dot.

Please sign in to add a comment. Registration is free, and takes less than a minute. Read more

Click here to reset your password.
Sign in to get notified via email when new comments are made.