Trayport Image
End of Day (EoD) File

Your complete daily snapshot of all your trading activity

Book A Demo Get in Touch
Why choose the End of Day File?

The EoD File is the simplest and most reliable way to access your daily trading activity without the need for complex integrations or technical setup.

It gives you a complete, ready-to-use record of all your private trades and orders in a familiar CSV format. This is necessary for all organisations that need accurate data for reconciliation, reporting, and risk management but prefer an automated delivery process over an API-based solution.

Benefits
Fast access to data: Delivered automatically each trading day, ready to use immediately.
No technical setup required: Works with standard tools like Excel. Development work or custom software aren’t required.
Accurate and complete: Captures every order, update, cancelation, and execution for the day.
Supports reconciliation and reporting: Provides the foundation for P&L, risk, and operational accuracy.
Secure delivery: Transferred via SFTP for encrypted, reliable data exchange.
Cost-effective: Avoids the complexity and expense of building API integrations.
CSV
Features
Daily automatic delivery via secure SFTP.

Your file arrives every trading day directly in your secure SFTP folder. No manual downloads or setup needed.

Complete client-specific trade data

Capture every order, update, cancel, and executed trade for a full, accurate view of your activity.

Simple CSV format for easy use and integration

Open it in Excel or import into your systems instantly. No technical work required.

Consistent data fields aligned with the MAR Surveillance File.

Structured the same way as the Surveillance File, making reconciliation and reporting simple.

No API or technical setup required.

No APIs, coding, or IT resources needed. Designed for simplicity and efficiency.

FAQs
What is the EoD File?

The EoD File is a daily CSV file delivered via SFTP (SSH File Transfer Protocol) that contains a complete record of a client trading activity for the day. 

This includes:

  • all orders (inserts, updates and cancels)
  • executed trades

It is similar to the (MAR) Surveillance File but it contains only private events and no public or market data.

What problem does the EoD File solve?

The EoD File is a means of capturing their trading activity. This is a critical business need for the following reasons:

  • Back-Office Reconciliation: They need to match the trades recorded in their internal systems with what actually happened on the market to ensure accuracy.
  • P&L and Risk Reporting: Accurate, daily data is the foundation for calculating their profit & loss and running internal risk assessments.
  • Operational Record-Keeping: It provides a simple, reliable “source of truth” for their daily operations.

We provide the Joule Direct (JD) API as the solution to this, but smaller firms or those with limited technical resources struggle with the complexity of the JD API. The EoD file provides a simpler alternative to this.

What are the benefits of the EoD File?
  • Content: Contains private order and trade events for a specific client.
  • Format: Standard Comma-Separated Values (CSV).
  • Data Fields: Contains the same set of trade, order, and reference data fields as our Surveillance File.
  • Delivery: Automatically dropped into a client’s designated SFTP folder. at the end of each trading day.
Why is a CSV file a better solution for this segment of clients?

A CSV file provides useful data fast because it’s simple and ready to use right away. You don’t need a tech team; anyone who knows Excel can open it and start working with the data. It also works easily with almost any other system, and it’s inexpensive since you don’t need to set up complex software or connections.

What are the key features of the EoD File?

The EoD File is a daily file made just for one client. It lists all their orders and trades for the day in a simple CSV format (like an Excel sheet). It includes the same details as the Surveillance File and is automatically sent to the client’s secure online folder (SFTP) at the end of each trading day.

When will EoD File be made available?

Now! Please contact your Client Relationship Manager or Trayport support.

How do I opt in/opt out of this feature?

Please contact your Client Relationship Manager or Trayport support.

Who should I contact for support or questions about this new update?

Please contact your Client Relationship Manager or Trayport support.

Book A Demo

For more information, get in touch with our dedicated sales team.

Book A Demo Get in Touch
Data Trading Activity