APL |
APL Portfolio Administration (Contents, Download) |
APL > APL Documentation > User Manuals > APL Portfolio Administration (Contents, Download)
APL Portfolio Administration (Contents, Download)
Tip: An Adobe AcrobatTM formatted version of the complete User Guide (PDF) materials are available for sharing with your customer.
Table of Contents
- Chapter 1: About this Manual
- 1.1 What is APL?
- 1.2 What is APL Expert?
- 1.3 What you need to use APL Expert
- 1.4 Conventions used in this user guide
- Chapter 2: Getting Started
- 2.1 Logging on to the APL Expert system
- The main APL Expert Menu
- 2.2 Types of user interfaces
- Full-screen interface
- Line editor interface
- Repeating field values
- 2.3 Searching database records
- Performing a simple search
- Special operators (Boolean operators)
- 2.4 Printing report data
- Printing an entire report
- Printing search results
- Logging off of the APL Expert system
- 2.1 Logging on to the APL Expert system
- Chapter 3: Account Master Database
- 3.1 Creating an account
- Creating an account using EDITAC
- Creating a template using EDITACFIELDS
- Editing a template using EDITACFIELDS
- Creating multiple accounts using NEWACCT
- 3.2 Viewing account profile data
- Viewing account data with CLIENTSCREEN
- Another view that can be edited: SCREENAC
- 3.3 Editing or viewing account profile data
- Editing or viewing a single account using EDITAC
- Editing multiple accounts using EDAC
- Editing the short name code (SNAM) using EDMISC
- Creating and editing broker codes
- 3.4 Copying and combining account data
- Copying account data using COPYACT
- Combining account data permanently
- Combining account data temporarily using COMBINE
- 3.5 Deleting accounts by using PURACCT
- 3.6 Searching for account short names by using FINDSNAM
- 3.7 Auditing account master data
- 3.8 Summary of account master functions
- Adding
- Combining
- Copying
- Deleting
- Editing
- Searching
- Viewing
- 3.1 Creating an account
- Chapter 4: Account Memo Files
- 4.1 Create memo files with EDMEMO
- 4.2 Add or remove memo entries with MEMOCODE
- 4.3 Create and edit global account memos with EDGLOBALMEMO
- Chapter 5: Security Master Database
- 5.1 Security master databases
- 5.2 Adding new securities to security databases
- Adding a single security using EDITSEC
- Adding multiple securities using ADDSEC
- 5.3 On-Demand Request to Add Security
- On-Demand Request
- On-Demand Request Status
- 5.4 Adding "special" securities
- Foreign securities
- Futures contracts
- Trading futures using TRADESNEW
- Chapter 6: Security Transactions
- 6.1 Posting security transactions using TRADESNEW
- 6.2 Understanding error messages when posting transactions
- Trades in batches that have problems
- “OVER SELLING SACUS” and “NOTHING TO SELL” errors
- Previously posted batches
- 6.3 Repeating field values
- Using the quote symbol
- Repeating descriptions in multiple TRADESNEW transactions
- 6.4 Units used with securities transactions
- 6.5 Entering Option Transactions
- Posting an Option Trade
- Posting Options Regulatory Fees
- 6.6 Entering price per share
- 6.7 Entering special trades
- Versus purchases (tax lot)
- Special settlement dates
- Accrued interest
- Showing delivery of a gift
- Showing receipt of a gift
- Unsupervised asset trades
- Trading discretion
- Options Regulatory Fees
- 6.8 Selling fractional shares
- 6.9 Looking up prices
- Looking up deliver values
- Looking up receive values
- 6.10 Posting transactions after creation
- 6.11 Deleting trades after posting by using DELBATCH
- 6.12 Duplicating trades after posting
- 6.13 Searching for security transactions
- Viewing batches of trades using VIEWBATCH
- Searching through trades batches using SEARCHBATCH
- Viewing list of batches using BATCHLIST
- 6.14 Auditing security transaction data
- 6.15 Summary of security transaction functions
- Copying
- Correcting
- Posting and trading
- Searching and viewing
- Utilities
- Chapter 7: Account Portfolio Data
- 7.1 Viewing account portfolio data using FASTPORT
- 7.2 Editing account portfolio data
- Editing account portfolio data for a single account using EDITPORT
- Editing portfolio data for multiple accounts using EDPORT
- 7.3 Transferring account portfolio data to another account
- Journaling a security to another portfolio using JNLSEC
- Journaling multiple securities using JNLALL
- 7.4 Auditing account portfolio data
- 7.5 Summary of account portfolio data functions
- Editing
- Transferring
- Viewing
- Chapter 8: General Ledger
- 8.1 Posting entries to the general ledger
- Posting entries using POSTGL
- 8.2 Posting dividends using POSTDIVS
- 8.3 Viewing general ledger data using FASTGL
- 8.4 Editing general ledger data
- Editing data for a single account using EDITGL
- Editing data for multiple accounts using EDGL
- 8.5 Removing general ledger entries
- Removing entries by SACUS and date with FIXGL
- Removing entries based on description with FIXGLDES
- Removing entries by account with RECONGLDES
- 8.6 Executing general ledger "sweeps"
- SWEEPINC
- SWEEPECM
- 8.7 Auditing general ledger data
- General Ledger Trade Types
- 8.8 Summary of general ledger functions
- Editing
- Fixing
- Posting
- Sweeping
- Viewing
- 8.1 Posting entries to the general ledger
- Chapter 9: Reconciling Portfolio Data
- 9.1 Basic reconciliation report
- 9.2 Reconciling account portfolio data with RECONSCREEN
- Starting RECONSCREEN
- Adjustment screens
- Account Market Value Detail screen
- Diary Note screen
- 9.3 Function keys used in RECONSCREEN
- Chapter 10: General Reporting
- 10.1 Running reports on demand
- 10.2 Advanced search utilities \SELECTAC and \SELECTSEC
- \SELECTAC
- \SELECTSEC
- Macro utilities \LASTACTS and \LASTSEC
- 10.3 Creating customized reports using APL Report Writer
- What is a template?
- Template Editor
- Accessing Template Editor
- Creating a new template
- Opening a template
- Running a template
- Saving changes to an existing template
- Deleting a template
- Exiting the Report Writer
- 10.4 Standard reports using PostScript
- RUNGLOBALPACK
- RUNGLOBALPACK3 - Fixed income report pack
- RUNGLOBALPACK4
- General PostScript-specific functions
- Customization
- 10.5 Viewing and printing reports using BROWSE, QUE, and PRINT
- Viewing reports using BROWSE
- Printing queued reports using QUE
- Using the PRINT command
- 10.6 Requesting reports for overnight processing using SUBMIT
- 10.7 Finding reports using FINDREPORT
- Chapter 11: Macro Utilities
- 11.1 Creating a macro
- Date variables
- 11.2 Accessing the Macro Utility system
- Using an existing macro
- Editing a macro
- FORMAT option
- Printing a macro
- Searching for a macro
- Deleting a macro
- 11.1 Creating a macro
- Appendix A: Data Dictionary
- A.1 Account Master fields
- A.2 Security Master fields
- Appendix B: Standard Functions
- B.1 Account level
- B.2 Benchmarks
- B.3 Corporate actions and capital adjustments
- B.4 DTC-specific
- B.5 Fixed income
- B.6 General Ledger
- B.7 Miscellaneous
- B.8 Multi-purpose
- B.9 Performance
- B.10 PostScript
- B.11 Pricing
- B.12 Printing
- B.13 Reconciliation
- B.14 Security-level
- B.15 Trading and Position
- B.16 Window
- Appendix C: Standard Reports
- C.1 Activity
- C.2 Audit
- C.3 Benchmarks
- C.4 Billing
- C.5 Cash
- C.6 Commission
- C.7 Corporate actions and capital adjustments
- C.8 Cross-reference
- C.9 Fixed income
- C.10 Foreign-sensitive
- C.11 Gain and loss
- C.12 General
- C.13 Holdings
- C.14 Income
- C.15 Industry
- C.16 Management
- C.17 Performance
- C.18 Pricing
- C.19 Ranking
- C.20 Rating
- C.21 Reconciliation
- C.22 Restriction
- C.23 Trading
- C.24 Transaction
- C.25 Turnover
- C.26 Weighting
- Appendix D: Standard Macro Utilities
- D.1 Editing screen utilities
- D.2 Search prompt utilities
- Appendix E: Variables and Codes
- E.1 Date variables
- E.2 Security issue types
- Equity
- E.3 Fixed income
- E.4 Cash and cash equivalents
- E.5 General ledger trade types
- E.6 Stock exchange codes
- E.7 Currency codes