A price page expression can consist of symbols, fields, operators, functions and numbers. The basic steps to insert an expression are always the same. For more information about the possibilities of price page expressions, see the detailed syntax description below.
▪ Right-click in the price page and select Insert Expression.
▪ In the new column Expr1, double-click the cell where you want to insert the expression.
▪ Type an equal sign = to start the price page expression.
▪ Do one of the following:
- In the list that appears, double-click (or use the ↑ and ↓ keys to highlight and then the Tab key to select) a symbol or a TeleTrader function.
- Press the Escape or Backspace key to make the list disappear and type parts of the expression manually. While typing, appropriate functions are recommended automatically. For example, typing an S will show a list with all functions starting with S.
▪ Continue creating your expression using the syntax described below. Appropriate lists appear after using symbols, operators or functions.
▪ After you have finished writing the expression, Press the Enter key. The expression is now added in the chosen cell.
Relative Symbol |
Relative symbols refer to the current symbol (the symbol that shows up in the same row as the expression cell). These symbols are not fixed – they change automatically in every row and thus make it easier to copy a formula to another row or a complete column. Use the keyword SYMBOL to refer to the current row symbol. |
Absolute Symbol |
Absolute symbols refer to a specific symbol that will be the same for every row. They can be used if you want to for example use the same benchmark symbol (index) in every row. Absolute symbols are enclosed in square brackets. To use an absolute symbol in an expression, either choose OTHER SYMBOL from the list or type an opening square bracket [ and choose the symbol from the list that appears by double-clicking it. The symbol list shows the symbols that are already visible on the price page. The closing square bracket is inserted automatically as soon as you choose the symbol. For example: =[ADIDAS AG O.N. (XETRA)] |
Fields |
For every symbol (absolute or relative), you can specify which field should be used for the calculation. A list with all available fields (that is, all columns that are currently visible in the price page including existing expressions and studies in price page) appears after you enter a symbol – choose the appropriate field by double-clicking it. The field is added to the symbol using the . (dot) operator (see below). Field names have to be enclosed in single quotes. For example: =SYMBOL.'VOL' =[ADIDAS AG O.N. (XETRA)].'LAST' |
Operators |
Operators connect symbols/fields with each other or with a constant number. In addition to the standard mathematical operators, the dot operator is used to specify the field for a symbol. You can enter operators from the keyboard manually, or choose them from the operator list when it appears. . Dot operator: Use it directly after a symbol to specify a field value to use for this symbol. + Addition - Subtraction / Division * Multiplication ^ Power () Round brackets for changing operator precedence of mathematical operators Standard operator precedence is the same as for all mathematical calculations: Brackets – Power – Multiplication and Division – Addition and Subtraction. |
TeleTrader Functions |
You can use some functions of the TeleTrader Language inside price page expressions. The list of available functions is automatically shown at the start of an expression and after entering a mathematical operator. You can also type the function manually - while typing, appropriate functions are recommended automatically. For example, typing an S will show a list with all functions starting with S. After choosing a function, an opening bracket is inserted and the list of symbols is shown. You have to close the function brackets manually. For example: =MIN(SYMBOL.'OPEN',SYMBOL.'CLOSE') For more information about the available functions, see the Function Reference. |
Numbers |
In addition to symbols, you can also use constant numbers in an expression. To use a number, you have to type it on your keyboard manually. For example, you could multiply the volume of a symbol by two using the following syntax: =SYMBOL.'VOL'*2 |
=SYMBOL.'LAST'*3 |
Multiply the Last price of the symbol that is shown in the same row by three. |
=SYMBOL.'LAST'*[EUR/USD SPOT (FOREX GTIS BASIC FX)].'LAST' |
Multiply the Last price of the symbol that is shown in the same row with the current EURUSD rate (the EURUSD symbol must be shown in the same price page, otherwise this expression won't work). |
=(SYMBOL.'HIGH'+SYMBOL.'LOW'+SYMBOL.'LAST')/3 |
Add the High, Low and Last price for the symbol that is shown in the current row and divide it by three. (This calculation is also called the typical price, used for example in the Commodity Channel Index.) The columns High and Low must be added to the price page first, otherwise this expression won't work. For this rather complex expression, you have to manually enter round brackets to force the correct operator precedence. |