Time & Sales

What is Time and Sales

Time & Sales panel displays all trades that occur for selected instrument and provides details for each trade including date, time, price, and quantity. Each line is color-coded to indicate whether the trade was a result of an aggressive buyer or seller.

Time & Sales panel keeps a running record of trades for selected instruments displayed in chronological order. Each new entry is added to the top of the list, causing the panel screen to auto-scroll downward.

Real-time and Historical modes

Real-time mode shows all the trades that are currently executed. The historical mode allows you to get all past trades for a specified period of time directly in the panel.

General settings

The basic settings in Time & Sales are similar to the parameters of most panels in Quantower — full flexibility in color settings, fonts, columns visibility, data position relative to the column, etc.

But some settings are unique for this panel:

• Line Spacing provides 3 options of raw formatting for better table view: Compact, Normal, Double

• Rows limit — this is the number of lines that will be displayed in the table, to save your computer's memory. When the number of lines exceeds the limit, old values will be deleted as new ones are added.

• Coloring scheme — this option lets you choose the color scheme for all rows in the table based on a selected condition: If you choose “By Aggressor Flag”, then for the trades with the Buy direction the line will be blue, and for the Sell trades, the line will be red. If the Aggressor flag is undefined (None), the color will be white.

  If you select “By Tick Direction”, the lines will be colored based on changes in the last price.

• Aggregate Trades — this mode helps you track large traders by summing up trades that match in price, direction, and time

• Time Delay, ms — it will continue to sum up data within the specified time with the same price and trade direction.

• Short Price Format reduces the amount of numbers in the price value to the left of the comma.

• The Abbreviation Rules option gives you the ability to simplify the values of trading sizes for easier readability. There are 3 options for Format Mode: Default: This option displays values as is, without any abbreviation or rounding. Round to: This option rounds values after the decimal point to the specified number of decimal places.

  Abbreviate: This option abbreviates values to the shortest form, such as "K" for thousands, "M" for millions, etc.

Export Data

Time & Sales panel allows exporting executed trades to either CSV or HTML files for further analysis. In the future, we will add the ability to auto-update the data directly in the external file via DDE and RTD functions.

• Select the "Export Data" in the panel's menu

• Select the necessary data that you want to export and click on the [Export File] button

• Specify the type of files and the path to save it

Setup Actions - Filters & Actions

We wrote about this functionality in the Advanced table filters and actions section, which explains in details the process of adding filters and creating different notifications. Here we briefly describe the filtering process in the table and the settings of various actions.

Filtering in the Time & Sales table

Rows in the table can be filtered by some data value in their column. There are two ways to apply the filtering:

• Quick filtering can be accessed by clicking the “Filter” icon in any table column’s header.

Once you select some option — the table rows will be filtered to those ones, containing the selected value. Quick filter can be canceled by pressing “Cancel filtering” option.

• Advanced filtering, for applying more complex filtering (multi-filtering). Select in the panel's context menu option “Setup actions”.

This screen has two tabs on the left side, where the first one is an Advanced filter.

This screen allows you to Enable/Disable filtering as well as set up filtering Conditions. These conditions are set up as:

IF (condition1 AND condition2 ...) OR (conditionN...) …

You can set up as many conditions as you like. Due to the possible complex logic of filtering, you are required to apply the changes once you finished the filter set up.

If you have additional questions or proposals about this functional, feel free to contact us. We are here to help you!