Preparing the files
Last updated 10 November 2026
Position Mapper reads a folder you choose. Put the files for one run in it: the position files your banks sent for one date.
Put every bank's files for the date into one folder
Each run into Excel replaces the four position sheets with what that run found. A deal that isn't in the folder disappears from the sheets, and so do all the deals of a bank whose files you left out. So put the files of every bank for that date into the folder, and run once.
- Several banks can share the folder. Position Mapper recognises each bank's files.
- Subfolders are read too.
- Zip files are unpacked into a folder of the same name next to them:
Bank A.zipintoBank A\. Zip files inside zip files are unpacked too. The zip files themselves stay. Two zip files that hold files of the same name don't overwrite each other. - Keep all of a bank's files together, including the ones that look secondary. Some banks send a deal's terms across several files, and Position Mapper joins them, for example a file of additional trade details that it merges into the trades by trade id.
The files it reads
Position Mapper looks at every file in the folder and its subfolders with one of these extensions:
- Excel:
.xls,.xlsx,.xlsm .csvand.txt.xml- no extension at all, as some banks' systems send them
Other files are skipped.
It works out the bank and the kind of file from the file's name, its extension and its content, such as its column headings or the names of its sheets. A file it doesn't recognise is skipped, and the log says so.
Some banks also send a summary file that repeats another report. Position Mapper recognises it and skips it on purpose, so the deals aren't counted twice.
What it maps
Depending on what each bank's files carry:
| Kind | Instruments | Sheet |
|---|---|---|
| FX | Spots, forwards, swaps, non-deliverable forwards, and options (vanilla, barrier, digital) | FXD_P |
| Cash | Cash balances | FXD_P |
| Interest rate | Forward rate agreements, interest rate swaps, cross-currency swaps, swaptions and other interest rate options | IRD_P |
| Inflation | Zero coupon inflation swaps and real rate swaps | IND_P |
| Listed | Bonds, stocks, warrants, futures, listed options and other securities | Listed |
Rows that carry nothing to value are left out: cash balances of 1 unit or less, and securities worth 1 or less, either way.
Dates are read in each bank's own format, whatever your computer's regional settings are.
To find out which of your banks' files are supported, and which products they carry, email us or ask for a demonstration.