Category Archives: Calculation engine

Calculation engines and frameworks

Calculation Nodes and Networks

The .NET Calculation Engine library finaquant® calcs (available until August 2013) will comprise Calculation Nodes and Networks in addition to the table functions of the non-commercial finaquant® protos. The term table function should be clear by now: Functions with in-memory … Continue reading

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

Calling table functions from Microsoft Excel

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

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 , , | 5 Comments

Converting a MatrixTable to a DataTable, and vice versa

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 , , | 1 Comment