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 , , | 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 , , , | 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

Posted in Calculation engine | Tagged , | Leave a comment

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

Posted in Calculation engine | Tagged , | Leave a comment