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

![Time & Sales panel in FundX shows all executed trades](https://1574671354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQAglKSOJnxCrGxFyuplO%2Fuploads%2Fgit-blob-5d76b7fe2de9e793a88e221d9e6b259b81b1b83a%2Ftime-and-sales.gif?alt=media)

{% embed url="<https://www.youtube.com/watch?v=-R_AXBMlNpM>" %}
Aggregated Time & Sales in FundX also known as Reconstructed Tape
{% endembed %}

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

![Get all past trades in Time & Sales for a specified period](https://1574671354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQAglKSOJnxCrGxFyuplO%2Fuploads%2Fgit-blob-9aa0200bff79f3c1ec80c2f68c1a49cb26720c56%2Fhistorical-mode-in-ts.png?alt=media)

### General settings

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

<figure><img src="https://1574671354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQAglKSOJnxCrGxFyuplO%2Fuploads%2Fgit-blob-a591a0d31e4dc1aae712bb188d84a104f3fc46d3%2Fimage%20(59).png?alt=media" alt=""><figcaption><p>Time &#x26; Sales settings in FundX</p></figcaption></figure>

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.

<figure><img src="https://1574671354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQAglKSOJnxCrGxFyuplO%2Fuploads%2Fgit-blob-b7692dd68ca514310466b9bc0b879ceb325a09d3%2FShort%20prrice%20format%20TS.gif?alt=media" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1574671354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQAglKSOJnxCrGxFyuplO%2Fuploads%2Fgit-blob-80d998e3c16ad8bb7c5694606f877ea7da1e6a22%2Fimage%20(364).png?alt=media" alt=""><figcaption><p>T &#x26; S panel allows exporting data into external files</p></figcaption></figure>

* 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**](https://funded-futures-network.gitbook.io/fundx/general-settings/setup-actions-and-advanced-filters) 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](https://1574671354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQAglKSOJnxCrGxFyuplO%2Fuploads%2Fgit-blob-1f9621a6d39f8b66634fef488c4e442fc9e841ff%2Fquick-filtering.png?alt=media)

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.

{% hint style="info" %}
Quick filtering can be applied only to one column of the table. For filtering multiple columns, we recommend to use “***Setup actions***”.
{% endhint %}

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

<figure><img src="https://1574671354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQAglKSOJnxCrGxFyuplO%2Fuploads%2Fgit-blob-6bd850a1efdec994cb1dba22dd14864c7313efef%2Fimage%20(1)%20(4)%20(1).png?alt=media" alt=""><figcaption></figcaption></figure>

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

![Advanced filtering in Time\&Sales table](https://1574671354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQAglKSOJnxCrGxFyuplO%2Fuploads%2Fgit-blob-dc7e6ed42b1838c524418f7b076491531bb5f9b6%2Fadvanced-filtering.png?alt=media)

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!
