Why finaquant® protos?

  • A free (zero-priced) .net library for analytical table functions; as far as we know, there is not a similar library yet in .net or java.

    Using this library, you can formulate table calculations without any SQL-based database programming, just like you would write mathematical matrix functions with matlab or R.

    So we think, users who can write matrix functions with matlab or R, or formulas in excel can use this library after learning the basic syntax of a .net language like C# or Visual Basic.

  • This library offers many general purpose table functions that are often required in applications like statistical estimations, cause-effect relationships, financial planning, reporting, fee and commission calculations.

    Good examples are function routers, aggregators, table arithmetics, date filters and samplers.

    This has two primary advantages:

    1. Users don’t need to spend time and brain force to write such functions; they are already written, documented and tested.
    2. Users are made aware that such general calculation patterns exist! So they save time and effort.

    You realize that some seemingly case or company specific problems can be solved with such general table functions, by just setting appropriate parameters.

  • A holistic approach to numerical computation: The users of math software like matlab, ILNumerics or R can use this library to apply their functions on selected parts of data residing in tables.

    An example demonstration with Function Router:
    How can estimation functions in R can be applied on selected parts of an input table

    In that sense, finaquant® protos integrates analytical table functions with matrix functions. These matrix functions need not be written with protos at all; they can also be written in other languages of math like R or matlab.

  • Upcoming feature, calculation nodes (until June 2013):
    Ability to calculate and store all the table valued parameters of multiple calculation instances

    For example you may want to execute a table function with 10 input and 5 output tables every month for every country for calculating some price estimations.

    A calculation node fetches all the inputs from the databases you want, executes its table function and writes the results to the databases you want, together with the instance information (month and country).

    This feature may be quite useful for applications that require periodic calculations and reporting.

Leave a Reply