Skip to main content

Data Aggregation

Overview

FA’s Data Aggregation allows you to automatically import data from a third party such as your custody, broker, or asset manager. FA’s Data Aggregation validates your data and automatically saves it to correct customers, portfolios and instruments, thus minimizing human error.

Functionality

Add new data or modify existing data in FA via importing

  • Import contacts, portfolios, securities, market prices, transactions, trade orders, account interest rates, FX contracts, model portfolios, corporate actions, postings and TWR data - you can import data into the system with different formats - see below for more details about the supported import formats.

  • Import data via manual file uploads, API calls or integrations - in addition to importing data into the system through uploading the imported files manually, you can import data through API calls or different kinds of integrations. Automatic file uploads are available via Bank and Custody Connections module or custom connections, which include reading files in .csv format sent via SFTP or via email from banks, custodians or other data providers.

Support for customized and specialized data formats

  • Build your own customized import file format for trades and prices - define your own file readers for transaction, trade order and security price files, to read in .csv files which don't adhere to FA's standard file formats.

  • Change the import file delimiter - configure the file delimiter for FA Format .csv files, allowing you to use your local file format conventions (comma-separated or semicolon-separated) for your import files.

  • Import MiFID costs - import standard cost information to your securities in EMT format.

Supported formats

Format

Description

XLSX file

XLSX files are available for manual and automatic import to FA. Each FA object type follows a strict column-row structure, with object properties in columns and objects on each row.

Standard CSV file

Semicolon-separated (or comma-separated) files with .csv format (Windows-1252 encoding) are available for manual and automatic import to FA. Each FA object type follows a strict column-row structure, with object properties in columns and objects on each row.

Header-based CSV file

Comma-separated files with .csv format (UTF-8 encoding) are available for manual and automatic import to FA. The difference compared to the "Standard CSV file" is, that this file format allows rearranging columns and omitting unused columns.

API

Import-endpoint takes a structured list of FA objects in JSON format. The required and supported properties (represented by keys and values of the objects) match file-based importing.

EMT file

Standard .csv file to import MiFID cost information.