APL |
APL Expert System Reference |
APL > APL Documentation > Reference Materials > APL Expert System Reference
APL Expert System Reference
Tip: An Adobe AcrobatTM formatted version of this document (PDF) materials are available for sharing with your customer.
Getting Started
| Editor Functions | |
|---|---|
| [P | Picture out the current information within the editor. |
| [D | Delete selected line(s) of information within the editor. |
| [S | Search for selected string of characters. |
| [Sxxx|xxx | Search for selected string of characters and replace with new string of characters. For example, SABL|APL. |
| [Q | Quit out of the particular editor being used. |
| [L# | Used within EDPORT to move from level to level. For example, to move from level 1 to level 3, type [L3 and press Enter. |
| [M | Used within EDPORT to move from level to level, in sequential order. For example, to move from level 1 to level 2, type [M and press Enter. |
| Primary Operators | |
|---|---|
| EQ | Equal To. Returns any records that have the expression specified in the field specified. |
| FEQ | First Equal To. Has the same uses as EQ except that it returns only the first occurrence. |
| NE | Not Equal To. Returns only the records that do not contain the expression specified. |
| GT | Greater Than (but not including). Returns any records that contain a value greater than the value specified. |
| GTE | Greater Than or Equal To. Returns any records that contain a value greater than or equal to the value specified. |
| LT | Less Than (but not including). Returns any records that contain a value less than the value specified. |
| LTE | Less Than or Equal To. Returns any records that contain a value less than or equal to the value specified. |
| EW | Ends With. Returns records that end with the value specified. |
| Secondary Operators | |
|---|---|
| SORT | Sorts accounts / securities selected in ASCENDING or DESCENDING order. |
| LIST | Lists the record short names selected on the screen. |
| AND | Links two search conditions. AND means that both conditions must be true. |
| OR | Links two search conditions. OR means that either one or both conditions must be true. |
| NOT | Returns all records that were not in the selection. |
| 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. |
| Printing and Viewing Options | |
|---|---|
| **COPY | Creates printable copy of file. |
| **COPYSOME | Creates printable copy of file for selected information. |
| Prints report to current printer. | |
| HO | Access the print holding queue. |
| BROWSE | View chosen report on screen. |
| SUBMIT | Request print jobs to be run and printed. |
| SETPRT | Select new printer. |
| SETFORM | Select new font and size / orientation. |
Account Master
| CLIENTSCREEN | View account information for an account. |
| COLLAPSEOPENS | Re-combines tax lots. |
| COMBINE | Temporarily combine one or more accounts into one account named COMBO. |
| COMBONYC | Combine one or more accounts into an account. |
| COPYACT | Copy account information and positions from one account to another. |
| EDAC | Edit account master data for one or more accounts. |
| EDGLOBALMEMO | Create memo codes for all accounts. |
| EDITAC | Edit account master data for one account. Add a single new account to the system. |
| EDITACFIELDS | Edit account master field mapping. |
| EDITBRKMAP | Edit mapping of broker codes and broker id numbers. |
| EDMEMO | Edit account memo files for individual accounts. |
| EDMISC | The only function that can change the SNAM. |
| EDRRNM | Edit and define broker (DESBRK) information, (CONTACT) information, Category (CATG), Budget, and Ticket charge. |
| FINDSNAM | Find the short name (SNAM) for an account group of accounts based on a partial description. |
| MEMOCODE | Add or remove memo codes for one or more accounts. |
| NEWACCT | Add one or more new accounts. |
| SCREENAC | View account master information for one or more accounts. |
| ACFIELDS | View the descriptions of the various account master database fields. |
Security Master
Databases
Private databases contain securities held in your accounts. You can edit a security if it is in one of your private databases. If it is not in your private database, it is the APL public database and cannot be edited.
(Note: XXX represents the client acronym).
| xxxHOT | Private subset of BW:SECSA. |
| xxxSEC | Other privately held securities and securities not priced by APL. |
| BW:SECSA | Master database (public). |
| BW:SECOPT | Options database (public). |
| BW:SECMISC | Miscellaneous securities (public, benchmarks and exchange rates). |
Sources
Fiserv has direct relationships with two pricing vendors:
| FT Interactive Data |
| JJ Kenny |
FT Interactive Data
| Equities, including common and preferred stocks. |
| Options. |
| Mutual Funds. |
| U.S. Government Treasury and Agency Obligations. |
| Corporate bonds, taxable rated Aaa/AAA to Baa3/BBB (Moody’s / S&P). |
| Corporate bonds rated less than BBB-(S&P) and Baa3 (Moody’s). |
| Medium Term Notes. |
| U.S. Treasury Obligations. |
| U.S. Government Agency Obligations. |
| Convertible Bonds. |
| Mortgage Backed Securities (includes ARM’s and SBA’s). |
| Collateralized Mortgage Obligations. |
| Asset Backed Securities. |
JJ Kenny
| Municipal Bonds. |
Functions
| ADDSEC | Add one or more securities to the SEC securities database. |
| COPYPRICES | Copy prices from one security to another. |
| EDDPR | Edit most recent dividend information. |
| EDFEND | Edit multiple securities using database commands (ISSTY EQ, EXCH EQ …). |
| EDINDNM | Edit security industry classification. |
| EDITFIXTYPS | Edit security FIXTYP descriptions. |
| EDITSEC | Edit security master data for a single security. Add single security to the system. |
| EDSEC | Edit security master data for one or more securities. |
| FINDSEC | Find securities based on a partial description. |
| FIXTYPMAP | Edit mapping of security master fields to a specific fix type. |
| **HELPCUSIP | Find CUSIP numbers for options, treasuries and corporate bonds. |
| SCREENSEC | View security master data for one or more securities. |
| SECFIELDS | View descriptions of the various security master fields. |
Security Transactions
| DELBATCH | Delete a previously posted batch of trades. |
| DUPBATCH | Duplicate a batch of trades. |
| EDITPORT | Edit specific account data for an account holdings. |
| EDPORT | Edit account holdings data. |
| FASTPORT | View portfolio data. |
| **JNLALL | Journal all selected securities from one account to another. |
| JNLSEC | Journal selected securities from one account to another. |
| POSTNEW | Post a batch that was previously created. |
| SEARCHBATCH | Search through batches of trades based on a particular search string. |
| TRADESNEW | Post security transactions. |
| VIEWBATCH | View a batch of trades. |
| \LOCKDES | Locks in identical description information across a group of trades. |
| **LOOKUPDLV | Looks up security prices on deliver transactions when creating a trades batch using TRADESNEW. |
| **LOOKUPRV | Calculates the receive value without accruals for any priced security when creating a trades batch using TRADESNEW. |
| **LOOKUPRVAI | Calculates the receive value with accruals for any priced security when creating a trades batch using TRADESNEW. |
General Ledger
| EDGL | Edit general ledger entries for a single account. |
| EDITGL | Edit general ledger entries for a single account, for a specific time frame. |
| FASTGL | View general ledger data for a single account, for a specific time frame. |
| FIXGL | Delete general ledger entries based on SACUS number. |
| FIXGLDES | Delete general ledger entries based on SACUS number and general ledger DESCRIPTION. |
| FUNDDIV | Post re-invested fund dividends. |
| POSTDIVS | Post cash dividends. |
Additional Macro Utilities
| \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 specific date. |
| \WHOWNSEC | Select accounts that own a specific security as of a specific date. |
Macro Programs
Macros are like batch jobs that you can run on-line. They are useful in any function that requires the operator to memorize a series of responses to the program's questions.
For example, you can set up macros to run reports on a group of accounts or to retrieve an unpriced security list. Macros can also screen through a group of accounts to retrieve accounts that are taxable, etc.
Access the MACRO system from the Directory of Programs.
@ON Turn macro recorder on.
@OFF Turn macro recorder off.