Author Archives: tuncalik

How to Add a User-Defined Table Function to Excel

Finaquant’s Excel add-in (Finaquant in Excel) comes with a list of table-valued functions like Table Arithmetics, Combine Tables, Filter Table, Aggregate Table, Distribute Table, and so on. You can however extend this list with your own user-defined table functions. Following … Continue reading

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

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