Author Archives: tuncalik

How to Apply a User-Defined Function on Rows of a Table in Excel

Though simple in use, Transform Rows with UDF (User-Defined Function) is one of the most powerful and versatile table functions. With this function you can manipulate every field of a table row as function of all other fields. A user-defined … Continue reading

Posted in Calculation engine | Tagged , | Leave a comment

Testing Table Valued Functions with LINQPad

LINQPad is a lightweight software development tool for .net developers that can be installed easily within a minute. LINQPad users may find it practical to test table-valued functions of finaquant’s .net libraries Finaquant Protos or Calcs directly in LINQPad, especially … Continue reading

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

Building a Web Service that Receives and Returns Data Tables

As you will see below, it is quite easy to build a web service with the Web API Framework (ASP.NET), which: receives data tables from a web client as input parameters, makes some analytical operations on these input tables using … Continue reading

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

Commission Calculation with Table-Valued Functions

Dealer, sales or any other kind of commissions can be calculated quite easily with the table functions of the .net library finaquant® calcs, as the following example will demonstrate. In this article we explain: Basic transaction-based (sales data) commission scenario … Continue reading

Posted in Fee and commission calculations | Tagged , | Leave a comment