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 a TransactionId is uploaded which already exists, this will result in a validation error.
AssetId and PortfolioId 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