Time & Sales

SM
Last updated 8 days ago

Time and sales panel shows all executed trades for selected trading instrument in table form and provides details for each trade including date, time, price, quantity, and trade direction.

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.

Time & Sales panel in action - BTC/USD via Bitfinex connection

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.

General settings of Time & Sales panel

But some settings are unique for this panel:

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

  • Time format — allows setting the time accuracy for executed trades.

  • Coloring scheme — this option sets the color scheme for all rows of the table, depending on the selected condition: If you chose “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 not defined (None) then the color lime will be white.

    If you selected “By Tick Direction”, then the lines will be colored according to the change in the last price.

Export Data

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

T & S panel allows exporting data into external files
  • 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.

Quick filtering per column

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

Quick filtering can be applied only to one column of the table. For filtering multiple columns, we recommend to use “Setup actions”.

  • 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.

Advanced filtering in Time&Sales table

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 setup 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!