Running Position Mapper

Last updated 10 November 2026

Run it

  1. Put the files in one folder, as in Preparing the files.
  2. Open your mapper workbook and make it the active workbook.
  3. On the GIAnalyzer tab, click Map and Load Positions.
  4. Choose the folder. The last folder you used is selected for you.
  5. In the Bank Adaptor window, choose the output format and click Start.
  6. When it finishes, click OK, then Close, and save the workbook.

The Bank Adaptor window

After you choose the folder, a window titled Bank Adaptor opens. The run takes place in this window, a program of its own; while it is open, Excel doesn't respond.

  1. The window lists the files it found in the folder: "Following N files will be processed. Press start to begin". Files in subfolders and in zip files are read too, though the list doesn't show them.
  2. Under Output format, choose Excel, CSV or JSON. Excel is chosen at first.
  3. Click Start. For CSV or JSON, choose the folder for the files first; if you cancel that, the run is cancelled.
  4. The button counts the files as they are read, for example "Processed files: 3 / 12", and the black panel below shows the log as it is written. You can resize or maximise the window to read it.
  5. When "Processing completed successfully. Close the application to apply changes." appears, click OK, then Close.

Excel comes back to the front. With the Excel format, the workbook is updated when the window closes: save the workbook.

Output formats

Excel. Position Mapper writes into the open mapper workbook, with the dates shown as dd/mm/yyyy. What a new run does to the rows already there is on The position sheets.

CSV and JSON. Nothing is written into the workbook. Position Mapper writes one file per table into the folder you chose, a file only when the table has at least one row: FXD_P, IRD_P, IND_P and Listed_P, as .csv or .json.

  • CSV files have the same column headings as the sheets, so you can paste the rows under a sheet's headings. Dates are Excel date numbers.
  • JSON files hold one record per row, and dates as yyyy-mm-dd. Where a deal has two legs, the leg fields start with "Pay" and "Rec".
  • A deal found in two files of one run appears twice in these files; in the Excel output it is written once. The base CPI of inflation legs is filled in the Excel output only.