-
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.
Follow me
-
Recent Posts
- Minimum Total Loss Rounding in Python
- Travel and Assignment Planning Software in Python
- Top-Down Distribution of Quality Measurement Requirements using Table Functions in Python
- A Simple Notation for Data Tables
- Calculating Sales Commissions in Excel
- How to Add a User-Defined Table Function to Excel
- How to Apply a User-Defined Function on Rows of a Table in Excel
- Empowering Excel with Table Valued Functions
- Testing Table Valued Functions with LINQPad
- Building a Web Service that Receives and Returns Data Tables
- Optimizing Marketing Investment
- Reporting with ReportViewer in Visual Studio
- Simulation of Dealer Commissions with Matlab
- Finaquant’s Matrix and Vector Functions
- Table Function Demo with Microsoft Excel
Recent Comments
No comments to display
Tag Archives: calculation engine
Transforming rows: row-by-row processing of tables
Even though quite easy to understand and use, TransformRowsDic()1 in the free .net library finaquant® protos is one of the most versatile and useful table transformation functions. This table function offers a simple way for applying user-defined formulas on each … Continue reading
Posted in Calculation engine
Tagged .net library, calculation engine, table functions
Leave a comment
Filtering and sampling tables by dates
Assume, you have a data table containing daily prices of different products in each entry, and you want to exclude all rows of table associated with weekend days. That is, you want to have only entries with business days from … Continue reading
Posted in Calculation engine
Tagged calculation engine, date filter, date sampler, table functions
Leave a comment
Filtering tables with finaquant® protos
As explained below in detail, finaquant® protos (free .net library) offers several table functions for selecting or deselecting rows of tables1. Three methods are available for filtering tables: Filtering with condition table Filtering with condition cell Filtering with condition list … Continue reading
Sorting tables with finaquant® protos
Sorting rows of tables after some fields may be required for certain table calculations. The table function SortRows()1 in finaquant® protos (free .net library) can be used for sorting tables: // Sort table after given fields and sort options (ASC/DESC). … Continue reading