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 for running queries on input and output tables. This is quite easy as the following steps will illustrate.
How to run demo queries with table functions in LINQPad
Demo queries (scripts in C# and VB.NET) for finaquant’s table-valued functions
1) Download and install LINQPad
How LINQPad is defined by its developer: Querying is merely a special case of using LINQPad. More generally, LINQPad is a C#/VB/F# scratchpad that instantly executes any expression, statement block or program with rich output formatting and a wealth of features that “just work”.
2) Download and install one of the .net libraries with table-valued functions, Finaquant Protos (free) or Finaquant Calcs (commercial).
All the demo queries (i.e scripts) in LINQPad can be run with both libraries, excluding the Commission Calculation example which requires Finaquant Calcs.
These libraries include high-level methods (of class MatrixTable) with table-valued parameters, as often required in analytics or business intelligence. Continue reading →
MS Visual Studio 2012 project Web Client (.NET 4.0)
As you can imagine, you could implement a variety of data processing services with such a web service which is capable of receiving and returning data tables (of type MatrixTable). Here are some examples: Continue reading →
Table Functions of our .NET libraries finaquant® protos (non-commercial) or finaquant® calcs (commercial) can be used to formulate evaluation function (also known as objective or fitness function) and constraints in any optimization scenario quite easily without cumbersome database programming; following model example shows how.
The output of an evaluation function can be measures like profit, time or costs, depending on the figure you want to minimize or maximize. In the following example, we want to get optimal marketing investment amounts per brand (value drivers) in order to maximize total profit from sales.
We will use Nelder-Mead Solver from Microsoft Solver Foundation (free .NET library) to find optimal investment amounts in this example.
You may download the Visual Studio project file with all the C# code required to run this example here.
An online digital products dealer wants to increase its sales through advertisements on internet. Each ad will promote a certain brand (i.e. ads at brand level). The increase in sales for each product depends on (1) investment amount, and (2) sensitivity α of the product. Continue reading →
With finaquant® protos (non-commercial) or finaquant® calcs (commercial) a .NET developer has everything she needs for analytical table computations and database connection (i.e. storing and reading complete data tables).
Sometimes, tables need to be broken down into matrices for detail processing. As shown in our related forum post, the available matrix and vector functions in finaquant libraries can easily be extended with other numerical .NET libraries like ILNumerics that offer more specific functions for statistics and optimization.
Reporting (presenting data visually in well-formatted layouts and pdf files) is the only missing link. Luckily, basic reporting functionality is built in Visual Studio and .NET framework. Following video demonstrates how a simple report with a parameter can be created with ReportViewer:
Important update on 16. February 2019: Some links, and especially downloads links on this personal website may not be uptodate, as I recently transferred the whole site from www.finaquant.com to software.tuncalik.com.
Give me some time; I will check and correct them one by one.
I decided to offer all the software introduced on this website open-source and free.
Check my shared folder for most uptodate downloads. Open-Source downloads of the C#/.NET libraries Finaquant Calcs and Finaquant Protos are also included in this shared download folder as zipped Visual Studio 2012 files.
You may contact me if you need any help or consulting for my analytical software.