Your blotter, explained.
Drop in your desk's export. Every total opens its deals.
Export. Drop. Read.
Export the blotter
From 360T, Murex, Bloomberg or the Excel your desk keeps.
Drop it in
Columns are matched for you. The file stays in your browser.
Read the day
P&L by price and points, positions, and seven checks.
Built around how a treasury desk reads its day.
Price and points, apart.
Realized P&L is split into spot price and forward points. Carry shows as overnight swap and MTM covers the open position. Swaps count as rolls and do not change the net position.
Every total opens its deals.
Group by pair, book, dealer, item type, deal size, hour or weekday. Click any figure and the deal rows behind it open.
Positions by value date.
A ladder from today through spot, one week, one month and beyond a year, per currency, next to your own limits.
Reads the file as it is.
Report title rows, total rows, headers in English, Turkish, German or French and local number formats are handled. Each column match shows its confidence, and you can change it.
Seven checks on every file.
Row counts, subtotals against the grand total, amount times rate on every leg, notionals by currency, the blotter's local-currency column, open lots against positions, and FIFO against average cost. A failed check turns red.
Twelve hand-computed cases match exactly.
Try it on our sample.
One week of deals from a bank FX desk as an Excel export: 224 legs, total P&L +99,400 USD, 7 of 7 checks passed.
In the browser
The same file opened in FX Blotter Analytics, with example rates and limits filled in.
Result
A workbook with a dashboard, P&L by pair, book and dealer, positions, the ladder, limits and the reconciliation.
Same deals, five systems.
Each file lays out the same week the way a different system would. Every one gives 224 legs and the same total P&L.
Trading platform export
Bought and sold columns, UTC times, one ID for both swap legs.
Treasury system report
Title rows, DD/MM/YYYY dates, dealt and contra amounts, a grand total row.
MT300 confirmations
SWIFT field tags, comma decimals, amendments as AMND with a related reference.
Judge it before any client data leaves the building.
Start on sample or anonymized data
Begin with our sample files or an anonymized export of your own.
Your data stays with you
The blotter is read in the browser on your machine. Counterparty names are dropped by default.
Bring your own rate files
Valuation uses the rates you already have. We supply no market data, so there is no new licence to sign.
Which systems can it read?
CSV and Excel exports from systems such as 360T, FXall, Bloomberg FXGO and Murex, and blotters kept by hand in Excel.
Which products are covered?
Spot, outright forwards, swap legs and NDFs. Options are detected and left out with a reason.
Is opportunity cost shown?
Not yet. It will be added once its definition is agreed with desks.
See it on your desk's export.
Tell us your organization type, desk size and the system your blotter comes from. We will reply by email to find a time.