Add columns

To add new columns to an open table, carry out the following steps.

1. 

   

   Select the command NEW COLUMN or NEW COLUMN FORMULA EDITOR in the menu of the "Columns" icon on the "Table" tab or select the "New column" or "New column formula editor" icon in the table toolbar.
2. This takes you to the function wizard or the formula editor. Here you can individually edit or redefine the formulas for calculating the individual columns.
   

   The formula is used to determine the output of the new column. If, for example, you would like to display the percentage change in the price of DAX securities since a certain date in an additional column within a securities list, you could enter the following formula in the formula editor:

   Current [_; today] / Current [_; $date] - 1

   To preset the "Date" parameter with a value, click in the "Variables" field in the formula editor and enter the desired date.

3. Accept the new formula with "Save" or "OK". The formula editor or the function wizard is closed.
4. The "Column heading" dialog box appears, in which you can define the heading of the new column, e.g. "Change [%]".
   

   

5. Confirm with "OK". The new column is added to the far right of the table or to the right of a previously selected column.

You can find more information on headings in the section Headings and labels with dynamic information.

Detailed explanations of the formula editor, the function wizard and the MM-Talk language can be found at MM-Talk reference. The fields and functions for entering a formula and the MM-Talk keywords are also explained there.

To be able to use such an extended table in the future, you must save it as a template. More on this in the chapter Save tables.