Resolver One for Quantitative Analysts
|
When you're building quantitative models, you have a huge range of languages and tools available. You can use statistics packages like R or S-plus, mathematical tools like Matlab, programming languages like C++ or Python... or you can use a spreadsheet. And however great the other tools are, spreadsheets frequently turn out to be the easiest way to get started — and they all-to-frequently turn out to be the longer-term solution you wind up maintaining. The spreadsheet model is a great way to get started, but eventually you hit the limit of what you can do with just formulae, and you have to build macros and user-defined functions in languages like VBA... and then the problems start. It works for simple scripting, and is fine if you structure your code with incredible care, but wouldn't it be nice to have a spreadsheet that supported a better programming language, with powerful analytical functions built in? Resolver One is a new kind of spreadsheet that is programmable in Python. You can write your user-defined functions in the language, and use it as an alternative syntax for your formulae. But more than that, you can also use the vast number of freely-available powerful packages that the language supports; packages like NumPy for high-performance numerical methods or Statlib for statistics. Even better, if you or your IT team have built analytical functions in Microsoft's .NET environment (using languages like C#) then you can just drop them in to Resolver One and use them directly. You get the benefits of Python and C#'s programmability with a spreadsheet's ease of use. You can even import your existing Microsoft Excel™ documents, or export Resolver One documents as .xls files. Want to find out more? Just follow the link below. |
 
|