File format for importing corporate actions
You can import corporate actions and corporate action runs in FA Platform. The file format is a semicolon-separated text file (CSV).
The import file contains information about:
Corporate actions
Corporate action runs (one run per corporate action)
Updating corporate actions
You can update only corporate actions that have no corporate action runs. If you already created of imported corporate action runs (fields 17-21), updating a corporate action is not allowed.
To update a corporate action, upload the CSV file with new values. Keep the following values unchanged – the system uses them to identify the corporate action to update:
Security
Transacrtion type
Date
The date in the
ca.date1field for capital calls, issues, splits, subscriptions and redemptions.The date in the
ca.date2field for capital returns, dividends, dividends as shares, and exchanges.Either
ca.date2orca.date2field for coupons.
FA Format for importing corporate actions
One row in the CSV file represents one corporate action and a corporate action run. To create a corporate action run, specify portfolio, contact or portfolio group in the fields 17-19. Optionally, add the taxation and the run time information in fields 20-21.
The table shows how to fill in the fields for each corporate action type (scroll horizontally to view all corporate action types). Required values are underlined.
Formats to use:
Dates: yyyy-MM-dd
Date and time: yyyy-MM-dd HH:mm:ss, for example, 2021-09-20 15:00:00.
Numbers: 123.45
Download the CSV file template:
FAFormat_corporate_actions.csv
You can configure the file delimiter of you CSV files in the Importing preferences.
# | Corporate action | Fee calculation | Capital call | Capital return | Coupon payment | Dividend | Dividend as shares | Exchange | Issue | Redemption | Split | Subscription | Other |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ca.type | ASSET_MANAGEMENT_FEE | CAPITAL_CALL | CAPITAL_RETURN | COUPON_PAYMENT | DIVIDEND | DIVIDEND_AS_SHARE | EXCHANGE | ISSUE | REDEMPTION | SPLIT | SUBSCRIPTION | OTHER |
2 | ca.currency | Currency code | Currency code | Currency code | Currency code | ||||||||
3 | ca.date1 | Capital call ex-date Format: yyyy-MM-dd | Annual meeting date Format: yyyy-MM-dd | Next coupon date/ Next coupon record date Format: yyyy-MM-dd | Annual meeting date Format: yyyy-MM-dd | Annual meeting date Format: yyyy-MM-dd | Issue date/ Issue record date Format: yyyy-MM-dd | Redemption date Format: yyyy-MM-dd | Split date Format: yyyy-MM-dd | Subscription date/ Subscription record date, yyyy-MM-dd | |||
4 | ca.date2 | Calculation date Format: yyyy-MM-dd | Settlement date Format: yyyy-MM-dd | Expiration date/ Expiration record date Format: yyyy-MM-dd | Payment date Format: yyyy-MM-dd | Dividend ex-date/ Dividend record date Format: yyyy-MM-dd | Dividend ex-date/ Dividend record date Format: yyyy-MM-dd | Exchange date/Exchange record date Format: yyyy-MM-dd | Corporate action ex-date/ record date | ||||
5 | ca.date3 | Settlement date Format: yyyy-MM-dd | Settlement date Format: yyyy-MM-dd | Settlement date Format: yyyy-MM-dd | Settlement date | ||||||||
6 | ca.memo | Memo | Memo | Memo | Memo | Memo | Memo | Memo | Memo | Memo | Memo | ||
7 | ca.value1 | Interest rate | Unit price per share | Redemption % | |||||||||
8 | ca.value2 | feeFixedValue | Capital call % | Capital return per share | Coupon rate | Dividend per share | Dividend per share | Price/unit | Amount per share | ||||
9 | ca.value3 | Unit price per share | Redemption price per share | Subscription price | |||||||||
10 | ca.text1 | Ratio | Split ratio | Ratio | |||||||||
11 | ca.text2 | ||||||||||||
12 | ca.text3 |
| |||||||||||
13 | ca.security1 | Security code | Security code | Security code | Security code | Security code | Security code | Security code | Security code | Security code | Security code | Security code | |
14 | ca.security2 | Dividend security's security code | Removed security's security code | Issued security's security code | Issued security's security code | ||||||||
15 | ca.transactionType | Transaction type | Transaction type | Transaction type | Transaction type | Transaction type | Transaction type | Transaction type | Transaction type | Transaction type | Transaction type | Transaction type | Transaction type |
16 | ca.transactionType2 |
| Transaction type 2 | ||||||||||
17 | ca.portfolioId | Portfolio ID | Portfolio ID | Portfolio ID | Portfolio ID | Portfolio ID | Portfolio ID | Portfolio ID | Portfolio ID | Portfolio ID | Portfolio ID | Portfolio ID | Portfolio ID |
18 | ca.contactId | Contact ID | Contact ID | Contact ID | Contact ID | Contact ID | Contact ID | Contact ID | Contact ID | Contact ID | Contact ID | Contact ID | |
19 | ca.groupCode | Portfolio group code | Portfolio group code | Portfolio group code | Portfolio group code | Portfolio group code | Portfolio group code | Portfolio group code | Portfolio group code | Portfolio group code | Portfolio group code | Portfolio group code | Portfolio group code |
20 | ca.generateTax | Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
| Apply taxes based on tax rules defined in FA:
|
21 | ca.run_time | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss | The date and time of corporate action run. If not given, or if the given date is in the past, then the corporate action is run immediately. Format: yyyy-MM-dd HH:mm:ss |
22 | ca.RunBasedOn | Run based on. Enter one of the options:
| Run based on. Enter one of the options:
| Run based on. Enter one of the options:
| Run based on. Enter one of the options:
| Run based on. Enter one of the options:
| Run based on. Enter one of the options:
| Run based on. Enter one of the options:
| Run based on. Enter one of the options:
| Run based on. Enter one of the options:
| |||
23 | ca.customType | Corporate action type |