Clearwater Analytics Data Requirements Currency Forwards
Clearwater Data Requirements – Currency Forwards Please contact your Clearwater representative to answer any questions regarding these guidelines.
File Transmission Requirements Please download the Clearwater Data Transmission Requirements for details on transmission options
Data Requirements for Currency Forward Contracts A unique identifier is required for each currency forward. This identifier needs to be associated with positions and transactions. Each currency forward transaction and position should be identified as pertaining to a currency forward. The following table contains the full range of data fields used by Clearwater. The fields listed are critical to reconciliation and must be supplied before the data can be processed. All fields are requested and required field are notated. Please provide as much data as available to ensure accurate reporting. The left two tables comprise of the data needed on a daily basis, while the right table is data only needed at the time of implementation (Initial Load). Transactions Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Cancel/Rebook Indicator Commission †‡ Contract Exchange Rate †‡ Contract Identifier Counterparty ‡ Currency coming in †‡ Currency going out †‡ Description of Activity †‡ Entry/Trade Date †‡ Number of Units of currency in †‡ Number of Units of currency out †‡ Reversed/ Canceled Transaction ID Settle/Post Date †‡ Trade Price †‡ Transaction ID Transaction Type †‡
Holdings Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Contract Exchange Rate †‡ Contract Identifier Currency coming in †‡ Currency going out †‡ Description †‡ Market Price †‡ Market Value †‡ Number of Units of currency in †‡ Number of Units of currency out †‡
Initial Load Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Commission †‡ Contract Exchange Rate †‡ Contract Identifier Counterparty ‡ Currency coming in †‡ Currency going out †‡ Description †‡ Market Price as of Load Date †‡ Market Value as of Load Date †‡ Number of Units of currency in †‡ Number of Units of currency out †‡ Opening Transaction Type †‡ Original Entry/Trade Date †‡ Original Proceeds on Trade †‡ Original Settle/Post Date †‡ Original Trade Price †‡
* Required for all files and should match between all files
1
† Required for reporting ‡ Required for NAIC statements
Definitions/ Explanations of Terms Transaction Types: Buy (opening a contract), Settle (the contract settles). Identifier: The identifier the client would like to see associated with this contract. Note that we need a unique identifier to represent each contract, the position we expect to move out of the account on the settle date, and the position that we expect to move it. Identifier Description: Description of the Derivative. For a currency forward, this should be something like “Currency Forward Contract” Number of Units of currency out: This should be a negative number in the positions file. Number of Units of currency in: This should be a positive number in the position file. Commission: Any commission on the trade.
2
File Transmission Requirements Please download the Clearwater Data Transmission Requirements for details on transmission options
Data Requirements for Currency Forward Contracts A unique identifier is required for each currency forward. This identifier needs to be associated with positions and transactions. Each currency forward transaction and position should be identified as pertaining to a currency forward. The following table contains the full range of data fields used by Clearwater. The fields listed are critical to reconciliation and must be supplied before the data can be processed. All fields are requested and required field are notated. Please provide as much data as available to ensure accurate reporting. The left two tables comprise of the data needed on a daily basis, while the right table is data only needed at the time of implementation (Initial Load). Transactions Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Cancel/Rebook Indicator Commission †‡ Contract Exchange Rate †‡ Contract Identifier Counterparty ‡ Currency coming in †‡ Currency going out †‡ Description of Activity †‡ Entry/Trade Date †‡ Number of Units of currency in †‡ Number of Units of currency out †‡ Reversed/ Canceled Transaction ID Settle/Post Date †‡ Trade Price †‡ Transaction ID Transaction Type †‡
Holdings Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Contract Exchange Rate †‡ Contract Identifier Currency coming in †‡ Currency going out †‡ Description †‡ Market Price †‡ Market Value †‡ Number of Units of currency in †‡ Number of Units of currency out †‡
Initial Load Account Number *†‡ As of Date *†‡ Identifier *†‡ Security Type *†‡ Commission †‡ Contract Exchange Rate †‡ Contract Identifier Counterparty ‡ Currency coming in †‡ Currency going out †‡ Description †‡ Market Price as of Load Date †‡ Market Value as of Load Date †‡ Number of Units of currency in †‡ Number of Units of currency out †‡ Opening Transaction Type †‡ Original Entry/Trade Date †‡ Original Proceeds on Trade †‡ Original Settle/Post Date †‡ Original Trade Price †‡
* Required for all files and should match between all files
1
† Required for reporting ‡ Required for NAIC statements
Definitions/ Explanations of Terms Transaction Types: Buy (opening a contract), Settle (the contract settles). Identifier: The identifier the client would like to see associated with this contract. Note that we need a unique identifier to represent each contract, the position we expect to move out of the account on the settle date, and the position that we expect to move it. Identifier Description: Description of the Derivative. For a currency forward, this should be something like “Currency Forward Contract” Number of Units of currency out: This should be a negative number in the positions file. Number of Units of currency in: This should be a positive number in the position file. Commission: Any commission on the trade.
2
