Export a Trade to a CSV File

You can export trades to a Comma Separated Value (CSV) file either from a trade view or from the Trade Side Details window. When you export trades, note the following:

  • When exporting from a view, the export defaults to all trades, so if you only want to export a subset of the trades in the view, select them first, then click  Export .
  • Only the trades and fields visible on the grid for those trades are exported. In other words, all fields that you filter out of the view are omitted in the exported file.
  • From the Search Results view, you can only export MAGR blocks within MAGR trades.

To export one, multiple, or all trades in a view:

  1. Locate the trades that you want to export:
    • If you want to export a subset of the trades, select the check box next to each trade.
    • If you want to export all of the trades, the UI defaults to All.

      The UI displays the Export to CSV pop-up window, shown below (when no trades are pre-selected for export).

      If a user tries to export MAGR NAV from the Combined view the following message will appear:  

      MAGR NAV export is disabled from the Match Agreed > Combined and User Defined views. Instead export MAGR NAV from the Match Agreed > Equity or Debt view.

  1. Select the My Side or Counterparty radio button.
  2. Click  Export  . The UI displays a pop-up confirmation in the lower right corner of your screen to confirm that your action was successful. It also downloads the trades to the /Downloads folder location on your system.

    The file name includes identifying data such as the asset class, view type, date, and time of the download. For example, Equity Mismatched Blocks 2021-Sep-02 1454.csv.

Note
If you are running macros from exported files, ensure that you review the layout of the exported files as there are differences between this export data and older exported data.