Author Archives: admin

Anatomy of Table Addition

With the following examples we want to demonstrate the practicality and versatility of table functions related with various addition operations. These examples may also provide our readers with a general idea about the logic of table functions included in our … Continue reading

Posted in Calculation engine | Tagged | Leave a comment

Application Scope of Calculation Engine finaquant® calcs

The upcoming .NET Library finaquant® calcs can be used to transform raw historical data into useful information for both operational and analytical purposes. Example for operations: Calculation of Dealer or Sales Commissions, Performance Fees etc. to ultimately produce some invoices … 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

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