Transactions
Declare Transactions made after the Position File Upload
FundApps provides a tool to automate the requirement for historical transaction disclosure. Below you can find information on how it works. If you would like to read more about it, please see here.
Schema
Column Name | Description | Data type | Required |
---|---|---|---|
PortfolioId | ID of the portfolio | String(255) | X |
AssetId | ID of the asset | String(255) | X |
TransactionId | ID of the transaction | String(100) | X |
ExecutionDate | Date the transaction was executed | Date | X |
TransactionType | See below for possible types | String(50) | X |
Price | Price transaction was executed at | Decimal(28,8) | X |
Quantity | Quantity purchased/sold | Decimal(28,8) | X |
BrokerName | Broker transaction was executed with | String(255) | |
Currency | Currency transaction was executed in | String(255) |
Recognised Transaction Types (All case sensitive)
Type | Description |
---|---|
Buy | A standard purchase / buy transaction |
Sell | A standard sale /sell transaction |
CorporateAction | The issue of bonus shares, stock splits - everything related to actions taken by the issuer |
Expiry | The expiry of a derivative contract |
Exercise | The exercise of an option, future etc. |
Adjustment | Internal transfer of Assets |
Maturity | The maturity of a convertible bond, for example |
TakeOn | Asset resulting from a new account being opened |
Withdrawal | Asset withdrawn due to an account being closed |
Data Requirements
TransactionId
needs to be unique. In the scenario where aTransactionId
is uploaded which already exists, this will result in a validation error.AssetId
andPortfolioId
values need to match the fields with the same name in Position data; this is key in order to be able to query the correct transactions for disclosure forms.
Example File
PORTFOLIOID,ASSETID,TRANSACTIONID,EXECUTIONDATE,TRANSACTIONTYPE,PRICE,QUANTITY,BROKERNAME,CURRENCY
17,FI0009000681,219,2015-02-20,Buy,100,310,Jim Broker,EUR
17,FI0009000681,218,2015-02-19,Buy,100,199,John Broker,EUR
17,FI0009000681,217,2015-02-18,Sell,100,38,Joan Broker,EUR
17,FI0009000681,216,2015-02-17,Sell,100,117,Janet Broker,EUR
17,FI0009000681,215,2015-02-16,Sell,100,119,Amber Broker,EUR
17,FI0009000681,214,2015-02-15,Buy,100,482,Jim Broker,EUR
17,FI0009000681,213,2015-02-14,Buy,100,340,Janet Broker,EUR
17,FI0009000681,212,2015-02-13,Buy,100,401,Joan Broker,EUR
14,FI0009000681,211,2015-02-12,Sell,100,484,John Broker,EUR
14,FI0009000681,210,2015-02-11,Sell,100,84,Joan Broker,EUR
14,FI0009000681,209,2015-02-10,Sell,100,217,John Broker,EUR
14,FI0009000681,208,2015-02-09,Sell,100,80,John Broker,EUR
14,FI0009000681,207,2015-02-08,Sell,100,316,John Broker,EUR
14,FI0009000681,206,2015-02-07,CorporateAction,100,332,Joan Broker,EUR
14,FI0009000681,205,2015-02-06,Expiry,100,467,Janet Broker,EUR
14,FI0009000681,204,2015-02-05,Exercise,100,368,Joan Broker,EUR
14,FI0009000681,203,2015-02-04,Adjustment,100,270,Joan Broker,EUR
14,FI0009000681,202,2015-02-03,Maturity,100,48,Janet Broker,EUR
14,FI0009000681,201,2015-02-02,TakeOn,100,270,Joan Broker,EUR
14,FI0009000681,200,2015-02-01,Withdrawal,100,446,Janet Broker,EUR
Updated 9 months ago