On Fire! Flash Sale — Up To 60% Off On Fire!

Offer Details

Why don’t my filtered results match my trades? (Open, Close and Transaction date explained)

Copy to clipboard

You filter your trades to one day or one week, and the total doesn’t match the returns of the trades in your list. Nothing is wrong with your data: one setting decides which day a trade’s profit or loss counts on, and a trade you closed in parts can land on different days.

Why it happens

Each row in your Trades list always shows the trade’s whole return, whatever the setting. What changes is the day that money counts on in your totals, calendar, dashboard and reports. That is set in Settings > Trades > Reports, with three options:

  • Open Date: the whole trade counts on the day you entered it.
  • Close Date (the default): the whole trade counts on the day you exited it.
  • Transaction Date: each exit counts on its own day, with the profit or loss you realized in that exit. The entry itself adds nothing.

An example

You buy 200 shares on Monday. On Tuesday you sell 100 for +$200. On Wednesday you sell the other 100 for +$300. The trade’s return is +$500. Here is what a date filter set to Tuesday shows:

Setting Where the +$500 counts Trades list (Tuesday) Total P&L (Tuesday)
Open Date +$500 on Monday No trades $0
Close Date +$500 on Wednesday No trades $0
Transaction Date +$200 on Tuesday, +$300 on Wednesday The trade, showing +$500 +$200

So there are two surprises:

  • With Open Date or Close Date, your Tuesday filter is empty even though you sold on Tuesday.
  • With Transaction Date, a trade appears when any of its executions falls inside the dates you filtered. Its row still shows the whole +$500, but the total only adds what you realized inside those dates (+$200). The same goes for a week filter that ends before the trade closes.

How to make them match

  • You want the total to add up to the trades in your list: choose Close Date (count each trade on the day you finished it) or Open Date (count it on the day you entered). Each trade counts once, on one day.
  • You want to see profit on the days you actually took it: choose Transaction Date. Expect a listed trade to show more (or less) than that day’s total when you exit in parts.

To change the setting, follow How to change reports by open date, close date or transaction date. Your choice saves as soon as you pick it, and your calendar, dashboard and reports update.

Have a question?

We Are Ready to Assist You 24/7 and Answer All Your Inquiries

Our specialists are always prepared to provide you with the necessary support and resolve any issues that may arise. Don’t hesitate to reach out - we are here to help you!

Start Live Chat

Learning center

Supporting You Every Step of the Way

We Use Cookies!

We have a friendly cookie policy on our website. This means that we use cookies to enhance your browsing experience and provide personalized content.

Rest assured, your privacy is important to us, and we only use cookies for necessary purposes. Feel free to adjust your cookie settings to suit your preferences.