KALIBRE

FX Blotter · Guide · 15 minutes

FX Blotter with your desk's export

Realized and unrealized P&L by pair, dealer and book with price and points apart, carry, MTM, net position by value date, limit usage, seven reconciliation checks and an end-of-day desk report.

Open FX Blotter on the sampleDownload this guide (PDF)

What you need

  • The desk's blotter as Excel (XLSX) or CSV, exported from the trading platform, the treasury system or a hand-kept sheet.
  • Closing rates for the pairs, in the file or pasted on the page.
  • A browser. Nothing to install.

Steps

  1. Try the sample first

    Open kalibremarkets.com/lab/blotter with the sample blotter, or click Take the 2-minute tour on the FX Blotter page.

  2. Drop your export

    Drop the blotter file on the box. Report title rows, total rows and repeated page headers are skipped. Headers in English, Turkish, German or French are matched.

  3. Check the column matches

    Each matched column shows its confidence. Change any match from the list. Fields that could not be found are named, so you can pick them by hand.

  4. Add the missing rates

    If the file has no closing rates, click Add the missing rates and paste them, one pair per line.

  5. Read the result

    P&L split into price, points, carry and MTM; positions by value date; limits; and the reconciliation checks, each with the rows behind it.

  6. Trade tickets from email

    Confirmations that arrive as emails can be dropped as saved .eml files, or pasted in Paste trade tickets. Each ticket becomes a blotter row.

  7. Hand it on

    Click Open the report page for the desk report. Save it as PDF or share a read-only link that opens for 30 days.

What you will see

  • Total P&L split into its parts, by pair, dealer and book.
  • Net position and the value date ladder.
  • Seven reconciliation checks with the rows behind each.
  • The end-of-day desk report.

Good to know

  • Old binary .xls files need to be saved as XLSX or CSV first.
  • Counterparty names are not used in the analysis unless you choose to show them.
  • Excluded rows are listed with their reason, so totals can be checked against the system.

Questions: markets@kalibrefin.com. Kalibre is software and does not give investment advice. Risk disclosure