Article in Derivatives Strategy
Spreadsheet Shootout

Extensive, well-documented capital markets code library, particularly strong in Fixed income.

By Andrew Webb and David Little

TechHackers was founded by Atul Jain and Michael How in 1986. The company's spreadsheet product, @nalyst, consists of six principal add-in libraries: Financial @nalyst, Bond @nalyst, Options @nalyst, MBS @nalyst, Exotics @nalyst and Swap @nalyst. As the titles imply, the products are mostly aimed at specific underlying markets. The exception is Financial @nalyst, which is suited to utilities for such functions as NPV, IRR, date arithmetic and business day calculations. The products are in use with some 3,000 institutions worldwide and are supposed by offices in New York and London. The analytics in the package are also available as QuantTools, C/C++ callable object libraries. The @nalyst range provides a total of more than 200 functions that can be run in either Excel or Applix.

Little: The main selling point of TechHackers' @nalyst package is its extensive market coverage, especially in fixed income. If you are buying a code library for a floor with multiple desks that focus on fixed-income areas, this is the one to choose.

The product has MBS, swaps, international EMG bonds, exotics of all types, a base set of core functionality that will be shared by all, and a great generic cash-flow manipulation/modeling module. The package is ideal for the enterprise that will be supported by a technical infrastructure but is smart enough not to build its own code. The documentation is extensive and covers everything you need to use the product (including numerous examples), and is available both in print and on-line. The functions are not designed to be that easy to use; I found that you could get lost in the code, because the parameters are complex and have no real design sensibility. TechHackers has made this a lot easier with helpful wizards that set most of the things up for you, but still, when you have to get down into it, you might find yourself squinting at the screen, counting commas and underlining examples in the book. Overall, the package is strong, will do most of the things you need a library code for, and covers almost the entire capital markets trading world. The only hitch is that TechHackers makes you pay for each different type of exotics option set. Why not stick them all together and raise the price? No one who trades path-dependent options makes a decision on code libraries based on the money.