Data aggregation

FA supports importing data in different formats. File based imports can be done using two CSV formats. The FA Format is a CSV with fixed column positions and can be used to import transactions, trade orders, portfolios, contacts, securities and market prices. This format is used when importing via the Import menu. The General importer CSV format is similar, but instead of requiring all the columns in a specific order, only the desired columns can be provided in any order, with the CSV column header defining the name of the column. The same fields are available when importing in JSON format via API.