Why Move Traders Away from Excel?

It's a question/sentiment that I hear often in different forms, the most recent being: "I can't help but feel like more use of Excel could be used here instead of reinventing the wheel."
 
Developer and traders both feel the frustration and difficulties of a move away from Excel.  Traders like the flexibility of Excel and the ability to get new features rapidly.  Developers feel like they're reinventing the wheel when they migrate functionality away from Excel and into rich applications.
 
So, why bother?
  • Control.  When you've got Excel spreadsheets being used by traders, there's absolutely no control.  Tools like ClusterSeven can help here and are a neccessity if you're going to stick with Excel.  Know that traders can and will screw up their formulas and this can have massive repercussions.
  • Maintenance.  You've got to get DLLs/XLLs onto a client's machine if they're going to run the complex calculations that they need.  Then you need to maintain the different versions of these libraries.  Yuck.
  • Performance.  If you're doing work in Excel, it's likely that all of your calculations, etc. are running on the client side.  Yuck.

Even with these points, it's hard to get the traders onside for a move away from Excel.  A couple of ways that we're getting around this are:

  1. Build a flexible framework that allows for rapid deployment of new features and products (often with an XML based solution).
  2. Change the game by creating a system which does not look and act like Excel but one which does what the trader needs to do in the most user-friendly way possible.  It helps if this is visually pleasing (we've been working with WPF recently and it provides capabilities to change the game).

Number 2 is hard and takes considerably more time than just replicating Excel functionality.  It requires deep knowledge of what the traders are trying to do and a time investment from the traders and technology.  Ultimately though, it's the only way that a system which is flexible, usable and better than an Excel spreadsheet will get produced.

However, there are still people who believe that Excel is best for trade capture (don't count me in that crowd).


Published: Apr-28-08 | Comments | 33200 Links to this post

Good week for JEPRS

Infusion's first-responder crisis management operational dashboard, JEPRS is having a good week. 
 
First, it was included as a featured case study as part of Microsoft's Citizen Services Platform which Syd is presenting at.
 
Today, it was featured on Microsoft's Environmental Sustainability website.
 
Nice work JEPRS team.

Published: Apr-23-08 | Comments | 32815 Links to this post

Detox and Retox???

When my wife and I decided to leave Canada and move to London, I don't think that either of us knew what we were getting into (at least I didn't).  One of my favourite things about living in London is being surprised about some of the wacky differences in the cultures.  Here's a good example of what I'm talking about:
 
Several months ago, I was walking back to BarCap after lunch and was handed a free bottle of pomegranate water.  Apparently it's supposed to be very healthy and detoxifying (so they say).
 
Here's the bottle:
 
 
Looks pretty normal, right?  OK, when you open up the 'Detox' paper attached to the water, this is what you see:
 
 
Let me get this straight...with my free 'detoxifying' pomegranate juice, I get free alcohol???  I could not stop laughing when I popped that open.  You could never do that in Canada...you just couldn't.  Sometimes I love this place.

Published: Apr-13-08 | Comments | 32849 Links to this post

London at one

Infusion London recently celebrated its one year anniversary and I thought it was high time that I get on the blogging bandwagon (although in truth I've been harrassing Kurt to set this up for me for months).
 
What should you expect to read in this space?
  • An account of the pain and pleasure of starting up a new office in a foreign country.
  • Technology and business challenges that Infusion has encountered.
  • Random musings about life in London.

Enjoy the ride.


Published: Apr-13-08 | Comments | 33094 Links to this post