Archive for October, 2009

Is VBA still relevant?

October 31, 2009 1 comment

John Durant made a post about whether VBA still makes sense. I mostly agree with him that VBA still has a relevant place, specially in the financial market.

My start with VBA, or Access Basic to be precise, was all the way back in 1994. As a technical support representative, I’d created an issues tracking database to allow us to easily log different statistics for a given customer call.

Over the years, I played with different programmatic aspects of Office and was always impressed with the speed with which I was able to develop and deploy a solution to suit business needs (or just for my own amusement). In this scope, one would not think of Office as an enterprise app but as a one-off, quick and dirty, solution to a problem. Nevertheless, a solution is a solution, and some times, a quick solution is all you, or the business (more importantly), need. Of course, in the financial market, there were complex pitch books or analytics or document management or similar Office based LOB applications already in place.

Jumping forward to my entry in the financial sector, there were mixed feelings in the IT department about using Excel as a base for any solution. The main concern was maintaining a plethora of workbooks which could lead to a chaotic environment where:

  1. Multiple versions of the same workbook existed.
  2. Multiple solutions were deployed for the same problem.
  3. Users had to rely on the IT staff for Excel support.
  4. Deployment was manual, or at best, via email.
  5. Documentation and source control didn’t exist.

For an IT staff, all these are valid and very real concerns. To address these issues, we preferred a pure .Net solution, outside of Excel, if we had a choice (mainly due to point 3 and 4 above which existed with VSTO back then). Although, we did have to resort to using VSTO for quite a bit of functionality.

For the most part, everyone was happy. But, as developers supporting front office operations know from experience, there’s almost a daily need to provide business with quick “reports” or other analytics in Excel. We simply didn’t have the luxury to push back with a half-a-day or a day requirement to develop the feature before testing and deployment. This is where VBA made sense for us.

We developed a library of common functionality which we referenced from a workbook. Most of the times, deploying a new report was simply a matter of tweaking the stored proc name or the sql passed to the addin. This allowed us to respond mostly within an hour to meet business needs.

We still had to rein this beast in, though. So we managed a catalog of workbooks sent to the desk by portfolio and by feature. Anytime we came across more than 1 version of the workbook deployed, we would migrate that functionality to .Net application and then ask the user to switch from Excel to .Net.

So, all in all, I do think that VBA is still a powerful tool that can be useful in the financial market, especially when paired with how comfortable traders and analysts are with Excel. But one needs to watch out for going overboard with deploying too many VBA based solutions without porting them to .Net whenever possible.

Categories: Office

PLINQ: Sequential vs Parallel

October 31, 2009 Leave a comment

The PFx team has a good post on some things to be aware of when using parallelism.

Categories: .net

NYSE again

October 30, 2009 1 comment

This time, problems with quote dissemination.

The alert stated that the recovery process in quote dissemination processing caused a temporary interruption of all quote dissemination processing, affecting “all symbol ranges.”

The result was “a slowness in quote dissemination in a subset of our issues,” an NYSE Euronext spokesman said.


By 11:58 EDT the issue had been resolved, following a restart of the technology systems, a four-minute process.

This indicates to me that hot fail over plans

  1. may not have existed, or
  2. that they didn’t work, or
  3. a cutover couldn’t be performed due to some issues, or
  4. the “outage” didn’t trigger a cutover due to SLA thresholds.

I wonder what the typical redundancy/recovery plans for such a real time system look like.

Categories: Finance

The volume? You can’t handle the volume!

October 28, 2009 Leave a comment

I was surprised to read about NYSE Euronext halting trades on ING yesterday.

More than 99 million shares in the biggest Dutch financial- services company changed hands before a computer problem halted the stock at 4:30 p.m. in Amsterdam, according to data compiled by Bloomberg. Volume was almost six times the daily average for the last six months, the data show.


The malfunction is the latest to affect Euronext this year. Its owner, NYSE Euronext, had to delay the start of trading on its stock markets in Paris, Amsterdam, Brussels and Lisbon by about 45 minutes on April 20 because of a technical problem with the new trading system.

Categories: Finance

Free videos at CosmoLearning

October 25, 2009 Leave a comment

With the Year of Astronomy slowly drawing to a close, here’re 500+ free documentaries and videos on the subject. The list includes complete series, like Cosmos, The Planets,  and one of my favorites (though the book is still better).

It’s worth noting that the site hosts much more free educational content on a variety of subjects.

Categories: Astronomy

VS 2010 Beta 2 now available

October 21, 2009 Leave a comment

VS 2010 Beta 2 is now available to the public and the installer is already running on my laptop.

Categories: .net

Gemini renamed

October 20, 2009 1 comment
Categories: BI