Tag Archives: integration

Calling table functions from Microsoft Excel

Posted on May 26, 2013 by admin

This article explains how the table functions of the non-commercial .net library finaquant® protos can be called from within Microsoft Excel using VBA macros. Two possible integration options are presented here: 1) Calling a .net method from an Excel macro … Continue reading →

Posted in Calculation engine | Tagged , , , | 1 Comment

Importing and Exporting a DataTable from/to an Excel file

Posted on May 2, 2013 by tuncalik

As explained in the related article, a MatrixTable of finaquant can easily be converted to or from a DataTable of the .net framework (ADO.net). That is, importing or exporting a MatrixTable from/to an excel sheet can be accomplished in two … Continue reading →

Posted in Calculation engine | Tagged , , | 4 Comments

Converting a MatrixTable to a DataTable, and vice versa

Posted on May 1, 2013 by admin

MatrixTable is a type (class) for in-memory representation of data tables just like DataTable of the .net framework (ADO.net). MatrixTable has but a much simplified data structure compared to DataTable with primary focus on mathematical (or analytical) table functions rather … Continue reading →

Posted in Calculation engine | Tagged , , | Leave a comment

Table data as input to estimation functions in R

Posted on February 19, 2013 by tuncalik

As mentioned earlier in related articles, functions written in other languages like R, matlab or ILNumerics can be integrated with table functions using the high-level constructs like function router1 and subtable transformer2. Following example scenarios demonstrate how different estimation functions … Continue reading →

Posted in Calculation engine | Tagged , , | Leave a comment