20 October 2014

John Cant

John Cant - MPI Europe Ltd

36 | posts 146,159 | views 17 | comments

Operational Risk Management

To share information, ideas and experience relating to all aspects of op-risk management and compliance with Basel II
A post relating to this item from Finextra:

Excel error leaves Barclays with unwanted Lehman assets

15 October 2008  |  23623 views  |  0
Barclays Capital has been forced to file a legal relief motion relating to its acquisition of Lehman Brothers' US assets after a reformatting error with an Excel spreadsheet resulted in 179 contracts ...

Excel is like a chainsaw

15 October 2008  |  5431 views  |  0

Excel is a powerful tool. Like a chainsaw, in the hands of a skilled operator it is hugely effective – but in untrained or rushed hands and without the proper safety equipment it can be positively dangerous. This latest story of spreadsheet mayhem is just another illustration of the power to get it wrong.

Microsoft themselves understand that for some business critical functions if you must use Excel, you should supplement it with additional tools such as those from Microsoft (and MPIE) alliance partner Finsbury Solutions (there are other similar tools, it is just that from our experience we think it is best for Financial Sector uses). For run of the mill spreadsheets the additional error checking, security, auditing and workflow, whilst preserving the majority of the power and flexibility of the spreadsheet, may not be needed. However, from the analysis we have done with clients across a range of spreadsheet use, there are a significant percentage that would benefit. For business critical uses where these is significant money to be lost, these tools and supporting processes and techniques can offer an important safety net.

TagsRisk & regulationWholesale banking

Comments: (0)

Comment on this story (membership required)
Log in to receive notifications when someone posts a comment

Latest posts from John

Would you ask someone else if they Know Your Client?

26 April 2014  |  1013 views  |  0  |  Recommends 0 TagsRisk & regulationInnovationGroupInnovation in Financial Services

To Tweet or Not to Tweet?

10 November 2010  |  3404 views  |  1  |  Recommends 0 TagsOnline bankingRetail bankingGroupInnovation in Financial Services

Does Cloud reduce operational risk and complexity

04 November 2010  |  5581 views  |  0  |  Recommends 0 TagsRisk & regulationPost-trade & opsGroupFinance 2.0

Do fines change the behaviour of financial firms?

06 October 2010  |  3406 views  |  1  |  Recommends 0 TagsRetail bankingWholesale bankingGroupInnovation in Financial Services

What sport tells us about financial regulation?

01 September 2010  |  4433 views  |  2  |  Recommends 0 TagsRisk & regulationWholesale bankingGroupInnovation in Financial Services
name

John Cant

job title

Managing Director

company name

MPI Europe Ltd

member since

2007

location

London

Summary profile See full profile »
I lead MPI Europe a niche financial sector consulting firm focussing on regulatory driven, risk, ...

John's expertise

Who is commenting on John's posts