Reports The Use of Spreadsheets in Commodity Trading | Page 8

The Use of Spreadsheets in Commodity Trading – 2015

8

La
uppck of v
er m isibi
ana lity fo
gem r
Lac
ent
k of
con
curr
ent
acc
Diffi
ess
cult
to g
ene
rate
rep
or ts

Diffi
cult
to te
st

Reg
ulat
ory/
C
gov orpora
ern
anc te
Lac
e
k of
bus
ines
s co
ntro
Inab
l
ility
to e
ns u
re a
ccu
racy

Erro
r pr
one

Lac
k of

aud
it

trail

Figure 6 | Disadvantages of Spreadsheets

Figure 7 | Concerned Over Spreadsheet Use?

When asked if the respondent was aware of a spreadsheet “horror story”, some 68% of the respondents indicated that they knew of at least one incident where the use of a
spreadsheet had created operational or financial issues. Some
of the respondents (we used both data sets here) related their
own bad experiences of using spreadsheets. These stories are
very telling and offer much food for thought when reviewing
the use of spreadsheets in your own organizations:
// A $2 million trading error was traced to the replacement of a
cell formula with a fixed