You can apply one of several Average Price data configurations to the Average Price view. The configuration you select results in the addition of data columns (e.g., Account, Branch Code, Broker) to the view, and may change the order and level of detail displayed.

1. Right-click the Avg Price view of the Message Monitor, and select Configure Average Price from the shortcut menu.

2. A sub-menu appears, and a checkmark indicates the filter selected.

3. Select an Average Price filter. The primary criteria of each filter option are Symbol and Side, and the default filter uses these criteria only. When you select an alternate filter, corresponding data columns are added to the Avg Price view, and a single data row may be split into several. For example, if you bought the same stock through several different Brokers and select the Average Price by Symbol, Side, Account and Broker, a single data row of IBM Bought 500 120.00 might appear like this:

IBM Bought 100 Broker1 120.00

IBM Bought 200 Broker2 121.00

IBM Bought 200 Broker3 119.00

1. Right-click the Avg Price view of the Message Monitor, and the shortcut menu appears.

2. If the Combine Long and Short filter is selected, click it to deactivate the filter. When you deactivate the Combine Long and Short filter, a single data row may be split into several based on the Side associated with the trade (e.g., Sell Short). For example, if you sold some shares of a stock long and others short, a single data row of IBM Sold 500 120.00 might appear like this:

• Long and short sales are combined in the Avg Price view by default; you can activate the filter by selecting it from the shortcut menu again.

1. Right-click one or more execution rows whose shares you want to allocate to another account(s) in the Messages pane, select ManualAllocations from the shortcut menu, and the Allocations dialog box appears.

2. The details corresponding to the row(s) you selected (Symbol, Side, TotalQuantity, AvgPrice) are displayed in the top list box. Rows with the same Symbol, Side, and Account are automatically combined, and shares will be allocated based on the average price. Select the row corresponding to the shares you want to allocate from the top list box.

• As in the Avg Price view, executions with the same primary Side (e.g., Bought, Sold) can be combined into a single row or displayed as separate rows. When the Combine Long and Short checkbox is cleared, a single data row may be split into several based on the Side associated with the trade (e.g., Sell Short). For example, if you sold some shares of a stock long and others short, a single data row of IBM Sold 500 120.00 might appear like this:

IBM Sold 200 120.00

IBM Sold Short 300 120.00

• Execution and Doneaway shares with the same Symbol, Side, and Account are also combined when the Combine Execution and Doneaway entitlement has been turned on.

3. Select or clear the Pro-rated updates checkbox based on your processing preference for the Allocate shares to list box.

• If the Pro-rated updates checkbox is selected, individual updates will override established allocations to prevent an imbalance. The ratio of shares allocated to the accounts (those other than the one that is updated) will remain constant to each other when adjusted so that the Total % equals 100. For example, if you have allocated shares between three accounts (20%, 50%, 30%), and then increase the second account's % to 60.0, the percentage of shares allocated to the other two accounts (which must total 40% to keep the Total % equal to 100.0) will be automatically pro-rated as follows:
  
  The two other accounts originally made up 50% of the total % allocated, and the ratio of shares allocated to these accounts is represented by 20/50 and 30/50 respectively. The calculation below seeks to maintain this ratio when the two accounts make up 40% of the total % allocated.

20/50 = X/40    X = 800/50 = 16

30/50 = X/40    X = 1200/50 = 24

Therefore, the pro-rated update results in 16%, 60%, and 24% of the shares allocated to the three accounts respectively.

*Imbalance

 

The Pro-rated updates functionality also performs rounding operations when necessary.

If the checkbox is cleared, the user must manually adjust the other accounts’ % so that the total allocation percentage equals 100.0.

4. Click the first cell in the Account column of the Allocate shares to list box and a drop-down arrow appears. Click the drop-down arrow and select the first account to which you want to allocate shares.

5. Enter the portion of the Total Quantity (shares) to be allocated to the account you selected by clicking and entering the value in the adjacent Qty or % column. Based on your entry, the corresponding AvgPrice and Total [share value (Qty x AvgPrice)] are populated.

• The Allocated and Remaining fields at the bottom of the dialog box are populated based on your data you enter in the Allocate shares to list box. The Remaining fields will be blank when 100% of the TotalQuantity has been allocated.

• If you are entitled for Multi-Avg Pricing, you can modify the AvgPrice corresponding to the shares you allocate, provided that:

1. You selected multiple rows with the same Symbol, Side, and Account, but different execution prices.

2. The modified prices remain within the range of the original execution prices; for example, if you selected rows with executions with prices of $10.50 and $10.54, the modified AvgPrice values must stay within that range.

