APL |
APL Trading System Reference |
APL > APL Documentation > Reference Materials > APL Trading System Reference
APL Trading System Reference
Tip: An Adobe AcrobatTM formatted version of this document (PDF) materials are available for sharing with your customer.
Getting Started
| Function Keys | |
|---|---|
| B | Move to the bottom of a report. |
| T | Move to the top of a report. |
| S | Search for a pattern on a report. |
| N | Search for next occurrence of a pattern. |
| P | Print a full report. |
| E | E-mail a report. |
| F | Fax a report (requires special set up). |
| D | Download a report. |
| (ESC) | Return to previous screen. |
Certain function keys are not accessible in some screens. Refer to the menu bar at the bottom of the screen or in the upper right hand corner for the valid function keys.
| F1 | Help / List of field choices. |
| F3 | Exit to main menu. |
| F4 | Search for a pattern. |
| F5 | Search for next match to a pattern. |
| F6 | Insert a blank line. |
| <SHIFT-F6> | Delete current line. |
| F7 | Display a list of accounts or securities. |
| <SHIFT-F7> | Print the screen. |
| F8 | Pull up special options. |
| F9 | Cycle through available field values. |
| F10 | Save file or execute command. |
| F11 | Save file or execute command (for LAN Workplace for DOS). |
| Selection Utilities | |
|---|---|
| \SELECTAC | Select and retain account grouping for use in other functions and/or reports. |
| \SELECTSEC | Select and retain security grouping for use in other functions and/or reports. |
| \LASTACTS | Retain and use last account selection entered at the Search For What? prompt. |
| \LASTSECS | Retain and use last security selection entered at the Search For What? prompt. |
| \WHONOTRADED | Select accounts that have not traded during a certain time frame. |
| \WHONOTRADEDISS | Select accounts that have not traded a certain issue type during a specific time frame. |
| \WHONOTRADEDSEC | Select accounts that have not traded a specific security during a certain time frame. |
| \WHONOWNSEC | Select accounts that do not own a specific security as of a certain time frame. |
| \WHOWNSEC | Select accounts that own specific security as of a certain time frame. |
Account Master Data
Make sure the proper account master fields are coded so that accounts are included in your trading universe. These fields are edited in the Expert system.
| ADM | Administrator. |
| BRKPCT | Broker discount commission. |
| BWNUM | Account number. |
| DESBRK | Directed or designated broker. |
| DESFIX | Designated fixed income target. |
| DESPCT | Designated equity target. |
| DTCNO | Custodian number (combination of DTCNO1 / 2). |
| DTCNO1 | First 6 characters of the custodian number. |
| DTCNO2 | Last 6 characters of the custodian number. |
| FDTYPE | Fund Type. |
| INVGRP | Investment Group. |
| MGR | Manager. |
| OBJECT | Investment Objective. |
| RR | Active Status. |
Calculated Account Master Fields
The fields below are calculated by the system overnight when windows are built and adjusted when a block of trades is committed. They cannot be edited.
| NAMES | Number of unique securities in the account. |
| WCASH | Cash and Cash equivalents. |
| WCOST | Total account cost. |
| WEQUTY | Equity balance. |
| WFIXED | Fixed Income balance. |
| WINCME | Total account income. |
| WTIME | Windows update time. |
| WTOTAL | Total account balance. |
| W13321 | Actual cash balance. |
Pseudo Fields
The pseudo fields work like account master fields, but they are calculated.
| $DIFEQT | Difference between the desired percent (DESPCT) in equity and the actual percent in equity. |
| $DIFFIX | Difference between the desired percent in fixed income (DESFIX) and actual percent in fixed income. |
| $DOLCSH | Allows you to maintain a set cash level to maintain the target minimum or maximum. |
| $DOLEQT | Defines the dollar amount an account would have to invest to reach the equity target. |
| $DOLEQT | Calculated by subtracting the actual market value in equities from the theoretical dollar target (DESPCT x WTOTAL). |
| $DOLFIX | Defines the dollar amount an account would have to invest to reach the fixed income target. |
| $PCTCSH | Actual percentage of the portfolio held in cash and cash equivalents. |
| $PCTDIF | This field is populated by the cash recon used by the client. It is the difference between the custodian balance and WCASH / WTOTAL. |
| $PCTEQT | Actual percentage of the portfolio held in equities. |
| $PCTFIX | Actual percentage of the portfolio held in fixed income. |
| $PCTISS | Actual percentage of the portfolio held in a particular issue type. You could use this field to select accounts that hold more than 20% corporate bonds. |
| $PCTSEC | Percentage of holdings in a given Security. |
| $PCTSHR | Percentage of outstanding shares. |
| $PCTSIC | Percentage of the portfolio in an industry group of your choice. |
| $ZMKCAP | Allows you to prevent the purchase of securities with greater than a specified dollar market cap. |
| $ZPCTOS | This field represents the percentage of outstanding shares that are held by accounts in all window universes. |
Trading Restrictions
Restrictions allow managers to code or edit security restrictions using the code RESTRC:
| ADDRESTRC | Post a restriction across a group of accounts. |
| EDRESTRC | Edit table for user-defined restrictions (used with the RESTRC security field). |
| UPDRESTRC | Update recent changes to restrictions for immediate use. |
| RMRESTRC | Remove restrictions from a group of accounts. |
Single account restrictions are coded in EDMEMO for each account. Firm-wide restrictions are coded in EDGLOBALMEMO. Both use the syntax RESTRC:
Swapping
TBA SWAP allows a manager to replace a “TBA” mortgage-backed security with a real bond-backed security by a collection of mortgages called a pool. Users can swap a single bond issue (pool) for multiple dates or multiple issues for a single purchase date.
Trade Creation
| WHAT-IF | Trade a single security across a group of accounts. |
| MULTI WHAT-IF | Trade multiple securities across a group of accounts. |
| QUICK SWAP | Create a new block of trades from an existing block. |
| TRADE ALLOCATOR |
Spread an order of trades across a set of accounts based on the following:
|
| TRADESCREEN | Manual creation of trades. |
| WHATIFTABLE | Specify rounding criteria for trade blocks. |
Model Trading
Model trading is trading against a set model of your ideal portfolio. Model are typically used with the rebalancing and adjusting functions.
| MODEL MAINTENANCE | Create new model accounts or edit existing model accounts. |
| ACTMODELMAP | Create a dynamic model by mapping a model account to an actively trading account. |
| ACCOUNT ADJUSTER | Adjust positions on an individual account or raise cash across a group of accounts. |
| ACCOUNT REBALANCER | Realign set accounts against a specific model account. |
| CASH REBALANCER | Align specified cash to a given model by purchasing securities. |
Trade Order Management (using Block Status)
| Show Detail | Display allocation within each block and summarize by security or broker. |
| Edit |
Modify a block of trades. Options include:
|
| Delete | Delete entire blocks of trades. |
| Combine Blocks | Combine blocks of trades. |
| Append Rebal Trades | Run the Cash Rebalancer and append the resulting trades to an existing block. |
| Create Empty Block | Create an empty block for manual trade entry. |
| Separate Block | Break one block into several blocks by designated broker code. |
| Extract Trades | Extract trades from a block and include in separate block. |
| Change Block Status | Make a market order good-till-cancelled and vice versa. |
Trade Execution Management (using Block Status)
| Commit | Commit a block of trades. |
| Multiple Commit | Commit multiple blocks of trades. |
| Un-commit | Un-commit a block of trades. |
| Execute Trades | After a block has been committed, price the trade for posting. |
| Full Execution | Execute several trades in a block at one time. |
| Quasi Execution | Execute trades in a block on an account by account basis. |
| Un-execute | Reverse one or all executions in a block. |
| Execution Detail | Display allocation detail for a block. |
| Execution Report | Display trade allocation ticket by sorted by broker ad trade type. |
| Effects of Block | Show before and after view of Accounts. |
| BLTSUM | Print hard copy report showing trades separated by security, price, broker or trade date. |
Trading Tickets and Reports
| BLOTTERAPL | Trades based on posting date. |
| BLOTTERDATES | Trades posted during a specified time frame. |
| BLOTTERTRD | Similar to BLOTTERAPL but runs off the execution file. |
| PENDINGTRADES | Unsettled transactions. |
| TRANLETBLOT | Standard transmittal letter. |
| TICKETBLT | Postscript transmittal letter. |
| TRANLETTRD | Trade letter created from execution file. |
| TRADEBLOTTER | Shows executed trades, sorted by account or Security. |
| Other Trade Transaction Reports | |
|---|---|
| ACTIVITY | All trades sorted by account. |
| ACTTRD | Compliant activity report that lists security, broker and commission information. |
| CAPAW | Positions received into or delivered out of an account. |
| COMMSUMM | Total commissions for all brokers for specified accounts, as of a specific date. |
| TRANPEN | Displays purchases, sells, contributions and withdrawals. |
| TRANALL | Displays purchases, sells and maturations, reorgs, receipts and disbursements. |
| TRANALL | Purchase and sells, including trade and settlement information. |