administration:administration_backoffice_imports

This is an old revision of the document!


Backoffice Imports

CTS is able to import a number of backoffice files from the FCM. These files include account balance, account net position and contract margin files.

Please contact CTS for project approval and FTP credentials.

CTS requires the files be sent in parallel to a pair of secure FTP servers via SFTP or FTPS. The parallel processing should be such that failure of transfer to one host should not negatively effect the transfer to the other. If transfer to the primary host fails it is the responsibility of the customer firm to notify CTS in order to have files processed properly prior to the open.

  • ftp.t4login.com & ftp2001.t4login.com
  • SFTP and FTPS are supported.
  • Standard FTP will not be accepted.

Standard GMI Files: Account Balances = MNYF1 Account Net Positions = POSF1 (sometimes POSF2 has been used) No standard file we are aware of for margins.

The data files must be fixed width. It is also helpful to include a delimiter. A delimiter within a fixed-width file reduces the amount of documentation required (field positions and lengths). Delimiters also make troubleshooting a breeze as support staff can more easily read the data file to spot discrepancies. If headers are included in the files the only additional documentation we need is a description of each field. Headers can be accomplished by using column widths wide enough to accommodate the header and the data. CTS compresses files prior to archive so we don't care about the files becoming slightly more bloated. If headers are not included then we need field descriptions as well as field locations and lengths. The same file name should be used every day. Don't include the date in the file name. Data must be uncompressed/expanded. No binary data. No special characters. The data should be human-readable. Numeric values should look like 12345.67.

  • administration/administration_backoffice_imports.1600450946.txt.gz
  • Last modified: 2023/09/21 19:54
  • (external edit)