• All Files

 

Financial Information Fields

Refer to the following table when completing the fields on the Financial Information worksheet in your Mass Upload Excel workbook.

Field Name	Required	Documentation
Customer ID	Y	A unique ID to map customer information from worksheet to worksheet. Use alphanumeric characters only or current account ID at your firm.
Investment objectives	Y	Possible values: Preservation of capital Income Growth Trading Profits Speculation Hedging *Trading Profits must be selected for Options. Preservation of Capital cannot be selected for Options.
Estimated net worth	Y	In base currency, exclude value of residence.
Estimated liquid net worth	Y	In base currency, exclude value of residence.
Annual net income	Y	In base currency.
Other sources of funds	Y	If customer is unemployed, retired, student/intern or homemaker, enter one of: Consulting Disability Inheritance Interest Other (if other, specify) Real Estate Rental Severance Spouse Trading & Investments Unemployment
Percentage	Y	If customer is unemployed, retired, student/intern or homemaker, enter up to 100 (percent) for other sources of funds.
Description	Y	Only if Other is selected for Other sources of funds.
Total Assets	Y
Specify below for Stocks, Bonds, Options, Futures and FX
Years of trading experience	Y
Number of trades per year	Y
Knowledge level	Y	One of: Extensive Good Limited