The Allocations dialog automatically adjusts the AvgPrice of the Remaining shares as you process your allocations.

6. Repeat steps 4 and 5 to allocate shares to additional accounts.

• The shares allocated must total 100% of the TotalQuantity corresponding to the row you selected in the top list box.

• You can apply an existing allocation template to the shares by selecting it from the <Manual Allocation> drop-down list box. Once applied, the details in the Allocate shares to list box can be modified as necessary.

7. When finished, click [Submit] to process the allocations.

1. Select the row(s) corresponding to the shares you want to allocate from the Messages pane.

2. Right-click the Messages pane, select Allocation templates from the shortcut menu, and then the desired template from the submenu. Shares will automatically be allocated based on the Accounts and % specified in the template, and the TotalQuantity and AvgPrice corresponding to the row(s) you selected.

You can reinstate (reverse) an allocation you’ve made. Once reinstated, you can allocate the shares differently or leave them as they were allocated in the original execution(s).

1. Right-click the row in the Execution or Doneaway view corresponding to your original allocation of shares, and select ReinstateAllocation from the shortcut menu.

2. A REDIPlus confirmation message appears, asking: “Are you sure you want to reinstate selected allocations?” Click [Yes], and the rows corresponding to your original allocation of shares are replaced by the original execution(s)/Doneaways. If you want, you can then reallocate the shares.

You can create allocation templates that establish the standard allocation (percentage) of shares to specific accounts. Once created, allocation templates can be applied to executions in a single step, making the allocation process easier.

1. Right-click the Avg Price view, select either Create/Edit Allocation Template from the shortcut menu, and the Create Templates tab of the Allocations dialog box appears.

2. Click [New], and a default name [Template (X)] appears and is selected in the Name drop-down list box.

3. Replace the default template name with a meaningful label.

4. Select or clear the Pro-rated updates checkbox based on your processing preference for the Allocate shares to list box.

5. If the Pro-rated updates checkbox is selected, individual updates will override established allocations to prevent an imbalance. The ratio of shares allocated to the accounts (those other than the one that is updated) will remain constant to each other when adjusted so that the Total % equals 100. For example, if you have allocated shares between three accounts (20%, 50%, 30%), and then increase the second account's % to 60.0, the percentage of shares allocated to the other two accounts (which must total 40% to keep the Total % equal to 100.0) will be automatically pro-rated as follows:
   
   The two other accounts originally made up 50% of the total % allocated, and the ratio of shares allocated to these accounts is represented by 20/50 and 30/50 respectively. The calculation below seeks to maintain this ratio when the two accounts make up 40% of the total % allocated.

20/50 = X/40    X = 800/50 = 16

30/50 = X/40    X = 1200/50 = 24

Therefore, the pro-rated update results in 16%, 60%, and 24% of the shares allocated to the three accounts respectively.

*Imbalance
 

The Pro-rated updates functionality also performs rounding operations when necessary.

If the checkbox is cleared, the user must manually adjust the other accounts’ % so that the total allocation percentage equals 100.0.

5. Click the first cell in the Account column of the Allocate shares to list box and a drop-down arrow appears. Click the drop-down arrow and select the first account to which you want to allocate shares.

6. Enter the portion of the shares to be allocated to the account you selected by clicking and entering the value in the adjacent % column.

7. Repeat steps 5 and 6 to allocate shares to additional accounts.

• The percentage allocated must total 100%.

8. When finished, click [Save]. The template will now be available from the Message Monitor’s shortcut menu, as well as in the Create Templates tab’s Name drop-down list box.

• You must save your workspace when exiting REDIPlus if you want to retain the template you created.

9. When finished, click [Close] to return to the Message Monitor.

1. Right-click the Avg Price view, select either Create/Edit Allocation Template from the shortcut menu, and the Create Templates tab of the Allocations dialog box appears.

2. Select the template you want to edit from the Name drop-down list box.

3. Make the necessary changes to the Account and % columns (i.e., adjust the portion of the shares to be allocated to an account by clicking and entering the value in the adjacent % column) of the Allocate shares to list box. Add additional accounts as necessary, keeping in mind that the percentage allocated must total 100%.

4. Click [Save] to save your changes, and when finished, click [Close] to return to the Message Monitor.

1. Right-click the Avg Price view, select either Create/Edit Allocation Template from the shortcut menu, and the Create Templates tab of the Allocations dialog box appears.

2. Select the allocation template you want to remove from the Name drop-down list box, and then click [Remove].

3. When finished, click [Close] to return to the Message Monitor.

• You must save your workspace when exiting REDIPlus if you want to retain your changes.