Value formatters

You can determine how the values appear in the Account Manager tables by using the formatter property of AccountManagerColumnBase. If no formatter is set, values are displayed as they are, separated by spaces. When a formatter is defined, it processes only the values specified in the dataFields property. If dataFields is an empty array, the formatter will receive the entire order/position data object.

// AccountManagerColumnBase object
{
    id: "limitPrice",
    label: "Limit Price",
    dataFields: ["limitPrice"],
    formatter: "formatPrice",   // Standard formatter that displays symbol's price
},

The formatter property can contain either StandardFormatterName or FormatterName object.

• StandardFormatterName refers to the built-in formatters.
• FormatterName is a general type that can be a built-in name or any other string corresponding to a custom formatter.

Formatter and dataFields dependency

The formatter property expects that the dataFields property has certain types of values defined in a specific order. dataFields is an array of strings that match the property names in the order/position data object. The values for these properties in the data object are expected to be a number, string, date, etc. The mapping of the formatter and dataFields values is described in the StandardFormattersDependenciesMapping interface.

Example

Assume that your data object has two custom fields: balance and currency.

{
  // <...other object fields...>
  balance: 1000.00,
  currency: "EUR",
}

You want to display the user's balance in a column. The balance value should have two decimal places and a currency symbol. For this purpose, you can use the built-in fixedInCurrency formatter that expects the following arguments:

1. A number that represents the price.
2. A string that represents the currency code.

This means that dataFields should have the values of the followings types: [number, string]. Then, the AccountManagerColumnBase object for the balance column should look as follows:

{
    id: "balance",
    label: "Balance",
    dataFields: ["balance", "currency"],
    formatter: "fixedInCurrency",
},

Built-in formatters

The table below lists the built-in formatter values, expected types of the properties within dataFields, and the default fields of the order/position data object.

Name	Value	Description
Date #	"date"	Displays the date or time. Expected data type: [date].
DateOrDateTime #	"dateOrDateTime"	Displays either the date or both the date and time. This formatter accepts an object in the following format: { dateOrDateTime: number, hasTime: boolean }. If hasTime is set to true, both the date and time are displayed; otherwise, only the date is displayed. Expected data type: [date].
Default #	"default"	Displays data as a string with space-separated values. Expected data type: [string].
Empty #	"empty"	Displays an empty string instead of a value. Expected data type: [string].
Fixed #	"fixed"	Displays a number with two decimal places. Expected data type: [number]. Often used for the following dataFields values: ["balance"] or ["equity"].
FixedInCurrency #	"fixedInCurrency"	Displays a number with two decimal places and adds the currency symbol. Expected data types: [number, string]. Often used for the following dataFields values: ["balance", "currency"] or ["equity", "currency"].
FormatPrice #	"formatPrice"	Displays a symbol's price. Expected data type: [number]. Often used for the following dataFields values: ["limitPrice"], ["stopPrice"], ["avgPrice"].
FormatPriceForexSup #	"formatPriceForexSup"	Displays the price of the symbol with the last character shown in superscript. This formatter works only if the instrument type is set to forex. Expected data type: [number]. Often used for the following dataFields values: ["last"].
FormatQuantity #	"formatQuantity"	Displays an integer or floating-point quantity with a space to separate thousands groups. Expected data type: [number]. Often used for the following dataFields values: ["qty"] or ["filledQty"].
IntegerSeparated #	"integerSeparated"	Displays integer values with thousands separated by non-breaking spaces. Expected data type: [number]. Often used for the following dataFields values: ["qty"] or ["filledQty"].
LocalDate #	"localDate"	Displays the local date or time. Expected data type: [date].
LocalDateOrDateTime #	"localDateOrDateTime"	Displays either the date or both the date and time in the local time zone. This formatter accepts an object in the following format: { dateOrDateTime: number, hasTime: boolean }. If hasTime is set to true, both the date and time are displayed; otherwise, only the date is displayed. Expected data type: [date].
MarginPercent #	"marginPercent"	Displays numeric values as percentages. If the value is below 0.01, the formatter returns the raw value with a percentage sign. If the value is non-finite, the formatter returns "> 200%". If the value is undefined, the formatter returns an empty string. Expected data type: [number]. Often used for the following dataFields value: ["marginRate"].
Percentage #	"percentage"	Displays numeric values as percentages. Expected data type: [number].
Pips #	"pips"	Displays numbers as pips. Expected data type: [number]. Often used for the following dataFields value: ["pipValue"].
PositionSide #	"positionSide"	Displays the position side: Short or Long. Expected data type: [number]. Often used for the following dataFields value: ["side"].
Profit #	"profit"	Displays profit in the account currency. It also adds the + (plus) sign, separates thousands, and changes the cell text color to red or green. Expected data type: [number].
ProfitInInstrumentCurrency #	"profitInInstrumentCurrency"	Displays profit in the instrument currency. It also adds the + (plus) sign, separates thousands, and changes the cell text color to red or green. Expected data types: [number, string].
Side #	"side"	Displays the order side: Sell or Buy. Expected data type: [number]. Often used for the following dataFields value: ["side"].
Status #	"status"	Formats the order status. Expected data type: [number]. Often used for the following dataFields value: ["status"].
Symbol #	"symbol"	Displays brokerSymbol and is used for a symbol field. Note that when you click a symbol, the chart changes according to the symbol field. Expected data types: [string, string, string]. Often used for the following dataFields value: ["brokerSymbol", "symbol", "message"].
Text #	"text"	Displays a text value. Expected data type: [string]. Often used for the following dataFields value: ["message"].
Type #	"type"	Displays the order type: Limit / Stop / Stop-limit / Market. Expected data types: [number, string, number]. Often used for the following dataFields values: ["type", "parentId", "stopType"].
VariablePrecision #	"variablePrecision"	Displays a number with variable precision. Expected data type: [number]. Often used for the following dataFields value: ["qty"].

Custom formatters

You can implement your custom formatter using the customFormatters property in the AccountManagerInfo object. Each custom formatter is an object with the following fields.

Property	Required	Description
name #	Yes	Unique formatter name. You should typecast it to FormatterName.
formatText #	Yes	A function that is used for formatting a cell value to string. formatText is required because it is used to generate exported data. However, if you choose not to display this data, you can return an empty string.
formatElement #	No	A function that is used for formatting a cell value to a string or an HTML element. If the formatElement function is provided, it only handles the formatting of displayed values. Otherwise, the formatText function is used. For optimal performance, it is recommended to only use formatText if you intend to display only string values.
isPriceFormatterNeeded #	No	Allows usage of priceFormatter.

Example

The CodePen example below implements two custom formatters that display the following:

• Dynamically changing text
• A button

These formatters are used to format values for custom columns of the Positions page.