December 1st, 2006, 8:54 pm
In my firm they dumped Wall Street Analytics in favor of handwritten excel sheets. WSA was just too cumbersome to use, too expensive, and not flexible enough. You can easily code all the tests in excel, even without VBA. For the optimization though....I dont know. Dont work on the CDO desk, but I guess at a price tag of 10k per year per license (something like that) you could try to code it up yourself and then claim the saved expenses from your boss in the form of a bonus (make sure to discount the future years savings...not just the 10k from this year).