Download FX Excel Transaction Loader
Populating the FX Excel Transaction Loader
.
Download FX Excel Transaction Loader
From the welcome page, navigate to Trading > FX Transactions:
Click the Download Template button and then select either Blank Template or Current Transactions: 
From here you can either:
- Select Download Template from Blank Template for a blank Excel file to load new trades.
- Select Download Template from Current Transaction for a pre-filled Excel transaction loader file that contains transaction details of current trades, between selected dates.
Select the green Download Template button, which will cause an Excel file to download within your web browser.
Populating the FX Excel Transaction Loader
The Excel sheet you just downloaded is explained in detail below:
Sections:
Row 2 provides section headers
Column Descriptions:
Row 3 provides details on the type of information that is required for the below field. Some columns are restricted to only a specific type of information or must be unique information. This row provides these explanatory details.
Fields:
Row 4 provides field headers for the trade economic and descriptive details:
- Note: Not all the sections (1) are relevant for all types of trades. If a section appears to be relevant for the trade, then you must enter information in all bolded fields (2) that fall under the section.
Example Scenario: If loading an FX forward, you must fill out the bolded field headers in row 4 under the Reference Numbers section. Internal Reference Number is required to be filled out since it is bold, but Counterparty Reference Number is not required.
Field Types:
The type of field is also found in row 3.
- DESCRIPTIVE FIELDS are highlighted in blue
- ECONOMIC FIELDS are highlighted in green
- TERMINATED FIELDS are highlighted in dark blue
- ACCOUNTING FIELDS are highlighted in orange
Action Fields:
New: Used for loading new trades into ChathamDirect. If a trade already exists in the system with the same Internal Reference Number (IRN) associated with it, it will not load, and an error message will be triggered.
Update: Used for updating existing trades in ChathamDirect. If a trade already exists in the system with the provided Internal Reference Number (IRN), it can be updated. The Update option, as opposed to Update Descriptives, will allow for updates to the economics and accounting treatment of the trade assuming proper permissions are held by the user.
Update Descriptives: Used for updating existing trades in ChathamDirect. If a trade already exists in the system with the provided Internal Reference Number (IRN), the descriptive fields associated with the trade can be updated. The Update Descriptives option, as opposed to Update, will only allow for updates to the descriptive fields and does not require any special permissions.
Terminate: Used for Terminating existing trades in ChathamDirect. If a trade with the provided Internal Reference Number (IRN) needs to be terminated early, it can be done through the termination action. Only the dark blue termination fields will be updated. The Terminate action doesn’t require any special permissions.
Delete: Used to deleting trades from ChathamDirect, using the Internal Reference Number.
Additional Tips:
- Columns can be hidden or deleted to make entering only relevant information easier to enter (ChathamDirect will still accept the file while columns are hidden).
- Extra informative columns may be added, but the information in those columns will not be loaded.
- Row 4 must have the field names with exact spelling.
- The tab in the Excel load file must remain “FX detail” for ChathamDirect to process the file.
Uploading the FX Excel Transaction Loader to ChathamDirect
To upload trades using the Excel transaction loader, navigate to Trading > FX Transactions to upload trades:
Select the Upload Trades up arrow:
Select Choose File and select the FX Excel Transaction Loader from your desktop, then select the green Upload Trades button:
Understanding Uploading Errors
After uploading the Transaction Loader on the FX Transactions page, the system will show the number of trades uploaded. If trades fail to upload due to an error within the Transaction Loader, the number of trades that failed will show in blue. Click the blue text for more detail on the error:
By clicking into the error, a box will pop up with more detail on why the trades failed to upload, and which rows those errors are in:
