Import Allocations

You can import allocations via a .csv file. Imported files must adhere to the following guidelines:

●         The file must be a .csv file.

●         Imported allocations will all be given today’s trade date.

●         The allocation quantity must be equal to the quantity available for a given Trading Account ID, Symbol, Side, and executing broker.

●         The file must use the format as illustrated below:

importFormat.gif

 

Where the required order and content of columns is:

Column A - Trading Account ID

Column B - Allocation account ID

Column C - Symbol

Column D - Side (B = Buy, S = Sell, SS = Short Sell, BC = Covered Buy)

Column E - Executing broker

Column F - Quantity, which must equal the quantity available for allocation for that symbol, side, trading account ID and executing broker.

To import allocationsimportField.gif

  1. In the import field, enter the name of the .csv file to import, or click the Browse button and navigate to the file.

  2. Click the Import button.

  3. If the file is successfully imported, it will be displayed alphabetically in the Allocation Summary as shown below.

importResults.gif