Import Microsoft Excel - Positions Dialog Box

1. Use the dropdown menu to select the Security ID Type.

2. In the File Name box, click the magnifying glass icon to browse to the Microsoft Excel file you want to import. Select the file and click Open. The path is displayed in the File Name box.

3. If the spreadsheet contains data in the first row, the system automatically selects the File Contains Header Line option. The column names are then shown as selections when mapping the file for import. Note: If the file does not contain column headings, the first row should be blank (contains no data).

4. Set the Date Format corresponding with the format for dates within the spreadsheet.

5. In the Column Order area, map each data type to the corresponding column in the spreadsheet. While most data points are optional, the following are required for valid positional imports:

   • Account Number

   • Ticker or Security ID

   • Share Quantity

6. Click the Reset button to clear any selections in the Column Order area. Note: If you have imported data previously, the column selections shown may be mapped to a prior spreadsheet. Use the Reset button to clear those selections prior to mapping the current spreadsheet.

7. Click the Import button to start extracting the data into the import blotters where you can review prior to posting to the client accounts.

8. Click Cancel to exit the screen without making changes.