Category Archives: Calculation engine

Calculation engines and frameworks

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

Persistent Table Array

Posted on April 9, 2013 by tuncalik

PersistentTableArray and DataStore are new classes of the non-commercial .net library finaquant® protos (starting from release 1.04) that enable connection to relational databases like MySQL and Microsoft SQL in order to read/write complete tables from/to a database together with their … Continue reading →

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