Preformulas

A preformula is a formula in a table that is evaluated before the column formulas. This allows you to filter or edit the input objects in the table (e.g. sort by profits or losses).

Below you will find an example of a preformula in which the input objects are already processed:

Beispiel: Präformel mit Eingabeverarbeitung

The following preformula generates a top list of the securities entered:

WP.Sort[#GreaterEqual;
 #[]($Close:=Close[;$CapitalMeasures;$Dividends];
 ($Close/$Close.Before[1]-1).At[$Date;10])].SubList[0;$Number-1]

First the securities list is read from the folder, this list is then sorted in descending order (first by size, then by the percentage difference of the close price to the previous day) and finally the first $number of elements is truncated.