Excel 12

June 9, 2006

Excel 12 aka Excel 2007 is going to be a big one for front office developers. Having coded XLLs for real time pricing and autoquoting, I was wondering when Excel would support multi threaded calcs. The good news is that Excel 12 adds multi threaded execution of XLL worksheet functions. This means that pricing sheets will now be able to fully exploit multi processor hosts.

So the next question has to be: can one run pricing XLLs in the new Excel Server environment ?  There's a limit to how much processing oomph we can have at a trading desk. Our traders are limited to two 2CPU PCs per desk, due to heat and power restrictions. If they need any more CPU we have to use blades in the machine room as remote desktops. Server hosting of pricing sheets would resolve these issues nicely.

 Fortunately, it looks like the answer is yes, given a bit of wrapping in managed code.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s