Home

SchwabLink® 2.3 User Manual v

1. Figure 5 9 Composite Security Positions Viewer To display the Security Cross Reference viewer double click ona record line in the list 5 51 Chapter5 Account Viewer Fields and Columns in the Composite Security Positions Viewer Fields and columns that you can customize are marked with an asterisk FIELD COLUMN DESCRIPTION Security type drop down list Shows a list of security classifications such as cs Common Stock The default is all All Security Types Security types are listed under the Security Type field description on page 5 45 of the Fields and Columns in the Client Account Positions Viewer section Symbol Symbol or CUSIP number used in identifying and pricing the security For details see the Symbol field description on page 5 45 of the Fields and Columns in the Client Account Positions Viewer section Security Description The name of the security Cash Margin The account from which payment for the security was drawn Number of Shares The number of units of the security held by all clients in the selected Master Account Long Short Indicates whether the position is long or short Latest Price Market price per unit of the security as of the date in the Date of Price field in the Security List viewer SchwabLink U ser M anual Market Value Market value of the security held by all clients in the Selected Master Account of Type Shows the percentage of each security as
2. Sending Files N ote You must transmit a Securities Allocation file to Schwab no later than one hour after the market closes on the day the associated trade was made To send files to Schwab 1 Click the button or select Send to Schwab from the File menu The Worksheet Q ueue dialog box appears Figure 8 7 Worksheet Queue E Figure 8 7 Worksheet Queue Dialog Box All files in the queue are automatically selected highlighted for transmission to Schwab Deselect files by using Ctrl C lick standard Windows selection functionality To remove files from the queue highlight them and click the Delete button If you accidentally delete a file from the Worksheet Queue you can requeue it See R equeuing Deleted Files on the next page 8 127 Chapter 8 Securities Allocation 2 Make sure that the files you want to send to Schwab are highlighted then click the Send button A dialog box appears showing the last Schwab Institutional Web site user ID that was entered 3 If your user ID is different from the user ID displayed enter your own user ID You must use your user ID and password every time you use the Securities Allocation module to send files to Schwab Enter your password Click OK The file is sent to Schwab If transmission is successful a confirmation message appears showing the name of the file 6 Click OK You are returned to the Allocation Worksheet Files that are sent successfully
3. Cancel Figure 5 32 Rebuild Secondary Table Selection Box 4 Select the appropriate option and click OK A progress bar appears W hen the task is complete the bar dis appears and the following message Is displayed Figure 5 33 Rebuild process complete Figure 5 33 Rebuild Success Message Box 5 Click OK and you are returned to the Account Viewer window The table rebuild will be shown as entries in the log 5 79 Chapter5 Account Viewer Viewing Historic Data You may need to look at historic views of data For example for audit purposes you may want to look at the status of a M aster Account at a date six months previous to the present date To review positions and balances for a certain period of time 1 Open the folder that contains the data for the M aster Account you want to view 2 Find the most recent build file prior to the date for which you want to view your data The build file should have the extension bkb if Build Update has been run consistently Change the extension to blid Find all the update files between that first build file and the last date for which you want to view information The update files should have the extension bku 5 Change the extensions to upd For example suppose you want to view data as of 6 30 00 The first build file prior to that may be cs062300 bkb Find the update files cs062600 bku cs062700 bku cs062800 bku cs062900 bku and cs063000 bku Change t
4. Figure 6 1 SchwabLink Status Reports Window W hen the Status Reports module opens all the report viewers are open and populated with the data from the first M aster Account in the M aster Account list on the left side of the screen Each report viewer has a tab at the bottom of the screen for each day for which there is data SchwabLink User M anual Viewing Master Account Data To view data for a particular M aster Account select the appro priate M aster Account number in the list on the left side of the Status Reports window The five report viewers immediately show the report data for the M aster Account you selected Selecting a Report Viewer To select a report viewer do one of the following e If the report is minimized double click on the report icon e If the report is cascaded or tiled double click on the report title bar e Select the report from the Window menu Selecting a Report File from an Open Viewer Each report viewer holds a report for each day of data Each report has a tab that shows the day it was generated For example if the report is generated on April 28 2000 the tab displays 04 28 2000 To select a report page from an open viewer select the tab that contains the report you want to see Figure 6 2 shows an example of a Transfer of Account TOA Complete report 6 92 Chapter 6 Status Reports CHARLES ical r W FINARE TAC ATS See LOL EETAFEFT ai Peele ch Wiigi 1 LC HEFE I
5. For example if a dividend was paid by a mutual fund company on February 27 2000 but was not posted to the client s Schwab account until March 5 then the transaction date displayed is 02 27 00 However note that this transaction will be down loaded as part of the March 5 transaction file Note Because Schwab does not credit client accounts until we receive payment from the appropriate source a delay of several SchwabLink User M anual days may occur before a transaction appears in the client account If you run a performance report the day after month end the numbers may not match the Schwab monthly state ment if the trailing transactions have yet to be posted It is Schwab policy to pay all distributions within a five day window of the actual payable date SchwabLink s use of the actual pay date is consistent with accrual accounting procedures A code representing the type of transaction such as sl Advent code or sel generic code for Sell To see a list of Advent and generic transaction codes select Transaction Code Descriptions from the View menu Occasionally the Transaction Code field is blank generic file format or is populated with an xx code Advent file format Schwab transmits a blank or the xx code to indicate the trans action is uncoded or is an adjustment to the account The blank field or xx code requires you to edit the transaction before posting it to your portfolio accounting system If you are using
6. Prime Broker Fee Aggregate fees for all trades that require a Prime Broker Fee Executing Broker Commission Aggregate commissions on those trades that require an Executing Broker Commission Trans Fee Aggregate transaction fees for all trades SchwabLink User M anual Other Fee Aggregate miscellaneous fees for all trades State Tax Aggregate state tax amount for all trades Commissions Aggregate commission amounts for all trades Principal Aggregate principal dollar amount for all trades Total Amount Aggregate total dollar amount for all trades The bottom left corner of the Trade Confirmations List shows the number of records in the list and the number of the record that is selected in the list Summary totals and the record totals also appear when you com plete a query They appear at the bottom of the list SchwabL ink displays in response to your query By using the Q uery com mand you can display summary totals for a client or group of accounts for a specific period of time Adjusting the Trade Confirmations List Viewer Display You can change how the information in the viewer is displayed To change column order and width or to sort data see Changing Column Order Adjusting Column Width and Sorting Data on page 5 83 5 68 Chapter5 Account Viewer Navigating in the Trade Confirmations List Viewer Use any of the following methods to locate a record in the Trade Confirmations List
7. To delete a M aster Account 1 Inthe Preferences dialog box click on the M aster Account that you want to delete 2 Click the Delete button A dialog box appears asking you to confirm the deletion of the selected M aster Account 3 Click the Yes button if you want to continue with the deletion The M aster Account no longer appears in the M aster Account list N ote Deleting a M aster Account from the list in the Preferences dialog box does not delete the account from the database OTHER SCHWABLINK INSTALLATION OPTIONS In addition to performing a Typical SchwabLink installation on your computer you can e Perform a Custom installation of SchwabLink e Remove SchwabL ink e Install SchwabLink on a network SchwabLink User M anual To install SchwabLink on a network see a later section Installing SchwabLink on a Network on page 2 25 Custom SchwabLink Setup To perform a Custom setup of SchwabLink 1 Refer to the earlier section Installing SchwabLink on Your Computer on page 2 14 Preform steps 1 through 7 2 When the Setup Type window Figure 2 17 appears select the Custom option ichawhlink Unrckisp Shop cep lpp Circos Hha rbag ippa ai bad ne pour meek D sconphon Tha skea a igs panira ih miidson of babli Cathia Figure 2 17 Setup Type Window 3 Click the N ext button to proceed with the Custom installation The Select Components window Figure 2 18 appears The
8. Use the Find function in the Securities Cross Reference Viewer to switch to another security or to search fields within the viewer 1 Open the Securities Cross Reference Viewer 2 Click the Find button or select Find from the Edit menu The Find dialog box appears 3 Do oneof the following to enter search criteria A Enter the symbol for which you would like to display a cross referenced account list Click Find N ext The Securities Cross Reference Viewer displays data for the selected security oJ Enter the text and or numeric string that you want to find within the Securities Cross R eference Viewer To restrict the search to values within the viewer select the option to Search Top Window You can also select the options to find only records that start with he string you entered or to search the selected column only Click Find N ext SchwabLink locates the first record that meets your search criteria SchwabLink U ser M anual Changing Column Order In some viewers you can change the order of the columns 1 M ove the mouse pointer to the header of the column you want to move 2 Hold down the mouse button and drag the column to the desired location 3 Release the mouse button The column should now bein its new position Adjusting Column Width In some viewers you can resize the columns To make columns wider or narrower 1 Movethe mouse pointer over the line between the header of the column y
9. You can repeat these steps as many times as necessary to refine your search W hen finished you can save your set of selection criteria for future use Click Save Query and enter a file name Click Save to return to the Query Builder screen Click Run Query to begin the search Loading a Previously Saved Query You can load previously saved queries in order to save time when running similar reports on a regular basis Li M ake sure that the transactions list that you want to query iS Open From the View menu select Query The Query Builder window opens Figure 5 14 Click Load Query Select a saved query and click Open The previously defined search criteria appear in the Query screen To further refine the search see the section Specifying Additional Search Criteria on this page 5 61 Chapter5 Account Viewer 4 Click Run Query to begin the search Completing the Query SchwabLink conducts the query and displays the results in the Account Viewer window as a new Transactions Query Results List viewer Figure 5 15 The basis of the query is displayed beneath the title bar nm Leer Peas Lol Ee Lier k arrr losers Sede ee i vee ected a prapa Figure 5 15 Transactions Query Results List Viewer Printing the Transactions or Query Results List You can print the Transactions List or a Transaction Query Results List The lists print continuously on multiple pages if necessary SchwabLink User M anu
10. Resizing Viewers You can resize viewers with the standard Windows resizing tools Pel E Refer to your Windows documentation Rearranging Viewers You can open any number of viewers at one time The default view of multiple viewers Is standardized screens cascaded with the active viewer on top To change the way open viewers are displayed in the Account Viewer window 1 Select Window from the menu bar The Window menu Figure 5 38 appears First Record Last Record Next Record Previous Record Cascade Tile Horizontal Tile Vertical Arrange cons Minimize All w 1 Client Information O8000000 Updated 0370171999 Figure 5 38 Window Menu SchwabLink User M anual 2 To rearrange the screens select the appropriate command e Cascade Returns the screens to standard size and cas cades the viewers with the active one on top Tile H orizontal Displays the screens in rows sized to fill the Account Viewer window Tile Vertical Displays the screens in columns sized to fill the Account Viewer window Arrange Icons R earranges the icons of any minimized screens at the bottom of the Account Viewer window M inimize All M inimizes all the open screens and tiles the icons at the bottom of the Account Viewer window If the Account Viewer window is resized and or the open viewers are out of sequence choosing any one of these options refreshes the arrangement accordingly For example if you a
11. SchwabLink User M anual FUND REBALANCER REPORTS Fund Rebalancer comes with a robust reports module that provides a series of predefined reports with additional selection options For example you may request a report on all accounts or an account range Additionally these reports may be previewed printed or saved in various file formats The four main Fund Rebalancer reports include e Trade Orders by Account e Trade Orders by Asset e Account Rebalancing Summary e Account Rebalancing D etail All Trade Orders You may view a report containing all orders for a M aster Account including exported orders for the current session This report includes all orders displayed on the Order List For each account with an order the report displays e Trade Type e Symbol e Description e Price Operation e Quantity e Cost e Proceeds C221 Appendix C Fund Rebalancer To print a listing of all orders 1 On the Fund Rebalancer toolbar click the Printer toolbar button sae Select Trade Orders By Account In the Account Selection area select All Accounts In the Order Selection area select Show all Trade orders Click the Print button ya a All Orders within an Account Range You may view a report containing all orders for a M aster Account including exported orders within the current session for an account range This report includes all orders displayed on the Order List For each account with an order the report
12. TR All trade detail records begin with TR 08001234 BUY DLRS SELL SHRS or SELL DLRS 150 37 1000 546 0 50 EXMAX N Y on Buy Comm and Sell Comm trades CC for Cash Divs Cash Cap Gains RR for Reinvest Divs Reinvest Cap Gains CR for Cash Reinvest 68 1 69 76 8 71 1 78 1 EXAMPLE Blank Space TIME STAMP Blank Space ALLOC GROUP HD FA M 08000000 FA30 M8000000 TR23456789 BUY DLRS TR23456789 BUY DLRS TR45678901 BUY DLRS TR56789012 SELL SHRS TR56789012 SELL SHRS Saving a Mutual Fund Trade List 100 00 500 00 10000 00 35 0000 0 90 13051299 0 No Allocation Group 1 Allocation Group Linked Trades TEST1 N RR 15394598 0 TEST2 N RR 15394597 0 TEST4 N RR 15394596 0 TEST4 N RR 15394596 0 TEST4 N RR 15394596 0 When you send a mutual fund trade order list to Schwab it Is automatically saved as a file However you may not want to send your list right away If you exit the application before you send the list you will need to save it manually as a file To save a mutual fund trade order list as a file 1 Click the Ea button or select Save As from the File menu The Save As dialog box Figure 7 11 appears 7 115 Chapter 7 Mutual Fund Trading 2 Change the drive directory and file name if required Save As ka Fa Save int fe 08129123 i E E a Cs032199 TM0 Cs037199 TM1 Cs037199 TM2 File name Save as type PArchive file id Cancel Figure
13. Viewer column Unless you hide the toolbar all the viewer command buttons remain visible so that you can move immediately to another viewer as required 5 39 SchwabLink User M anual activity dating to the period that you specify Chapter 5 Account Viewer VIEWER SECURITY ACCOUNT LINKS INFO INFO WITH Client N A All client accounts inthe Client Account Information selected Master Account Positions with single account details Client Account All securities Single account Security Cross Positions Reference Security List All securities N A Composite Security Positions Composite All securities N A Security Cross Security Positions Reference Security Cross Single security All accounts holding Client Account Reference the security Positions Transactions List All securities with All accounts with N A activity datingto activity dating to the the period that you period that you specify specify trades dividends etc Deposit Withdrawal Cash only All accounts with N A Trade Confirmations All confirmed All accounts linked to Trade List security trades the confirmed trade Confirmation Detail Trade Confirmation Single security Single account N A Detail NAVIGATING IN ACCOUNT VIEWER As discussed in previous sections you can go from one viewer to another by clicking the appropriate toolbar button Also most viewers are linked to another viewer which you can access by double clicking a record In general y
14. This report provides a listing of all the accounts linked to the master account without a model assignment For each account the report displays e Account e Description e Custom Account number e Custom Description SchwabLink User M anual 0001 03511 To print accounts without model assignments 1 Click the M odel Assignment Screen toolbar button ai 2 Click the Printer toolbar button pe 3 Select Accounts without M odels from the drop down menu The M odel Assignments Reports dialog opens 4 Inthe Account Selection section select the All Accounts radio button 5 Click the Print button Model Assignments by Account This report displays all the accounts listed on the Account with M odels tab It does not include any accounts without model assignments For each assigned account the report displays e Account e Description e Model name e Current portfolio market value and variance e Account Exclusion instructions To print model assignment by account 1 Click the M odel Assignment Screen toolbar button el 2 Click the Printer toolbar button Se 3 Select M odel Assignments by Account from the drop down menu The M odel Assignments Reports dialog opens 4 Inthe Account Selection section select the All Accounts radio button 5 Click the Print button C 232
15. Using Filter Profiles Using Predefined Filter Profiles M odifying an Existing Profile Creating a N ew Profile Filtering on Comment Lines Deleting a Profile Running the Transaction File Filter Viewing the Selection Criteria Running the Filter in M anual M ode Running the Filter in Unattended M ode Canceling the Results of the Filter Process Log File Appendix C Fund Rebalancer Overview Fund Rebalancer Program Structure Getting Help Using This Appendix Tutorial Accessing SchwabLink Fund R ebalancer Understanding the Fund Rebalancer Work Area B 168 B 169 B 170 B 173 B 175 B 175 B 176 B 176 B 176 B 178 B 178 B 179 C 180 C 181 C 182 C 182 C 182 C 183 C 184 Table of Contents Step 1 Creating M odels Step 2 Assigning an Account to a M odel Step 3 Defining Account Exclusions Step 4 M oving Accounts to the Select List Step 5 Inputting Cash M anagement O ptions Step 6 Generating the Order List Step 7 Reviewing Orders Step 8 Approving Accounts for Order Export Step 9 Exporting the Orders Step 10 Importing the Trade File M odel Configuration O verview U nderstanding the M odel Configuration Work Area Working with M odels Creating a M odel Deleting a M odel with Assignments Deleting a M odel without Assignments Copying a M odel Changing M odel C ontents Deleting an Asset from the M odel Changing an Asset s Percentage Adding Cash to a M odel SchwabLink User M anual C 185 C 187 C 189 C 190 C 19
16. Using the Find Command on page 5 81 e Scroll bars e Query function to find groups of records with common criteria see Using the Query Command for Transactions on page 5 60 5 58 Chapter5 Account Viewer Adding the Previous Day s Transactions If you do not specify transactions as part of the Build Update process you can add the previous day s transactions from the Add Transaction Files dialog box To add the previous day s transactions 1 From the File menu select Transaction File then select Add The Add Transaction File s dialog box Figure 5 12 appears Add Tranzection File s bE eff Eo es Fies o hpa Tieni hes 5 ie TS oS ince E E Figure 5 12 Add Transaction File s Dialog Box The file names appear in CSM M DDY Y trn format For example if the previous day s date is M arch 9 2000 the transaction file name is CS030900 trn To locate a transaction file in another directory select the drive and directory from the Look in field All transaction files for the directory you select appear in the window SchwabLink User M anual 2 Select the file name of the transaction file you want to add The file name appears in the File name field You can select more than one file using standard Windows Ctrl and Shift click functionality 3 Click Open SchwabLink checks the records in the file s you selected against the records already in the list Duplicat
17. When you are performing more than one installation of the SchwabLink program files you must specify the same network control directory for each installation Do not overwrite or replace previous data files Do not select a new directory The SchwabLink installation program will ask for the drive and directory destination for program files This drive may bea network drive but must not bea RAM drive Access Rights N etwork operating systems allow limited access to the file server directories To install SchwabLink you must have the following rights to file server program and data directories Read Write Create Delete and M odify Drive Letter Assignments C is usually the name DOS assigns to the hard disk drive in the computer N etwork operating systems allow drive letters to be assigned to sub directories on other computers known as file servers After Installing Before you begin using SchwabLink on a network for the first time please review the following SchwabLink User M anual Time and Date Restrictions You must have the correct date and time set on your computer to access SchwabLink s Paradox data tables To check the date and time settings and change them if necessary follow these steps 1 Open the Start M enu on your desktop 2 Select Settings 3 Select Control Panel 4 Click the Date Time icon 5 Change the date time or time zone as necessary on the screen 6 Click OK to update and exit the
18. gt as the Operator and 100 00 as the Value 6 Click Add 7 If you would like to save your Query now for future use click Save Query and enter a file name Click Save to return to the Query Builder screen You may save your query at any stage during the query building 8 If you are finished entering search parameters click Run query to begin the search To refine your search further go to step 9 in the next section Specifying Additional Search Criteria You can refine your search by completing additional sets of search criteria For example in addition to specifying transac tions greater than 100 in the first set of fields you can specify that they have a value of less than 200 SchwabLink User M anual 10 iL 12 13 Select the And radio button in the N ew Atom section to find records that contain both values you specify Select the Or radio button to find records that contain either set of values you specify Repeat steps 3 through 6 as appropriate to complete the additional search criteria Click Add You can repeat these steps as many times as necessary to refine your search W hen finished you can save your set of selection criteria for future use Click Save Query and enter a file name Click Save to return to the Query Builder screen Click Run Query to begin the search Loading a Previously Saved Query You can load previously saved queries in order to save time when running similar r
19. ur 1 My itl Schwab LIN SchwabLink 2 3 User Manual IIE Schwab INSTITUTIONAL VERSION Table of Contents SchwabLink 2 3 User Manual Access to electronic services may be limited or unavailable during periods of peak demand market volatility system upgrades maintenance or for other reasons The material in this document may not be reproduced distributed or shared with anyone outside of your organization SchwabLink User M anual Table of Contents Chapter 1 Introduction Other SchwabLink Installation O ptions 2 23 Welcome 1 11 Custom SchwabLink Setup 2 23 W hat s N ew 1 11 Removing SchwabLink 2 24 Installing SchwabLink 1 11 Post Setup Activities 2 24 Using This M anual 1 11 Post Setup Sequence for N ew Users 2 24 Getting Help 1 11 Post Setup Sequence for Ongoing Users 2 25 Installing SchwabLink on a N etwork 2 25 Chapter 2 Getting Started N etwork Installation Tips 2 25 Welcome to SchwabLink 2 3 and the Client Server N etwork Installation 2 26 Schwab Institutional Web Site 212 Peer to Peer N etwork Installation 2 21 Getting Immediate Assistance Ze EROS Connon DIRECT 2 21 O ther Resources 212 OEEC an Contents of the CD ROM 2 12 Before You Begin gt 13 Chapter 3 Schwab Institutional Web Site Recommended System Configuration 2 13 Overview 3 28 Installing SchwabLink on Your C omputer 2 14 Security and System Requirements 3 28 Accessing the SchwabLink Desktop and Services 2 19 Key Features 3 28 Accounts 2
20. Fields and Columns in the Client Account Positions Viewer on page 5 45 CUSIP number of the security Executed Date Action Account Name Quantity Price Principal Commission The date on which the trade was executed Indicates whether securities were bought or sold Account name as registered with Charles Schwab amp Co Inc The number of units of the security that were traded The price per unit of the security Principal dollar amount involved in the trade The dollar amount of the commission charge Total Amount Item Description Confirm ID Total dollar amount of the trade The name of the security The file name and the confirmation number for the record To display this column place the cursor to the left of the Account Number column When the double arrow cursor appears click and drag the Account Number column to the right 5 67 Chapter5 Account Viewer TOTALS FIELDS Buys Buys Total number of buy confirmations Commission The total dollar amount of the commission charges for buys Principal Principal dollar amount total involved in the buys Total Amount Total dollar amount of the buys Sells Sells Total number of sell confirmations Commission The total dollar amount of the commission charges for sells Principal Principal dollar amount total involved in the sells Total Amount Total dollar amount of the sells Summary SEC Fee Aggregate SEC fees for all trades
21. Fund Rebalancer 2e ok herel eles Booked Soe Ne a MSE a DF eH FA ee ee PRUE HEIGL PUSS oa Figure C 8 Highlighted Accounts before Linking 5 Click the Link Accounts with M odel toolbar button EAN Fund Rebalancer updates these accounts and they now display on the Accounts with M odels tab SchwabL ink User M anual Bi E eit eee ree ele Cah Paki BFH ee Dl eb ee De iT BG bish ac hd E Leck aren ci sare mit Te ee Ti ELIE air FITE LO re ere a p a Sample Data Can eee F decided ama ha e choo Ra deye p parkai prior p a m ali ah a iel T Eerkah d jad peia Peeks eee eee f a Ce m a am Pa a a ae fen ee ee Figure C 9 Accounts with Models after linking 6 Click the close box x in the upper right corner to close the M odel Assignment program Note The securities displayed are fictional and used for illustration purposes C 188 Appendix C Fund Rebalancer Step 3 Defining Account Exclusions The M odel Assignment program allows you to exclude specific assets from the rebalancing process T hese assets may include cash mutual funds or marginable funds Fund Rebalancer program uses these exclusions to generate the order list Any fund position not included in the assigned model appears in the Asset Exclusions table N ote The Account Exclusion settings remain with the account even if you assign a different model to the account To set Account Exclusions 1 Click the M
22. R eports Overview Saving Reports Viewing Saved Reports SchwabLink User M anual C 215 C 215 C 218 C 219 C 220 C 222 C 222 C 222 C 222 C 223 C 224 C 224 C 224 C 224 C 224 C 224 C 225 C 226 C 226 C 226 C 227 C 227 Fund Rebalancer Reports All Trade Orders All Orders within an Account Range Exported Orders for the Current Session Excluded Orders Trade Orders by Asset Account Rebalancing Summary Account Rebalancing D etail M odel Configuration R eports M odel Portfolios by N ame Assets for All Portfolios Individual Asset Reports M odel Assignment Reports All M odel Assignments One M odel Assignment Accounts without M odels M odel Assignments by Account C 227 C 227 C 228 C 228 C 229 C 229 C 229 C 230 C 230 C 230 C 230 C 231 C 231 C231 C 232 C 232 C 232 Chapter 1 Introduction WELCOME Welcome to SchwabLink 2 3 SchwabLink helps you maximize performance by automating your routine trading tasks so you can focus your attention on building relationships and gathering assets SchwabLink links your personal computer to the Schwab network and the wide range of resources and data it provides SchwabLink facilitates trading receives confirmations obtains prices and provides up to date client account information With SchwabLink you can transfer data directly from Schwab into your portfolio management software PM S and record keeping software databases spreadsheet or cus
23. Schwab will be forwarded to a Schwab transfer representative for CLOS Closed The transfer of assets has been closed with no transfer of processing assets occurring The transfer will be resubmitted or returned to the delivering firm for additional information MEMO Memo PTR The receiving firm initiates a Partial Transfer request Information is passed to the delivering firm as a memo CLSPRG Close Purge The Closed item is purged from ACAT system MEMPRG Memo PTR Purge The Memo PTR is purged from NSCC files at the end COMP Completed The transfer has been completed and assets have of the day it is submitted transferred For ACAT transfers the status changes to COMP when the assets are received from the delivering firm Not all assets need to be NEW New For ACAT transfers only delivering firm prepares assets for received for the status to change to COMP For example trailing delivery to Schwab For IRA transfers status remains NEW for a dividends are transferred through the ACAT system after the initial maximum of 10 business days For brokerage transfers the status transfer is complete remains NEW for a maximum of 5 business days For non ACAT transfers the transfer receives a COMP status only after all the assets being transferred are received into the Schwab account NON ACAT Non ACAT Non ACAT transfers are used for non member firms banks Savings amp Loans some brokers and all partial transfers DELV Delivered For incoming out
24. Yee A Font Figure 6 11 Status Reports Preferences Dialog Box 6 99 Chapter 6 Status Reports This section explains how to e Change the default opening display of Status Reports e Use the Automatic Actions boxes to automate Status R eports features e Format the report fonts For information on adding editing and deleting M aster Accounts see Chapter 2 Getting Started Changing the Opening Display The first time you run Status Reports the report viewers are cascaded You can change this default opening display in the Status R eports Preferences dialog box In the New Document Layout area select the option that describes how you want the viewers to appear each time you open Status Reports e Cascaded the default shows the report viewers in cascaded format Figure 6 7 e Tiled Horizontally opens the report viewers in tiled horizontal format Figure 6 5 e Tiled Vertically opens the viewers in tiled vertical format Figure 6 6 e M inimized shows the report viewers as icons at the bottom of the Status Reports window Figure 6 8 e M aximized shows the reports in maximized format Switch to other reports by selecting from the Window menu SchwabLink User M anual Setting Automatic Actions In the Automatic Actions section of the Preferences dialog box you can set the following preferences e Arrange Icons on M inimize All Icons appear neatly arranged at the bottom of the Status Reports window
25. default display selects all SchwabLink components to install 2 23 Chapter 2 Getting Started 4 Review thelist of components and click the box next to the component to indicate which one s you do not want to install The check mark disappears ncheabhl m liad hop Sate Gekecg Coppi Chee the rapan p eal i Teie Goer p i o r rd Chea Bt its pou ddd rr wear be ra APERT ea Ceaiengteor at Bl ected Fe Ue kia of el iba Frome T irg vars ef h Debut Piaget atl ECL Sle Se WLL Sihhi ienga Daa sf a L guis age ikra y a Fund Fabie Space Reduaed on C ard i Space Aaleble on L TTD E etes O cwe Figure 2 18 Select Components Window 5 Click the N ext button In the Select Program Folder window the Setup program displays the name of the SchwabLink folder to be added to the Program Files folder on your hard disk You can rename the folder or select a folder from the existing line of folders 6 Follow steps 9 12 of the installation procedure beginning on page 2 17 The program installs only the SchwabLink components you have selected SchwabLink U ser M anual Removing SchwabLink To remove SchwabLink from your computer in Windows select Start gt Settings gt Control Panel gt Add R emove Programs Select SchwabLink Desktop and click the Add Remove button PosT SETUP ACTIVITIES After you install SchwabLink you need to complete post setup activities to verify t
26. details for that account in the Client Account Positions viewer M aster Account is selected in the SchwabLink Account Viewer window and click the Transactions button The Transactions List sivas viewer Figure 5 11 appears Printing from the Security Cross Reference co pap Viewer The selected M aster Account is shown in the title bar To print from the Security Cross Reference viewer HGH eacrleilete eco oer 1 Makesure that the data you want to print appears in the active viewer a obeak rmi Somer renn lode Le EE eee ETI E 2 Click the Print button on the toolbar or select Print from the File menu The Print dialog box appears 3 Set print parameters as appropriate and click OK TRANSACTIONS LIST VIEWER The Transactions List viewer provides next day access to all transactions in the selected M aster Account Transactions can be reviewed sorted and queried and dollar totals can be tracked N ote T he viewer retains transaction records for transactions that take place within the time period you specify in the Transaction records retention period days field of the Account Viewer Preferences dialog box See Specifying the Transaction and Confirmation Record Retention Period on page 5 90 ea Dea e H Tag Cee 17 Figure 5 11 Transactions List Viewer To designate an automatic update of the Transactions List viewer during the Build U pdate process see Include Positions Balances Transa
27. portfolio management software see the editing and posting sections of your user manual The type of security involved in the transaction To view a list of security types select Security Type Descriptions from the View menu Or see the Security Type field description on page 5 10 of the Fields and Columns in the Client Account Positions Viewer section If you are using portfolio management software you can set up or access a translation program to translate an existing security type code to another security type code Refer to the translation program section of the manual for your portfolio management or operations software 5 56 Chapter 5 Security Symbol Dollar Amount Account Type Account Viewer Schwab downloads security symbols from the following sources and in the following formats Primary NYSE AMEX NASD ticker symbols Schwab uses the standard industry accepted ticker symbols frequently used by quotation services such as Quotron or ADP Secondary CUSIP number A CUSIP number contains nine characters but some portfolio management programs use only eight The ninth character is reserved for use as a check character Most bond transactions are downloaded with a CUSIP number Tertiary Schwab security number Transmitted by SchwabLink if no ticker symbol or CUSIP number is available The security symbol contains seven numbers For example 1234567 This security number is internal to Schwab and
28. the corresponding Account Exclusions or M odel Assignment information will appear on the right side C 207 Appendix C Fund Rebalancer Ph rh ara ee ee pmr Biz FE eT ae de kebar ema e eah Ee ee N e Laa nra Pee a Hi bab deam E l Eshak g mi pana a Tress EHA Tet SE METEL aoa fore bbe fea are hg ni e ay ernie ee papery pee Daag erreien ri need poe Geel reer rhad Lj Pe ESH b mea Biel fbh M se en pees ld all ee Be m e a Pee a Figure C 32 Model Assignment Note The securities displayed are fictional and used for illustration purposes ASSIGNING ACCOUNTS TO A MODEL Assigning accounts to models is a prerequisite to both setting Account Exclusions and rebalancing portfolios An account may not be assigned to more than one model portfolio To assign accounts to a model 1 Click the M odel Assignment Screen toolbar button Td 2 Click the Accounts without M odels tab 3 CTRL click on each account you d like assigned SchwabLink User M anual 4 On the M odel Assignment tab click the M odel N ame you d like to assign the account s to 5 Click the Link Accounts with M odels The accounts are moved from the Accounts without M odels tab to the Accounts with M odels tab va toolbar button Removing Accounts from a Model In order to reassign an account to a different model portfolio you need to remove the current assignment To remove an account
29. the initial transaction file to your individual client portfolios within your portfolio management system The initial transaction file is generated automatically when you first use the Download Utility so you do not have to request it separately The naming convention for the file is CSM M OOYY TRN Example CS070099 TRN N ote You may not want to post the initial transaction file if you already have current client account data in your portfolio man agement system If you choose not to use the file simply delete it N ote that two data items are not included in the initial transaction file e Historical cost basis e Historical date of purchase You must enter this data manually before you post Once you set up the positions and balances within your portfolios you can begin downloading the daily transaction files from which you can generate up to the day reports If you have questions about setting up your portfolios and transferring the data in your initial transaction file contact customer service for your portfolio management system SchwabLink User M anual WHAT You DOWNLOAD Schwab downloads all transactions in our ledger records that affect your client accounts The majority of transactions repre sent the following activities e Money market fund share purchases sales e Cash deposits withdrawals Securities deposits withdrawals Cash dividend positions Reinvested dividends M utual fund dividend and capital gain
30. 7 11 Save As Dialog Box 3 Click the Save button You return to the M utual Fund Template Printing a Mutual Fund Trade List Follow the steps in this procedure to print the list of mutual fund trade orders displayed in your M utual Fund Template window You can print the entire list or a range of pages 1 Click amp or select Print Report from the File menu The print dialog box appears 2 Set your print parameters then click OK The trade orders are printed as a report SchwabLink User M anual Opening a Previously Saved Mutual Fund Trade Order File You can open previously saved files to print amend or send to Schwab To open a previously saved mutual fund trade order file 1 Click the button or select O pen from the File menu The Open dialog box Figure 7 12 appears Look ir ee OSO00000 1 Cs032199 Open Files of type Mutual Fund Archive file tm Cancel Help File name Figure 7 12 Open Dialog Box 2 Select the drive directory and file type of the previously saved file 3 Select the file that you want to open The file name appears highlighted in the File name field 4 Click Open The mutual fund trade information appears in the grid 7 116 Chapter 7 Mutual Fund Trading SENDING A MUTUAL FUND TRADE LIST TO SCHWAB Before sending the mutual fund trade order list for the first time contact your Firm Security Administrator to ensure that your user ID has been acti
31. 9 135 9 135 9 136 9 136 9 136 9 138 9 138 9 138 9 138 9 139 9 139 9 139 9 139 9 140 9 140 9 141 Setting Preferences Setting Up Disbursement Accounts Specifying Account Validation Chapter 10 Upload Utility Overview Setting Preferences Adding M aster Accounts Adding a Data Folder Default Settings Editing M aster Accounts Editing Data Paths Deleting M aster Accounts Transfer Lists Editing the File Transfer List Removing a File from the Transfer List Sending the Files to Schwab M aintaining Directories Changing Archive Directories Changing Default Directories Unattended PCRA Upload Setup 9 141 9 142 9 142 10 143 10 143 10 144 10 145 10 146 10 146 10 147 10 147 10 148 10 150 10 150 10 150 10 151 10 151 10 152 10 153 Table of Contents Appendix A Transaction File Formats Overview W hat You Download Transaction File Formats Generic Transaction File Format Advent Transaction File Format Using SchwabLink with O ther Programs Additional Information Appendix B Transaction File Filter Overview Installing the Filter Launching the Filter Setting U ser Preferences O pening the User Preferences Dialog Box Selecting the File Format Choosing Directories for Filtered Files Selecting a Default Filter Combining M ultiple Transaction Files A ppending Files SchwabLink User M anual A 157 A 157 A 158 A 158 A 160 A 164 A 164 B 165 B 165 B 165 B 166 B 166 B 166 B 167 B 167 B 168
32. Allocation file to Schwab Visit the Schwab Institutional Web site www schwabinstitutional com to review the status of the uploaded Securities Allocation file 4 Store and back up Securities Allocation files according to state regulations SchwabLink archives files you send to Schwab through the Securities Allocation module Check the regulations in your state regarding storage and backup of Securities Allocation files Securities Allocation Window To open the Securities Allocation module 1 Select the Trade tab from the SchwabLink Launcher screen 2 Click the Securities Allocation icon The Securities Allocation window opens In the Schwab Trade view Figure 8 1 8 120 Chapter 8 Securities Allocation C Securities Allocation File Options Window Help i Yad J r Select Type of Trade to Allocate _ Allocation Summary __ Schwab Trade Total Shares Remaining 0 O Prime Broker Trade Total Shares Allocated 0 Total Quantity O son 2chmab Trade Detal Allocation Worksheet Inv Manager STUDEBAKER FINANCIAL FAS MASTER ACCOUNT Trade Date 03 23 1999 Master Account sole 2 zig Security Symbol LEY Security Desc LY rr Price Required Field Mote Figure 8 1 Securities Allocation Window Schwab Trade View The Inv M anager and M aster Account fields are populated with the details of the selected M aster Account If you have
33. Deleting Old Data Files All backup build and update files for each M aster Account are stored in the M aster Account folder which may eventually cause problems with storage space You can delete build files that you no longer require SchwabLink User M anual To delete old build and update files 1 From the M aster Account list select the M aster Account from which you want to delete the files 2 From the Tools menu select Delete Old Data Files The Delete Old Data Files dialog box Figure 5 31 appears Delete Old Data Files Ea Select old data files to delete For Master Account 08999999 cs 22099 BRE Delete All Figure 5 31 Delete Old Data Files Dialog Box 3 To delete an individual file select the file you want to delete and click Delete To delete contiguous files select the first file you want to delete hold down the Shift key and select the last file that you want to delete The files in between should be highlighted Click Delete To delete non contiguous files select the files you want to delete while holding down the Ctrl key When all the files you want to delete are highlighted click D elete If you want to delete all files in the list click Delete All After clicking Delete or Delete All you are returned to the Account Viewer window 5 78 Chapter5 Account Viewer Log Files for Build Update W hen Build U pdate is run a log file is created that shows the tasks that have run as part o
34. Files of type External Import file txt pri Cancel Figure 7 8 Import Dialog Box 3 From thelist of files in the window select the file that you want to import then click the Open button If errors were detected the Import File Format Errors window appears Figure 7 9 Error messages are displayed for transaction lines with format errors or invalid data If no errors were found a message appears to indicate that no format errors were detected 7 112 Chapter 7 Mutual Fund Trading ee ee Biha hora Tear legar epi P e F a T a ka lE El T ka Er e H ae a a dy OO a cir ee pe Daktu k ghh a hih D ak ia a bi h Y inhi el Ts i ee eee ee Pe Pee ee pe Bees ee Pi e Figure 7 9 Import File Format Errors Window To deactivate the files format validation see Checking File Format on Import later in this chapter 4 To print the list of error messages click Print 5 Click Close You are returned to the M utual Fund Template and the trade information is displayed as shown in Figure 7 10 SchwabLink User M anual Haha hard ephir pmi be TU eed TED iei i BHO De h fai Heia Ola al Mees Sout Hamia eee ee imper Dot a A Re Coats Tate lii Bihi d arty Z Teia Faa acd ra S ff eee E iti deiae rir briri Imie a Figure 7 10 Mutual Fund Template with Imported Files To send the file to Schwab follow the instructions in Sending a M utual Fund Trade List to Schwab on page 7
35. Filter Account List toolbar button 3 Deselect any previous selections Cm False banat Gia Pleads Disl Mia ay RL a PANT HUA BE Be EEr H ALL A EL Portfolio Variance indicator Figure C 43 Portfolio Variance Indicator Note The securities displayed are fictional and used for illustration purposes SchwabL ink User M anual C 223 Appendix C Fund Rebalancer Click the Portfolio variance above check box In the variance percent field type a numeric value In the List Update Type section click either the replace or append option 7 Click OK Selecting Accounts by Export Date The Export Date column indicates when trades were exported for each account The column is displayed on the Account List pane under the Status section To filter the Account List by Export Date Click the Account List tab in Fund R ebalancer Click the Filter Account List toolbar button Deselect any previous selections Click the Last order export before check box Click the drop down arrow on the date field Select the date from the calendar control oy eS mw NY In the List Update Type section click either the replace or append option 8 Click OK OPTIONS Restoring Screen Defaults Fund Rebalancer allows you to resize both panes and columns as well as resort data These custom settings remain in place until additional changes are made or the default settings are restored Schw
36. Filter to select a customized subset of transactions from the daily downloaded Schwab transaction file trn The filter gives you the ability to customize the daily transaction file so that it includes only those transactions from Schwab that are not included in other feeds such as cash deposits and withdrawals You implement this fea ture by using filter profiles that come with the application or by creating new ones Filter profiles contain the selection criteria used to select transaction records You can modify the profiles The filter is particularly useful if you import transaction data into a portfolio management system from sources that include duplicate information For example you may manually enter data download Schwab data use DTC and or use a trading system to input data into your portfolio system Using the filter application helps eliminate the posting of duplicate data from the Schwab file The filter can operate in two different modes manual and unattended Run It in manual mode from within the Transaction File Filter application and in unattended mode from the com mand line or a third party scheduler The procedures in this appendix show you how to e Install the SchwabLink Transaction File Filter e Launch the filter e Set up user preferences e Use predefined filter profiles e M odify and create filter profiles e Run the filter SchwabLink User M anual Installing the Filter Before you install the SchwabLi
37. Login Information e Number of days to keep the Upload Utility logs N ote Only clients of RPS who transmit PCRA Account O pening and Cashiering files have the ability to use the Unattended PCRA Upload feature that is built into the Upload Utility All other file types do not have the capability to use the unattended upload process Unattended is defined as a process initiated by a scheduled task or command requiring no intervention Contact RPS Technical Clients Services TCS for additional information In order for the Unattended PCRA Upload to work both the Unattended PCRA Archive and Upload directory as well as the Unattended PCRA Login User Id and Password fields this is the same User ID and Password for the Schwab Institutional Web site must be set W hile the directories are set for each master account the Unattended PCRA Upload Login Information applies to all listed master accounts Adding Master Accounts If a M aster Account was added in any other module within SchwabLink you do not have to repeat the steps here To add a M aster Account 1 Select Preferences from the O ptions menu The Upload Utility Preferences Window appears Figure 10 2 SchwabLink User M anual Upload Utdily Peelers E st use Fija C Dove Second Daa Foia ORN Gapond Hase ocam Unatiended PCRA iposi Logn Inioanstion Lica ID Piss pad Delak Maske Accom x Deliou File Type Kasp Li plowed likey kenge oe
38. M anual 3 From the Tools menu select Run Build U pdate The Build Update Selection dialog box Figure 5 27 appears Build Update Selection E4 Perform Build Update on the selected Master Account Perform Build Update on all Master Accounts Cancel Figure 5 27 Build Update Selection Dialog Box 4 Select the appropriate option 5 Click OK The following message Figure 5 28 appears The length of the Build Update process is dependent on the size of the daily data file It may take a significant amount of time to complete Do you wish to continue Figure 5 28 Build Update Time Message 6 Click Yes to continue Build Update begins to run and a progress bar appears on your screen similar to the one shown in Figure 5 29 311 Chapter5 Account Viewer Build Update for Master Account 08999999 Processing Transaction file cs122999_trn Figure 5 29 Build Update Progress Bar W hen Build Update is complete the following message appears Figure 5 30 Build Update success Q Build Update was successful Figure 5 30 Build Update Complete Message 7 Click OK You return to Account Viewer The files are updated N ote During the Build U pdate process the file extension is changed for build files and update files Build files change from the extension bld to okb and update files change from upd to oku These files will remain in the relevant M aster Account folder until deleted
39. N umber is 08000000 The file is archived as C 08000000 CS050100 T M 0 The second trade file you send that day is C 08000000 CS050100 TM 1 M utual Fund Trading archives these files to a M aster Account subdirectory created from the root directory of the archive drive Typically the default archive drive is C If the system cannot create a subdirectory from the root directory of the archive drive you can select an alternate archive drive 1 From the File menu select Archive File Path The Archive Dialog box appears Figure 7 15 Archive Dialog E4 Select the drive where pou Will archive pour files CHT Cancel Figure 7 13 Archive Dialog Box 2 Select an alternate drive and click OK You return to the M utual Fund Template window Future files are archived automatically to this directory after they are sent to Schwab SchwabLink U ser M anual SETTING PREFERENCES Use M utual Fund Trading preferences to e Set up a M aster Account see Chapter 2 Getting Started e Select a fund instruction default e Automatically check for duplicate trades e Show or hide titles in the M utual Fund Template window grid e Check file format in imported files From the Options menu select Preferences The M utual Fund Trading Preferences dialog box appears Figure 7 14 Maubial Fis Iradi Pieherences asi Recon Deb UI atte Lata kPa Filed chreratiLonk L Cane Das C Poogeam Files S cheabLink
40. OK The dialog box disappears and the name of the selected directory appears in the Append all the resulting filtered files together to create one large TRN field 7 Click OK USING FILTER PROFILES A filter profile contains all the criteria necessary to select a trans action file Profiles are used to select data from the downloaded files to eliminate transactions that would duplicate data received from other sources and to select specific transactions A filter profile does not exclude data from your trn file but rather sorts through the downloaded data and extracts files based on user selected criteria B 168 Appendix B Transaction File Filter The logic in a profile specifies which transactions are included in the resulting filtered transaction file Only those transactions meeting the criteria are included in the resulting filtered files The profiles allow you to include common types of transactions There are three types of filter profiles e Predefined filter profiles e M odified existing profiles e New custom profiles This main section contains subsections on using predefined filter profiles modifying existing profiles and creating new custom profiles Using Predefined Filter Profiles Included in the SL Filter software are several predefined profiles designed to meet the needs of most users You can also use these predefined profiles as a template to create other profiles Users fall into two gene
41. SOURCE DEST field displays the symbol mxmx which in this example is the code that describes the client s money market account The funds to pay for the trade are immediately debited from the mxmx account In contrast if clearing through a cash account SchwabLink transmits the following transaction on the initial trade date Now editing TABLE BLOTTER PORT TC DATE TY SECURITY DOLLAR SOURCE QTY BROKER COMMISS CODE SYMBOL AMT DEST CODE AMT Jones by 032290 cs icm 5049 00 cash 45 00 schwab 49 00 On settlement date the following transaction Is transmitted PORT TC DATE TY SECURITY DOLLAR SOURCE QTY BROKER COMMISS CODE SYMBOL AMT DEST CODE AMT Jones wd 03 ca mXmx 5049 00 cash SchwabLink User M anual Data Elements of the Advent Transaction File Data elements in the Advent transaction file include e Account number This is your client s 8 digit Schwab account number To translate this number to your designated portfolio code see the user manual for your portfolio management system Transaction code This will be one of the fourteen accept able portfolio management operations transaction codes by dv al XX sl in rc XC dp SS ac wd CS Schwab does not use the Advent pv Present Value code Transaction date This date is the actual activity date that the transaction occurred trade date or ex dividend date not the date that the transaction was posted in the client s Schwab account Example A
42. To print a Trade Confirmations List or Trade Confirmations Query Results List 1 Makesure that the list you want to print is active To print the entire list go to step 3 To print selected records go to step 2 2 Select records to print using one of the following procedures e To select contiguous records use the up or down cursor keys on the keyboard while holding down the Shift key e To select non contiguous records click on Individual lines while holding down the Ctrl key 3 Click the Print button on the toolbar or select Print from the File menu The Print Records dialog box Figure 5 23 appears Print Arenorda EJ Pont Selected Record s C Pari All Phases Figure 5 23 Print Records Dialog Box 4 Select whether you want to print selected record s or all records 5 Click Print The Print dialog box appears 5 72 Chapter5 Account Viewer 6 Set appropriate print parameters and click OK SchwabLink prints the appropriate records from the active Trade Confirmations List or Trade Confirmations Query R esults List Using the Purge Function When you add a file of confirmations to the Trade Confirmations List SchwabLink combines the new confirmations with those already added Over time your summary list may become too large or contain information you no longer need Use the SchwabLink purge function to delete confirmations from the dis play in your summary list automatically after a number
43. Utility allows you to indicate the folder location your download files will reside on your computer s hard drive or network drive After files have downloaded the Download Utility s Processed File List window displays the list of files that were downloaded It also lists the directories to which they were copied N ote The Download Utility module must be installed on each workstation that you will use for downloading files from the Schwab Institutional Web site You must designate a separate directory for each M aster Account number that receives down loaded files Existing SchwabLink for Windows users already have separate directories for each M aster Account H owever you should verify the setup of these directories before installing the Download Utility Launching Download Utility A successful installation of the software automatically will add the Download Utility icon to the SchwabLink Launcher screen if you accept the default checked box Once installed the Download Utility launches when one or more files are downloaded from the Schwab Institutional Web site To exit the application click the X in the top right corner of the application window or select Exit from the File menu To launch the application and manually execute the download 1 Locate the SchwabLink icon on your desktop Double click the icon to launch it Select the Utilities tab Click the Download Utility icon From the File menu select Download All N ew File
44. Viewer to e Set up a M aster Account see Chapter 2 Getting Started e Select the data type of the files you work with for each M aster Account Specify whether to include cash in positions for each M aster Account Specify whether to use a four digit year for reconcile files Specify preferences for the Build Update function for each M aster Account Specify whether to include master account information in printouts Specify whether to include column headers in export files SchwabLink User M anual e Specify how long transaction and confirmation record details should be retained for each M aster Account e Specify whether to rebuild the consolidated portfolios for Fund Rebalancer From the Options menu select Preferences The Account Viewer Preferences dialog box Figure 5 41 appears Select the M aster Account for which you will be setting preferences ficcoont eee Poolhmences Metis secu Jenee Dini Progen Far Car D Dash o Brochan Tms i Tani Compare F hri Carh n Porem Feno Fh a ee a E Eii Phn Aaoi Ya o L D biri birba 4 tae Seed Cacho Paco D miih Dipi ionga lindane Woes fe Bich ied E beech ae Heke Sate beatae ce Pod pty F hri Liom Haarr m Expert Ge Trazia Conirmaion racord terion pared fiaa a beth ae Fesp Siiri i e Bak hie pene Fe Fomr adeno F Tee Fe Tada rimer Figure 5 41 Account Viewer Preferences Dialog Box 5 88 Chapter5 Account Viewer Selecting the File Data Typ
45. a ot bihi EH KHA BETHET EF kii T EEEL iy Dab ehm kaiii oe eee g l haa N biii argi arii Pih bib duir Fi C Eecher sever eee dale aes fore bbe E lap ere r ered pee ha eer od Lh Primed Ries th deihi pihhh TBs os a Seca WTAE es ln once ee Be m e a Pee Uei berilmu Be ae f bai Figure C 35 Asset Exclusion Examples 5 Click the Update button at the bottom of the screen The account will display an X in the last column on the Accounts with M odels tab In Fund Rebalancer the fund will display with an X to the left of the symbol The line also appears in a lighter shade Note The securities displayed are fictional and used for illustration purposes SchwabLink User M anual Fund Exclusions Excluding Mutual Funds in the Margin Account In some situations you may want to exclude all mutual funds held in the margin account To exclude all mutual funds in the margin account from rebalancing 1 Click the M odel Assignment Screen toolbar button EF 2 Click the Accounts with M odels tab 3 Click the account for which you wish to set the exclusion 4 On the Account Exclusions tab click the checkbox labeled Exclude all fund positions in the margin account 5 Click the Update button at the bottom of the screen C 212 Appendix C Fund Rebalancer The account will display an X in the last column on the Accounts with M odels tab Any mutual funds held in the margin
46. a m and 6 00 p m Eastern Time M onday through Friday SchwabLink User M anual e For investment advisors call 1 800 647 LINK 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 Option 2 or e mail rps techserv schwab com N ote The Schwab Institutional Web site requires users to change their password immediately after their first successful logon to the site If you are logging on to the Web site for the first time log on to www schwabinstitutional com manually using your user ID and temporary password You will be required to reset your password before running the Download All N ew Files function of the Download Utility Configuration The Download All N ew Files feature of the Download Utility is designed to support various ways to connect to the Web site including dial up networking Prior to your first download you will need to setup Destination Directories See M aintaining File Directories on page 4 33 N ote You must test your dial up networking at least once before using Download All N ew Files Verify that you are able to connect to your ISP Operations The Download All N ew Files function of the Download Utility does not automatically log you off your ISP connection at the end of the file download In order to avoid unexpected charges you should verify whether your ISP automatically logs off inactive sessions after a pre specified number of minutes This functio
47. account are removed from the Asset Exclusion table unless the fund is part of a split position In Fund Rebalancer the excluded fund s will not display on the Actual Portfolio tab The funds value will be reflected in the Other Assets total FILTERING ACCOUNTS The Filter Accounts List function provides an easy means to find accounts meeting specific criteria For example you could filter the account list to display only accounts with Account Exclusions The function also allows filtering by multiple selection criteria such as model portfolio and account exclusions The filtering process is similar between the account lists however there are some subtle differences On the Account without M odels tab the selection criteria appear to the right of the M aster Account list box On the Accounts with M odels tab the selection criteria remain in full display at the bottom of the list Click on Filter Account List in the Accounts menu to toggle the selection criteria on and off You may also use the wildcard when filtering on account numbers or account names SchwabLink User M anual Filtering by Account Number To filter either account list for account numbers 1 Click the M odel Assignment Screen toolbar button esl 2 Click either the Accounts with M odels tab or the Accounts without M odels tab Click the Filter Account List toolbar button A l In the selection criteria area click the Account N umber check
48. accounts related to a Master Account number Use this feature to review a list of clients quickly Includes address biographical data and handling instructions for each client account SchwabLink User M anual Client Account Positions A summary list of position information for each security held in one client s account Includes cash and margin account balances for each client account Security List A summary list of all securities held in all client accounts within one Master Account with pricing information Composite Security A detailed list of all security positions held by all client Positions accounts in one Master Account grouped by security type Includes market value of each position Security Cross Reference Lists of client accounts that hold a specific security Transactions List Next day access to a selected Master Account s transac tions such as buys sells dividends and cash transfers Deposit Withdrawal A summary of all cash deposit and withdrawal transactions from the Transactions List Trade Confirmations List A list of trade execution information for all trades you placed through Schwab Detailed information on each trade listed in the Trade Confirmations List Trade Confirmation Detail VIEWER INFORMATION SUMMARY AND LINKS The following table summarizes viewer information The Links With column tells you which viewer you can access by double clicking on a record in the viewer named in the
49. and used for REPORTS illustration purposes OVERVIEW Each of the three programs Includes a series of built in reports that are displayed from the Print toolbar menu These report modules allow for additional selections that can be customized such as account range asset type etc The report module allows you to preview print or save any report N ote Since Fund Rebalancer is designed to clear order data whenever a session is either closed or initiated we strongly recommend that you either print or save your reports prior to exporting your files SchwabLink User M anual C 226 Appendix C Fund Rebalancer Saving Reports Fund Rebalancer comes with a defined file format QRP This format allows you to view a saved report within each of the three applications To print a report to a file 1 Click the Printer toolbar button amp l 2 Choose your report settings 3 Click the Preview button 4 Click the Save R eport toolbar button The Save report dialog will open In the File N ame box type a name for the report Click the Save button 7 Click the Close toolbar button D U Viewing Saved Reports The report module allows you to view saved reports with a QRP file extension To view a saved report 1 On the Fund Rebalancer toolbar click the Printer toolbar button amp 2 Select Saved Report Viewer On the printer toolbar click the Load Report toolbar button Double click the document you want to open
50. assignment i 1 Click the M odel Assignment Screen toolbar button Td 2 Click the Accounts with M odels tab 3 Click the account you wish to unlink 4 Click the Unlink Accounts from M odel toolbar button a Showing All Accounts The Show All Accounts feature displays all accounts represented on one of the two account list tabs in the M odel Assignment program It does not represent a list of all accounts assigned to a M aster account To display the full account list 1 Click the M odel Assignment Screen toolbar button 2 Click either the Accounts with M odels tab or the Accounts without M odels tab 3 From the Accounts menu select Show All Accounts C 208 Appendix C Fund Rebalancer Sorting Columns M ost tables displayed in M odel Assignment may be sorted by the column heading These include Account Description M odel N ame and M odel Description The one exception is data displayed on the Asset Exclusions table To sort column data 1 Click the M odel Assignment Screen toolbar button 2 Click on the desired tab 3 Click the column heading on the column you d like to sort The column resorts and a small arrow to the right of the column header indicates the sort order ACCOUNT EXCLUSIONS Understanding Account Exclusions Account exclusions are optional settings that represent any asset you wish to exclude from the rebalancing process T hese assets may include cash mutual funds or both All
51. available in Account Viewer Before you run Build Update you must set appropriate prefer ences See Specifying Preferences for Build Update on page 5 89 To run Build Update manually see Running Build Update on page 5 77 To run Build Update automatically as part of your daily downloads routine see M odifying the Completion Task in Chapter 4 Download Utility CLIENT INFORMATION VIEWER The Client Information viewer Figure 5 3 is divided into two sections The lower half of the viewer displays a list of all client accounts within the selected M aster Account To display infor mation for a specific account highlight click on the account in the lower account grid The upper section of the screen displays information for that account In addition to clicking on the Client Info button in the toolbar you can display this viewer by clicking on a M aster Account in the M aster Accounts list The selected M aster Account is shown in the title bar Client Information 08000000 SchwabLink User M anual Client Information 08000000 Updated 03 01 1999 Social Security H Opened 000 1 2 3456 1002 1989 Home Phone H Business Phone 000 000 0000 Feode 4923 Branch ID SBN FRANCISCO Securities Proceeds Dividend DYP COD OYP COD DYP ICOD STUDEBAKER FINANCIAL FAS MASTER ACCOUNT 234 HOOD LANE Ml 12345 Cash Instructions Margin Instructions Fund Selection Account Rest
52. box is displayed Figure 4 3 Figure 4 3 Add Destination window ii Enter the new M aster Account number This should be a numeric eight digit number with no punctuation For Broker Dealer M aster Accounts there should be one leading zero For example 08123456 For Charles Schwab Trust Company M aster Accounts which are 3 digits there should be at least 5 leading zeroes For example 00000999 You may enter a description for the master account This field is optional SchwabLink User M anual 4 34 Chapter IV o oO C 4 Download Utility Select the drive using the drop down box below the Destination directory area This drop down box displays the other drives that are accessible by your workstation Highlight and double click on the directory name to open it To create a new directory Double click on the folder in which you want to create the new directory and click N ew Folder The Create N ew Folder window appears The base folder that the new directory is added to is displayed at the top N ote Directories M UST exist before they can be assigned Enter the name of the new folder Click OK to add the folder or click Cancel to exit the window without adding the new folder Click OK to add the new destination directory to the Download Utility Destination M ap N ote M aster Accounts may not share a directory B To change the M aster Account number or Description for an existing e
53. cay oe om Figure 10 2 Upload Utility Preferences Window 2 Click the Add button or press ALT A The Add M aster Account dialog box appears Figure 10 3 10 144 Chapter 10 Upload Utility Add Master Account Master Account Descriptions Destination fe CA gt Program Files SchwabLink Desktop Upload Utility E C LOCAL ha Selected Destination CAS chwabLink Desktop Upload Utility New Folder Cancel Figure 10 3 Add Master Account Window 3 Typein the new M aster Account number and Description in the appropriate text boxes 4 Inthe Destination section double click on the folder that contains your M aster Account data If the directory does not exist see the next section Adding a Data Folder SchwabLink User M anual 5 Click OK The new M aster Account number description and data path are added to the Upload Utility Preferences grid 6 Click OK to return to the Upload Utility main menu Adding a Data Folder To add a data folder In the Destination area of the Add M aster Account window navigate to the base folder that you want to add the new folder to as a sub directory for instance 1 Click the New Folder button on the Add M aster Account dialog The Create N ew Folder dialog box Figure 10 4 appears Create New Folder x Base Folder C Data m Figure 10 4 Create New Folder Dialog Box 2 Enter the new folder name 3 Click O
54. contents for 10018632 Order List T his section shows orders that must execute to meet your projected portfolio The chart section displays a bar for each order The charts display sell transactions as negative numbers and buy transaction as positive numbers N ote The fund color legend may not match the colors from the Actual Portfolio tab SchwabL ink User M anual Sample Data Buy Orders gt Figure C 17 Order List tab contents for 10018632 To clear the Order List 1 Click the Undo Orders toolbar button l The Order List and Projected Portfolio tabs are cleared but any account exclusions or cash management options remain intact Projected Portfolio This tab s information is similar to the Actual Portfolio tab with the addition of exclusion symbols and two column sections Orders and Projected The Orders section estimates the dollar value of the order Sell transactions are repre sented as negative red values and buy transactions as positive blue values The Projected section indicates each position s dollar value and what percentage of the portfolio it represents Note The securities displayed are fictional and used for illustration purposes C 195 Appendix C Fund Rebalancer The Difference section represents the difference between the Target M odel portfolio and the Projected portfolio This section is extremely useful when using the High Low rebalancing method When reviewing orders you
55. day s will be deleted because the logs are more than two days old One 1 day is the default 10 155 Chapter 10 Upload Utility Upload Utility Confirmation Log The Upload Utility automatically generates a confirmation log of Uploaded files to the Schwab Institutional Web site This log can be viewed by using any text editor program O pening the sendtoschwab log file 1 Open Notepad 2 Select Open from the File menu 3 Navigate to the directory of C program files schw ablink desktop logs 4 Find the most recent SendtoSchwab log file N ote The actual name of the log will contain a time and date stamp 5 Select the log file to open Click Open File Count The gray box in the lower right corner shows the number of files in the grid not yet uploaded If you have any questions please contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time e For investment advisors call 1 800 647 LIN K 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 Option 2 or email rps techserv schwab com SchwabLink User M anual 0901 03199 10 156 Appendix A Transaction File Formats OVERVIEW The first time you perform the Download Utility operation the initial transaction file is the first file you receive as part of the download The initial transaction file sets up security positions and balances within your portfolios All you have to do is post
56. displays e Trade Type e Symbol e Description e Price e Operation e Quantity e Cost e Proceeds To print all orders all orders within an account range 1 On the Fund Rebalancer toolbar click the Printer toolbar button Be 2 Select Trade Orders By Account 3 Inthe Account Selection area select Account Range SchwabLink User M anual 4 Typein numeric values in both the From Number and To N umber 5 Inthe Order Selection area select Show all Trade orders 6 Click the Print button N ote If you used custom account numbers that are alphanumeric they will not show using the account range option You must use All Accounts Exported Orders for the Current Session You may view a report containing all session orders for a M aster Account including exported orders for an account range For each account with an order the report displays e Trade Type e Symbol e Description e Price e Operation e Quantity e Cost e Proceeds To print a listing of exported orders 1 On the Fund Rebalancer toolbar click the Printer toolbar button Select Trade Orders By Account In the Account Selection area select Account Range Type in numeric values in both the From Number and To N umber C 228 Appendix C Fund Rebalancer 5 Inthe Order Selection area select Show only trade orders exported to M utual Fund Trading 6 Click the Print button Excluded Orders An excluded order is any order that wasn t generated be
57. distributions Trade related activity Equities Mutual funds Fixed income Certificates of deposit Options The remaining data consists of transactions for reorganization and other corporate actions You may also see transactions that are uncoded Please contact your Institutional Service Group between 8 00 a m and 8 00 p m Eastern Time M onday through Friday to clarify these entries The key to SchwabLink focuses on Schwab s ability to convert its daily ledger records into a data format that your portfolio management system can use After each Schwab ledger record is converted SchwabLink downloads the converted records in a trade blotter formatted file A 157 Appendix A Transaction File Formats TRANSACTION FILE FORMATS The transaction file structure is in ASCII text format Two trans action file formats are available for your use the generic file and the Advent file The generic file is compatible with most portfolio management programs At the time you subscribe to SchwabLink you select which file format best meets your needs The Advent file is compatible with all Advent software portfolio management software programs including T he Professional Portfolio Axys Advantage and Axys Generic Transaction File Format The generic transaction file consists of up to twelve data elements and has a fixed length of 104 characters The data elements appear as follows All numeric fields are right ju
58. dividend was paid by a mutual fund company on February 27 but was not posted to the client s Schwab account until M arch 5 Therefore the transaction date is 0227Y Y However please note that this transaction will be downloaded as part of the M arch 5 transaction file Because Schwab does not credit client accounts until it receives payment from the appropriate source there may be a delay of several days before a transaction appears in the client account If a performance report is run the day after month end the numbers may not match the Schwab monthly statement because the transactions are yet to be posted Schwab s policy is to pay all distributions within a five day window of the actual payable date SchwabLink s use of the actual pay date is consistent with accrual accounting procedures A 161 Appendix A Transaction File Formats where applicable are carried out to three decimal places Fractional shares of mutual funds are rounded to the nearest thousandth 0011 to 0014 Is rounded down to 001 0015 to 0019 is rounded up to 002 The method of rounding excess digits is consistent with the Schwab system Broker code Where applicable the broker code is trans mitted as schwab If the trade was done with another broker Prime Broker trade that broker s code will be shown The broker code must be defined in the Security Information File of your portfolio management system e Security type Security types fo
59. dollar totals can be tracked These records are iden tical to ones that can be found in the Transactions List Viewer To open the Deposit W ithdrawal List Viewer make sure the cor rect M aster Account is selected in the SchwabLink Account SchwabLink User M anual Viewer window and click the Deposit W ithdrawal button The D eposit W ithdrawal List viewer Figure 5 19 appears HLE ET j a ee ee E Figure 5 19 The Deposit Withdrawal List Viewer FIELDS AND COLUMNS IN THE DEPOSIT WITHDRAWAL VIEWER An asterisk indicates total amounts that will change when files are added to or removed from the viewer list N ote Although you can customize certain fields and columns such as Account N umber in other viewers the customized values for those same fields and columns do not show up in the Transactions List D eposit W ithdrawal List Trade Confirmations List or Trade Confirmations Detail viewers The fields in these viewers revert to Schwab assigned values 5 64 Chapter 5 FIELD COLUMN Account Number Sub Account Name Transaction Date Account Viewer DESCRIPTION Your client s 8 digit Schwab account number Account name as registered with Schwab The actual activity date on which the transaction occurred Type Account Type Designates a deposit or withdrawal transaction D Deposit W Withdrawal The account from or to which funds are being transferred This field can contain the foll
60. is taken the transfer is purged after seven days Request Reject The delivering firm rejects a transfer because of a 24 Hour Pend reject If the receiving firm adjusts the transfer within 24 hours the status changes to Request Adjust If no adjustment is made the transfer is purged 24 Hour Pend Rejects include SSN Tax ID mismatch Account title mismatch Additional documentation required Delivering account is flat and Invalid account number Request The receiving firm transmits the transfer form to the NSCC Set For ACAT transfers only assets are in the process of being settled The transfer status remains SET for 2 business days until the assets are actually received into the Schwab account 6 102 Chapter 7 Mutual Fund Trading OVERVIEW The SchwabLink M utual Fund Trading module enables you to create mutual fund trade orders and transfer them to Schwab electronically You can create trade orders directly in the M utual Fund Template and send them to Schwab You can also create orders in a spread sheet or portfolio management program and import them into the M utual Fund Template where you transmit them to Schwab This chapter shows you how to e Create edit and remove single and multiple trade orders e Select accounts for duplicating trades e Create duplicate edit and remove linked trade orders e Format trading files created in another application and import them to the M utual Fund Trading module e Print
61. like to save the current file Figure 7 2 File New Information Dialog Box WORKING WITH DATA IN THE MUTUAL FUND TEMPLATE The procedures in this section show you how to e Create edit and delete single trade orders e Create edit and delete linked trade orders e Create multiple trade orders e Save and print a mutual fund trade order list Single Trade Orders A single trade order consists of one buy or one sell transaction Creating a Single Trade Order To create a single trade order 1 Inthe M utual Fund Template window select the M aster Account to which the trades apply by clicking the scroll arrow next to the M aster Account Number field and select ing from the drop down list 2 From the drop down lists in the Select by Account N umber or Name fields select the client account number or name for which you want to place the trade order The corresponding field populates 7 104 Chapter 7 Mutual Fund Trading In the Action field select the type of transaction from the drop down list Buy buy dollars The actual purchase amount will be less than the quantity entered by the amount of the commission Buy Comm buy dollars plus commission The commission is charged in addition to the purchase amount entered Sell Shares Sell Sell All Sell sell dollars The commission is deducted after the amount entered is sold Sell Comm sell dollars plus commission The amount of the sale is increased
62. moor f aE eee LIS Hi ae id D do ULIH GLU TEAR i E Pao i TOE Sc FTE ia LHE FG Pats Td re Ts io D do Ree DE RSLLT PEF I di TEJ ries Sa Ti Si LPA FLEE MI E EH LEE ILA ria TOE 20 LPL SL eA E of TEA rio i TOE i Notice there is no difference between the Projected portfolio and Target Model portfolio in either the table or graph area Figure C 37 Projected Portfolio using Strict Rebalancing Method Note The securities displayed are fictional and used for illustration purposes SchwabLink User M anual C 216 Appendix C Fund Rebalancer Pee oe Frei Urh a aapka BLU TAT Cae ee A CERT ape Slate Mmj Sini aye ey Using the High Low rebalancing method notice how the Difference section iS populated Figure C 38 Projected Portfolio using High Low Rebalancing Method Note The securities displayed are fictional and used for illustration purposes SchwabL ink User M anual C 217 Appendix C Fund Rebalancer Comparison Example of Rebalancing Methods Let s compare the Strict and High Low rebalancing methods on a sample account Both the Current Allocation and the M odel Allocation share two fund positions FUNDC and FUNDB Current Allocation Asset FUNDA FUNDB FUNDC Cash FUNDD FUNDE M odel Allocation Asset FUNDC NEWF1 NEWF2 FUNDB SchwabLink U
63. non mutual fund assets are automatically excluded from the rebalancing process These exclusions are linked to the account s model assignment Accounts without model assignments do not have any Account Exclusions and the tab is dimmed The M odel Assignment program automatically determines which funds are eligible for exclusion by comparing the account s current portfolio to the model portfolio Any mutual fund presently held but not included in the model portfolio will appear in the Asset Exclusion table These funds will be sold unless excluded SchwabLink User M anual With the exception of split mutual fund positions the same fund resides both in the cash and margin account asset exclusions apply to the whole fund position It is not possible to exclude a specific number of shares Setting Cash Exclusions Entire Cash Position It s possible to exclude an entire cash position from rebalancing In effect this prevents cash funds from being used to purchase additional mutual funds Accompanying sell transactions must fund any purchases This option should not be used on accounts that are 100 cash To exclude the entire cash position 1 Click the M odel Assignment Screen toolbar button 2 Click the Accounts with M odels tab 3 Select the account you wish to exclude cash from 4 On the Account Exclusions tab select the Exclude entire cash position radio button 5 Click the Update button at the bottom of th
64. not want to save the profile The SL Filter window reappears The addition of a new profile is complete Click the Setup Filter icon to view the Profiles list The new profile is added to the pro files list along with its description Filtering on Comment Lines You can filter on comment lines For example you may want to select transactions that have the words cash in lieu in the Comment field 1 In the Filter Builder dialog box click the Edit button The SL Filter Criteria box appears Figure B 14 SchwabLink User M anual 2 Select Comment from the Field N ame list The operator Like automatically appears in the O perator name list Like and Not Like are the only choices 3 Typein the comment or a portion of it in the Value field SL Fitter Creterca z i E i m l i iji J OF C Figure B 14 Filtering on Comment Lines 4 Click OK The new selection criterion appears at the bottom of all other criteria 5 Click the Close button You return to the Setup Filter dialog box If you have unsaved changes you are prompted to save Deleting a Profile To delete a profile 1 Click the Setup Filter button to view the profiles list in the Setup Filter box 2 Highlight the profile you want to delete by clicking to the left of the name 3 Click the Delete button SL Filter asks you to confirm the deletion If you click Yes the profile is deleted its nam
65. now ready to send your trade orders to Schwab If you exit the M utual Fund Trading module before sending your orders you will need to save them manually See Saving a M utual Fund Trade List on page 7 115 Editing a Single Trade Order To edit a single trade order l In the M utual Fund Template grid select highlight by clicking on the trade order that you want to edit The trade order information appears in the Enter Edit Trade area of the window M ake the necessary changes to the fields then click the Add Update button The changes appear in the grid 7 105 Chapter 7 Mutual Fund Trading Deleting a Single Trade Order To delete a single trade order 1 Select the trade order that you want to remove from the grid The order is highlighted 2 Click the Delete button A message appears asking whether you want to delete the trade order 3 Click Yes The trade order is deleted from the grid Selecting Accounts to Duplicate a Trade Order You may be entering multiple trade orders that are the same or very similar for multiple accounts For example you may be selling shares in the same mutual fund for several clients with the same numbers of shares for each client The M utual Fund Trading module enables you to create multiple trade orders without having to re enter all the same data You can use the Security Cross Reference Viewer in Account Viewer to report the accounts that hold positions in a spe
66. numbers with up to 2 actin FY decimal places i ca ee lt 4 Price Takes numbers with up to 4 decimal places ase Riis e O ther Description A notes field for adding miscellaneous Interest M OherFes o information Enter up to 24 characters ce DC pieve o oo 6 Edit the fields as necessary Required Field Go to Adding Information to the Allocation Worksheet on the next page to allocate the trade Figure 8 3 PB Trade Detail II Page SchwabLink User M anual 8 124 Chapter 8 Securities Allocation Completing the Allocation Worksheet Use the Allocation Worksheet to distribute the Schwab or Prime Broker block trade among client accounts On this screen you indicate how many shares are bought or sold by each client Adding Information to the Allocation Worksheet To add information to the Allocation Worksheet 1 Click the Allocation Worksheet tab or select Allocation Worksheet from the Window menu Figure 8 4 shows the Allocation Worksheet in the Schwab Trade view The worksheet is the same for the Prime Broker Trade view C Securities Allocation File Options Window Help iar Yad J Select Type of Trade to Allocate AAAAA_ _ r Allocation Summan ADD Schwab Trade Total Shares Remaining 500 O Prime Broker Trade Total Shares Allocated 4500 Total Quantity 5000 Schwab Trade Detail Allocation Worksheet Enter Edit Allocation Account Humber Account Mame Client
67. of status report from the drop down list 6 93 Chapter 6 Status Reports The following is a list of each file type and its matching report FILE EXTENSION DESCRIPTION TXT May be any one of the reports below saved as a text file Can be opened in Status Reports DEP Deposits and Withdrawals report EVT Event Notifications report TOA TOA Transfer of Account Status report TOC TOA Complete report CON Confirmation Summary report x All files The files are named in CSM M DDY Y ext format For example the file name of the Deposit and Withdrawal report for April 28 2000 is cs042800 dep 4 Click the file icon for the file that you want to open The file name appears in the File name field 5 Click Open The Status Reports window with the file you selected is displayed in the report viewer The file name is listed on the title bar SchwabLink User M anual Saving a Report In addition to storing reports in the M aster Account folder you can save a report to a diskette on your floppy A or B drive or to another drive to a different directory or to a different file To save the report to another location 1 Display the report in the Status Reports window 2 Click the ba button or select Save As from the File menu The Save As dialog box Figure 6 4 appears Save Deposits amp Withdrawals 06 12 1998 As csQ61298 DEP Save Save as type Text Files TAT Cancel Figure 6 4
68. serves no other use Contact the Schwab trading desk for the security description that matches the number Schwab security numbers are currently assigned to Certificate of Deposit transactions The net dollar amount of the transaction This amount is the net cost or net proceeds as displayed on an individual confirmation Slip or on your electronic confirmation The account from or to which funds are being transferred This field can contain any of the following types cash Cash account margin Margin account client Client fees and charges SchwabLink User M anual Quantity Commission Amount Unit Cost short Records all short term capital gain investments long Records all long term capital gain investments dvwash Provides wash treatment Records all mutual fund dividend investments dvshort For short term dividends dvlong Records all mutual fund long term capital gain reinvestments Same treatment as dvwash calong Records all mutual fund long term capital gain distributions paid in cash cashort Records all mutual fund short term capital gain distributions paid in cash xxlong Records all non reinvested long term capital gain dividends to an account such as client Note that if your portfolio management or operations software offers this account type you can substitute any two characters for xx xxshort Records all non reinvested short term capital gain dividends to an account such as client Note that if
69. should review the information in all three tabs including the chart option The Chart feature is avail able from the Options menu or toolbar If after reviewing the orders you decide to make any changes you must undo the entire order list modify the parameters for one or more accounts and then regenerate the orders ep cE SELT ee E E era hea Bam oo e Eey mal r ge E e fare eian I testes niet Errai Hiii biy DELAD b Elri Ta EFE LEPE me H s Ein i Ip T pi i On Pile LL ie oll cu Pes ee ace Bla di FTE a a rE Ti 1 ip E p B gi HHFA Ei HF o od ca Pe ee Ace Sle o of et Sie a LELE TEE Em rr TIR e m a gE LFLT TATE tAE G o ol ea Pes ee A Sie Oo of Sample Cate Figure C 18 Projected Portfolio tab contents for 10018632 Note The securities displayed are fictional and used for illustration purposes SchwabLink User M anual C 196 Appendix C Fund Rebalancer Step 8 Approving Accounts for Order Export Aya This is the final step before exporting a trade file This process initially marks every account on the Selected Accounts List for approval however an account may be deselected after approval To mark all accounts for approval 1 Click the Approve Orders for Export toolbar button _ All the accounts are marked as approved and a red checkmark appears in the Orders column on the Selected Accounts list a gel eo el ct Eclat aa ti I u jf E pg Bas RUHI E di i ii Be Pos i
70. the total number of records on that list are shown in the bottom left hand corner of the viewer For example 12 of 154 SchwabLink User M anual ACCOUNT VIEWER FEATURES Follow the procedures in this section to e Run Build Update e Delete old Build Update files e Use the Find command e Change column order Adjust column width Sort data in grids tables Export data Customize the Account Viewer window e Customize account and securities data Build Update The Build U pdate process updates the database tables with the most recent Build U pdate files These tables provide the informa tion that appears in your Account Viewer windows Each day after the daily download is completed you should run Build Update to make sure the most recent data is available in Account Viewer The daily download inserts build bld update upd and or confirmation cnf and transaction trn files in the appropriate M aster Account folder as specified in the Account Viewer Preferences dialog box These files will generally reflect the activity that was executed through SchwabLink on the previous business day When Build U pdate is run it searches for the most recent build file for the M aster Account s and then the consecutive update files for all the business days since that build file was created 5 76 Chapter5 Account Viewer The program can recognize weekends and holidays and calculate the next working day accordingly If the
71. to cover the commission You cannot execute a Sell or a Sell Comm trade order on funds that involve any of the following factors e Contingent redemption fees e Mixed positions that include both NTF and non NTF holdings e Short term redemption fees e Linked trades If you select a sell option other than Sell or Sell Comm the Swap field is enabled This field is not relevant for single trades Complete the Quantity field according to the type of transac tion action you selected e Buy Buy Comm Buy Commission Sell or Sell Comm Sell Commission Enter the dollar amount of the trade e Sell Shares Enter the number of shares being sold SchwabLink User M anual e Sell Enter the percentage of the fund you are selling You cannot enter less than a whole percentage point or more than 100 e Sell All The Quantity field is populated with 100 In the Symbol field enter the five character fund symbol or select from the drop down list If you select a fund that is already in your database the fund name appears in the Fund N ame field If you are entering a buy order select the appropriate fund instruction To set up a fund instruction default see Selecting the Fund Instruction Default on page 7 119 Click the Add Update button The trade order details appear in the grid in the lower half of the template Repeat steps 1 7 for each mutual fund trade order for each client You are
72. viewer e Record navigation buttons e Record navigation functions in the Window menu e Find command see Using the Find Command on page 5 81 e Scroll bars e Query function to find groups of records with common criteria See Using the Query Command for Confirmations on page 5 70 Adding the Previous Day s Confirmations If you do not specify confirmations as part of the Build Update process you can use the File menu to add the previous day s confirmations SchwabLink sends confirmation files with the prefix cs followed by the execution date of the trades whose confirmations are in the file CSM M DDYY cnf The file type is cnf for confirmation To add the previous day s confirmations 1 From the File menu select Confirmation File then select Add The Add Confirmations File s dialog box appears 2 Locate and select the name of the confirmation file you want to add to the Trade Confirmations List The file name appears in the File N ame field You can select more than one file using standard Windows Ctrl and Shift click functionality SchwabLink User M anual 3 Click Open SchwabLink checks the records in the file s you selected against the records already on the list Duplicates will not be added to the list The confirmations are added to the Trade Confirmations List For each record the Confirm ID column displays the file from which each confirmation was added plus the confirmation
73. you want to import 5 Select the file The file name appears highlighted in the File name field 6 Click Open The details and Allocation Worksheet tabs should populate with the information from your spreadsheet and the window should show the appropriate view Schwab Trade or Prime Broker Schwab Trade File Format Header Format OFFSET WIDTH 1 2 2 3 10 8 11 18 8 19 21 3 CONTENT Record type Transmission Date Send Master Account Action EXAMPLE EH Header 19940317 08000000 B Buy BCC Buy Call Close BCO Buy Call Open BPO Buy Put Open BPC Buy Put Close 8 129 Chapter 8 Securities Allocation Header Format Continued Trailer Format OFFSET WIDTH CONTENT EXAMPLE OFFSET WIDTH CONTENT EXAMPLE S Sell 1 2 2 Record Type ET Trailer SCC Sell Call Close PAGT 5 Number of Records 00003 SCO Sell Call Open 8 16 9 Total Number of Shares 000014140 SPC Sell Put Close Right justified SPO Sell Put Open Sample Data ue el The following is an example of how your spreadsheet file will 22 30 9 Security Symbol ICMB or 123123x2 eee One eae EH1994100108000000B ICMB 00000074 320019940317 31 43 13 Average price 00000074 3200 12345678 0000000840 44 51 8 Trade date 19940317 aidan os 23456789 0000001000 Right justified 45692924 0000012300 File Format gra 3000024240 OFFSET WIDTH CONTENT EXAMPLE 1 8 8 Client Account Number 12345678 9 1 Blank Space 10 18 9 Shares to
74. your portfolio management software offers this account type you can substitute any two charac ters for xx The number of shares or the face value of an asset such as a corporate bond denominated in dollars All downloaded trans actions where applicable are carried out to four decimal places The dollar amount of the commission charge as displayed on an individual confirmation When you complete a transaction on a principal basis no commission amount appears The dollar amount of the cost of one unit of the security 5 97 Chapter5 Account Viewer Accrued Interest The dollar amount of accrued interest paid Most often used in determining the cost basis of a bond When you purchase a new bond the accrued interest shows as 0 00 When you purchase a non interest bearing security this field is blank Broker Code When applicable the broker code is transmitted as schwab If the trade was executed with another broker Prime Broker trade that broker s code will be shown Original File This column is at the far right of the viewer screen The down Record loaded file name in the format CSMMDDYYTRN and the allocated record number Record numbers are allocated in the order in which the transaction is received that day For example C 011200 trn 1 refers to a record that was the first in a list of transactions for January 12 2000 Comments One line of explanatory notes about the transaction This field may be empty Comment
75. 0 Projected Portfolio with Excluded Orders using Minimum Order Threshold Note The securities displayed are fictional and used for illustration purposes SchwabL ink User M anual Down arrow indicates order was excluded because of thresholds Excluding Assets from the Actual Portfolio Tab Assets may also be excluded from the rebalancing process using the exclusion column on the Actual Portfolio tab prior to Order Generation This method produces the same results as if you had excluded the asset using the Account Exclusion screen in M odel Assignment One advantage to excluding assets from the Actual Portfolio tab is that you can easily change the exclusion status by clicking the column check box In contrast fund exclusions set through the Account Exclusions screen must be changed using the M odel Assignment program C 220 Appendix C Fund Rebalancer To exclude assets from the Actual Portfolio tab 1 Click the Selected Accounts tab 2 Highlight the account 3 Inthe Asset pane click the check box for each asset you wish to exclude from rebalancing S a kil l J a SB ji ELi Feba breiar 1 a Ta Lii HE mi 10 i ase ia Bs ili Z ELE ELI NirIT Em MF IE Eir CFH eee AE Tepi GATE DERE EH HE i Serre Da LPL T SE mae Beat LT i li F LTD eee Ee i i TELAN maL DA LLE FL ie BSH LE PAY es mi mi iiir SSS Se
76. 034521 37 96 151 56 Prime Broker Notes These are the notes Right justified Sample Data PH1995012308001234GOLDMAN SACHS GOLDMAN SACHS 0372BUY 1995012319950128938424DE2IBM AGENT NYSEUS TREASURY NOTE 12345678 000000840 52342094 000001000 59260342 000005000 84922941 000000325 PTOO004NO 000007165000000025 6250000256250 00000000 00000000 00000894 65000000 0000 002 57144 65 SchwabLink User M anual Example Importing an Excel Spreadsheet Follow the steps in this section to import Schwab trade data from a M icrosoft Excel spreadsheet into a Securities Allocation Worksheet The format presented here can also be used to import Prime Broker trade data from Excel spreadsheets The data is for the Allocation Worksheet only 1 Format the spreadsheet data according to the specifications in the following table Column A B C Column width 8 1 9 Data Client account number Blank space Quantity of shares N ote Client names are not used in the import data 2 Adjust column width in Excel by selecting the column selecting Format Column Width and filling in the desired column width in the dialog box 3 Enter data into the formatted spreadsheet Save the file in Excel spreadsheet format so you can edit the file in the spreadsheet program Select Save As from the File menu The Save As dialog box appears 5 Typeina file name and save the file in spreadsheet format to the desired location 8 132 Chapter
77. 1 C 193 C 194 C 197 C 198 C 199 C 200 C 200 C 200 C 201 C 201 C 201 C 202 C 203 C 203 C 203 C 204 C 205 Adding a N ew Fund to a M odel M odel Assignment Overview U nderstanding the Work Area Assigning Accounts to a M odel Removing Accounts from a M odel Showing All Accounts Sorting Columns Account Exclusions Understanding Account Exclusions Setting Cash Exclusions Entire Cash Position Setting Cash Exclusions Specific Dollar Amount Excluding Specific Funds Excluding M utual Funds in the M argin Account Filtering Accounts Filtering by Account N umber Filtering by Account Name Filtering by Portfolio M odel Filtering Accounts with Rebalancing Exclusions Showing All Accounts Filtering Accounts by M ultiple Selection Criteria C 206 C 207 C 207 C 207 C 208 C 208 C 208 C 209 C 209 C 209 C 209 C 210 C 211 C 212 C 213 C 213 C 213 C 214 C 214 C 214 C 214 Table of Contents Fund Rebalancer U nderstanding Rebalancing M ethods Comparison Example of Rebalancing M ethods Setting Minimum Order Thresholds Excluding Assets from the Actual Portfolio Tab Filtering Accounts Filtering the Account List in Fund Rebalancer Displaying All Assigned Accounts Selecting Accounts by Account Description Selecting Accounts by Portfolio Variance Selecting Accounts by Export Date O ptions Restoring Screen Defaults Starting a N ew Session Viewing Portfolio Charts Changing M aster Accounts Sorting Columns Resizing Columns
78. 117 Import File Format Requirements This section contains the file format rules required for files that are imported into the M utual Fund Template from spreadsheet or portfolio management software N ote Charles Schwab amp Co Inc is not responsible for trade errors caused by incorrect formatting of trade orders created outside the M utual Fund Template 7 113 Chapter 7 Mutual Fund Trading Enter all characters in UPPER CASE The Quantity field entry for Buys Sell and Sell Commission must be in dollars and cents For Sell Whole Shares the format isXXXXXXX XXX The number of whole shares cannot exceed seven digits For example enter 100 shares as 100 000 The Quantity field entry for Sell and Sell All is a three digit number in the format X XX where 100 is 1 00 and 10 is 0 10 Follow the rules regarding linked trades Refer to Linked Trade Requirements on page 7 108 Do not use dollar signs minus signs or commas to separate numbers Save the trade order file you created with your spreadsheet or portfolio management software as a space delimited or fixed format file Save files from M icrosoft Excel as prn and save files from other programs as txt Right justify each quantity in its field The Action field for all Buy options must read BUY DLRS and for Sells either SELL SHRS or SELL DLRS Sell and Sell All must be entered as SELL SHRS The system distinguishes the differe
79. 2 Inthe Setup Filter dialog box highlight the profile you want to edit by clicking to the left of the name in the list 3 Click the Edit button The Filter Builder appears 4 Highlight the line you want to change by clicking in the box to the left of the line 5 Click the Edit button The SL Filter Criteria portion of the dialog box appears at the bottom of the window Figure B 7 Ee aa aaa Diii mip a Dros fal ey ari lees AH rna rrira oe rair rhe AH Bo i dy pee ball d ce ele mE SL Fitar Grh ria wj Wika Fien r iii aii Tr x Bei r Figure B 7 Filter Builder Edit Function with SL Filter Criteria 6 If you are going to filter on the field that is displayed in the SL Filter Criteria box go to step 7 Or select a new field from the drop down list 7 If you want to modify the operator select the new operator from the drop down list in the O perator field B 171 Appendix B Transaction File Filter 8 Enter a new value or click on the down arrow button of the value field and select the value If there are no values in the drop down menu enter the data N ote Although SL Filter gives you the ability to type in information that is not listed in the pull down menus it does not validate information that is entered in this manner If you choose to do this make sure the information you enter exactly matches the target criteria 9 Click the OK button The Filter Criteria dia
80. 20 Backup N etwork 3 29 Trade 2 20 Utilities 2 21 Chapter 4 Download Utility Setting U p M aster Accounts and Preferences 2 21 O verview 4 30 Adding a M aster Account 2 22 The Download Function 4 30 Editing and Deleting M aster Account D etails Zio Launching Download Utility 4 30 SchwabLink User M anual Table of Contents Downloading All N ew Files from the Schwab Institutional Web Site Security Configuration Operations Download All N ew Files Setup and Procedure M odifying the Completion Task M aintaining File Directories Viewing the Audit Trail of Recently Downloaded Files Download Utility Logs Setting the N umber of Download Attempts Downloading Historical Files Chapter 5 Account Viewer Overview Account Viewer Window Account Viewer Toolbar The Nine Viewers N avigating in Account Viewer Selecting and Viewing M aster Accounts O pening a Viewer Closing a Viewer Closing All Viewers SchwabLink User M anual 4 31 4 31 4 31 4 31 4 32 4 32 4 33 4 36 4 37 4 37 4 37 5 38 5 38 5 39 5 39 5 40 5 41 5 41 5 41 5 41 Using Build U pdate Client Information Viewer Fields and Columns in the Client Information Viewer Adjusting the Client Information Viewer Display N avigating in the Client Information Viewer Printing from the Client Information Viewer Client Account Positions Viewer Fields and Columns in the Client Account Positions Viewer Adjusting the Client Account Positions Viewer Display N aviga
81. 3 Click OK The Font dialog box closes and the status report Is redis played showing the font size and style you selected All reports will reflect this change SchwabLink User M anual WORKING WITH REPORT FILES Follow the procedures in this section to print copy and delete reports Printing a Report You can print only the report that is active in the Status Reports window If you have multiple viewers open click on the title bar of the viewer that you want Then select the tab of the specific report to display it To print the report 1 Click the 3 button or select Print from the File menu The Print dialog box appears If necessary set print parameters Click OK The report prints To print reports automatically at startup see Setting Automatic Actions on page 6 100 Copying Text From an Active Report to Another Location You can copy only the report currently displayed in the Status Reports viewer To copy a report to another location 1 If you have multiple viewers open click on the title bar of the Status Report viewer that contains the report you want to copy Select the tab of the specific report to display it Highlight part or all of the report or select Select All from the Edit menu 6 98 Chapter 6 Status Reports 4 Click or select Copy from the Edit menu Place the cursor at the location where you want to paste the report This location can be in another application 6 Se
82. 500 O Prime Broker Trade Total Shares Allocated 4500 Total Quantity 5000 Schwab Trade Detail Allocation worksheet Enter Edit Allocation Account Humber Account Mame Client Allocation 23456709 DORIS CORVETTE amp CHRISTY CORYET 1000 _jAccount Name i en CORVETTE amp CHRISTY CORVETTE JT TEN 1000 elon Mumbar Figure 8 5 Selecting a Row to Edit 2 To edit the number of shares in the selected record highlight the Client Allocation field and type in the revised number of shares You must allocate any remaining shares Deleting Accounts To delete the selected record click the Delete button The client record is removed from the grid To select contiguous multiple accounts for deletion click on the first account you want to delete hold down the Shift key and click on the last account you want to delete All the accounts In SchwabLink User M anual between will be highlighted You must reallocate the shares from the deleted rows Any changes you make are reflected in the Allocation Summary window SENDING SECURITIES ALLOCATION FILES TO SCHWAB Before sending the Securities Allocation files to Schwab for the first time contact your Firm Security Administrator to ensure that your user ID has been activated with trading authorization For further information visit the online help portion of the Schwab Institutional Web site N ote You must transmit a Securities Allocation file no later than one h
83. 6 3 The Default File Type should also automatically appear in the File Type Field N ote To select a different file type click the File Type drop down and select the appropriate master account Refer to Default Settings on page 10 146 SchwabLink User M anual Figure 10 8 Master Account Selection D Fiar ir Lica nett 10 148 Chapter 10 Upload Utility a Fri atl en Li pond ihai a iari era l gere Tries e o AAT Taku ubi Figure 10 9 File Type Selection 4 Click the Browse button to open the Select File dialog box Figure 10 10 N ote Unlike the other modules within SchwabLink this module does not have a specified file format There are multiple file formats that can be selected therefore users need to ensure that the file s are in compliance with Schwab file formats If you have any questions please contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time e For investment advisors call 1 800 647 LIN K 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 O ption 2 or email rps techserv schwab com SchwabLink User M anual oehenct File wna i am eo 2901 10 ja TAO 10 rome SS S Files ol bape AN Hes __ Cancel Oper ac padori Figure 10 10 File Selection 5 Select the file s to add to the file transfer list If you are sending multiple files of the same type and M a
84. 6 Including Cash in Positions 5 89 M inimizing Viewers 6 97 Reconciling Files Using Four Digit Y ear 5 89 Arranging Icons 6 97 Specifying Preferences for Build Update 5 89 Changing Type Font Style and Size 6 98 Specifying the Transaction and Confirmation Working with Report Files 6 98 Record Retention Period 5 90 Printing a Report 6 98 ioe eae PORSMOS TON 5 90 Copying Text From an Active Report to Another Location 6 98 Deleting Report Files 6 99 Chapter 6 Status Reports Setting Preferences 6 99 Overview 6 91 Changing the O pening Display 6 100 Downloading Data into Status R eports 6 91 setting Automatic Actions 6 100 Status R eports Window 6 91 Setting D efault Text O ptions 6 100 Viewing M aster Account Data 6 92 e a Status and TOA gion Selecting a Report Viewer 6 92 Selecting a Report File from an O pen Viewer 6 92 SchwabLink User M anual Table of Contents Chapter 7 Mutual Fund Trading Overview Prerequisites M ain Steps M utual Fund Trade List M utual Fund Template Window Working with Data in the M utual Fund Template Single Trade Orders Selecting Symbols to Duplicate a Trade Order Linked Trade Orders Importing Trading Files Saving a M utual Fund Trade List Printing a M utual Fund Trade List Opening a Previously Saved M utual Fund Trade Order File Sending a M utual Fund Trade List to Schwab H andling Duplicate Orders Archiving Files Setting Preferences Selecting the Fund Instruction Default Checking for Duplica
85. 8 Securities Allocation 10 11 12 13 14 After you save the file in spreadsheet format select Save As again and select Formatted Text Space Delimited in the Save File as Type field You will import this file into the Securities Allocation module This format preserves the text contents and spacing to accommodate Securities Allocation Select a destination in SchwabLink for the file The default file storage location is C Program Files SchwabLink Desktop Securities Allocation D ata Click OK Open the Securities Allocation module From the File menu select Import Schwab Trade File N avigate to and select the previously saved text file Click OK The data from the file should be displayed in the Allocation Worksheet Select the Schwab Trade Detail tab and complete the worksheet Save the file in the Securities Allocation module format defaults to extension of EQ0 queue it and send it to Schwab See Sending Securities Allocation Files to Schwab on page 8 126 SchwabLink User M anual 1000 0764 8 133 Chapter9 Management Fees OVERVIEW Use the M anagement Fees module to process your client management fees electronically You enter management fees in the M anagement Fee Processing Worksheet and then transmit them to Schwab where the fees are processed for payment This chapter shows you how to e Enter and edit data in the M anagement Fee Processing Worksheet Import d
86. Allocate 00000840 Right justified SchwabLink U ser M anual 8 130 Chapter 8 Prime Broker Trade File Format Header Format Securities Allocation OFFSET WIDTH CONTENT EXAMPLE 1 2 2 Record Type PH Header 3 10 8 Transmission Date 19950123 11 18 8 Sender Master Account 08001234 19 43 25 Executing Broker Dealer Goldman Sachs 44 68 25 Clearing Broker Name Goldman Sachs 69 72 4 Clearing Agent DTC 3 0372 73 78 6 Action Buy or Sell 79 86 8 Trade Date 19950123 87 94 8 Settlement Date 19950128 95 103 9 CUSIP Number 938424de2 104 112 9 Security Symbol IBM 113 121 9 Capacity of Exec Broker Agent or Principal or N A 122 125 4 Exchange Where Executed NYSE 126 150 25 Security Description US TREAS NOTE Left justified SchwabLink User M anual File Format OFFSET WIDTH CONTENT EXAMPLE 1 8 8 Sub Account Number 12345678 9 1 Blank Space 10 18 9 Shares to Allocate 00000840 Right justified Trailer Format OFFSET WIDTH CONTENT EXAMPLE 1 2 2 Record Type PT Trailer PE 35 5 Number of Records Allocated 000002 8 10 3 New Issue Yes or No YES 11 19 9 Total Shares Allocated 000012345 20 33 14 Price 000000023 4212 34 46 13 Principal 000000123 56 47 55 9 Interest 000234 66 56 64 9 Taxes 000345 67 65 73 9 Commission 000452 54 74 82 9 Other Fee 000345 64 8 131 Chapter 8 Securities Allocation Trailer Format Continued OFFSET WIDTH CONTENT EXAMPLE 83 95 13 Net Amount 0000
87. Allocation Figure 8 4 Allocation Worksheet Schwab Trade View SchwabLink User M anual Select accounts by client account number or by account name The corresponding name or number appears in the respective field You cannot type in these fields N ote Accounts are sorted by account number not client name In the Client Allocation field enter the number of shares you are allocating to the selected client account For bonds enter the face value for example 25000 not 25 Click the Add Edit button to add the information to the grid at the bottom of the screen Repeat steps 2 4 for each client to whom you are allocating shares until all the shares are allocated As you add each allocation to the grid the information in the Allocation Summary portion of the window changes The number of shares in the Total Shares Allocated field increases and the number of shares in the Total Shares Remaining field decreases corresponding to the data you enter Editing Allocation Information To edit allocation information In the grid click on the record that you want to edit The client record is highlighted and the fields in the boxes above the grid are populated with that client information Figure 8 5 8 125 Chapter 8 Securities Allocation C Securities Allocation File Options Window Help i Yad J Select Type of Trade to Allocate i i r Allocation Summan i OO Schwab Trade Total Shares Remaining
88. CHWAB To send a file transfer list to Schwab a 1 Click or select Send to Schwab from the File menu 2 Fill in your Schwab Institutional Web User ID and Password in the Upload Information Dialog Box Figure 10 12 Upload Information M wselD Password fae Cancel User ID Figure 10 12 Upload Information Dialog Box 3 Click OK to connect to Schwab and begin the transfer process A confirmation message indicates that the files were successfully transferred Figure 10 13 10 150 Chapter 10 Upload Utility imap ee l Figure 10 13 Upload Successful Confirmation Message 4 Click Close to close the dialog box N ote Files that are sent successfully are automatically saved in your archive directory and removed from the list Each selected file must be less than 1 MB in size MAINTAINING DIRECTORIES Within the Upload Utility you can change the Archive directories or the Default directories to any directory on a local or network drive Changing Archive Directories The SchwabLink Upload Utility module automatically saves files that are successfully transmitted to Schwab in a directory of your choice This directory is known as the Archive directory To change the Archive directory 1 Select Preferences from the Options menu SchwabLink User M anual 2 Highlight the M aster Account for which you would like to change the Archive Directory The directory information will appear in th
89. Cash 0 0000 Short 0 00 23456789 DORISCORVETTE Cash 0000 Shot sanereso DAVIDBEDSEL Cash 0000 Shot 0 00 Eea O ANNE SHAVEN en o e _1_0 00 Market Value Long 177 659 51 Market Value Short 0 00 Quantity Long 177 659 8100 Quantity Short 0 0000 Figure 5 10 Security Cross Reference Viewer To display the Client Account Positions viewer double click on a record line in the list 5 53 Chapter5 Account Viewer Fields and Columns in the Security Cross Reference Viewer Fields and columns that can be customized are marked with an asterisk DESCRIPTION FIELD COLUMN Symbol Symbol or CUSIP number of the security for which client details are being displayed Used to identify and price the security For details see the Symbol field description on page 5 45 of the Fields and Columns in the Client Account Positions Viewer section Security description The name of the security for which information is displayed Account Number The client account number assigned by Charles Schwab amp Co Inc Account Name Account name as registered with Charles Schwab amp Co Inc Cash Margin The account from which payment for the security was drawn Number of Shares Number of shares of the selected security type held by a client Short Long Indicates long or short position of the security type held by a client Market Value Market value of the security held by a client SchwabLink
90. Copy M odel toolbar button The M odel Copy dialog appears Copying a model does not impact model assignments hEN E ANE hE EE T a coca i a H Os ee eh rs aT See m Figure C 26 Model Copy Dialog SchwabLink User M anual In the N ew M odel section type the new M odel Name Edit the description if necessary Select a different M aster Account if necessary 7 Click the Copy button The new model is posted to the M odel table with the same assets as the original model If you copied the model to a different master account you will have to select that master to see the new model in the M ode Table N ote You must use a different model name if copying to the Same master account but may keep the same name if copying to a different master account a S CHANGING MODEL CONTENTS Deleting an Asset from the Model As your investment objectives change you may decide to delete one or more assets from an existing model Prior to deleting assets you may wish to print a M odel by Name report for reference To delete an asset from a model 1 Click the M odel Configuration Screen toolbar button 2 Highlight the model name 3 Highlight the asset you wish to delete The asset displays in the Update Asset Allocation section After deleting an asset you must either add a new asset or change an asset s allocation to bring the TOTAL ALLOCATION value up to 100 C 203 Appendix C Fund Rebalanc
91. ENIX Az a94do2 MASTER ACCOUNT NUMBER 08123456 Dear Financial Advisor 406121998 Figure 6 7 Cascaded Report Viewers Minimizing Viewers To minimize open report viewers click the button or select M inimize All from the Window menu Arranging Icons If viewers or icons get out of alignment you can rearrange them so that they appear minimized and neatly arranged at the bottom of the viewer as shown in Figure 6 8 Do one of the following SchwabLink User M anual e If the Arrange Icons on M inimize All preferences option is set click the Lo button or select M inimize All from the Window menu To set this preference see Setting Automatic Actions on page 6 100 e Regardless of whether the preferences option is set select Arrange Icons from the Window menu rah SchwabLink Status Reports File Edt Options Window Help i P lt a OPES FI Master Acct Sample Data TOA Status EJO x ci Confirmati f EEJ rv Event Not EGIk d Deposits EJE EJ iv TOA Com EGIk Figure 6 8 Minimized Arranged Report Viewers 6 97 Chapter 6 Status Reports Changing Type Font Style and Size To change the type font style and size for all reports 1 Click the button The Font dialog box Figure 6 9 appears Font Font style Courier Hew Finedsys T MS LineDraw Terminal habh Yyas Script wetem F Figure 6 9 Font Dialog Box 2 Select the type font style and size
92. K to accept the new folder name 10 145 Chapter 10 Upload Utility 4 Click OK to return to the Upload Utility M enu N ote Any changes to the M aster Account details in the Preferences section of the Upload Utility will show in the Preferences for Account Viewer Securities Allocation M utual Fund Trading Status Reports and M anagement Fees Default Settings You have the ability to select a specific default master account number and file type in the Upload Utility Preferences screen This feature is beneficial if you frequently upload the same file type for the same master account The Defaults button on the Upload Utility M ain M enu Figure 10 1 allows you to reset the fields to the default M aster Account and File Type Editing Master Accounts To edit M aster Account details 1 Select Preferences from the O ptions menu The Upload Utility Preferences Window appears Figure 10 2 2 Click the M aster Account you would like to edit from the Upload Utility Preferences grid 3 Click Edit or press ALT E The Edit M aster Account dialog box appears Figure 10 5 SchwabLink User M anual Edit Master Account Master 4ccounk Descriptors Second Master Account Destination Second Data Folder 0 Archive C Default E C LOCAL Selected Destination C DataSecond Data Folder New Folder Cancel Figure 10 5 Edit Master Account Dialog Box e Change the M aster Account Descript
93. L Ech dd i Fund Inehuchon Default Fames C Cash C Cash A eirwest Check for duplicates fe Show hiies in gid pe Check Ge format on impi Figure 7 14 Mutual Fund Trading Preferences Dialog Box 7 118 Chapter 7 Mutual Fund Trading Selecting the Fund Instruction Default This option applies to buys only To change the Fund Instruction Default select the radio button next to your preferences in the M utual Fund Trading Preferences dialog box When you open the M utual Fund Trading Template the option selected in the Preferences window will be the default fund instruction for new buys You can specify a different fund instruction in the Fund Instruction field of the M utual Fund Template each time you make a buy otherwise the fund Instruction defaults to your selection in the Preferences dialog box N ote Payment instructions for subsequent purchases will default to the same Instructions as the existing position regardless of the Fund Instruction selection in the M utual Fund Template To change payment instructions on an existing position contact your Institutional Service Group Changes must be made at least one business day before record date of a distribution to be effective for that distribution Checking for Duplicates You can check for identical trade orders in a mutual fund trade order list This check occurs during file import format validation and when sending the files to Schwab To activa
94. Lines on page B 175 Modifying an Existing Profile When you modify a profile it is strongly recommended that you either start from an existing profile and save it under another name or create a new profile It is often easier to make modifica tions in an existing profile To modify an existing profile 1 Click the Setup Filter button in the SL Transaction File Filter main window Highlight the profile that you want to modify Double click on the selection or click on the edit button The Filter Builder appears B 170 Appendix B Transaction File Filter N ote The buttons at the bottom of the Filter Builder dialog box are the same as on the previous screen the Setup Filter dialog box H owever these buttons refer to actions per formed on single lines in the profile while actions in the prior screen refer to entire profiles You can modify an existing profile as follows e Delete lines e Edit existing lines e Add lines To delete a line 1 From the Filter Builder highlight the line you want to delete by clicking on it 2 Click the Delete button You are prompted to confirm whether you want to delete the selected line Figure B 6 Fite Bolder Edt N Daki naciai cl eh Figure B 6 Filter Builder Edit Dialog Box 3 Click the Yes button The line disappears 4 Click the Close button The Setup Filter window reappears SchwabLink User M anual To edit a line 1 Click the Setup Filter button
95. N ew button In the M odel Attributes section type the model s name in the Name text box and optionally add a description in the ription box Creating a model is the foundational step in the rebalancing saa process You may create multiple models provided each account 4 In the Asset Allocation section click the Add Asset has no more than one model assignment Allocation drop down arrow To create a model 5 Highlight the mutual fund symbol you wish to add to the 1 Click the M odel Configuration toolbar button T model This mutual fund list represents all the funds presently This opens the M odel Configuration program linked to the M aster Account Alternatively you may type a new fund symbol Models can only be saved when the TOTAL ALLOCATION equals 100 Sample Data Figure C 4 Model Configuration program Figure C 5 Add Asset list box l Note The securities displayed are fictional and used for Appendix C Fund Rebalancer 6 Typethe model percent value the fund represents in the field 7 Click the Add button The model s asset table updates and includes the new fund 8 Repeat steps 4 7 until the model s TOTAL ALLOCATION is 100 9 Inthe M odel M aintenance section click Save M odel mL on Pade ee Ph PLT ae ee SPLAT HAA DOHC HE Loses Bd mH misii HH RLH Li Dii TEI ALC ie Figure C 6 Model Configuration program Note The securities displaye
96. NTIIMI ALI M MHRAELIEF FF MILITE Ei FREI L kih LOOT Bie BEG 7858 WERE TIBU IAL ANTIJER E E FOEL Te INPE PO THAT TEE FLL BOC TRANSFOR HME WEEN CHMFHETED PRIME THE FAST WEEE THAR TET POE EEIE RENEE MF TIE LoS TTS k COMFLETE LIST OF ASS0TS RECEIVED I SEIEN BELOW FOR ACAT TRANSFERS ONLY FUR TRAMSTERS TEET EPI NIT FAPT OF THE ECET SPEER BO ACKT TRENEN BELL SPPELE IE TER SCOR T BSI FTI Feels PLELSE CHEE TEEF EEFT HANTHLY ATATEHENT GR ChLL TAR CURE HPIITINS REHESEMTLTINE FER i MAFLETE LIST OF TEE ASSETS RECEIVED ON FEN hIAT TEASTEFS Figure 6 2 TOA Complete Report Opening a Report by Report Type In order for you to see report data in Status Reports the data must be downloaded to a M aster Account folder H owever you can view reports that have been saved elsewhere for example to a disk for archive purposes or in another program To open a report by a specific report type 1 Click the button or select O pen from the File menu The Open dialog box Figure 6 3 appears SchwabLink User M anual m al E a Comments db a ConfirmsOId_db Comments px ContirmsO Id px Composit db Bs cs161298 Composit px cs061298 CON Confirms db c3061298 DEP Confirms px cs061298 E T Balances db Balances px Perms ee Files of type Figure 6 3 Open Dialog Box 2 Inthe Look in field select the directory that holds the status report 3 Inthe Files of type field select the type
97. OTE wete DUETS zamole irsi 215620000 11 056 tn SLSUPL 422452 DUE TIIE S9FACTOYM 25 0n0 0000 1 103 4688 25 e65 0000 13 262 91282 7 w in SLSU PL 141845 DUE 08 15 15 FACTOR M 20 000 0000 112 22 430 0000 11 5012 cs CRYONIC ASACH APPLICATION Mi 50 0000 Lo aao 6062 5000 31087 DAVENPORT INDUSTRIES M 200 0000 L oat 8 725 0000 4 arte D cs Figure 5 5 Client Account Positions Viewer To display the Security Cross Reference viewer for an individual security double click on a record line in the list SchwabLink User M anual Fields and Columns in the Client Account Positions Viewer An asterisk indicates fields or columns that can be customized FIELD COLUMN Account Number Account Name DESCRIPTION Eight digit client account number as registered with Charles Schwab amp Co Inc Account name as registered with Schwab TOTAL ACCOUNT BALANCES Net Market Value Portfolio Value Market Value Short Invested Cash Idle Cash Total Cash The total market value of all long positions in the account The total market value of all short positions long positions and cash positions in the account The total market value of all short positions in the account Any cash invested in a money market fund Uninvested cash plus balances in the FDIC insured Bank Deposit feature The total market value of all invested cash and idle cash 5 45 Chapter5 Account Vie
98. Save As Dialog Box File name 3 Inthe Savein field select the drive and directory where the report is to be saved If you do not change the file name it will be saved with its Original name and extension for example CS061298 DEP 6 94 Chapter 6 Status Reports If you rename the file it will be saved as a text file txt Text files can be opened and reformatted in some word pro cessing packages Text files created from Status Reports that have not been saved in a different file format can be reopened in Status Reports 4 Click the Save button SchwabLink saves the report to the new location Closing a Report Viewer To close a Status Reports viewer 1 Select the viewer you want to close by clicking in it If you have multiple viewers open click on the title bar of the Status Reports viewer you want to close 2 From the File menu select Close The viewer closes CUSTOMIZING THE STATUS REPORTS DISPLAY You can customize the Status Reports display as follows e Hide or show the toolbar e Adjust the width of the M aster Account list e Tile cascade or minimize the report viewers Viewers are cascaded by default the first time you run Status Reports To change the default for the opening display see Setting Preferences on page 6 99 e Change the type size style and font of reports SchwabLink User M anual Hiding or Showing the Toolbar To hide or show the toolbar select Show Too
99. SchwabLink Transaction File Filter Main Window SETTING USER PREFERENCES When you run the SchwabLink Transaction File Filter also known as SL Filter for the first time the User Preferences window pops up Before you run create or modify a filter for the first time make sure the information in the User Preferences dialog box is correct for the particular filter The User Preferences box gives the filter applica tion all the information it needs to run your filter properly Opening the User Preferences Dialog Box To open the User Preferences dialog box Figure B 2 click the User Preferences button on the SL Transaction File Filter toolbar or select Preferences from the Options menu SchwabLink User M anual Add Data Directory Ciibesc bow Sahect dove ana deecctoey A bs ahi fo Snareaccticn ine F dJunezhung linl Se lialsa hate in wei Pm it Figure B 2 User Preferences Dialog Box Selecting the File Format In the upper portion of the dialog box specify which transaction file format you use Advent or Generic If you will be using the filter in manual mode you have completed the setup Proceed to Using Filter Profiles on page B 168 and Running the Filter in M anual M ode on page B 176 B 166 Appendix B Transaction File Filter Choosing Directories for Filtered Files The remaining parameters in the User Preferences dialog box are used with the application in unattended mode only The fir
100. Start gt Programs gt SchwabLink Desktop The SchwabLink Launcher Figure 2 12 appears The SchwabLink launcher is organized into three folders e Accounts e Trade e Utilities SchwabLink User M anual 2 19 Chapter 2 Getting Started I trash ink Darkine Ail Ei Figure 2 12 SchwabLink Launcher When you select the tab for a folder it opens and displays icons for services related to that folder Accounts The Accounts folder provides these services Account Viewer You can display a wide range of account related informa tion including security positions cash balances client account names and addresses client transactions for a single date or across a range of dates confirmations and results of queries for which you specify parameters Download All N ew Files Download your daily client data files from Schwab Status R eports Status R eports provides next day access to a variety of timely accurate account status data You receive these reports as part of your download from Schwab each day SchwabLink User M anual Trade Select the Trade tab to display the Trade folder icons Figure 2 13 I ctreabl ink Dorking MEE De Dime Hee Schwab idee Deke Figure 2 13 Trade Folder The Trade folder provides these services Fund Rebalancer Perform mutual fund allocation and rebalancing functions Mutual Fund Trading Execute mutual fund trade orders for client accounts e Securities Allo
101. Step 6 Generating the Order List Aja The Generate Orders function creates the Order List and Projected Portfolios for all accounts on the Selected Accounts List Prior to generating orders the program evaluates all account exclusions and cash management options set in Step 3 and Step 5 T eod o generate orders Fund Rebalancer lets you set order thresholds based on the dollar 3 value of the order or the order weight as a percentage Any order 1 Click the Selected Accounts tab that doesn t meet either set minimum is removed from the Order List For example setting an Order Amount threshold of 1 000 would exclude any buy or sell orders equal to or less than that amount SchwabLink User M anual Status and Amount Once minimum order thresholds are set they remain in place until changed or a new session is opened T hese Order Generation parameters are global and applied against each account on the Selected Accounts List 2 Click the Launch Order Generation toolbar button i The Order Generation dialog opens C 193 Appendix C Fund Rebalancer N ote If this step produces an error message click the Undo Bereala Oedees Orders toolbar button W hen the process of undoing the orders completes return to Item 2 above to generate the orders Seeder the psrameders bp uss lw the ada geretaion tesen and peace the It s also possible your settings from Step 3 or Step 5 could Launch button ho Hart the rebala
102. TO P Cs101497 out Statistic c WINDOWS DESKTOP Cs101497 org record count 6760 c WINDOWS DESKTO P Cs101497 trn record count 6750 c WIN DOWS DESKTOP Cs101497 out record count 10 B 179 Appendix C Fund Rebalancer OVERVIEW Fund Rebalancer simplifies the time consuming process of rebalancing an account portfolio to match a given model The program identifies which assets should be bought or sold based on an assigned model and produces a trade file that can be imported into the M utual Fund Trading module The program allows you to create multiple models based on your clients and investment strategies For example you could have one model for customers desiring preservation of capital and another model for aggressive growth The program also provides flexibility by defining exclusions and different rebalancing methods The Fund Rebalancer module consists of three integrated programs Fund Rebalancer M odel Configuration and M odel Assignment These programs are a central part of SchwabLink that provide Investment M anagers the tools to e Define and assign model portfolios e Create what if analysis e Perform portfolio rebalancing e Generate mutual fund trade lists e Print account and model reports SchwabLink User M anual The M odel Configuration program creates and maintains models You may access the program within Fund Rebalancer using the M odel menu or M odel Configuration toolbar button The M odel Assignment
103. The file name appears in the File name field 6 Click the Open button If the account names and numbers already appear in the database you are immediately returned to the M anagement Fee Processing window The imported account names num bers and fees appear in the Worksheet grid If the account names and numbers are not already in the database you get a message telling you that they are not rec ognized and asking whether you want to abort the Import function If you want to add these accounts to the grid click Yes for each account that the database does not recognize or click Yes to All You are returned to the M anagement Fee Processing window which will display the information you have imported An SchwabLink User M anual asterisk appears in the question mark column next to each client account number that the database does not yet recognize There may be a one day delay between the time you set up a client account and the time it appears in the SchwabLink database Import File Format You can import fee information from a spreadsheet or an exter nal database into the M anagement Fee Processing Worksheet if it is formatted as described below The fields must be separated by commas in files with a csv extension or by tabs in files with a txt extension FIELD NAME MAXIMUM FIELD LENGTH Account Number 8 Fee Amount 8 including the decimal point and two decimal places Account name optional 35 Impo
104. U ser M anual Quantity Long and Total number of long positions and total number of short Quantity Short positions for the selected security type across all accounts Market Value Longand Total market value of long positions and total market value Market Value Short of short positions for the selected security type held across all accounts Note The Market Value field may be gray to identify any securities with stale prices Adjusting the Security Cross Reference Viewer Display You can change how information in the viewer is displayed To change column order and width or to sort data see Changing Column Order Adjusting Column Width and Sorting Data on page 5 83 Navigating in the Security Cross Reference Viewer To navigate through the lists of securities place the cursor in the Symbol or Security Description field at the top of the viewer and use the navigation buttons on the toolbar or the record navigation functions on the Window menu To find a record in the viewer select the appropriate security and do one of the following Scroll or page through the list until you locate the record you want e Use the Find command to locate the record See Using the Find Command in the Positions and Security Cross Reference Viewers on page 5 82 5 54 Chapter5 Account Viewer Double click on any record in the account table to display the To open the Transactions List viewer make sure the correct
105. User M anual a ee ee ee TUL a Cee ee ee Be Cd a ADEF a es es PLATE re OC AA Cea Fk alate Mund bea Dic Figure C 23 Model Configuration Note The securities displayed are fictional and used for illustration purposes M odel M aintenance panel left The table in the upper section displays model names and descriptions The lower section defines model names and descriptions For example you might add a description indicating the model s objective and creation date Asset Allocation panel right T he table displays the assets belonging to the highlighted model on the left The top section provides the symbol description and model percentage allocation of each asset The lower section is used to add assets to a model or change the percentage allocation of an existing asset You may adjust the panel or column widths using your mouse C 200 Appendix C Fund Rebalancer WORKING WITH MODELS Creating a Model Creating a model is the foundational step in the rebalancing process You may create multiple models but each account may have only one model assignment To create a model 1 Click the M odel Configuration Screen toolbar button 2 Inthe M odel Maintenance section click the N ew button 3 Inthe M odel Attributes section type the model s name in the N ame text box and optionally add a description in the Description box 4 Inthe Asset Allocation section click the Add As
106. a mutual fund trade order list e Send a mutual fund trade order list to Schwab e Save and archive trade order files e Open a previously saved trade order file e Set preferences specific to M utual Fund Trading Prerequisites To use the M utual Fund Trading module you need the following e At least one M aster Account that is set up To set up a M aster Account for the first time see Chapter 2 Getting Started A list of the single trade and or linked trade orders to be made in each client account Schwab Institutional Web site user ID and password that are authorized for trading SchwabLink User M anual If you are not sure of your user ID and password or do not know whether they are authorized for trading contact your Firm Security Administrator FSA For further information visit the online help section of the Schwab Institutional Web site Main Steps Using the M utual Fund Trading module to send a trade order list to Schwab involves four main steps 1 Enter or import trade orders into the M utual Fund Template 2 Send the mutual fund trade order list to Schwab 3 Visit the Schwab Institutional Web site www schwabinstitutional com to review the status of the uploaded mutual fund trade order file 4 Store and back up mutual fund trade order files SchwabLink archives trade orders you send to Schwab through the M utual Fund Trading module see Archiving Files on page 7 117 Check the reg
107. a proportion of the type selected in the drop down list at the top of the screen of All Types Shows the percentage of each security as a proportion of all the securities in the Master Account Market Value Long The total market value of the all long positions for all accounts Market Value Short The total market value of all short positions for all accounts Note Latest Price and Market Value fields may be gray to identify any securities with stale prices Adjusting the Composite Security Positions Viewer Display You can change how information in the viewer is displayed To change column order and width or to sort data see Changing Column Order Adjusting Column Width and Sorting Data on page 5 83 Navigating in the Composite Security Positions Viewer Display a security type by selecting it from the drop down list at the top of the viewer To find a record in the viewer do one of the following 5 52 Chapter5 Account Viewer e Use the record navigation keys and the record navigation functions in the Window menu to move through the secu rity types not the securities listed in the grid e Scroll or page through the security types list until you locate the record you want e Use the Find command to locate the record See Using the Find Command on page 5 81 Use the Find function to find records in the list of securities for the security types you currently have listed Find will not sear
108. abLink User M anual To restore screen defaults 1 From the Options menu select R estore Screen Default 2 Click Yes 3 Click OK 4 Close and restart Fund R ebalancer N ote Restoring screen defaults clears the Selected Accounts List Any order that hasn t been exported is lost Starting a New Session To start a new session 1 From the Fund Rebalancer menu select Session 2 Select N ew N ote Starting a new session clears the Order List and Selected Accounts list Any orders that were not exported will be lost Viewing Portfolio Charts Fund Rebalancer provides graphical representations for each enabled tab on the Portfolio pane Actual Portfolio Order List and Projected Portfolio These graphs are especially useful in determining the differences between model allocations particularly when using the High Low rebalancing method By default the graph area is not shown and may be viewed by clicking the View Chart toolbar button lt lt The graph pane Is resizable Changing Master Accounts Fund Rebalancer uses the same SchwabLink databases as Account Viewer The program allows you to switch between M aster C 224 Appendix C Fund Rebalancer Accounts so long as you haven t generated orders When you switch M aster Accounts your Selected Accounts list is cleared To change M aster Accounts 1 Locate the M aster Account list box to the right of the toolbar Be betes eee Figure C 44 Master A
109. age of the wide variety of activities and information it offers For additional help use these tools e The SchwabL ink 2 3 User M anual The chapters provide a detailed description of each SchwabLink module and step by step procedures Chapter 3 provides an overview of the Schwab Institutional Web site SchwabLink User M anual e SchwabLink Help Get immediate help with the module you are working in by selecting the H elp menu from the top of the SchwabLink window e Schwab Institutional Web Site H elp Log on for a detailed description of the site s features After logging onto the site click on Help located in the top right corner e Microsoft Windows user documentation and telephone support for questions concerning your Windows software Contents of the CD ROM Install SchwabLink 2 3 from the CD ROM your firm received from Schwab Institutional The CD ROM contains additional applications you can choose to install now or later The SchwabLink 2 3 CD ROM contains Autorun Installer When you insert the SchwabLink CD ROM into your CD ROM drive Autorun begins installation automatically It displays the first installation screen then steps you through the installation process SchwabLink 2 3 for Windows Place trades and view account data with the latest version of SchwabLink for Windows Transaction File Filter T FF 1 1 Automatically eliminate transaction information that might duplicate data from DTC IDC o
110. age 2 22 This procedure assumes that you use the C drive 3 Map a drive letter on the other PCs to the C drive on the first PC If possible make the path similar in all remote machines For example G SchwabLink Data would correspond to the C SchwabLink Data directory on the PC where SchwabL ink and the data are installed on that C drive During the software installation on remote stations select the G SchwabLink Data directory instead of the C SchwabLink Data directory Network Control Directory In both client server and peer to peer networks it is necessary to set up the network control directory The software will use this directory to govern file sharing The network control directory path must correspond to the same location for all workstations accessing the SchwabLink data The directory must have read write create modify and delete privileges for all users To set up the network control directory 1 Install SchwabLink on the client server or peer to peer network as described in the preceding sections 2 On the server client server or local peer to peer machine click the Windows Start button and select Settings gt Control Panel SchwabLink User M anual 0901 03180 3 Double click the BDE Administrator icon 4 Select the Configuration tab 5 Double click on Configuration gt Drivers gt N ative 6 Click on Paradox then click on the C displayed in the NET DIR box7 Type the drive lett
111. al To print a Transactions List or Transactions Query Results List 1 Makesure the list you want to print is active To print the entire list go to step 3 To print selected records go to step 2 2 Select records to print using one of the following procedures e To select contiguous records use the up or down curser keys on the keyboard while holding down the Shift key e To select non contiguous records click on Individual lines while holding down the Ctrl key 3 Click the Print button on the toolbar or select Print from the File menu The Print Records dialog box Figure 5 16 appears Print Records f Print Selected Records Print All Records Figure 5 16 Print Records Dialog Box 4 5 Select whether you want to print selected record s or all records Click Print The Print dialog box appears 5 62 Chapter5 Account Viewer 6 Set appropriate print parameters and click OK SchwabLink prints the appropriate records from the active Transactions List or Transactions Query Results List Using the Purge Function When you add a file of transactions to the Transactions List SchwabLink combines the new transactions with those already added Over time your summary list may become too large or contain information you no longer need Use the SchwabLink purge function to delete transactions from the display in your summary list automatically after a number of days that you specify or upon demand Remem
112. ancer i Schema ih Frama Poalen Mestad es Figure C 24 Removing Account Assignment 6 Click the Unlink Accounts from M odel toolbar button x 7 Click the close box x in the upper right corner to return to Fund Rebalancer A confirmation dialog appears SchwabL ink User M anual Fand H ebhalar et Figure C 25 Model Configuration Assign Confirmation message Click the OK button on the Fund Rebalancer new session message Click the M odel Configuration Screen toolbar button T Select the model for deletion from the M odel table Click the Delete M odel toolbar button x Click the Yes button on the Delete M odel dialog The model is removed from the M odel list Deleting a Model without Assignments A model portfolio may be deleted within M odel Configuration provided no account is assigned to it To delete a model without account assignments 1 2 3 4 Click the M odel Configuration Screen toolbar button Ps Select the model for deletion from the M odel table Click the Delete M odel toolbar button x Click the Yes button on the Delete M odel dialog The model is removed from the M odel list C 202 Appendix C Fund Rebalancer Copying a Model You may find it useful when creating a model to use an existing model as a template To copy an existing model 1 Click the M odel Configuration Screen toolbar button T 2 Select the model for copying from the M odel table 3 Click the
113. and refine your search SchwabLink displays the results of your query in a Trade Confirmations Query Results List viewer which you can sort and print Making an Initial Query Follow the steps in this procedure to set search parameters then search the confirmations list 1 Make sure that the Confirmations List that you want to query is open 2 From the View menu select Query The Query Builder window opens Figure 5 21 SchwabLink User M anual swt Hi B mlhi Her Atom Fe AND r OF Achon BOUGHT Save Cie Losi uey Fun Daey Chess All Clee Lat Lance Figure 5 21 Trade Confirmations Query Dialog Box Select the field or column you want to search Select one of the O perator options SchwabLink finds transactions with a value equal to the one entered in the Value field in the field that you selected to search Select to find values less than the one you entered lA 5 70 Chapter5 Account Viewer lt Select to find values less than or equal to the one you entered gt Select to find values greater than the one you entered gt Select to find values greater than or equal to the one you entered IN Select to find records matching any of the values entered LIKE Select to find records that begin with the value entered 5 Inthe Value field select or type the value you want to locate For example to locate trades over 100 00 you select Dollar Amount as the Field
114. are automatically deleted from the queue Files that were not selected from the queue will remain in the queue until sent or deleted It is possible to make changes to these files H owever you must re save them before sending You can view the Worksheet Q ueue at any time by clicking E Requeuing Deleted Files Files that are deleted from the Worksheet Q ueue are still present on the drive to which they were originally saved To requeue an allocation file 1 Do one ofthe following e Open the file click Save As in the File menu and rename the file e Open the file edit it and save it SchwabLink User M anual 2 Click or select Send to Schwab from the File menu The Worksheet queue appears with the file requeued Opening Existing Files To open an existing file 1 Click the Fa icon or select O pen from the File menu The Open dialog box Figure 8 8 appears Look ir a Cs032499 eq0 aj cs032495_ eq a cs032499 eq aj cs032499 eq3 File name eg Open Files of type Schwab Trade i gt Cancel Figure 8 8 Open Dialog Box 2 Select the drive directory and file type of the previously saved file you want to open 3 Select the file The file name appears highlighted in the File name field 4 Click the O pen button The fields in the Securities Allocation window are populated with the file information 8 128 Chapter 8 Securities Allocation You can edit the information in this file i
115. are currently assigned to Certificate of Deposit transactions Security Type Ca Cash Equivalent cb Corporate Bond cd Certificate of Deposit cl Call Option cp Convertible Preferred CS Common Stock dl Reorganization ep Expense Account ex Expense Account gb Government Bond gm GNMA ip Index Participation Contracts Security Description Cash Margin drawn Number of Shares client holds Long Short Abbreviation for the type of security To view a list of the security types used in Account Viewer select Security Type Descriptions from the View menu This list is shown below mb Municipal Bond mf Mutual Funds Taxable mn Mutual Funds Non taxable 0a Other Assets pS Preferred Stock pt Put Option tb Treasury Bill tn Treasury Note un UIT Non taxable ut UIT Taxable wt Warrants zt Zero Coupon Bond Taxable The name of the security The account from which payment for the security was Number of shares in the selected security that the Indicates whether the position is long or short 5 41 Chapter5 Account Viewer Price Market price per unit of the security as of the date in the Date of Price field in the Security List viewer Schwab transfers these prices and dates to you as part of your daily download Market Value The number of shares multiplied by the current price per unit in the Price field Percentage Percentage of the account portfolio each security listed represents Not
116. assets but wasn t included in the model portfolio The sale proceeds of 67 355 are used for the purchases of NEWF1 and NEWF2 NEWF1 This fund represented 30 of the assets in the model portfolio and wasn t included in the current portfolio NEWF2 This fund represented 20 of the assets in the model portfolio and wasn t included in the current portfolio The order was only for 10 392 since that was the remaining balance from FUNDA sale and NEWF1 purchase 67 355 56 963 Setting Minimum Order Thresholds Fund Rebalancer lets you set order thresholds based on the dollar value of the order or the order weight as a percentage Any order that doesn t meet either set minimum is removed from the Order List This may also result in differences between the projected portfolio and target portfolio Once minimum order thresholds are set they remain in place until changed These parameters are global and applied to all generated orders SchwabLink User M anual To set order thresholds 1 Click the Launch Order Generation toolbar button H 2 IntheMinimum Order Thresholds section enter a value in the Order Weight and or Order Amount fields Genciwe Dudeis a Selec the praras oo lee bu the odie geri pecan ancl pees the Laurrch bethor bo ater thee baker picid ho thet theca Figure C 39 Minimum Order Threshold Example of 5000 3 Click the Launch button C219 Appendix C Fund Rebalancer hen djo Figure C 4
117. ata into the M anagement Fees module e Save the M anagement Fee Processing Worksheet file e Send the file to Schwab Prerequisites N ote You must have written approval from your clients when they open their Schwab accounts in order to debit management fees auto matically from their accounts The appropriate forms for obtaining client authorization to deduct fees are available electronically on the Schwab Institutional Web site www schwabinstitutional com or from your Institutional Service Group Before you can use the M anagement Fees module to send files to Schwab you need the following e At least one M aster Account that is set up see Chapter 2 Getting Started e Disbursement Account number for the first time you process fees for each M aster Account see Setting Up Disbursement Accounts on page 9 142 Contact your Institutional Service Group if you do not know your disbursement account number e Client account numbers for each client account that you will charge SchwabLink User M anual e Fee amount being charged to each client e Schwab Institutional Web user ID and password that are authorized for file uploads If you are not sure of your user ID and password or do not know whether you are authorized for file uploads contact your Firm Security Administrator FSA For further information visit the online help portion of the Schwab Institutional Web site Main Steps The M anagement Fees processing pr
118. ay the Query command can greatly simplify your work by taking you directly to the subset of transactions you want to work with After selecting the Query command you specify the transaction list field s you want to search and the value for each field You can search for any field in the transactions list In addition to specifying values you can select search parameters such as less than and greater than and sort the columns in your query results to focus speed and refine your search SchwabLink displays the results of your query in a Transactions Query Results List viewer which you can sort and print SchwabLink User M anual Making an Initial Query Follow the steps in this procedure to set search parameters then search the transactions list 1 Make sure that the transactions list that you want to query iS Open 2 From the View menu select Query The Query Builder window opens Figure 5 14 lt pump Hanie Tensor Linde pe Cave uan Load Duru Figure 5 14 Transactions Query Dialog Box 3 Select the field or column you want to search 5 60 Chapter5 Account Viewer 4 Select one of the Operator options SchwabLink finds records with a value equal to the one entered in the Value field in the field that you selected to search lt Select to find values less than the one you entered lt Select to find values less than or equal to the one you entered 2 Select to find values
119. ber that you are not deleting the original transactions from the files sent by SchwabLink The transactions on the Transactions List are copies SchwabLink made when you added the new transaction file to the list If you need to view a transac tion record you have purged you can go back to the original files on your hard drive or on a backup diskette and add them to your Transactions List again Setting Up the Automatic Purge Function You set up the automatic purge function in the Account Viewer Preferences dialog box Refer to Specifying the Transaction and Confirmation Record Retention Period on page 5 90 Purging Transactions on the Scheduled Day When you open Account Viewer on the day of the scheduled purge the Transaction Purge dialog box Figure 5 17 appears The message prompts you to delete transactions older than the number of days set in the Account Preferences dialog box SchwabLink User M anual lianza n Purge COM P Found 7 recods olde thar 30 dapis Dio piia Haani io delete iene meidt Figure 5 17 Transaction Purge Dialog Box To purge the records click Yes The dialog box closes and the Transactions List appears The transactions you were prompted to purge are no longer on the list If you do not open the Transactions List Viewer on the day of the scheduled purge the purge does not take place You will receive the Transaction Purge message the next time you open the Transactions List Viewer Pur
120. box 5 Typein either an account number or wildcard pattern in the Account N umber textbox For example you could type 12345678 or 12 6 Click the Filter button Filtering by Account Name To filter either account list for account names 1 Click the M odel Assignment Screen toolbar button esl 2 Click either the Accounts with M odels tab or the Accounts without M odels tab 3 Click the Filter Account List toolbar button al 4 In the selection criteria area click the Account Name checkbox 5 Type the exact account name or a partial name surrounded by the wildcard character For example smith would return Adam Smith Adam Smith Wesson and Adam Smithfield 6 Click the Filter button C 213 Appendix C Fund Rebalancer Filtering by Portfolio Model To filter by Portfolio M odel 1 Click the M odel Assignment Screen toolbar button a 2 Click the Accounts with M odels tab 3 If the Selection Criteria dialog isn t already displayed on the lower portion click the Filter Account List toolbar 4 button 4 Click the Portfolio M odel checkbox Select a portfolio model from the drop down list Click the Filter button Filtering Accounts with Rebalancing Exclusions The program allows you to filter for account exclusions Collectively these rebalancing exclusions include e Accounts that excluded the entire cash position e Accounts with specific dollar exclusion e Accounts with specific fu
121. cation Allocate block trades to your client accounts N ote Allocations may also be done via Web Trading on www schwabinstitutional com 2 20 Chapter 2 Getting Started Utilities Select the Utilities tab to display the Utilities folder Figure 2 14 we mk Be na Figure 2 14 Utilities Folder The Utilities folder provides these services e Download Utility Define parameters associated with your daily download of client data files Fund Rebalancer U pdate View the status of or manually initiate the Fund R ebalancer update process for specific master accounts M anagement Fees Submit your management fees to Schwab electronically Schwab Institutional Launch your browser to take you to the login page of the Schwab Institutional Web site Transaction File Filter Eliminate specific transactions from the daily downloaded transaction files to avoid duplication from other interfaces such as DTC or IDC SchwabLink User M anual N ote The Transaction File Filter icon does not appear until after you launch the Transaction File Filter application which you install from the SchwabLink CD ROM U pload U tility Use the Upload Utility to send files directly to Schwab that are not created in SchwabLink You can send multiple files in one operation This utility is used primarily by clients of Schwab Institutional s Retirement Plan Services SETTING UP MASTER ACCOUNTS AND PREFERENCES After you complete t
122. cause of thresholds or adjustments Although there is not a specific report that only displays excluded orders you can get a report showing all orders including any excluded orders For each account with an order the report displays e Trade Type e Symbol e Description e Price e Operation or Exclusion reason e Quantity e Cost e Proceeds To print a listing of orders including excluded orders 1 On the Fund Rebalancer toolbar click the Printer toolbar button ae 2 Select Trade Orders By Account In the Account Selection area select All Accounts In the Order Selection area select Show all trade orders plus orders excluded due to thresholds adjustments 5 Click the Print button SchwabLink User M anual Trade Orders by Asset You may view a report containing all generated orders by asset for a M aster Account For each fund order the report displays Trade Type Account Symbol Description Latest Price Export Time O peration e Quantity e Cost e Proceeds Total Trade Orders To print a listing of trades by asset 1 On the Fund Rebalancer toolbar click the Printer toolbar button l Select Trade Orders By Asset In the Asset Selection area select All Assets In the Order Selection area select Show all trade orders Click the Print button oo eS Account Rebalancing Summary The Account Rebalancing Summary provides a consolidated report for each account with generated orders Th
123. ccount List box en Master Account List box 2 Click the drop down arrow on the M aster Account list box 3 Select the new M aster Account Sorting Columns M ost tables displayed in M odel Assignment may be sorted by the column heading These include Account Description M odel N ame and M oda Description The one exception is data displayed on the Asset Exclusions table To sort column data 1 Click the desired tab 2 Click the column heading on the column you d like to sort The column resorts and a small arrow to the right of the column header shows the sort order ll Figure C 45 Example of Column Sort Indicator Value fo Sort Indicator SchwabLink User M anual C 225 Appendix C Fund Rebalancer Resizing Columns To resize a column 1 Rest the cursor between the two column headers until a double headed arrow appears ES Double headed arrow thtet Cat 4 xaf 0 w 20 Ja a0 BLUM BLU INTERNATIONAL FUND 0 il B m si mi EMSFK DEFAULT MORTGAGE SECS op 62 200 62 H LFAHE STATE MUM BOND HI rUD 0 io E 20 42 20 A STATE MUM BOND LTO D on o a O a Figure C 46 Column Resizing Indicator 2 Left click and drag the column boundary until the column is the size you want 3 Release the mouse Note The securities displayed are fictional
124. ccount number or name to which you will charge a fee Select from the drop down list in the Account N umber or Account Name field The corresponding field automatically populates Alternatively place the cursor in the Account N umber field and enter the number If the account is in the database the Account N ame field will populate Enter the fee amount 4 Click the Add Update Fee button The account fee information appears in the worksheet grid 5 Repeat these steps for all accounts to which you want to charge a fee The total number of fees and total fee amount are automatically calculated for you on the worksheet N ote The worksheet automatically validates the data that you enter into the worksheet against the details held in the SchwabLink database If you enter a client account number that is not in the database and you have not selected the Validate typed sub accounts option in the M anagement F ees Preferences dialog box an asterisk appears in the question mark column next to the account number If you have selected this option you receive a warning message that the account number is unknown and you will not be able to enter a fee amount or transmit the account information to Schwab There may be a one day delay between the time you set up a client account number and the time it appears in the SchwabLink database SchwabLink User M anual Loading Data from the SchwabLink Database To load all the accoun
125. cepting a Linked Trade Order You must accept linked trade orders in order to transmit them To accept the linked trade orders that you have made for an account SchwabLink User M anual 1 After you create all linked trades for the account click OK 2 TheAccept Changes dialog box appears Figure 7 5 Accept Changes E4 Accept Linked Trades to Trade List Figure 7 5 Accept Changes Dialog Box 3 Click OK If the buys equal 100 of the sells you are returned to the M utual Fund Template The linked trade orders are added to the grid If the buys are less than 100 of the sells the unused sell pro ceeds are allocated to the client s cash account and the message shown in Figure 7 6 appears Link Trade Information E4 Buys total 152 Excess proceeds will go to cash Figure 7 6 Link Trade Information Message Click OK You are returned to the M utual Fund Template The linked trade orders appear in the M utual Fund Template grid 7 110 Chapter 7 Mutual Fund Trading Duplicating a Linked Trade Order in the Linked Trades Window To duplicate a linked trade order in the Linked Trades window 1 Select the trade order that you want to duplicate 2 Click the Duplicate button SchwabLink copies the selected trade order and places it in the appropriate Buys or Sells section in the Allocation Group area of the Linked Trades window 3 Select the duplicated trade order so that the details appear in the Ente
126. cer 2 Click the Filter Account List toolbar button This Opens the Account Selection Filter dialog SchwabLink User M anual 4j Accobnd Salarins Fitter rake Fa eh ad eee i ee ed pele ee ey ep eg P ke rs hs Basen re osprey bebi ip hba pp lig le SHEA the ECA PR eects E ee teed bs he eer Siders rima oe ee 7 bime Sees T Emam lempe Pratik bicia mooy M Faiy saree aber pE Leek meter ost e ena aia toes ear ers Lert Upebsdies pra B Pemper radhe mla rs ox Dada Figure C 42 Account Selection Filter dialog 3 Click the Show all accounts check box 4 Click OK Selecting Accounts by Account Description To Filter the Account List by Account Description 1 Click the Account List tab in Fund R ebalancer 2 Click the Filter Account List toolbar button 3 Deselect any previous selections 4 Click the Account Description check box 5 In the Account Description text box type a partial account description e g IRA 6 Inthe List Update Type section click either the replace or append option 7 Click OK C222 Appendix C Fund Rebalancer Selecting Accounts by Portfolio Variance To Filter the Account List by Portfolio Variance Fund Rebalancer allows you to filter by Portfolio Variance 1 Click the Account List tab in Fund R ebalancer This variance represents the percentage of the account s current rm portfolio that will change because of rebalancing 2 Click the
127. cer FUND REBALANCER UNDERSTANDING REBALANCING METHODS Fund Rebalancer uses two distinct rebalancing methods Strict and High Low The Strict Rebalancing method generates orders based on the value differences of all positions including memo cash positions If no Minimum Order Thresholds were triggered the M odel portfolio and the Target portfolio are identical This method generates orders to bring every portfolio position into exact alignment with the model portfolio Additionally the portfolio variance is reduced to zero if all orders are executed The High Low Rebalancing method generates orders by first bringing the furthest outlying positions into line with the model This method starts with the position having the highest Difference on the Actual Portfolio tab regardless of the or sign In many scenarios this method generates fewer orders since the total value of the buy orders equals the total value of the sell orders or allocated cash Typically this method reflects a gradual approach to reaching the model portfolio Until you re familiar with the two rebalancing methods you might generate orders using one method and observe the Order List tab and Projected Portfolio tabs Then undo the orders and regenerate the order list using the other rebalancing method SchwabLink User M anual C 215 Appendix C Fund Rebalancer es ee laal Hela ra z ee ee ETE Diii LES mU 1 ii niea SiL Pat Ai QD ma inate
128. ch the full list unless you select all All Security Types You can also use the scrollbar and the keyboard up and down keys Printing from the Composite Security Positions Viewer To print from the Composite Security Positions viewer 1 Using the drop down list box at the top left of the screen select the security types for which you want to print infor mation for example ca Cash and Equivalents 2 Click the Print button on the toolbar or select Print from the File menu 3 Set print parameters and click OK SECURITY CROSS REFERENCE VIEWER Use the Security Cross Reference viewer Figure 5 10 to see which client accounts hold a position in a specific security bond fund or money market instrument Records in the viewer appear by account number in ascending order according to the particular security selected from the list at the top of the screen In addition to client account number and name you see the quantity held and the current market value At the bottom of the viewer you SchwabLink User M anual see total quantities long and short for that security across all client accounts and total market value long and short across all client accounts The selected M aster Account is shown in the title bar Security Cross Reference 08000000 Security Cross Reference 08000000 Updated 03 01 1999 CASHO MONEY MARKET FUNDS Cash Margin Number of Shares Short Long Market Value STUDEBAKER FINANCIAL
129. cific mutual fund See Security Cross Reference Viewer beginning on page 5 53 To select accounts for duplicating a trade order in the M utual Fund Template window 1 Enter a new order or select a trade order from the grid 2 Click the Select Accounts button The Select Account window appears displaying all accounts that belong to the selected master account SchwabLink User M anual Select Accoanl sa Bebe ta Ca rar atte fa Pa 25 ST 234565 Figure 7 3 Select Account Window 3 Select from the list of Available Accounts for which the trade order will apply You may select more than one account at a time using standard Windows functionality 7 106 Chapter 7 Mutual Fund Trading Click the Add button to add them to the list of Selected Accounts Click the Add All button to add every account to the list of Selected Accounts 4 To deselect an account for duplication highlight the account from the list of Selected Accounts then click Remove To deselect all accounts click Remove All 5 Click OK The duplicated orders appear in the M utual Fund Template window for the selected accounts Selecting Symbols to Duplicate a Trade Order You may be entering multiple trade orders that are the same or very similar in a single account For example you may be selling all of the shares in several different mutual funds for an individ ual client The M utual Fund Trading module enables you to create multiple trade
130. ct Technical Client Services between 8 00 a m and 6 00 p m Eastern time e For investment advisors call 1 800 647 LIN K 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 Option 2 or email ros techserv schwab com Handling Duplicate Orders If you have activated the Check for duplicates feature the system checks for identical orders within the trade order list when you try to transmit it If identical orders are found a duplicate error message appears To complete sending of the identical files to Schwab click Yes in the dialog box If you click No you are returned to the M utual Fund Template window where you can delete the duplicate trade order To activate or deactivate this feature see Checking for Duplicates on page 7 119 Archiving Files Consult with your compliance or legal expert for information concerning electronic and non electronic record keeping requirements for mutual fund trades M utual Fund Trading automatically archives all M utual Fund Trade files that are sent to Schwab To save a mutual fund trade list to a file manually at any time see Saving a M utual Fund 7 117 Chapter 7 Mutual Fund Trading Trade List on page 7 115 The files are archived in CSmmddyy TM format The sequen tially names your files from 0 to 9 and then from A to Z For example if the first trade file is sent on M ay 1 2000 and your M aster Account
131. ction dialog box Figure 5 8 appears 5 50 Chapter5 Account Viewer Security List Print Selection Ed Entire security list Only securities with stale prices Figure 5 8 Security List Print Selection Dialog Box 2 Select the Print a security list check box and select the entire security list or only securities with stale prices 3 Click OK In the print dialog box set appropriate print parameters and click OK COMPOSITE SECURITY POSITIONS VIEWER Use the Composite Security Positions viewer Figure 5 9 to view cumulative positions for individual securities across all managed client accounts Select a security type from the drop down list to display cumulative positions for all securities of that type Securities are displayed alphabetically by symbol The selected M aster Account Is shown in the title bar Composite Security Positions 08000000 SchwabLink User M anual Composite Security Positions 08000000 Updated 03 01 1999 all All Security Types Cash Margin Number of Shares Long S hort of All Types a CASHO CASH ACCOUNT BALANCE Cash 30 703 1600 Long 30 703 1600 1 292 1 292 ong ong ong ong ong Lng 20 zn bavENPoRT NOUSTRIES eer zooming ese ws 0000 ze aa p eee ea l a seo armel tol an Market Value Market Value Long 2 376 304 5800 2 376 504 9800 Market Value Short 0 0000 2 5000 3 750 0000 121 2500 36 3750000 121 2500 6 062 5000
132. ctions and Confirmations on page 5 90 If you have not set preferences to update this viewer as part of Build Update you can still view and add transactions by using the add feature described in Adding the Previous Day s Transactions on page 5 59 SchwabLink User M anual 5 55 Chapter5 Account Viewer Fields and Columns in the Transactions List Viewer An asterisk indicates total amounts that will change when files are added to or removed from the viewer list N ote Although you can customize certain fields and columns such as Account N umber in other viewers the customized values for those same fields and columns do not show up in the Trans actions List Deposit W ithdrawal List Trade Confirmations List or Trade Confirmation Detail viewers The fields in these viewers revert to Schwab assigned values Transaction Code FIELD COLUMN DESCRIPTION Account Number Your client s 8 digit Schwab account number If you are using portfolio management software you can translate these Schwab account numbers to your designated account codes Refer to the translation program section of the manual for your portfolio management or operations software Sub Account Name Account name as registered with Schwab Security Type Transaction Date The actual activity date on which the transaction occurred transaction date or ex dividend date not the date that the transaction was posted in the client s Schwab account
133. d Figure C 41 Examples of Excluded Assets Note The securities displayed are fictional and used for illustration purposes SchwabLink User M anual ak E mN IJF Pe A 8 Say E LEJ En ana Waj Kai ke mal LAJ ee ee et ee The boxed X indicates the exclusion was done from the Actual portfolio tab The X indicates the exclusion was done using Model Assignment C221 Appendix C Fund Rebalancer FILTERING ACCOUNTS Filtering the Account List in Fund Rebalancer The Filter Account List feature allows filtering of items on the Account List by a number of criteria In addition you may filter accounts by combining several criteria at once or by running multiple queries and appending the results For example you could create a filtered Account List representing accounts assigned to a specific portfolio model with a portfolio variance above 60 You could also create a filtered account list from two different portfolio models by running a filter on each portfolio model and appending the results The Filter Account list allows you to filter by e All Accounts e Account N umber e Account Description e Portfolio M odel Portfolio Variance e Export Date e Accounts with exclusions Displaying All Assigned Accounts You can remove any set filters from the Account List in order to view all assigned accounts To display all accounts on the Account List 1 Click the Account List tab in Fund R ebalan
134. d are fictional and used for illustration purposes SchwabL ink User M anual 10 Click the close box x in the upper right corner to close the M odel Configuration program 2 lt Model Components C 186 Appendix C Fund Rebalancer Step 2 Assigning an Account to a Model Assigning accounts to a model is the second step in the rebalancing process You can only have one model assigned to an account To assign accounts to a model 1 Click the M odel Assignment toolbar button T This opens the M odel Assignment program FF Fred mi Fral H rivien H miri Lar mr Amer Spee ferar ioe Hep All ll Mere ioman DITAR Fares rents 4 nciuni Esri enn Lh reirmer Pda FPES hug coach boar ihe carga hes hah em hau ro B oTr rub 7 Cockle dsla amaan inp ee wah Jone Eakin Peeks ep bed ee bp eed ee ha eg a Sample Data Grm Ger a er pon hat a cured choad i Plc aiea W k p h k a a a i D Eaki ai hrd paiia a h iph e I pias ecwwety vette Meir aocora ahaaa MediAuigerert cena ech Figure C 7 Model Assignment program SchwabLink User M anual At the bottom of the Account pane are two tabs Click the Accounts without M odels tab On the M odel table click a model name On the Account pane hold down the CTRL key and then click each account you want assigned to the model Until you assign accounts the Account with Models tab will be empty C 187 Appendix C
135. d file before the current date and rename all subsequent update files Set the Last update of Positions Balances date to any day prior to the build file Run Build U pdate To review transactions for a particular period of time 1 Select the appropriate M aster Account from the M aster Account list 2 From the Options menu select Preferences 3 Inthe Account Viewer Preferences dialog box purge the transactions table of all records by setting the Transaction records retention period days to zero 4 Click OK From the File menu select Purge In the Purge Records dialog box select the box to purge transactions and click OK 7 From the File menu select Transactions then select Add 8 Inthe Add Transactions Files dialog box select the files for the time period that you want to view and click OK The files are added to the Transactions List viewer After viewing the desired files be sure to reset the Transaction record retention period in the Account Viewer Preferences and add the purged files if desired to restore the Transactions List viewer to its normal display To review trade confirmations for a particular period of time 1 Select the appropriate M aster Account from the M aster Account list 2 From the Options menu select Preferences SchwabLink User M anual 3 Inthe Account Viewer Preferences dialog box purge the confirmations table of all records by setting the Confirmation r
136. d last file you want to open You can also hold the Shift key and use the up and down arrow keys e To open files not listed consecutively hold down the Ctrl key and use the mouse to select each file you want to open Click OK The SL Filter main window reappears The names of the files you chose appear in a shaded list box in the toolbar at the top of the window Click the Run Filter button The Select Filter dialog box Figure B 16 appears The box lists all created filters for the selected file format Advent or Generic The file type is always either Advent or Generic and is specified in the File Format portion of the User Preferences dialog box SchwabLink User M anual Select Filter Include non DTC transactions i DTC and IDC user Include non DTC and non IDC transactions iz Moxy 2 and IDC User Include non Moxy and non IDC Users W Moxy 2 Users Include non Moxy transactions Cancel Figure B 16 Select Filter Dialog Box 7 Select one filter and click the OK button The filtering process begins If you have chosen multiple files SL Filter processes each file in the order listed You can monitor the filtering process by looking at the record count in the status bar at the bottom of the dialog box When the process is complete SL Filter displays a separate window with the results of the filtering process for each file selected If you expand the results box es within the window you can view the res
137. date button MODEL ASSIGNMENT OVERVIEW The M odel Assignment program has two primary objectives The first objective is to pair accounts with model portfolios This step is also a prerequisite to the second objective setting account exclusions It s important to realize the association between models and account exclusions Only accounts with assigned models may have Account Exclusions If an account is unlinked from a model all the associated account exclusions are removed Any change to either an account s assignment or account exclusions automatically starts a new session when the M odel Assignment program Is closed bred H alee Figure C 31 Example of Model Assignment Session message SchwabLink User M anual UNDERSTANDING THE WORK AREA The M odel Assignment program consists of two sets of resizable tabbed panels The left tab set represents all accounts linked to your M aster account The right tab set lists all M odel Assignments and Account Exclusions Accounts with M odels lists each account and its assigned model portfolio Accounts without M odels lists accounts without assigned models M odel Assignment lists every model portfolio and description Account Exclusions displays cash and fund exclusions for specific accounts There is also a relationship between the left and right sets of tabs If you select any account from the left set of tabs Accounts with M odels Accounts without M odels
138. down list Securities Allocation automatically updates the DTC field and inserts the same broker name into the Clearing Broker field You can also enter information in these fields in which case the DTC of the Clearing Broker will be entered by the Prime Broker Team In the Exchange field select the stock exchange through which the trade was executed or type in the stock exchange name In the Capacity of Executing Broker field select the capacity from the drop down list Agent Principal or N ot Disclosed You can also type the information Complete the Executing Broker Contact and Clearing Broker Contact fields as appropriate If you are allocating securities from a new Issue or from an IPO click in the IPO N ew Issue check box to activate It Once activated a Y appears In the N ote field you can enter up to 256 characters of information or comments about the allocation The first 56 characters of data will be sent to Schwab with the worksheet file so this should include any specific instructions for the Schwab Institutional Trading Desk If necessary edit your field entries by highlighting the infor mation and typing in new information over the highlighted text Or where applicable make a new selection from the drop down list 8 123 Chapter 8 Securities Allocation Proceed to the next section to complete the second page of the N ote The following fields are required Trade Date Prime Broker Trade view S
139. e If you work with Schwab Institutional on the selected M aster Account select Broker D ealer as the data type If you work with Retirement Plan Services select Trust Company Broker dealer files start with cs and trust company files start with ts Including Cash in Positions To show cash balances as entries in positions make sure that the Preferences dialog box has a w in the box next to Include Cash in Positions Reconciling Files Using Four Digit Year Select this option to specify that the reconciliation file name will include a four digit year instead of a two digit year For more information on the function of the reconciliation file see Extract Position Reconcile Values on Build Update on this page Specifying Preferences for Build Update Include any or all of the following options in the Build Update process by checking the appropriate box Extract Position Reconcile Values on Build Update If this option is activated a position reconciliation file CSM M DDYY RPS will be extracted automatically from SchwabLink when the Build Update process is run Select this option if you want to create a position reconciliation file in the M aster Account folder SchwabLink User M anual The reconciliation file represents the client positions in the Schwab database This file can be used in the reconciliation process with your portfolio software to determine whether client information as presented by Schwab is consi
140. e Price and Market Value fields may be gray to identify any securities with Stale prices Adjusting the Client Account Positions Viewer Display You can change how viewer information is displayed To change the order and width of columns or to sort data see Changing Column Order Adjusting Column Width and Sorting Data on page 5 83 You can also expand your view of the client security list by expanding that portion of the screen To adjust the proportions of the two parts of the viewer 1 Move the mouse pointer between the security list grid and the summary grid until the cursor changes to a double arrow 2 Hold down the mouse button and move the arrow cursor upwards until the security list grid covers the information in the upper portion of the screen that you no longer want to view To redisplay the information move the arrow cursor down SchwabLink User M anual Navigating in the Client Account Positions Viewer To switch the viewer display between accounts use the naviga tion buttons on the toolbar or the record navigation functions on the Window menu To find a record in the viewer select the appropriate account and do one of the following e Scroll or page through the list until you located the record you want e Use the Find command to locate the record See Using the Find Command in the Positions and Security Cross Reference Viewers on page 5 82 Double click on any record in the p
141. e disappears from the list and it is not available for use B 175 Appendix B Transaction File Filter RUNNING THE TRANSACTION FILE FILTER The filtering process can be automated so that the user does not have to filter each transaction file manually every day At times you will want to run the filter in manual mode on a daily basis in order to keep a closer watch over the process usually when you are starting or changing a procedure There are four ways to run the SchwabLink SL Transaction File Filter e M anually e In unattended mode in conjunction with any scheduling software you have installed e Launched in unattended mode using an icon on the desktop e In unattended or manual mode from the Windows command line Use the manual mode to familiarize yourself with the filtering process When you are comfortable with your knowledge of filters and how they work you can use scheduling software you already have installed to set the time of your daily download and filter process Alternatively set up a shortcut on your Windows desktop and select this shortcut after you have manually downloaded your daily transaction files from Schwab Viewing the Selection Criteria Before you run a filter you may want to view your selection criteria To review the selection criteria for a filter 1 Inthe SL Transaction File Filter main window click the Setup Filter button SchwabLink User M anual The Setup Filter dialog box appears Se
142. e format error If you receive this message click Close and upload the trade file 5 If necessary browse to the folder where the trade file resides Note The securities displayed are fictional and used for illustration purposes SchwabL ink User M anual C 199 Appendix C Fund Rebalancer MODEL CONFIGURATION OVERVIEW The M odel Configuration program is used to create models for managing M utual Fund assets within existing portfolios The program seamlessly integrates with the SchwabLink portfolio database to generate trade files designed to bring each portfolio into compliance with the assigned model Each of these model portfolios might represent a different objective or investment strategy The program provides the ability to e Add assets to a model e Delete assets from a model e Change asset allocations within a model e Create new models e Delete models e Print model portfolio reports Any change to either the model list or asset allocations within a model automatically starts a new session when the M odel Configuration program Is closed UNDERSTANDING THE MODEL CONFIGURATION Work AREA The M odel Configuration work area consists of two linked panels 1 Model M aintenance panel models are created 2 Asset Allocation panel asset allocations are defined Each panel is further divided into an upper section that displays existing model information and a lower section for configuring models SchwabLink
143. e lower portion of the dialog 3 Click the Browse button to the right of the Archive Directory textbox 4 Navigate to the new directory from the Add Archive Directory dialog box Figure 10 14 Double click on the desired directory Add Archive Directory Deshnatiory ec Data E C LOCAL Selected Destination C Data First Data Folder v4archive Figure 10 14 Add Archive Directory Dialog Box 10 151 Chapter 10 Upload Utility 5 Click OK Click OK on the Upload Utility Preferences dialog box N ote Any subsequent file sent to Schwab will be saved to this new location directory Changing Default Directories When files are added to the file transfer list by clicking the Browse button the SchwabLink Upload Utility points to a starting directory where you can select files This directory is known as the Default directory To change the Default directory 1 Select Preferences from the Options menu 2 Highlight the M aster Account you would like to change the Default directory for The directory information will appear in the lower portion of the dialog 3 Click the Browse button to the right of the Default Directory textbox 4 Navigate to the new directory from the Add Default Directory dialog box Figure 10 15 Double click on the desired directory SchwabLink User M anual Add Default Directory Deshnatiors ec Data gt First Data Folder E C LOCAL Selected Des
144. e report contains the data displayed on the Projected Portfolio tab and the Order List Optionally you may select to print the allocation charts C 229 Appendix C Fund Rebalancer To print the Account Rebalancing Summary report 1 On the Fund Rebalancer toolbar click the Printer toolbar button 3 Select Account Rebalancing Summary In the Account Selection area select All Accounts In the Account Restrictions area select N o restrictions a a In the Charting O ption section check the Show portfolio allocation chart O ptional 6 Click the Print button Account Rebalancing Detail The Account Rebalancing D etail Report provides a sectional report for each account with generated orders These detail sections include Current Rebalancing Portfolio Order Generation Final Trade orders and Projected Rebalancing Portfolio The detail report does not provide an option for allocation charts To print the Account Rebalancing Detail report 1 On the Fund Rebalancer toolbar click the Printer toolbar button g Select Account Rebalancing Detail In the Account Selection area select All Accounts In the Account Restrictions area select N o restrictions Click the Print button oY oe w w SchwabLink User M anual MODEL CONFIGURATION REPORTS Model Portfolios by Name The M odel Portfolios By Name report displays a list of all assets symbols descriptions and allocations for a saved portfolio To print a speci
145. e screen The account will display an X in the last column on the Accounts with M odels tab In Fund Rebalancer the Actual Portfolio tab will display an X in the first column for the Cash line C 209 Appendix C Fund Rebalancer Figure C 33 Exclude Entire Cash Position Example N ote If the linked model has a cash allocation the Exclude entire cash position option is disabled Note The securities displayed are fictional and used for illustration purposes SchwabLink User M anual Exclusion indicator and entry Setting Cash Exclusions Specific Dollar Amount In certain circumstances you may wish to exclude a specific dollar amount from rebalancing This excluded amount is then deducted from the CASH value displayed in Fund R ebalancer To set a specific dollar cash exclusion 1 Click the M odel Assignment Screen toolbar button s 2 Click the Accounts with M odels tab 3 Click the account you wish to exclude cash from 4 On the Account Exclusions tab select the Exclude Dollar amount radio button 5 Typein the dollar amount to exclude in the text box 6 Click the Update button at the bottom of the screen The account will display an X in the last column on the Accounts with M odels tab C 210 Appendix C Fund Rebalancer In Fund Rebalancer an additional EX line item is added to the Actual Portfolio tab representing the dollar amount to excl
146. ecords retention period days to zero Click OK From the File menu select Purge In the Purge Records dialog box select the box to purge confirmations and click OK From the File menu select Confirmations then select Add In the Add Confirmations Files dialog box select the files for the time period that you want to view and click OK The files are added to the Trade Confirmations List viewer After viewing the desired files be sure to reset the Trade Confirmation retention period in the Account Viewer Preferences and add the purged files if desired to restore the Trade Confirmations List viewer to its normal display Using the Find Command Use the Find function to search every field in a viewer and locate specific information N ote See the next section for special features of the Find func tion for the Positions and Security Cross Reference Viewers 1 Make sure that the appropriate viewer is active 2 Click the Find button or select Find from the Edit menu The Find dialog box Figure 5 35 appears 5 81 Chapter5 Account Viewer M Siwt yh E Cancel Figure 5 35 Find Dialog Box Enter the text and or numeric string that you want to find Click Find N ext To restrict the search you can select the options to find only records that start with the string you entered or to search the selected column only SchwabLink locates the first record that meets your search criteria 5 Do a
147. ejects a transfer because it is a duplicate request the account is already in distribution or transfer the Account Holder rescinded the instructions or the transfer is missing authorized signatures The receiving firm may also reject an account or non standard transfer Review Accelerate The receiving firm initiates an acceleration of a FULL transfer thereby shortening the settlement period Review Adjust The delivering firm adjusts assets being delivered CODE RQSAD RQSADP DESCRIPTION Request Adjust The receiving firm adjusts a transfer previously rejected as a 24 hour pend 24 Hour Pend Rejects include SSN Tax ID mismatch Account title mismatch Additional documentation required Delivering account is flat and Invalid account number Request Adjust Past The delivering firm fails to validate or reject a transfer previously rejected as a 24 hour pend AND the receiving firm has adjusted the transfer form If no action is taken the transfer form is purged after seven days REVERR REVW Review Error The delivering firm had an error on assets validated for transfer If no adjustment is made in the allotted time the account is purged after seven days Review The receiving and delivering firms review the assets to transfer SchwabLink User M anual 1000 0885 RQSPST ROSRE RQST SET Request Past The delivering firm fails to validate or reject a transfer in the allotted time If no action
148. eld by clicking on it 9 Select an operator from the Operator field drop down list 10 Select a value from the Value field drop down list You can also enter the value in the value field If no value is listed for this field type it in Fiter aider N ote Although SL Filter gives you the ability to type in information that is not listed in the pull down menus it will not validate information that is entered in this manner If you choose to do this make sure the information you enter exactly matches the target criteria If you do not want to make an addition click the Cancel Figure B 11 New Filter Dialog Box button 3 Construct the statements that specify the new selection criteria line by line Use the six fields in the SL Filter Criteria dialog box SchwabLink User M anual B 173 Appendix B Transaction File Filter These six fields are SS SSS e And Or operator a __ hetim Trame heel ade rss e Optional open parenthesis e Field Name e Operator e Value e Optional close parenthesis The procedure is the same as editing existing profile lines The Field Name Operator and Value fields all have a pull down menu that you access by clicking on the down arrow The Field N ame box displays all field names that are valid for either the Advent or Generic transaction file depending on your User Preferences selection The O perator field lists possible Boolean operations The Value field lists predefined values un
149. elds in the Trade Confirmation Detail viewer Settlement Date the trade will settle N ote Although you can customize certain fields and columns such as Account N umber in other viewers the customized CUSIP Number CUSIP number for the security traded values for those same fields and columns do not show up in the Transactions List Deposit Withdrawal List Trade Confirmations Security Number Internal Schwab number assigned to the List or Trade Confirmation Detail viewers The fields in these security viewers revert to Schwab assigned values Principal Principal dollar amount involved in the trade SchwabLink U ser M anual 5 75 Chapter 5 Account Viewer Commission Exec Br Com Trans Fee Accrued Int State Tax SEC Fee Other Fee Total Amount Prime Br Fee Net Amount Comments Commission charged for the trade Commission paid to the executing broker for Prime Broker trades Transaction fee charged for the trade Accrued interest due State tax charged for the trade SEC fee charged for the trade Any miscellaneous fee charged for the trade Total dollar amount of the trade Fee charged for Prime Broker trades Net amount for the trade transactions Up to 14 lines of explanatory notes about the trade Use the scroll bar at the right of the field to move from comment to comment This field may be empty The number of the record tn the list from which the detail is cur rently being displayed and
150. elect the destination for the file The default location is C Program Files SchwabLink Desktop M anagement Fees D ata 4 Enter anamein the File name field Click Save All files are saved with the extension mfa The file name appears at the top of the M anagement Fee Processing Worksheet SchwabLink User M anual Sending Files To send files to Schwab 1 After saving the files that you want to send click the Icon or select Send to Schwab from the File menu The Worksheet Q ueue dialog box Figure 9 8 appears Worksheet Queue Ed Queued Worksheets testi mta Send Delete Close Figure 9 8 Worksheet Queue Dialog Box All files in the queue are automatically selected highlighted Deselect files that you do not want to send by using Ctrl C lick standard Windows selection functionality You can remove a file from the queue by selecting highlighting it and clicking the Delete button To deselect use Ctrl Click If you accidentally delete a file from the queue you can requeue it by following the procedures on page 9 141 Requeuing Deleted Files 9 140 Chapter9 Management Fees 2 Make sure that the files you want to send to Schwab for processing are selected and click the Send to Schwab button The following acknowledgement appears Figure 9 9 Acknowledgement venty and affirm that The clients listed on the worksheets am transmitting have provided written authorization
151. ending cash deposits or withdrawals For example if an account Is expected to receive 5 000 in interest payments this week you may include this amount in the rebalancing process by selecting the Deposit buy option A separate 5 000 line item posts to the Projected Portfolio tab and the funds are included in the rebalancing process and used for purchases This process allows the account to maintain the model percentages N ote Accounts still must have sufficient funds to cover all fund transactions The default settings are for no cash exclusions or cash flow changes Unlike account exclusions these cash management options are only in effect when the account displays on the Selected Accounts list M oving an account from the Selected Accounts tab back to the Account List tab removes the Cash M anagement O ptions for that account An important distinction is that Cash M anagement amounts are in addition to any Account Exclusion settings Step 3 For example if you set 1000 cash Account Exclusion and a 3000 Cash Adjustment a total of 4000 Is excluded from rebalancing The cash movement settings are reflected on the Projected Portfolio tab after order generation To input cash management options 1 Click the Selected Accounts tab 2 On the Account pane select the account you d like to set cash management options for 3 Click the Input Cash M anagement toolbar button Ea The Account Cash M anagement window opens SALI App
152. endix C Fund Rebalancer rdar tha cash floss meari ba pod ba ihe Figure C 13 Account Cash Management SchwabL ink User M anual Enter in any dollar values for cash exclusions or cash movement Click the Update button Repeat steps 2 5 for each account requiring Cash M anagement The amount and status entered in step 4 appears in the Cash Op section on the Selected Accounts List Cash Management Status Symbols On the Selected Accounts tab various status symbols appear in the far right column These symbols represent various options entered in the Account Cash M anagement dialog These symbols include X Indicates cash exclusion The value entered in the Amount column will be excluded from the current balance before rebalancing the portfolio Indicates a deposit The value entered in the Amount column will be used for buy orders Indicates a withdrawal The value entered in the Amount column will be used for sell orders C197 Fund Rebalancer Appendix C fase frome MBG MELCI POND finds it F E LELEN Canals Exe Me MHI aa rf oe Ws GME GOODS LAS ArH FUH 1 HE TE a LJ Tk lE DLUH DUD ATENT DHAL PIH i LI 1 Mi H Foote CLT OT CALE SS E LI 41 ma 1415 ad C SLATE HJH AHE Lo I LI Mi aa LREN E SLATE HOH DMO LIC Sample Data Figure C 14 Account with Cash Management Exclusion Note The securities displayed are fictional and used for illustration purposes
153. eports on a regular basis 1 M ake sure that the confirmations list that you want to query iS Open From the View menu select Query The Query Builder window opens Figure 5 14 Click Load Query Select a saved query and click Open The previously defined search criteria appear in the Query screen To further refine the search see the section Specifying Additional Search Criteria on this page Click Run Query to begin the search 5 71 Chapter5 Account Viewer Completing the Query SchwabLink conducts the query and displays the results in the Account Viewer window as a new Trade Confirmations Query Results List viewer Figure 5 22 The basis of the query is displayed beneath the title bar oo Se gh decd epee n Doaa jp Bay Lips DS ee lie ene e hi 4 z Timi bia T Te CoP Dra assesses i S bekar r a HISA dete r HU ke Sampin Fann oe Recent eM o l n n is a ELN i EI CR PEHI HEHH aA PEs 4 Tai Bis laa bap 1 SEE Foe io mmr r pii m Beare fe Fee fin Ferag al pmi E Ee Bs Com pio nba eet ia aL E Tene Fa Hig z is Fae ho iT E He Te nm Cor ro ir ie E im raps mi Frc EE Tsi eet mii E LETE PrE ET LLE Figure 5 22 Trade Confirmations Query Results List Viewer Printing the Confirmations List or Query Results List You can print the Trade Confirmations List or a Trade Confirmations Query Results List The lists print continuously on multiple pages if necessary SchwabLink User M anual
154. er eee ank Fumi H erian E mm maare pia rea ih Sample Data Figure C 27 Deleting an Asset 4 In the Update Asset Allocation section click the Delete button 5 Click the Save M odel button Note The securities displayed are fictional and used for illustration purposes SchwabL ink User M anual Changing an Asset s Percentage You may change the weighting of any asset within a portfolio so long asthe TOTAL ALLOCATION value remains at 100 The allocation value may be any whole number To change an asset s percentage 1 Click the M odel Configuration Screen toolbar button To 2 Highlight the model name 3 Highlight the asset you wish to change The asset displays in the Update Asset Allocation section C 204 Appendix C Fund Rebalancer Sar UATE ae GEED HEY LO BO Fee cha ii Ue a LO Talai aura Palen __ i The TOTAL ALLOCATION value must equal 100 The program does not allow you to save partial model portfolios Sample Data Figure C 28 Adjusting an Asset s Allocation 4 Inthe Update Asset Allocation section enter a new value in Adding Cash to a Model the field It s possible to set a percentage of a model s allocation as cash 5 Click the Update button The procedure is the same as adding an existing mutual fund cieee sae Moda buton except that there is a designated symbol To add cash to a model ie Note The securities displayed are fictional and used for 1 Click the M ode
155. er Account in the SchwabLink Account Viewer window 2 Open the viewer you want to see for the M aster Account Select the next M aster Account Open the view without closing the previous viewer The new viewer opens and displays information for the new M aster Account The original viewer remains open display ing the original M aster Account information N ote When you select a new M aster Account number the infor mation in viewers that are already open still relates to the previ ous M aster Account Only the new viewers that you open will show information for the newly selected M aster Account SchwabLink User M anual Opening a Viewer To open a viewer in Account Viewer do one of the following e Click the viewer button on the toolbar e From the View menu select O pen Viewer and select the viewer from the drop down list Closing a Viewer To close a viewer 1 Make sure that the viewer is active 2 From the View menu select Close The activated viewer will close Closing All Viewers All viewers can be closed at once From the View menu select Close All Viewers 5 41 Chapter5 Account Viewer UsiInG BUILD UPDATE The Build Update program builds files on your PC hard drive that contain your most recent account data These files update the data that appears in your Account Viewer windows Each day after the daily download is completed you need to run Build Update to make sure that the most current data is
156. er and path for the network control directory or click on the box to browse and select the desired path 8 Asyou exit the BDE Administrator application it offers to save the changes Click Yes 9 Repeat these steps for all workstations Record Locking When directories are shared by two or more computers it is possible that two or more people will attempt to update the same records simultaneously In order to prevent the same record from being updated by several persons concurrently SchwabLink provides a record locking process With record locking the first person to access the record can update it Everyone else has read only access to that record until the first person releases it by saving changes moving to another record or exiting the file The network administrator must set up the network control directory to make sure that record locking is in effect We recommend that the network administrator complete this procedure before using the system N ote In order to prevent simultaneous multiple updates of records you must perform the steps described on this page in Network Control Directory on every computer that uses SchwabLink 2 3 2 27 Chapter 3 OVERVIEW The Schwab Institutional Web site www schwabinstitutional com simplifies your business dealings with both your clients and Schwab Institutional Used in conjunction with SchwabLink for Windows the Web site and SchwabLink enable
157. es will not be added to the list You return to the Transactions List viewer and the new transac tion file records are added to the grid For each record the Original File R ecord column will list the file from which each transaction was added plus the transaction number within that file For example CS011200 trn 1 indicates that the record was the first in a list of transactions for January 12 2000 Opening an Individual Transactions File A transactions file consists of one day s transactions for one M aster Account In addition to listing all transactions over a certain period of time you can open a file that contains one day s transactions Those transactions will be listed in a new Transactions List viewer when you open the file To open a transactions file 1 From the File menu select Transaction File then Select O pen The Open Transaction File dialog box Figure 5 13 appears 5 59 Chapter5 Account Viewer Sr HE Lk Sra Sl a w Crain wm o Files cd hpa Trertractan bar C9 hn TS an hn 05 ol Cri Figure 5 13 Open Transaction File Dialog Box 2 Select the file that you want to open and click O pen A new Transactions List viewer opens containing only the transactions for the file you have opened Using the Query Command for Transactions Use the Query command to search for display and work with selected transactions on your list If you receive large numbers of transactions each d
158. estriction on the account Abandoned account Blocked account due to Exception Registration Cash and stock up front Required documents or information missing Liquidations only Mail undeliverable No activity pending receipt of documentation Student cash and stock up front Outgoing transfer of account in progress Unemployed cash and stock up front Closed per internal Schwab request N x Cc HAH wn DW Z I ODD Closed per customer request Cash and margin instructions for securities proceeds and dividends Eight digit account number as registered with Charles Schwab amp Co Inc 5 43 Chapter5 Account Viewer Adjusting the Client Information Viewer Display You can change how information in the viewer is displayed To change the order and width of columns or to sort data in the account list see Changing Column Order Adjusting Column Width and Sorting Data on page 5 83 You can also expand the account list display by adjusting the proportions of the two parts of the Client Information viewer 1 Movethe mouse pointer between the account list grid and the account information grid until the cursor changes to a double arrow 2 Hold down the mouse button and move the arrow cursor up until the account list grid covers the information in the upper portion of the screen that you no longer need to view To redisplay the information drag the arrow down Navigating in the Client Information Viewe
159. et Prinia E iei le Haran r Ega en Ci chews ink Deskiopiirpuni Viere Hew Fodder coca Figure 2 16 Add Master Account Dialog Box Tiripa jpam erin pirs kirit Fi Trade Caiena et iid ene pa bend it Fekk hace Mirine dip othe Hue pda paces E Foii Bala F Turana Trace Contenge 3 Select the directory and drive that you want to add Type in the M aster Account number and give the account a description optional This description is useful if you have more than one M aster Account 5 Click the OK button You are returned to the module Preferences dialog box The number and description of your M aster Account plus the directory that contains the M aster Account should be displayed in the M aster Account List You can add as many M aster Accounts as required by repeating steps 2 through 5 Schab Fund Aebalence Pla Coide Poriin Pasta ale Figure 2 15 Preferences Dialog Box Account Viewer SchwabLink User M anual 2 22 Chapter 2 Getting Started Editing and Deleting Master Account Details To edit existing M aster Account details 1 In the M aster Account list in the Preferences dialog box Figure 2 15 click on the M aster Account that you want to edit 2 Click the Edit button The Edit M aster Account dialog box appears Revise the M aster Account number description and destination as appropriate 3 Click the OK button Y our changes appear in the M aster Account list of the Preferences dialog box
160. ettlement Date Action Security Symbol Quantity Security Desc and Price These fields are marked with an asterisk Completing the PB Trade Detail II Page 2 If necessary edit the Trade Date and Settlement Date fields by scrolling backwards or forwards through dates By default the Trade Date field shows today s date and the set tlement date is set at three business days after the trade date N ote Some fields have drop down lists from which you make selections but you can also enter data in these fields To complete the second page of Prime Broker Trade Detail Te ECTE PE TACE eater ran Select a Security Symbol and the Security Description field The PB Trade Detail II page appears Figure 8 3 populates accordingly If the security you want is not shown in the Security Symbol list you can type in the security F Securities Allocation description 3 Select the appropriate action buy or sell from the list File Options Window Help 2 OO O E aaa 5 Enter information in the remaining fields goag i Select Type of Trade to Allocate r Allocation Summar Q uantity N umber of shares being allocated For bonds eoa raas Lae e inked enter the face value for example 25000 not 25 This Total Quantity 0 numeric field accepts whole numbers only PB Trade Detail Principal Interest Commission N et Amount SEC Fee and Trade Date Settlement Date Other Fees N umeric fields that take
161. ever the M odel Configuration or M odel Assignment program is open or displays on the Windows taskbar To access Fund Rebalancer you must first close the other program Getting Help If you have any questions or need assistance contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time M onday through Friday e For investment advisors call 1 800 647 LIN K 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 Option 2 or email rps techserv schwab com Using This Appendix This appendix consists of two main sections The first section is an overview of the program The remaining part of the appendix provides a tutorial designed to quickly introduce you to Fund Rebalancer and the work area Additional help topics are included in each program s built in help function In certain topics one or more program icons may appear next to the title These program icons identify which program s are involved in the task Both the M odel Configuration program and M odel Assignment program are accessed from within Fund R ebalancer The SchwabLink M utual Fund Trading program is accessed from the SchwabLink Desktop SchwabLink User M anual Icon Program Fund Rebalancer M odel Configuration M odel Assignment SchwabLink M utual Fund Trading TUTORIAL There are 10 basic steps involved between creating a model and importing the trade file into the M utual Fund T
162. ext day s download attempt 4 36 Chapter 4 Download Utility Download Utility Logs Changing the number of days the Download Logs for the Unattended PCRA Upload are retained l 2 Select O ptions from the View menu The Download Utility Log information will appear in the lower portion of the dialog box Enter the number of days to retain the log files N ote Zero 0 days means that the logs are only kept for the current transmission and will be deleted the next time the Download Utility is run One 1 or more days means the logs are kept for that number of days So if it s set to 1 then it will keep all of the current day s logs If 2 it will keep the current day and the day before N ote The number of days are date based If the field has the amount set for 2 days and the utility hasn t run for a week all the logs except the current day s will be deleted because the logs are more than two days old One 1 day is the default SchwabLink User M anual 0901 03207 Setting the Number of Download Attempts 1 2 From the View menu select Options Enter the number of download attempts the Download Utility should execute until a successful download is completed N ote T he default setting is 0 zero attempts A retry count 0 means that the download will be attempted once with no retries Click OK Downloading Historical Files 1 Zi From the File menu select Download Files B
163. f the process This file is placed in the Logs folder in the SchwabLink Desktop directory where your SchwabLink files are held For example if SchwabLink is held in C Program Files SchwabLink Desktop the log folder will be under SchwabLink Desktop The log entry for the Build Update process will be placed in this file The log is a text file that can be opened in Wordpad or any text editor You can print this file When Build U pdate is run again in attended mode either for another M aster Account or for another day the log entry is overwritten Rebuilding Secondary Tables As part of Build U pdate the database tables that support Account Viewer are rebuilt O ccasionally it is necessary to reoroduce this function on its own rather than as part of Build Update You may need to rebuild secondary tables when e The Build U pdate process is interrupted before the secondary tables are created e You undo customized changes to the tables To rebuild secondary tables 1 Open Account Viewer 2 Ifyou want to rebuild database tables for one M aster Account select the M aster Account To rebuild tables for all M aster Accounts proceed to the next step 3 From the Tools menu select Rebuild Secondary Tables The following dialog box Figure 5 32 appears SchwabLink User M anual Rebuild Secondary Table Selection E4 f Rebuild secondary tables for selected Master Account Rebuild secondary tables for all Master Accounts
164. fic model s portfolio Click the M odel Configuration Screen toolbar button al Click the Printer toolbar button sae Select M odels by Name from the drop down menu In the M odel Selection select the One M odel radio button In the model drop down list select the model Click the Print button Set any print options such as page range or number of copies 8 Click the OK button a oe ae I E Assets for All Portfolios The M odel Portfolios By Asset report displays a list of all models descriptions and allocations for all assets including To print all model portfolios i 1 Click the M odel Configuration Screen toolbar button zk 2 Click the Printer toolbar button sae 3 Select M odels by Assets from the drop down menu 4 Inthe Asset Selection select the All Assets radio button 5 Click the Print button C 230 Appendix C Fund Rebalancer 6 Set any print options such as page range or number of MODEL ASSIGNMENT REPORTS copies 7 Click the OK button All Model Assignments The M odel Assignment by M odel report provides the following Individual Asset Reports information for each model The M odel Portfolios By Asset report displays a list of all models descriptions and allocations for a specific asset To print the models linked to one asset Click the M odel Configuration Screen toolbar button ia e Linked accounts e Account Description e Current Portfolio values and variance I e Last Order Exp
165. g term capital gain distributions paid in cash cashrt Records all mutual fund short term capital gain distributions paid in cash Set up each of these source and destination codes in your Security Information File SchwabLink User M anual Security and Expense Account Symbols The following security and expense symbols should be defined in your Security Information File The download will transmit these security types and symbols TYPE Cd Cd Cd Cd eX eX eX eX eX ex eX ep SYMBOL mmp gsp tef schwab1 tefra expone exptwo expthre expfour expfive expsix manfee DESCRIPTION Schwab Money Fund Schwab Government Securities Fund Schwab Tax Exempt Fund Source of Schwab One interest credits Interest paid to a Schwab Account will show this as the security symbol Destination of any type of backup withholding Schwab One fees Miscellaneous fees Examples wire charges billing for services IRA Keogh account fees Consolidated fee charged to account Trade Away and Prime Broker fees Dividend reinvestment fee Financial advisor management fees A 163 Appendix A Transaction File Formats USING SCHWABLINK WITH OTHER PROGRAMS SchwabLink works with any spreadsheet software that can import an ASCII text file Check the sections on importing files in your spreadsheet software user manual SchwabLink also works with software programs created and cus tomized to meet individ
166. ge N ote Any subsequent files sent to Schwab will be saved to this new directory To set or change the Upload directory l Z Select Preferences from the O ptions menu Highlight the M aster Account for which you would like to set or change the Unattended PCRA Upload Directory The directory information will appear in the middle portion of the dialog box N ote If the Unattended PCRA Upload Upload amp Archive directories are going to be the same as the general directories you can simply press the copy button located at the top right corner of the Unattended PCRA Upload section Click the Browse button to the right of the Upload Directory textbox N avigate to the new directory from the Set Unattended Upload Directory dialog box Double click on the desired directory SchwabLink User M anual Sel Unattended Upload Daecborg Desigiepn fo E s Dats gt Fast Dats Folder L i Dielau i ia C LOCAL E Selected Dettinatiorr C Daste Fiest Data Folden PCRA_ Defaut DF Carcel Figure 10 17 Set Unattended Upload Directory Dialog Box Click OK Click OK on the Upload Utility Preferences dialog box to save the set up or change N ote Any subsequent files sent to Schwab will be uploaded from this new directory Unattended PCRA Upload Login Information Select Preferences from the O ptions menu 10 154 Chapter 10 Upload Utility Unload Liibe Preberieme gmim
167. gement Fee Processing Worksheet grid do one of the following e Click on the column header that you want to sort by e From the Options menu select the name of the column you want to sort by The column sorts in ascending order PRINTING THE WORKSHEET You can only print the M anagement Fee Processing Worksheet currently displayed in the Worksheet grid To print the displayed worksheet 1 Click amp or select Print from the File menu The Print dialog box appears 2 Specify print parameters 3 ClickOK SENDING FILES TO SCHWAB You must save M anagement Fees files before sending them to Schwab Saved files are automatically placed in the Worksheet Queue for transmission to Schwab Before sending a M anagement Fees file for the first time contact your Firm Security Administrator to ensure that your Schwab Institutional Web user ID has been activated with file upload authorization For further information visit the online help portion of the Schwab Institutional Web site 9 139 Chapter9 Management Fees Saving the Worksheet as a File To save a M anagement Fee Processing Worksheet as a file 1 Make sure the worksheet you want to save Is displayed 2 Click the button or select Save As from the File menu The Save As dialog box Figure 9 7 appears Save As Save in Daa c EE Save at Ippe Management Fee files mta Cancel Figure 9 7 Save As Dialog Box 3 Inthe Save in field s
168. ging Transactions Before the Scheduled Purge Day To purge transactions manually prior to the scheduled purge date 1 Decrease the number of days set in the Account Viewer Preferences dialog box to a number low enough to include the transactions you want to remove Refer to Specifying the Transaction and Confirmation Record Retention Period on page 5 90 2 From the File menu select Purge The Purge Records dialog box Figure 5 18 appears 5 63 Chapter5 Account Viewer Purge Records E4 For Master Account O800000 Found f2 records older than 14 day s Found 3 records older than 90 days J Purge Confirmation records Associated viewers will be closed prior to purging of the tables Figure 5 18 Purge Records Dialog Box 3 Click in the Purge Transaction records check box A Y appears You can also purge your Trade Confirmations List records by clicking in the appropriate check box 4 Click OK SchwabLink deletes the transactions and the con firmations if selected Prior to purging SchwabLink will close any open Transactions and Confirmations List Viewers M ake sure that you reset your automatic Transactions List purge date in Account Viewer Preferences if necessary DEPOSIT WITHDRAWAL LIST VIEWER The Deposit W ithdrawal List Viewer provides next day access to all cash deposit and withdrawal transactions in the selected M aster Account Transactions can be reviewed sorted and queried and
169. going ACAT transfers this status means the transfer form has been transmitted to the NSCC The transfer has a OPEN Opened The transfer request is received by Schwab but not yet DELV status for one day only processed For incoming non ACAT transfers this status means the transfer form For ACAT transfers status remains OPEN until the transfer information has been mailed to the delivering firm The status changes from INIT to is transmitted to the delivering firm through the ACAT system DELV once a Schwab transfer representative processes the appropriate transfer papers The transfer remains in the DELV status until the assets are received by Schwab For Non ACAT transfers status remains OPEN until Schwab transfer representatives receive and process transfer papers SchwabLink User M anual 6 101 Chapter 6 CODE OPT PND RE REVACL REVAD Status Reports DESCRIPTION Option For ACAT transfers that have Option assets transferring these assets settle manually through the OCC The TOA department verifies completion of transfer before manually updating the status to completed Pending For ACAT transfers only the delivering firm advises Schwab of the assets being delivered via the ACAT system The transfer status remains PND for 3 business days unless the delivering firm makes adjustments to the delivering assets If adjustments occur the transfer iS delayed an additional 2 to 3 days Reject The delivering firm r
170. greater than the one you entered gt Select to find values greater than or equal to the one you entered IN Select to find records matching any of the values entered LIKE Select to find records that begin with the value entered 5 Inthe Value field select or type the value you want to locate For example to locate transactions over 100 00 you select Dollar Amount as the Field gt as the Operator and 100 00 as the Value 6 Click Add 7 If you would like to save your Query now for future use click Save Query and enter a file name Click Save to return to the Query Builder screen You may save your query at any stage during the query building 8 If you are finished entering search parameters click Run Query to begin the search To refine your search further go to step 9 in the next section SchwabLink User M anual Specifying Additional Search Criteria You can refine your search by completing additional sets of search criteria For example in addition to specifying transac tions greater than 100 in the first set of fields you can specify that they have a value of less than 200 9 10 11 12 13 Select the And radio button in the N ew Atom section to find records that contain both values you specify Select the Or radio button to find records that contain either set of values you specify Repeat steps 3 through 6 as appropriate to complete the additional search criteria Click Add
171. hapter 8 Securities Allocation G Securities Allocation File Options Window Help ACHE Select Type of Trade to Allocate M i om __ r Allocation Summan i Oo O Schwab Trade Total Shares Remaining O Total Shares Allocated O Total Quantity 0 FE Trade Detail PB Trade Detail Allocation worksheet Inv Manager STUDEBAKER FINANCIAL FAS MASTER ACCOUNT Master Account e000000 Executing Braker LEY Executing Broker Contact LC Capacity of Executing Broker L TM O IPO New Issue Required Field Figure 8 2 Securities Allocation Window Prime Broker Trade View If you have already set up a M aster Account the Investment M anager and M aster Account fields should be populated with your default M aster Account information If these fields are blank you will need to set up a M aster Account R efer to Chapter 2 Getting Started N ote The following fields are required M aster Account Executing Broker Clearing Broker Exchange Capacity of Executing Broker The IPO N ew Issue field is required if you are allocating securities from a new issue or IPO These fields are marked with an asterisk 2 If you have more than one M aster Account make sure that the correct one is selected To change the M aster Account SchwabLink User M anual listed select the appropriate account from the drop down list in the M aster Account field Select the Executing Broker from the drop
172. hat your computer can link to the Schwab computer receive data and display the data you receive Post Setup Sequence for New Users The post setup sequence of activities for new users of SchwabLink differs slightly from post setup for ongoing users If you are using SchwabLink for the first time you must complete the following activities If you need assistance refer to the appropriate section in the SchwabLink User M anual chapter for the module referred to in the steps Today 1 Download your data files from the Schwab computer 2 Set up the Download Utility for ongoing daily downloads and the Build U pdate process starting tomorrow See Chapter 4 Download Utility 3 UseAccount Viewer to run the Build Update function and verify client positions and balances See Chapter 5 Account Viewer 4 Use Account Viewer to view and verify transaction file data See Chapter 5 Account Viewer 2 24 Chapter 2 Getting Started Tomorrow 1 Perform the daily download and process the update file 2 Use Account Viewer to view account and position data for each or all of your portfolios 3 Use Account Viewer to view and verify your most recent files of all transactions you made through Schwab 4 UseAccount Viewer to view and verify confirmation data Post Setup Sequence for Ongoing Users If you have used SchwabLink prior to installing the current Windows version of SchwabLink you have alread
173. he SchwabLink installation and configuration you need to set up the following e M aster Accounts e Account Viewer preferences e Mutual Fund Trading preferences e Status Reports preferences e M anagement Fees preferences e Upload Utility preferences N ote M aster Accounts can be set up from M utual Fund Trading Account Viewer Securities Allocation Status R eports M anagement Fees and Download Utility M aster Account information that is added or deleted in one of those modules is automatically reflected in the others The following section explains how to set up M aster Accounts After you set up a M aster Account refer to the chapters about each module for instructions on setting module specific preferences 2 21 Chapter 2 Getting Started Adding a Master Account 2 If the directory you want to access is not listed in the M aster To set up a M aster Account Account list you need to add it Click the Add button 1 From the Options menu in one of the SchwabLink modules The Add M aster Account dialog box Figure 2 16 appears select Preferences The Preferences Dialog Box Figure 2 15 appears Add Master Account Ej ioc eer FPrelorescens beini ekp c C PT4 Dita E inka as 0 Tnt Cranpare E akaz bad erein clude ah ri Peera errei Fis us ee au EF Ekipi Fiii Fhar V cary Sake ie 0 irei Haha aa Set Cah im Acorn D Eiby Cunha n e a r Baad paces EF kabab Mih bani riara g
174. he columns and fields In the Trade Confirmations List viewer N ote T he Totals fields display summary totals for the list you are viewing The numbers in these fields change each time confirma tions are added to or purged from the Trade Confirmations List This aggregate data is useful for fast reporting on your Schwab trading for one or many accounts For example if you complete a query to display only the previous day s confirmations the aggregate summary data reflects your Schwab trading for that day When you complete a query to display the confirmations for one client account for a specific period of time the aggregate data shows Schwab activity totals for that account for that period For assistance with queries refer to the Using the Query Command for Confirmations section on page 5 70 N ote Although you can customize certain fields and columns such as Account N umber in other viewers the customized values for those same fields and columns do not show up in the Transactions List Deposit W ithdrawal List Trade Confirmations List or Trade Confirmation Detail viewers The fields in these viewers revert to Schwab assigned values SchwabLink User M anual FIELD COLUMN Account Number Symbol CUSIP DESCRIPTION The account number assigned by Charles Schwab amp Co Inc Security symbol Used for identifying and pricing the security that was traded For details see the Symbol field description under
175. he current price per unit that appears in the Price field Note Schwab transfers these prices and dates as part of the daily download Note Price and Date of Price fields may be gray to identify stale prices SchwabLink User M anual Adjusting the Security List Viewer Display You can change how information in the viewer is displayed To change column order and width or to sort data see Changing Column Order Adjusting Column Width and Sorting Data on page 5 83 Navigating in the Security List Viewer To find a record in the viewer do one of the following e Use the record navigation keys and the record navigation functions in the Window menu to move through the securities in the list e Scroll or page through the list until you locate the record you want e Use the Find command to locate the record See Using the Find Command on page 5 81 Double click on any record in the security list to display the Composite view for that security in the Composite Security Positions viewer Printing from the Security List Viewer You can print a list of all securities in a selected M aster Account or only those securities that have a stale price Stale prices refer to security prices with price dates prior to the last Build Update date To print a securities list from the active Security List viewer 1 Click the print button on the toolbar or select Print from the File menu The Security List Print Sele
176. he file extensions so that the file names read as follows cs062300 bld cs062600 upd cs062700 upd cs062800 upd cs062900 upd and cs063000 upd 6 Open Account Viewer and select the M aster Account you want to view 7 From the Tools menu in Account Viewer select Change Update Date The Change Update Dates dialog box Figure 5 34 appears SchwabLink User M anual Change Update Daler 18125458 Chargers the upelate cate val MOT change Pa ateari sakt Io lha macia dale K D 06 22 2000 Curent Date zamo H Curen Date Las Ueda of Piei B ree Lact updsle of Tenesi Last upise of Corer ri Figure 5 34 Change Update Dates Dialog Box The dialog box should show the date when Build U pdate for positions and balances was last run 8 Using the scroll arrows change the date for Last update of Positions Balances The date should be any day prior to the date of the build file In the example from step 5 the date can be set to 6 22 2000 the day before the build file date of 6 23 2000 9 Click OK 10 Run Build Update See Running Build Update on page 5 77 A message appears indicating that a more recent build file is required In this instance this message can be ignored Account Viewer will now show your data as per the date selected 5 80 Chapter5 Account Viewer To restore your data to the current date follow the same proce dure Rename the file extension for the most recent buil
177. he retention period in days for transactions and or confirmations Rebuild Consolidated Portfolios for Fund Rebalancer If you use Fund Rebalancer select this option to automatically rebuild the consolidated portfolio tables immediately upon completion of the Account Viewer Build Update See Appendix C Fund Rebalancer N ote This option is available only if Fund R ebalancer is installed 5 90 Chapter 6 Status Reports OVERVIEW The Status R eports module contains the following reports Transfer of Account TOA Status Shows the status of your requests to transfer accounts to Schwab The report displays TOAs sorted by Schwab client account number with completed TOAs listed first This data is available on a daily basis TOA Complete Shows completed requests to transfer accounts sorted by account number This data is available weekly on M onday Event N otifications Displays notifications regarding changes bond calls bond rating changes etc to fixed income securities held in client portfolios N otifications are listed by security Deposits amp Withdrawals Summarizes the preceding busi ness day s cash activity The report displays deposits then withdrawals by account number with totals for both Confirmation Summary Summarizes the preceding business day s trade activity The report displays buys then sells by account number N ote N ew SchwabLink users will receive this informa
178. his should include any specific instructions for the Schwab Institutional Trading Desk If necessary edit your field entries by highlighting the infor mation and typing in new information over the highlighted text Or where applicable make a new selection from the drop down list Entering Prime Broker Trades Before you begin to enter and allocate Prime Broker trades make sure that the order has been placed and that you have the follow ing information e Name of the security symbol or CUSIP CUSIP may not be available for new issue bonds Total buy or sell price of the trade Broker s commission if any N umber of shares or face value for bonds being allocated Action buy or sell A list of the accounts to which these shares are to be allocated and the quantity of shares to be allocated to each account N ame and capacity of the executing broker N ame of the clearing broker if different Stock exchange on which the shares were traded Whether the shares were PO N ew Issue Completing the PB Trade Detail Page To complete the PB Trade Detail page 1 Select the Prime Broker Trade option button The PB Trade Detail page Figure 8 2 appears M ake sure that the PB Trade Detail tab is selected You have now completed the Schwab Trade D etail page and are ready to complete the Allocation Worksheet See Adding Information to the Allocation Worksheet on page 8 125 SchwabLink User M anual 8 122 C
179. his user manual is available on the CD ROM ina file compatible with Adobe Acrobat Before You Begin In order to download data from the Schwab Institutional Web site to SchwabLink your firm needs access to the Schwab Institutional Web site Each user within your firm must have a SchwabLink User M anual valid user ID and password Schwab Institutional initially sets up one user ID and password for each firm Contact your Firm Security Administrator for additional user accounts If your firm does not have access to the Web site or you do not have an initial user ID and password your Firm Security Administrator should contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time M onday through Friday e For investment advisors call 1 800 647 LIN K 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 Option 2 or e mail rps techserv schwab com Recommended System Configuration To use SchwabLink effectively we recommend that you havea personal computer that meets these minimum requirements SYSTEM COMPONENT RECOMMENDED MINIMUM Operating system Microsoft Windows 98 or Windows NT 4 0 with SP 6 or Windows 2000 with SP1 Processor Pentium 200 MHz or faster Memory 64 megabytes of RAM Hard drive 200 megabytes of free space to install all applications Internet Connection 56 6 Kops modem or higher or a persistent Internet connection such as T1 ISDN DSL o
180. hlighted do one of the following e Click on the row that you want to highlight That row is highlighted and the incorrect row is no longer highlighted e From the Edit menu select Deselect The row is no longer highlighted 7 107 Chapter 7 Mutual Fund Trading Linked Trade Orders Use the linked trades feature to link the proceeds from a sell or group of sells to a buy or group of buys for one client The procedures in this section show you how to e Create swaps in the M utual Fund Template window e Create linked trade orders in the Linked Trades window e Duplicate linked trade orders e Edit and delete linked trade orders Linked Trade Requirements When creating a linked trade order be aware of the following e The proceeds from the sells are applied to the buys on the sub sequent business day according to the percentages specified You must always start with at least one sell trade order The total value of the buys cannot exceed 100 If the buys total less than 100 of the sells the unused sell proceeds will go to the client s cash account You cannot create a linked trade order from a dollar sell Sell or Sell Commission There must be at least one Sell Sell All or Sell Shares and at least one Buy Buy isthe only buy action available for linked trade orders A maximum of 30 trade orders can be linked in one trans action That is you can link 1 sell to 29 buys or 14 sells to 16 buys a
181. ht side of the window and typing in the new information as appropriate 5 86 Chapter5 Account Viewer If you want to customize all the account information simply begin entering data into the fields on the right hand side of the window 5 Repeat steps 3 and 4 for every account that you want to cus tomize 6 When you finish customizing accounts for this M aster Account click Customize 7 Click Close Editing Customized Account Data To edit customized account data 1 Select the M aster Account that contains the information you want to change From the Tools menu select Account Customization Select the account Change the details in the right hand side of the Account Customization window 5 Click Customize 6 When you finish editing the details of your customized accounts click Close Restoring Schwab Assigned Values To restore Schwab assigned values 1 Select the M aster Account that contains the information you want to change From the Tools menu select Account Customization Select the account Click Erase SchwabLink User M anual The details are removed from the right hand side of the Account Customization window Click Customize When you finish erasing customized values for your selected accounts click Close Customizing Security Information To customize security symbols and names 1 Select the M aster Account that contains the securities you want to customize 2 From the T
182. hwab Trade view shown in Figure 8 1 If this view is not displayed make sure that the Schwab Trade option button and the Schwab Trade Detail tab are both selected 8 121 Chapter 8 Securities Allocation N ote The following fields require data M aster Account Action Security Symbol Quantity Price and Trade Date These fields are marked on screen with an asterisk Complete the M aster Account Action and Security Symbol fields by selecting the appropriate values from the drop down lists Completing the Security Symbol field automati cally populates the Security Description field In the Quantity field enter the total number of purchased or sold shares up to a maximum of nine characters This field allows only whole shares In the Price field enter the purchase or sell price of the shares does not include commission This field can hold up to 14 characters including a maximum of 4 decimal places The Trade Date field automatically defaults to today s date If you are allocating the shares proactively or retroactively use the scroll arrows to select the appropriate date Enter the contact name and phone number of someone who may be contacted by the Schwab Institutional Trading D esk in the event of any questions on your data In the N ote field you can enter up to 256 characters of information or comments about the allocation The first 56 characters of data will be sent to Schwab with the worksheet file so t
183. i ii File LT ba ida Fa iri o oe a de E i WF rH E We a ras yiri 7A Fil E ng Semple Cinta Lr ne fT eee E rae mo 8 i E Hi S es HUPE i E ite i Figure C 19 Approved Orders MPOT ONA Gneenilielhs To remove an account from approval 2 Click the red checkmark x for the account N ote If the Exclusions Cash M anagement O ptions or other factors resulted in 0 trades being generated for an account the account will not be marked for approval Note The securities displayed are fictional and used for illustration purposes SchwabLink User M anual C 197 Appendix C Fund Rebalancer The final steo within Fund Rebalancer is the exporting of the orders This process creates a single trade file containing all approved orders The resulting order file must be imported into the M utual Fund Trading module for submission to Schwab N ote Since Fund Rebalancer is designed to clear order data whenever a session is either closed or initiated we strongly recommend that you either print or save your reports prior to exporting your files To create the export order file 1 Click the Export Approved Order to M FT toolbar button Figure C 20 Order Export dialog SchwabL ink User M anual 2 Notethe name of the exported file and the directory where it s saved 3 Click the Export button The export file is created and a small email icon appears in the last column where the app
184. ierg Gacond Haze ccout CDa Second Datis Folie fuctive Diectoy E Daa en Daa Foiea O Default Directory CAData Fis Cate Fokis Diela E Unsiiended FORA Upload Copy Cies gt Uplosd Directory CADataFist Data Folden PCR Defaut w Unaltended PORA Upload Login Infomation Uke 1D l Pasaord Delai Master Account 19000000 Defaut Fle Typa Ureecead Tiades Keep Upload Unity logs for aa Figure 10 18 Upload Utility Preferences Dialog Box SchwabLink User M anual 2 Enter in the www schwabinstitutional com User ID and Password 3 Click OK on the Upload Utility Preferences dialog box Upload Utility Logs Changing the number of days the Upload Logs for the Unattended PCRA Upload are retained 1 Select Preferences from the O ptions menu 2 TheUpload Utility Log information will appear in the lower portion of the dialog box 3 Enter the number of days to retain the log files N ote Z ero 0 days means that the logs are only kept for the current transmission and will be deleted the next time the Unattended PCRA Upload utility is run One 1 or more days means the logs are kept for that number of days Therefore if it s set to 1 then it will keep all of the current day s logs If set to 2 it will keep the current day and the day before N ote The number of days is date based If the field has the amount set for 2 days and the utility hasn t run for a week all the logs except the current
185. inimized SchwabLink uses the dp deposit and wd withdrawal transaction codes to record the movement of funds to or from money market accounts or between a cash and margin account In the daily transaction file that you download one of the Schwab cash security types listed in Source and Destination Codes on page A 163 is always used as the source or destina tion of the funds involved in the transaction Example One of your clients has a money market balance of 100 000 As his advisor you decide to buy 50 000 worth of stock in the cash account The day after the trade date the money market balance remains at 100 000 but the cash account shows stock valued at 50 000 and an outstanding debit of 50 000 for the purchase of the stock due on settlement date On the settlement date 50 000 is withdrawn from the money market account and deposited into the cash account A 160 Appendix A Transaction File Formats to pay for the stock purchase The money market balance is reduced to 50 000 the outstanding debit of 50 000 is settled and the cash account has stock valued at 50 000 As a user if you are not clearing transactions through a cash account the transaction would be recorded in the following manner Now editing TABLE BLOTTER PORT TC DATE TY SECURITY DOLLAR SOQURCE QTY BROKER COMMISS CODE SYMBOL AMT DEST CODE AMT Jones by 032290 cs icm 5049 00 mxmx 45 00 schwab 49 00 N ote how the
186. ion and or Destination fields as appropriate N ote If you change the M aster Account N umber make sure that you do not use a preexisting Account If you enter a preexisting M aster Account N umber a warning appears Figure 10 6 10 146 Chapter 10 Upload Utility e Click Yes to cancel the edit Then click OK to return to the Upload Utility main menu OR e Click No to overwrite the information then click OK You are returned to the Upload Utility Preferences window and the changes are reflected in the grid Click OK to return to the Upload Utility main menu Wap F dice Cb f The Bipi Apia irabia ireti Fahy pakina ina irv aie bada sai y a ery mag tary They ral poured data bi hep irean oral iy iiny n negi iaren Ghee wou deecaed thn change nr Oe pau enh be ho a Figure 10 6 Preexisting Master Account Conflict Editing Data Paths To edit a M aster Account data path 1 Select Preferences from the Options menu 2 Highlight the M aster Account to edit 3 Click the Edit button or press ALT E on the Upload Utility Preferences dialog 4 Select the new folder where the data should reside Click OK SchwabLink User M anual Deleting Master Accounts When you delete a M aster Account from the Upload Utility Preferences dialog box the database is not erased Only the M aster Account number is deleted from the O ptions Preferences screens of all SchwabLink applications If you wish to reinstate a M as
187. ion file Because Schwab does not credit client accounts until it receives payment from the appropriate source there may be a delay of several days before a transaction appears in the client account If a performance report is run the day after month end the numbers may not match the Schwab monthly statement because the transactions are yet to be posted Schwab s policy is to pay all distributions within a five day window of the actual payable date SchwabLink s use of the actual pay date is consistent with accrual accounting procedures A 158 Appendix A Transaction File Formats e Security type One of the Schwab defined security types ca Cash Equivalent mf M utual Funds Taxable cb Corporate Bond cd Certificate of Deposit mn M utual Funds N on taxable cl Call Option oa Other Assets cp Convertible Preferred ps Preferred Stock cs Common Stock pt Put Option dl Reorganization to Treasury Bill tn Treasury Note un UIT Non taxable eo Expense Account ex Expense Account gb Government Bond ut UIT Taxable gm GNMA wt Warrants ip Index Participation zt Zero Coupon Bonds Contracts Taxable mb M unicipal Bonds e Security symbol Schwab downloads security symbols from the following sources and in the following format Primary NYSE AMEX NASD ticker symbols Schwab uses the standard industry accepted ticker symbols frequently used by major financial newspapers and by quotation services such as Quotron
188. irectory to a shared directory on a network server or designated peer workstation You specify the data directory accessed by SchwabLink applications in the Preferences section of the applications Directories are created as needed through the Preferences dialog box In order to share the data the workstations should have access to a common network drive and directory Refer to the sections that follow for specific guidelines on installing SchwabLink on client server and peer to peer networks N ote Installing this program adds the Borland Database Engine which may replace an existing version on your computer In addition it creates entries in the system Registry file Network Installation Tips Before installing SchwabLink on your network review the following points with your network administrator who may need to make changes The network administrator normally performs these operations because they may affect the operation of the computer or of applications already installed 2 25 Chapter 2 Getting Started N ote For time saving tips on installing SchwabLink on four or more workstations contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time M onday through Friday e For investment advisors call 1 800 647 LIN K 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 Option 2 or email rps techserv schwab com Before Installing Shared Data Directory
189. irmation Purge message the next time you open the Trade Confirmations List Viewer Purging Confirmations Before the Scheduled Purge Day To purge confirmations manually prior to the scheduled purge date 1 Inthe Account Viewer Preferences dialog box decrease the entry in the Confirmation records retention period days to a number low enough to include the transactions you want to remove Refer to Specifying the Transaction and Confirmation Record Retention Period on page 5 90 2 From the File menu select Purge The Purge Records dialog box Figure 5 25 appears 5 73 Chapter5 Account Viewer Purge Records lt For Master Account 0800000 Found records older than 90 day s C Purge Transaction records Found records older than 90 dafs C Purge Confirmation records Associated viewers will be closed prior to purging of the tables Figure 5 25 Purge Records Dialog Box 3 Click in the Purge Confirmation records check box A v appears You can also purge your Transaction List records by clicking in the appropriate check box 4 Click OK SchwabLink deletes the confirmations and the transactions if selected Prior to purging SchwabLink will close any open Transactions and Confirmations List viewers M ake sure you reset your automatic trade confirmations purge date in the Account Viewer Preferences dialog box if necessary Storing Your Trade Confirmations Each day a c
190. it W ithdrawal List or Deposit W ithdrawal Query Results List 1 Makesure the list you want to print is active 2 Click the Print button on the toolbar or select Print from the File menu The Print dialog box appears 3 Set appropriate print parameters and click OK SchwabLink prints the the active Deposit Withdrawal List or Deposit W ithdrawal Query Results List TRADE CONFIRMATIONS LIST VIEWER The Trade Confirmations List viewer Figure 5 20 provides next day access to trade execution reports for all trades that you placed through Schwab N ote T he viewer retains records for trade confirmations that take place within the time period you specify in the Confirmation records retention period days field of the Account Viewer Preferences dialog box See Specifying the Transaction and Confirmation Record Retention Period on page 5 90 SchwabLink User M anual Trade confirmations can be reviewed sorted and queried and dol lar totals can be tracked As with the Transactions List viewer you can have the Trade Confirmations List updated automatically as part of Build Update or you can add the confirmations manually nE Figure 5 20 Trade Confirmations List Viewer D ouble click on a row in the list to be taken to the Trade Confirmation D etail Viewer for that record 5 66 Chapter5 Account Viewer Fields and Columns in Trade Confirmations List Viewer The following table lists and describes t
191. ite demo Take a tour of the Web site to learn more about the key features Balances View intraday balances of your client s accounts which reflect transactions deposits and withdrawals that occur during the day Available account information includes total account value cash balance and cash available to withdraw Positions View intraday security holdings for your client s accounts that are valued based on delayed quotes Account information includes securities market value and dividend reinvestment options Electronic Account Submission Electronically submit account holder information to Schwab Institutional and receive a reserved account number immediately O nly available to investment advisors Web Forms Improve the speed and accuracy of completing forms by accessing the most current version of frequently used forms online Accelerate the completion process by auto populating account holder information from a desktop database U pload Activity Log Check the receipt of your uploaded files 3 28 Chapter 3 Schwab Institutional Web e Web Trading Place trades of individual securities via the Internet Access real time quotes and online trade order status e Mutual Funds Search by fund family name or symbol Create view and print complete or customized lists of funds Access individual fund facts performance data changes and updates e Individual Securities Research Provides complimentary resea
192. ities are allocated the allocation information is sent to the Schwab Institutional Trading Desk for processing In order to use Securities Allocation you must set up at least one M aster Account Refer to Chapter 2 Getting Started The procedures in this chapter show you how to e Open and exit the Securities Allocation module e Allocate securities traded via Schwab or Prime Broker e Save Allocation Worksheets to a file e Send files to Schwab for processing Print Allocation Worksheets e Open existing files e Import external files Prerequisites To use the Securities Allocation module you need the following e At least one M aster Account that is set up To set up a M aster Account for the first time see Chapter 2 Getting Started e Trade allocation information for each client account See Entering Schwab Trades on page 8 121 and Entering Prime Broker Trades on page 8 122 e Schwab Institutional Web site user ID and password that are authorized for trading SchwabLink User M anual If you are not sure of your user ID and password or do not know whether your ID is authorized for trading contact your Firm Security Administrator FSA Main Steps Using the Securities Allocation module to send a Securities Allocation file to Schwab involves four main steps 1 Enter or import trade data into the Schwab Trade or Prime Broker Trade view of the Securities Allocation module Send the Securities
193. ities purchased 0612 1998 0671271998 Figure 6 5 Horizontally Tiled Report Viewers i To tile viewers vertically click the button or select Tile Vertical from the Window menu The reports appear tiled as shown in Figure 6 6 SchwabLink User M anual j SchwabLink Status Reports File Edit Options Window Help Te I 4 ETL E At Deposits amp Withdrawals PI j EG cap TOA Status Sample Data J LIVERMORE INVESTMENTS 610 W SCHWABLINE BD ST J LIVERMORE INVESTMENT PHOENIX AZ ATTN JESSE LIVERMORE 610 W SCHWABLINE RD STE PHOENIX Az 99462 MASTER ACCOUNT NUMBER O Dear Financial Advisor MASTER ACCOUNT NUMBER Charles Schwab Co In Dear Financial Advisor assets pending or in pro The following DEPOSITS Account 5756 9230 5AM V Date Type NEWUFELLOW On l on W061 21 998 f 10671271 995 Confirmati ELGOI cap Event Not Ted Ea Figure 6 6 Vertically Tiled Report Viewers Cascading Open Report Viewers To cascade open report viewers click the button or select Cascade from the Window menu The reports appear cascaded as shown in Figure 6 7 6 96 Chapter 6 Status Reports mal SchwabLink Status Reports File Edit Options Window Help Te A k 4 TEAL El gt TOA Status Sample Data cP Event Notifications ci Confirmation Summary A TOA Complete A Deposits amp Withdrawals J LIVERMORE INVESTMENTS INC ATTN JESSE LIVERMORE 610 W SCHUARLINE RD STE 300 PHO
194. k SchwabLink Desktop 2 3 to install the application We recommend that you install SchwabLink 2 3 first then install other applications as needed A welcome screen Figure 2 2 appears N ote A message may appear indicating that you do not have Administrator privileges We recommend that the installer have Administrator privileges Tehas ee Welcome lo the Incialliheeld Wied ioe ScheablLink Deckioe The Wells heehee eal eta 5 cheeebLinks Daki On Poul Ooanpubey To continua cbc Meet Figure 2 2 Welcome to SchwabLink Desktop Setup Screen 4 Click the N ext button The SchwabLink Software License Agreement window Figure 2 3 appears SchwabLink User M anual Tehas Oe ee Lines Aqeemneni Pewee nasd they Indien rene ageme caeu READ E STT OH 45 OCENG OW THE YES BUTTON WLL INDICATE YOUR JAGAREENENXT TO THESE TERMS AMD COMDITIONE De peu acces all the bei af the pecie Liceroe Agaa l pou i Ho Bae tue val cies Ta mial a Dip a dl accep the ee Figure 2 3 Software License Agreement Window Review the software license agreement To accept it and continue installation click the Yes button To decline and end the installation click No If you click Yes the User Information window Figure 2 4 appears 2 15 Chapter 2 Getting Started SheabLink Geskiop Setup Ej Certo nimm Peace end ecu information Pisa erim pou nare ered Da rara of thes pogar Gor viem you rear jiii Here Cha
195. l Configuration Screen toolbar button illustration purposes 2 Highlight the model name 3 IntheAdd Asset Allocation section select from the drop down menu This is the very last entry SchwabL ink User M anual C 205 Appendix C Fund Rebalancer De Fan T teen a STATE HIMA EDL HLL WJH FIET STATE miki BOM LIDIA TOTAL CA Te Sample Data Figure C 29 Adding Cash to a Model 4 Inthe Asset Allocation section enter a new value in the field 5 Click the Update button ADDING A New FUND To A MODEL The Add Asset Allocation list is dynamically built from the SchwabLink portfolio database and only contains funds presently held in accounts SchwabL ink User M anual To add a new fund to a model 1 Click the M odel Configuration Screen toolbar button a 2 Highlight the model name 3 Inthe Update Asset Allocation section type the 5 character fund symbol in list box The description line remains blank Coe Fag h baat GC STATE HIE EDET HYLDER BIAN FLEN STATE miti peek LIACH TOTAL ALLA Sample Data Figure C 30 Adding a Fund Not Linked to Master Account The Asset Description line will not indicate the name of the new fund until the position is reflected in a client account Note The securities displayed are fictional and used for illustration purposes C 206 Appendix C Fund Rebalancer 4 Inthe Update Asset Allocation section enter a new value in the field 5 Click the Up
196. lbar from the Options menu When you select to show the toolbar a check appears next to the option To hide the toolbar select the option again and the check disappears Adjusting the Width of the Master Account List To adjust the width of the list 1 Movethe cursor over the right hand border of the M aster Account list until the pointer changes to a double headed arrow 2 Hold down the left mouse button then drag the border in the direction you want the border to move 3 When the list is the appropriate width release the mouse button Tiling Report Viewers If you have more than one report viewer open you can tile or cascade them for ease of use Viewers can be tiled horizontally or vertically 6 95 Chapter 6 Status Reports To tile viewers horizontally click the button or select Tile H orizontal from the Window menu The reports appear tiled as shown in Figure 6 5 4 TOA Complete _ JOE x 4 TOA Status J LIVERMORE INVESTMENTS INC 610 W SCHWABLINE ED STE 300 PHOENIX AZ agoa MASTER ACCOUNT NUMBER 08001234 J LIVERMORE INVESTMENTS 610 W SCHWABLINE FD SUITE 300 PHOENIX 42 395016 J LIVERMORE INVESTMENTS INC ATTN JESSE LIVERMORE 610 W SCHWABLINE RD STE 300 J LIVERMORE INVESTMENTS INC ATTN JESSE LIVERMORE 610 W SCHWABLINE RD STE 300 FHOENIX AZ 19462 The following trades have been confi J LIVERMORE INVESTMENTS INC ATTN JESSE LIVERMORE 610 W SCHWABLINE RD STE 300 Secur
197. lect Paste from the Edit menu to paste the copied report into the new location or document Deleting Report Files You can delete older reports that you no longer want to view You can delete only one report at a time To delete a report file 1 Click on the title bar of the Status Reports viewer that contains the report you want to delete 2 Select the tab that displays the specific report you want to delete 3 Click the button or select Delete from the File menu The Confirm dialog box appears Figure 6 10 T Delete Deposits amp Withdrawals 0671271998 Cancel Figure 6 10 Confirm Dialog Box SchwabLink User M anual 4 Click OK SchwabLink deletes the report file N ote This procedure does not delete the file from the computer rather it deletes the file from the Status R eports viewer SETTING PREFERENCES From the Options menu select Preferences The Status R eports Preferences dialog box appears Figure 6 11 Preferences Sample Data C Program Files S chwabLink Deskt D Masimized New Document Layout a ae Tiled Vertically a ae Tiled Horizontally Cascaded D Minimized Master amp ccounts CCC z Master Account Data Directory i Aen 4ctong _ el arergelconsonMiriice sl E Pint Recent Repotson Statue Arrange el arergelconsonMiriice sl E Pint Recent Repotson Statue on Minimize All CJ Print Recent Reports on Startup Text Options Sample Font Size ee Courier New g
198. lect a filter by clicking the box to the left of the filter name To get a more detailed view of the criteria double click the selection or click the Edit button The Filter Builder Figure B 5 appears See Accessing the Filter Builder Window on page B 170 for more information If you determine that the selection criteria need to change follow the instructions as needed in M odifying an Existing Profile on page B 170 and Filtering on Comment Lines on page B 175 Running the Filter in Manual Mode You can filter a transaction file manually whenever necessary To run a filter in manual mode 1 Open the transaction file s by clicking the O pen Files icon The File O pen dialog box appears Figure B 15 File Open File pane E JES T ic lenia cn ia tin a L oe OF ten PET J dala Hne List piep of epee Ditwes Tiancazion Fides CS e T Figure B 15 File Open Dialog Box B 176 Appendix B Transaction File Filter Click on the file name of the transaction file to filter The file appears in the File name field To choose a file in a different directory select the appropriate drive in the Drives field then navigate to the correct directory in the Folders field If you want to select only one file go to step 5 If you need to select multiple files you can do so with the Shift Ctrl and Arrow keys To open consecutive files hold down the Shift key then click on the first an
199. less it is a variable such as an amount in which case you must type it in Enter all criteria via this dialog box Figure B 12 Entering Filter Criteria 2 Click theOK button The criterion appears in the main portion of the Filter Builder The SL Filter Criteria portion disappears Example To create a profile that includes all dividend and buy transac tions enter criteria with the Transaction Code equal to dv or by for Advent format or div or buy for Generic format 3 Click the Add button to enter the second selection 1 Enter Field Name Operator and Value 4 Inthe And Or field select Or This field does not apply to the first line of a profile Example Under Field N ame enter Transaction Code on eee A oo male operator anA yae le Under O perator enter EXAmp E Under Valieventavdusormdventor div Under Field N ame select Transaction C ode for Generic Under O perator select Under Value select by for Advent or buy for Generic SchwabLink User M anual B 174 Appendix B Transaction File Filter 6 Click OK 7 From the Filter Builder click the Save button to store the pro file The SL Filter N ame dialog box appears Figure B 13 SL Filter Name ries iak Lia Desmi Figure B 13 Saving a New Profile in the SL Filter Name Dialog Box 8 To save the profile enter the name and description and click the OK button to complete the save action Click Cancel if you do
200. lete All Confirmation Box 2 Click Yes All trade orders are removed 71 111 Chapter 7 Mutual Fund Trading Importing Trading Files You may want to send Schwab a trade file that was created with Fund Rebalancer see Appendix C a spreadsheet or portfolio management software Each trade record must adhere to the format rules and parameters described on the next several pages in Import File Format Requirements H eader Record Format Parameters and Trade Record Format Parameters These requirements enable SchwabLink to process the record and edit it for errors inconsistencies and discrepancies If you have any questions contact your assigned Trading Desk There are two ways to send these files to Schwab e Via the browser and the Schwab Institutional Web site www schwabinstitutional com Import the files into the M utual Fund Template and send to Schwab To import correctly formatted files into the M utual Fund Template 1 From the File menu select Import External File The Import dialog box Figure 7 8 appears 2 Inthe Look in field select the drive and directory where the Import file is held The Files of type field is set to External Import file and only files with txt or prn file extensions are listed in the window To view all file types select All Files in the Files of type field SchwabLink User M anual Import x Look ir 08000000 c File name
201. lly logs an audit trail of the most recent download from the Schwab Institutional Web site This log can be displayed automatically after a successful download To review the files that were downloaded in your most recent download 1 Start up the Download Utility module as described earlier in Launching Download Utility 2 From the View menu select Processed File List The M ost Recently Processed Files window is displayed This window shows Information about the file s that were copied to the workstation or network drive in the most recent down load The window shows the directory where the file was copied along with the file name SchwabLink User M anual Do one of the following A If you do not want to view the file list after every download i Select Show this window after files are downloaded An empty check box indicates that this window will not be displayed automatically after every file download li Click OK B To view the file list after every download Select Show this window after files are downloaded An X in the box indicates that the window will be displayed automatically after every file download li Click OK To change the number of days the log Is retained select Options from the View menu i At the bottom of the Options Window enter the number of days the log should be retained The default setting is one 1 day which means the log will be overwritten during the n
202. log box disappears The changes you have made are shown in the Filter Builder listing 10 Repeat steps 4 9 for as many lines you need to change 11 You have two choices for saving the altered profile e Save the changes you made as a new profile with a different name which is the recommended approach To do this click the Save As button in the Filter Builder dialog box The SL Filter Name dialog box appears Figure B 8 Type in the new name and description in the name field and click OK SL Filter Name Film Hara Figure B 8 SL Filter Name Dialog Box e Save the changes in the same profile To do this click the Save button SchwabLink U ser M anual After completing either of the above actions the SL Filter main window reappears The next time you access the Setup Filter function you see the new filter listed in the dialog box N ote If at any point during the editing process you do not want to continue click the Cancel button To add a line 1 Click the Setup Filter button 2 Highlight the profile to which you will add a line 3 Click the Edit button 4 The Filter Builder appears 5 Click the Add button The SL Filter Criteria portion of the dialog box appears at the bottom Figure B 9 This part of the screen allows you to enter an additional criterion to the bottom of the profile by specifying the name operator and value of a field OCTET ee l S E em re rAr mrii esd eed i me ruts e
203. n the Schwab Trade or Prime Broker detail pages and the Allocation Worksheet Printing Securities Allocations You can print one or more pages of your Securities Allocation information Securities Allocation prints a report of the data that you have entered for a particular file The first page of the report consists of the trade and broker information The subse quent pages list the allocations by client account that is the worksheet grid To print one or more pages of your allocation file 1 Open the file 2 Click the S icon or select Print from the File menu The print dialog box appears Set your print parameters Click OK IMPORTING TRADE FILES This section explains how to import a correctly formatted file from spreadsheet software For an example of how to import only the allocation details from a M icrosoft Excel spreadsheet see Example Importing an Excel Spreadsheet on page 8 132 To import information from a spreadsheet file into the Security Allocation module 1 Format the file as described in one of the following sections Schwab Trade File Format or Prime Broker Trade File Format 2 From the File menu in Securities Allocation select Import Schwab Trade File or Import Prime Broker Trade File SchwabLink User M anual 3 Inthe Open dialog box Figure 8 8 select the drive and directory of the file you want to import 4 Inthe Files of type field select All to view the file
204. nality is especially important when you run the Download All N ew Files function on an unattended basis using event scheduling software 4 31 Chapter 4 Download Utility Download All New Files Setup and Procedure To set up and execute the Download All N ew Files function of the Download Utility 1 Start up the Download Utility module as described earlier in Launching Download Utility on page 4 30 2 From the Security menu select User ID and Password A window is displayed in which you can enter your user ID and password 3 Enter your user ID and password For security purposes the password that you enter is not displayed in clear text 4 Click OK to save your entry The user ID and password are stored in the Download Utility If you want to exit without entering a user ID or changing your password click Cancel N ote If you log on to the Schwab Institutional Web site and change your password which you need to do the first time you log on to the Web site you will also need to change your password in the Download Utility in order to use the Download All N ew Files 5 From the File menu select Download All N ew Files This action logs you into your ISP using dial up networking logs into the Schwab Institutional Web site with the user ID and password you specified in Step 3 and downloads all your new files This operation is the same as the one per formed by the Download All N ew Files function of
205. nce process ho the celested accourts produce similar problems and may need adjusting Step 7 Reviewing Orders Aja The order review step is one of the most critical steps in the Fund Rebalancer process This step allows you to review both the account Order List and Projected Portfolio It s important to note that the contents of the Order List tab can t be changed Each account s order list is either accepted as Is or the list is regenerated using different parameters such as rebalancing method Actual Portfolio This panel displays the account s current holdings It also indicates any mutual funds or cash marked for exclusion The chart section displays pie charts for the current portfolio and the assigned model target portfolio Figure C 15 Order Generation 3 Select a Rebalancing M ethod The Difference section represents the difference between the N ote Additional information on Rebalancing M ethods is Target M odel portfolio and the Projected portfolio For excluded available in the Fund Rebalancer section of this appendix assets the Difference column always displays zero beginning on page C 215 4 Select an option from the Fund Standing Instructions list box 5 Enter any values for Minimum Order Thresholds Click the Launch button SchwabLink User M anual C 194 Appendix C Fund Rebalancer FI Pe Se Sample Data Figure C 16 Actual Portfolio tab
206. nchecked box Indicates that the task will not run automatically after a download ii Click OK C To enable the completion task that has been set up Select Task Enabled A checked box indicates that the task will run automatically after a download is complete ii Click OK MAINTAINING FILE DIRECTORIES After the initial installation and setup of the Download Utility you can review or update the directories where files for a particular M aster Account are copied If you set up a new M aster Account at Schwab Institutional you must manually add the new M aster Account to the Download Utility Destination M ap To maintain the file directories do the following 1 Start up the Download Utility module as described earlier in Launching Download Utility From the View menu select Destination M ap The file directories that have been specified for each M aster Account are displayed Figure 4 2 If no directories are set up the map is empty 4 33 Chapter 4 Download Utility SchwabLink Date File Destination Mop Add Destination ED Moher Accel Chencniption asima pa Fijian Files G Account oem Fie Fcuten LEH ima c MT a Edi Arnd Dalata ia Selected Destinations C Fiap Fier rah LE e hp Figure 4 2 File Destination Map Ne Faide cael 3 Do one of the following A To add a new entry to the D estination M ap i Click the Add button The Add Destination dialog
207. ncluded in SchwabLink preferences Alternatively you can run Build Update for a selected M aster Account SchwabLink User M anual Account Viewer Window To open SchwabLink Account Viewer 1 Select the Accounts tab from the SchwabLink Launcher screen 2 Click the Account Viewer icon The Account Viewer window Figure 5 1 appears Pee eee hir mr em MAC Figure 5 1 SchwabLink Account Viewer Window To exit Account Viewer select Exit from the File menu 5 38 Chapter5 Account Viewer Account Viewer Toolbar The first nine buttons in the Account Viewer toolbar represent the nine viewers Figure 5 2 Click a viewer button to go to that viewer The button position varies according to window size If you cannot see all the buttons you may need to Increase the size of the window Ciad iaa Fiir Taai aig eda Sue CaceaPlel Traakia Di pata cies inii Dina ad Pape Fraj Pied ix E 5 Figure 5 2 Account Viewer Toolbar Use the remaining buttons of the toolbar to e Link to the Status Reports module e Enter an alphanumeric string to find a record e Print from the active viewer e Navigate between records in the active viewer The Nine Viewers The following table summarizes the contents of each Account Viewer screen or viewer Refer to the specific viewer section later in this chapter for detailed information about fields and functions VIEWER NAME DESCRIPTION Client Information A summary list of all client
208. nd exclusions e Accounts with fund positions in the margin account To filter by Rebalancing Exclusions 1 Click the M odel Assignment Screen toolbar button 2 Click the Accounts with M odels tab 3 If the Selection Criteria dialog isn t already displayed on the lower portion click the Filter Account List toolbar button l 4 Click the Accounts with rebalancing exclusions checkbox Click the Filter button SchwabLink User M anual Showing All Accounts The Show All Accounts feature displays all accounts represented on one of the two account list tabs in the M odel Assignment program It does not represent a list of all accounts assigned to a M aster account To display the full account list 1 Click the M odel Assignment Screen toolbar button a 2 Click either the Accounts with M odels tab or the Accounts without M odels tab 3 From the Accounts menu select Show All Accounts Filtering Accounts by Multiple Selection Criteria The filtering feature also allows you to combine selection criteria To filter for multiple selection criteria 1 Click the M odel Assignment Screen toolbar button sullll 2 Click either the Accounts with M odels tab or the Accounts without M odels tab 3 Click the Filter Account List toolbar button ey In the Selection Criteria area click the checkboxes for your criteria Type in your selection criteria Click the Filter button C 214 Appendix C Fund Rebalan
209. nd so forth A Fidelity or Vanguard exchange done to preserve loads must be sent as a one to one swap The buy side must be 100 No other option is allowed SchwabLink User M anual e When selling one mutual fund and dividing the proceeds into multiple alternate funds use the Linked Trade func tion rather than Swap For example enter Sell All 100 ABCDX Buy 50 LMNOX Buy 50 WXYZX one linked trade group rather than Sell 50 ABCDX Buy 100 LMNOX Sell 50 ABCDX Buy 100 WXYZX two separate swaps Creating a Swap in the Mutual Fund Template Window The simplest form of linked trade order is a swap whereby all or some of a client s shares in one mutual fund are sold and the proceeds are fully reinvested in one other mutual fund Swaps are created in the M utual Fund Template window To create a swap in the M utual Fund Template window 1 Select the account 2 Inthe Action field select Sell Sell Shares or Sell All You cannot select Sell or Sell Comm for a linked trade The Swap field is enabled 3 Inthe Quantity field enter the percentage or number of shares to sell If you selected Sell All in step 2 the quantity appears as 100 4 Select or enter the symbol for the mutual fund to be traded 7 108 Chapter 7 Mutual Fund Trading 5 In the Swap field select or enter the fund in which the proceeds of the sale are to be reinvested If you select a fund already contained in your da
210. ne execution string of the task to be automatically executed when a file download successfully completes Use the folder icon to the right of the Command Line box to find the executable that you want to run To run the SchwabLink for Windows Build Update process access the following file C Program Files SchwabLink Desktop A ccount Viewer acctvw 32 exe ii Enter the parameters for the task to be executed To run the SchwabLink for Windows Build Update process enter U Enter the working directory for the task The folder icon to the right of the Working Directory box allows you to browse to find the working directory you want to use In order to run the SchwabLink for Windows Build U pdate process the working directory should be set up as follows C Program Files SchwabLink Desktop A ccount Viewer iv Enter the run style for this task by selecting one of the following options on the drop down list Normal M aximized or M inimized In order to run the SchwabLink for Windows Build Update process the run style should be Normal SchwabLink User M anual v Select Task Enabled A checked box indicates that the task will run automatically after a download is complete vi Click OK N ote This task will launch the Account Viewer to run the Build U pdate process and will automatically shut down the Account Viewer after it completes B To disable the completion task that has been set up i Select Task Enabled An u
211. ng the files you only need to import one file into your portfolio management system To do this you need to specify in the User Preferences dialog box the output directory that will hold the resulting appended file The output directory should be different from those that hold the transaction files to be filtered N ote The append files option applies only when you run the filter in unattended mode To append files 1 If you are not in the User Preferences dialog box click the User Preferences button of the SL Transaction File Filter window The User Preferences dialog box appears 2 Inthe bottom portion of the screen click the small square checkbox next to the heading Append all the resulting filtered files together to create one large TRN SchwabLink User M anual This action activates the Select button If this option is not selected the output files are not appended and the separate output files are written to the same directories that hold the input file 3 Click the Select button The Select Data Directory dialog box appears 4 Inthe Directory box use your mouse and arrow keys to highlight the directory where the appended files will be placed You can choose only existing directories therefore if you want to have a new directory for this purpose you must create one first using standard Windows procedures 5 Double click on the directory you have selected or click the Select button 6 Click
212. nish adding directories click OK in the User Preferences dialog box All changes are saved Selecting a Default Filter If you plan to run the filter in unattended mode you must select the active or default filter that SL Filter uses to process the transaction files 1 Inthe Default filter for unattended mode field of the User Preferences dialog box click the arrow button to display a list of filters 2 Use your up and down arrow keys to highlight the default filter you want to use and press Enter You can also click on the name of the filter in the list Only existing filter profiles for the selected file type are displayed If you want to usea filter other than one of the filters that come with the application it must be created first before it can be selected See M odifying an Existing Profile on page B 170 or Creating a N ew Profile on page B 173 B 167 Appendix B Transaction File Filter 3 Exit the User Preferences dialog box by clicking the OK but ton to save your changes or click Cancel to abandon your changes Combining Multiple Transaction Files Appending Files If you have more than one M aster Account you will download more than one transaction file per day into more than one direc tory When you use unattended mode you have the option of having SL Filter combine append the resulting filtered files into one large trn file instead of separate ones for each directory By combini
213. nk Transaction File Filter make sure SchwabLink for Windows is installed on your system You should also be familiar with the structure and purpose of trn files before using this product This product is designed for experienced SchwabLink users To install the Transaction File Filter 1 Close down the launcher and close all applications including the M S Office toolbar 2 Choose SLFILTER from the CD ROM or open the exe file to begin the installation process Follow the onscreen instructions to complete the installation Alternatively from the CD ROM select the Transaction File Filter from the Setup application Follow the on screen instructions The installation process automatically creates a Transaction File Filter icon on the Utilities tab of the SchwabLink Launcher N ote Please consult the Readme txt file for the latest infor mation regarding SchwabLink Transaction File Filter It is available after you install the filter Launching the Filter To launch the SchwabLink Transaction File Filter 1 Select the Utilities tab of the SchwabLink Launcher 2 Click the Transaction File Filter icon The SL Transaction File Filter main window Figure B 1 appears B 165 Appendix B Transaction File Filter The buttons at the top of the window are from left to right Open Files Run Filter Set Up Filter User Preferences H elp Exit SL Transaction File Filter File Filters Options Windows Help Figure B 1
214. not yet set up a M aster Account these fields will be blank To set up a M aster Account refer to Chapter 2 Getting Started To exit Securities Allocation select Exit from the File menu Master Account Field To display a M aster Account select the M aster Account number from the drop down list in the M aster Account field SchwabLink User M anual ALLOCATING SECURITIES If the block trade you want to allocate was placed through Schwab refer to the next section Entering Schwab Trades If another firm executed the trade refer to Entering Prime Broker Trades on page 8 122 Entering Schwab Trades Before using the Securities Allocation module to enter and allo cate Schwab traded securities you must ensure that the order has been placed and executed You also must have the following information e Name of the security e Total buy or sell price of the trade e Total number of shares to be allocated e Action buy or sell options e A list of the accounts to which these shares are to be allocated and the quantity of shares to be allocated to each account N ote If this information is already held in a spreadsheet or other account management software you may be able to import it into the Securities Allocation module for transmission to Schwab See Importing Trade Files on page 8 129 To complete the Schwab Trade Detail page 1 Open the Securities Allocation module The system defaults to the Sc
215. nt option positions margin account MTD month to date Amount of interest that has accrued on the margin debit Margin Interest from the beginning of the interest period MARGIN ACCOUNT BALANCES Credit or Debit Balance of the margin account reflecting settled and unsettled transactions Can be debit or credit Market Value Long Total market value of all long positions in the margin account SchwabLink U ser M anual 5 46 Chapter 5 SECURITIES INFORMATION Symbol security Account Viewer Symbol or CUSIP number for identifying and pricing the Schwab downloads security symbols from the following sources and in the following formats Primary Secondary Tertiary SchwabLink User M anual NYSE AMEX NASD ticker symbols Schwab uses the standard industry accepted ticker symbols frequently used by quotation services such as Quotron or ADP CUSIP number A CUSIP number contains nine characters but some portfolio management programs use only eight The ninth character is reserved for use as a check character Most bond transactions are downloaded with a CUSIP number Schwab security number Transmitted by SchwabLink if no ticker symbol or CUSIP number is available The security symbol contains seven numbers For example 1234567 This security number is internal to Schwab and serves no other use Contact the Schwab trading desk for the security descrip tion that matches the number Schwab security numbers
216. nt types of buys and sells by examining the quantity fields for data BUY DLRS must have two spaces after BUY and before DLRS Use decimals when indicating percents For example enter 100 as 1 0 and 50 as 0 50 Time stamps must be identical for each grouping of linked trade orders SchwabLink User M anual e Orders that are not linked must have an allocation group code of 0 e Each set of linked trades must have a different time stamp Header Record Format Parameters Format parameters for a mutual fund trade record header first record only N ote W hen creating the file in a spreadsheet program simply type the entire header record as shown in the example below into the first cell OFFSET WIDTH CONTENT EXAMPLE 0 6 7 HD FA M HD FA M Note Space after D and A identifies the header record 8 15 8 MASTER ACCOUNT 08000000 17 20 4 FA30 FA30 identifies the file format 22 1 M M 23 29 7 MASTER ACCOUNT 8000000 last 7 digits Trade Record Format Parameters Format parameters for mutual fund trade record details all subsequent records 7 114 Chapter 7 OFFSET WIDTH 0 1 2 2 9 8 10 1 11 19 9 20 35 16 36 51 16 52 1 53 56 4 57 1 58 62 5 63 1 64 1 65 1 66 67 2 SchwabLink User M anual CONTENT TR ACCOUNT NO Blank Space ACTION QUANTITY QUANTITY SHR Blank Space QUANTITY Blank Space SYMBOL Blank Space COMMISSION Blank Space FUND INST Mutual Fund Trading EXAMPLE
217. ntry in the Destination M ap Highlight the row to be changed and click the Edit button The Edit Destination dialog box Figure 4 4 is displayed The M aster Account number that is currently set up for the selected entry is displayed at the top SchwabLink User M anual E chat D eatr Aur athe Aort HIE THF a sarpo 0 a maor So E5 Pojan Fibers gt Secheeweb Link Och bop Ge Sang Data Eae Dots C HTa hele of Leet Co Sogo ie Deke 5 aarti Date He oe Figure 4 4 Edit Destination window Enter the new M aster Account number or Description iii Click OK to save the change C To change the directory for an existing entry in the Destination M ap Highlight the row in the Destination M ap to be changed and click the Edit button The Edit Destination window Figure 4 4 is displayed The selected directory is highlighted in the Destination area of the window 4 35 Chapter 4 Download Utility ii Select the drive using the drop down box below the Destination directory area This drop down box displays the other drives that are accessible by your workstation Highlight and double click on the directory name to open it ili Click OK to save the change D To delete an entry in the Destination M ap Highlight the row to be deleted ii Click the Delete button iii Click OK VIEWING THE AUDIT TRAIL OF RECENTLY DOWNLOADED FILES The Download Utility automatica
218. number associated with that file For example CS011200 cnf 1 indicates that the record was the first in a list of confirmations for January 12 2000 Opening an Individual Confirmations File A confirmations file consists of one day s confirmations for one M aster Account In addition to listing all confirmations over a certain period of time you can open a file that contains one day s confirmations Those confirmations will be listed in a new Trade Confirmations List viewer when you open the file To open a confirmations file 1 From the File menu select Confirmation File then select O pen The Open Confirmation File dialog box appears 2 Select the file that you want to view and click Open A new Trade Confirmations List viewer opens containing only the confirmation records for the file you have opened 5 69 Chapter5 Account Viewer Using the Query Command for Confirmations You can use the Query command to search for display and work with selected confirmations on your list If you receive large numbers of confirmations each day the Query command can greatly simplify your work by allowing you to go directly to the confirmations you need After selecting the Query command you specify the field s you want to search for and the value for each field In addition to specifying values you can select parameters such as less than and greater than and sort the columns In your query result to focus speed
219. ny of the following e Click Find N ext to find the next instance of your search string e Enter another string of characters and then click Find N ext e Click Cancel to close the Find dialog box If no matches are found the following message Figure 5 36 appears SchwabLink User M anual Security List E4 Ho more matches found for string CA Figure 5 36 Find Message Box 6 Click OK Using the Find Command in the Positions and Security Cross Reference Viewers Use the Find function in the Positions Viewer to switch to another account or to search fields within the viewer 1 Open the Positions Viewer 2 Click the Find button or select Find from the Edit menu The Find dialog box appears Figure 5 37 Fart what c2 Stats yi 5 Cancel Figure 5 37 Find Dialog Box 3 Do oneof the following to enter search criteria A Enter the account number for which you would like to display positions Click Find N ext The Positions Viewer displays data for the selected account 5 82 Chapter5 Account Viewer B Enter the text and or numeric string that you want to find within the Positions Viewer To restrict the search to values within the viewer select the option to Search Top Window You can also select the options to find only records that start with the string you entered or to search the selected column only Click Find N ext SchwabLink locates the first record that meets your search criteria
220. o im Dewar keen rate i 2 mr ras po ihip year de sie sad ade jA Iemm arkam rate ihip rrari l par Ireti A eee pam jL_ Se n Ses luna E m l ast Eie Deis Sms aera Chee SL Piter Criteria Dri Tika _ a Lerrel Figure B 9 Filter Builder Add Function B 172 Appendix B Transaction File Filter 6 Select the operator And or Or Creating a New Profile 7 Click the down arrow button of the Field N ame field If you have changed a profile according to the instructions in A drop down list shows the fields in this transaction M odifying an Existing Profile and saved it with another name Figure B 10 you have created a new profile The other way of creating a profile is to build an original profile by inputting each selection line by line SL Filer Criteria Fact Meme There are three main steps to creating a new original profile See 7 5 u To a i dil os also the following Example section on page B 174 i g 1 Inthe SL Filter main window click the Setup Filter button Danit The Setup Filter dialog box appears tend ine 2 From the Setup box click the Add button at the bottom of the screen Figure B 10 Field Name Drop Down List A blank Filter Builder entitled N ew Filter Figure B 11 appears 8 Scroll through the list to find the field you want to add then select the fi
221. ocedure requires six steps 1 Enter or import data into the M anagement Fee Processing Worksheet Save the worksheet as a file Send the file to Schwab for processing Visit the Schwab Institutional Web site to review the status of the uploaded M anagement Fees file 5 Store and back up M anagement Fees files according to state regulations 6 Invoice your clients Management Fee Processing Window To open the M anagement Fee Processing window 1 Select the Utilities tab on the SchwabLink Launcher screen 2 Click the M anagement Fees icon The M anagement Fee Processing window opens Figure 9 1 Please consult with your firm s compliance expert or legal counsel to ensure that the record keeping and other procedures established in your firm comply with applicable standards 9 134 Chapter9 Management Fees ee ee Ce Ch Ci Oech iht 0 a 4 Ao eee a Ta ag ik mi Hii a E i T Eni Pe i i e HA i Dee Tt oe Fer bisi by bee ene der Bo rm Lon i ae j rin i bii cake Dia at Gen oem soe Figure 9 1 Management Fee Processing Window W hen the M anagement Fee Processing window opens the M aster Account and the Disbursement Account fields should be populated If these fields are not populated you will need to set up a M aster Account and a Disbursement Account See Chapter 2 Getting Started If you created a M aster Account in a module other than M anagement Fees and ha
222. odel Assignment toolbar button T This opens the M odel Assignment program 2 Click the Accounts with M odels tab The Account Exclusions tab appears on the right side Account Exclusions SchwabLink User M anual 3 On the Account pane select the account for which you d like to set exclusions 4 Onthe Account Exclusions tab select an option in the Cash Exclusions section 5 Inthe Asset Exclusions section select any fund positions you would like to retain All non mutual fund positions are automatically excluded 6 You may also select the check box to Exclude all fund positions in the margin account 7 Click the Update button An X now displays on the Account pane PP ee eek h eee Heb feet mi Ff Cece Api Eee Cie Heth aj a F Hane eT Tz h F ete bee xl IEL ki i Cala ktl imran EEH HARARE bree 1 a PEE EFF dpp i E vil Ee ET te ii Tt Cae EH ag Ce Ti LE EREI ireli ETET H fl ar kilis HAET ee bti Darb minem he Pa fe irg h g eg ri W bis pak perk pr b he iia sed ope mima ers Er mi pee se dade bee ee eee eee Tey rr DD bai aT ie EPM Ti Tea HEZE EE mib CAPALL HELE A ams Thi O Eri m TR ea fann pi Di ap iei oe hi ja Tl a laee i rd MA Pej Jea ps a par gt ns re ai hg yal T Eebak Hi i pa n h a ee me Figure C 10 Setting Account Exclusions Note The securities displayed are fictional and used for illustration purposes C 189 A
223. of days that you specify or upon demand Remember that you are not deleting the original confirmations from the files received in SchwabLink The confirmations on the Trade Confirmations List are copies SchwabLink made when the new confirmation file was added to the list If you need to view a confirmation record you have purged you can go back to the Original files on your hard drive or on a backup diskette and add them to your Trade Confirmations List again Setting Up the Automatic Purge Function You set up the automatic purge function in the Account Viewer Preferences dialog box Refer to Specifying the Transaction and Confirmation Record Retention Period on page 5 90 Purging Confirmations on the Scheduled Day When you open Account Viewer on the day of the scheduled purge the Confirmation Purge dialog box Figure 5 24 appears The message prompts you to delete confirmations older than the number of days set in the Account Preferences dialog box SchwabLink User M anual Confirmation Purge O amp 000000 Ej AN Found 3 records older than 90 day s Do you want to delete these records Figure 5 24 Confirmation Purge Dialog Box To purge the records click Yes The dialog box closes and the Trade Confirmations List appears The purged records are removed from the list If you do not open the Trade Confirmations List Viewer on the day of the scheduled purge the purge does not take place You will receive the Conf
224. on about adding editing and deleting M aster Accounts see Chapter 2 Getting Started You can set up and revise M aster Accounts in M anagement Fees M utual Fund Trading Securities Allocation Account Viewer Status R eports and Download Utility Any changes made to M aster Account details in the preferences of one of these modules will automatically apply to the other modules 9 141 Chapter9 Management Fees Management Fees Preferences Destination Map EE Sample Data C Program Files S chwabLink Desk 0871 23456 fake data EASL Win 2 04D ata081 23456 sani 08999999 demo data ESL Win 2 040 atastuture dated fil Validate typed sub accounts Disbursement Account for the selected Master Account i 2345678 OF Cancel Figure 9 10 Management Fees Preferences Dialog Box Setting Up Disbursement Accounts When you set up a M aster Account you may also enter a Disbursement Account number N ote Although you can create M aster Accounts in most other modules you can enter a Disbursement Account number only in the M anagement Fees Preferences dialog box To set up a Disbursement Account 1 Inthe M anagement Fees Preferences dialog box highlight the M aster Account to which you will add a Disbursement Account number SchwabLink User M anual 1000 0897 2 Inthe Disbursement Account for the selected M aster Account field enter the Disbursement Account number or select it from the drop down lis
225. onfirmation file is downloaded additional storage space is taken up on your hard disk Although the trade confirmation files are not exceedingly large you may want to SchwabLink User M anual consider storing daily confirmation files on a diskette or other storage media N ote Consult with your compliance or legal expert for informa tion concerning record keeping requirements TRADE CONFIRMATION DETAIL VIEWER For every item in the Trade Confirmations List or Trade Confirmations Query Results List SchwabLink provides a detailed record Figure 5 26 You access the details for a record by double clicking on the record in the Trade Confirmations List or the Query Results List The SchwabLink trade confirmation you see on your PC screen captures key information provided by the paper confirmation that Schwab sends to your clients If you prefer to store this data on your PC you may want to receive electronic confirmations instead of hard copy confirmations N ote Regardless of whether you choose to receive hard copy or electronic confirmations of your clients trades you may need to supplement the information if you plan to use the confirmations to meet any of your regulatory books and records requirements Consult with your legal and compliance advisors to determine whether you need to supplement the confirmations with your own information to fulfill your regulatory responsibilities Receiving client data electronically can save
226. ools menu select Security Customization The Security Customization List Figure 5 40 appears Security Customization List 31358628 FED DEBT MTG ASN x w297 BOND DUE 04 11 97 97 3S8xS 7 ROUNDWOOD TACO 296 912810C08 US TREA BOND x xex 11 97 12827469 US TREA NOTE s nen 4 96 12827485 US TREAS NOTE 205 01 12827C91 US TREAS NOTE 1197 DUETAS o 312527041 L Custom Security Information Symbol Security 912010COE Security Identifier US TREA BOND 15211 97 DUE 11715797 DUE 11 15 97 DUE 11 30 96 Ea Erase Schwab Security Information Customize Editing Record for Schwab Symbol 912870008 Figure 5 40 Security Customization List 5 87 Chapter5 Account Viewer 3 From the grid in the upper part of the window select the security to be customized The details appear under Schwab Security Information on the left side of the window 4 Do one of the following e Click the arrow button next to Schwab Security Information The Schwab details appear under Custom Security Information on the right side of the window Edit these details as appropriate e Enter the new security identifier and description on the right side of the screen 5 Repeat steps 3 and 4 to customize details for other securities in this M aster Account 6 When you finish entering securities details click Customize 7 When you finish customizing securities click Close SETTING PREFERENCES Use the preferences section of Account
227. or ADP Secondary CUSIP number M ost bond transactions are downloaded with a 9 digit CUSIP number Tertiary Schwab security number If no ticker symbol or CUSIP number is available then the Schwab security number is transmitted SchwabLink User M anual This security number is internal to Schwab and serves no other purpose When a Schwab security number appears in a downloaded transaction please contact the Schwab Trading Desk and give them the security number They will give you the security description that matches the number N ote The Primary Security Symbol the ticker sym bol isin the file if it is available If not then the Secondary Symbol is in the file If neither are present then the Tertiary Symbol is in the file Dollar amount of transaction The net dollar amount of the transaction This amount is the net cost or net proceeds as displayed on an individual trade confirmation Account type One of these Cash Transactions occurring in a cash account Margin Transactions occurring in a margin account Short Transactions occurring in a short account Quantity The number of shares or the face value of an asset if denominated in dollars All downloaded transac tions where applicable are carried out to three decimal places Fractional shares of mutual funds are rounded to the nearest thousandth 0011 to 0014 is rounded down to 001 0015 to 0019 is rounded up to 002 The method of rounding e
228. order 1 Inthe Linked Trades window select an account number or name and the corresponding number or name appears In the Action field select an available sell option Complete the Quantity field according to the sell options you selected 4 Select or enter the symbol for the fund you are selling 7 109 Chapter 7 Mutual Fund Trading 5 Click Add Update Trade The data you entered in the Enter Edit Trade area of the Linked Trades window appears in the Sells grid of the Allocation Group area 6 To enter more sell trade orders for the same client repeat steps 2 through 5 7 Inthe Action field of the Linked Trades window select Buy 8 Inthe Quantity field enter the percentage you want to buy For example if you want to use 25 of the total sell proceeds to purchase a certain fund enter 25 9 Inthe Symbol field enter the five character symbol of the mutual fund you want to purchase or select it from the drop down list 10 In the Fund Instruction field select the fund instruction for the mutual fund being bought 11 Click Add Update Trade The data you entered in the Enter Edit Trade fields appears in the Buys section of the Allocation Group area 12 To enter more buys for the same client repeat steps 7 through 11 Remember that the total value of the buys cannot exceed 100 13 After you create all trades for the account go to the next section Accepting a Linked Trade Order Ac
229. orders without having to re enter all the same data To select symbols for duplicating a trade order in the M utual Fund Template window 1 Enter the account action and quantity for a new order 2 Click the Select Symbols button The Select Symbols window appears displaying available symbols from the selected master account N ote If the trade is a Sell action only positions held by the indi vidual account will appear as available symbols 3 Select from the list of Available Symbols for which the trade order will apply Click the Add button to add them to the list of Selected Symbols Click the Add All button to add every symbol to the list of Selected Symbols SchwabLink User M anual 4 To deselect a symbol for duplication highlight the symbol from the list of Selected Symbols then click Remove To deselect all symbols click Remove All 5 Click OK The duplicated orders appear in the M utual Fund Template window for the selected symbols Adjusting the Mutual Fund Template Grid To adjust the column width 1 Place the mouse pointer over the line between the column header you want to change and the neighboring column The cursor changes to a double headed arrow 2 Press and hold down the mouse button then drag the col umn border in the direction you want it to go 3 When the column reaches the desired width release the mouse button Deselecting a Row To deselect a row that has been inadvertently hig
230. ort date 2 Click the Printer toolbar button amp l e Account Exclusion information 3 Select M odels by Asset from the drop down menu To print all model assignments a 4 Inthe M odel Selection select the One Asset radio button 1 Click the M odel Assignment Screen toolbar button cal 5 Select the asset from the drop down menu 2 Click the Printer toolbar button 2 6 Click the Print button 3 Select M odel Assignments by M odel from the drop down 7 Set any print options such as page range or number of copies 4 8 Click the OK button SchwabLink User M anual menu The M odel Assignments Report dialog opens In the M odel Selection section select the All M odels radio button Click the Print button C 231 Appendix C Fund Rebalancer One Model Assignment The M odel Assignment by M odel report provides the following information for the requested model e Linked accounts e Account Description e Current Portfolio values and variance e Last Order Export date e Account Exclusion information To print one model assignment 1 Click the M odel Assignment Screen toolbar button 2 Click the Printer toolbar button pe 3 Select M odel Assignments by M odel from the drop down menu The M odel Assignment Reports dialog opens 4 Inthe M odel Selection section select the One M odel radio button 5 Select the model name from the drop down list box Click the Print button Accounts without Models
231. ositions table to display the Security Cross Reference view for that security Printing from the Client Account Positions Viewer You can print statements balances and positions for all accounts or for a selected account To print from the Client Account Positions viewer 1 If you will be printing information from one account select the account 2 Click the Print button on the toolbar or select Print from the File menu The Positions Print Selection dialog box Figure 5 6 appears 5 48 Chapter 5 Account Viewer Positions Print Selection Ea C Print statements for f Selected account All accounts C Print balances for f Selected account 3 All accounts C Print positions for f Selected account f All accounts Cancel Figure 5 6 Positions Print Selection Dialog Box 3 Specify whether to print statements balances and or positions by selecting the appropriate check box 4 Select whether you want each option to print for a selected account or for all accounts 5 Click OK The print dialog box appears 6 Select appropriate parameters and click OK SchwabLink User M anual SECURITY LIST VIEWER The Security List viewer Figure 5 7 shows a list of all securities held in all client accounts within the selected M aster Account For each security in the selected M aster Account the Security List viewer shows the symbol type security description price and date of p
232. ou navigate among records in a viewer using the fol lowing methods Refer to the individual viewer sections in this chapter for additional information e Use the Find command to locate a specific record quickly See Using the Find Command on page 5 81 e Use the record navigation buttons in the second row of the Selects the first record in the list Selects the previous record Selects the next record O 2 mS if Selects the last record in the list e Use the scroll bars or page up and down functions e Use the record navigation functions in the Window menu identical to toolbar buttons In the Transactions List Deposit W ithdrawal List and Trade Confirmations List viewers you can also use the Query command to go directly to specified individual and groups of transactions and confirmations 5 40 Chapter5 Account Viewer Selecting and Viewing Master Accounts To select a M aster Account 1 Inthe M aster Accounts list in the SchwabLink Account Viewer main window Figure 5 1 highlight the M aster Account 2 Open a viewer and the information for that M aster Account is displayed To switch from one M aster Account to another 1 Close all open viewers 2 Inthe M aster Accounts list Figure 5 1 highlight the M aster Account that you want to view 3 Open the viewers that you want to see for the selected M aster Account To view more than one M aster Account at a time 1 Select a M ast
233. ou want to adjust and the neighboring column header until the cursor changes to a double headed arrow 2 Hold down the mouse button and drag the column border in the direction you want it to go 3 Release the mouse button when the column is the desired width Sorting Data You can sort data by column headers in the viewers Click on the header of the column you want to sort by The data sorts immediately and the text in the header becomes bold so that you can identify how the data Is sorted All columns toggle between ascending and descending order when you click on the column header 5 83 Chapter5 Account Viewer To perform a secondary sort hold down the Ctrl key and click on a different column header The text in the header becomes italicized so that you can identify the secondary sort criteria To toggle between ascending and descending order hold down the Ctrl key and click the italicized column header again Exporting Data You can export data from Account Viewer grids either by using the Export feature or by copying and pasting data directly from the grid to a spreadsheet program To copy and paste data to a spreadsheet program 1 Select records in the grid to be exported 2 Select Copy from the Edit menu 3 Open you spreadsheet Select Paste from the Edit menu in your spreadsheet program The Account Viewer data should appear in your spreadsheet To export data 1 Make sure that the screen you want to expor
234. our after the market closes on the day the associated trade was made Saving Files Before you send a Securities Allocation file to Schwab you must save it The files that you save are automatically queued for transmission in the Worksheet Q ueue You send the Securities Allocation files to the Schwab Institutional Trading Desk from this queue To save the active trade allocation 1 Click the button or select Save As from the File menu The Save As dialog box Figure 8 6 appears 8 126 Chapter 8 Securities Allocation Save as Svein ar EEE File name c Save Save astupe Schwab Trade I Cancel Figure 8 6 Save As Dialog Box In the File name field the default name for your file consists of CS plus today s date The file will be saved with the extension of eq for Schwab trades or pb for Prime Broker trades plus a sequential number or letter The sequential naming convention is 0 9 then a z For example if today s date is M arch 24 1999 and you are saving the first Schwab trade file of the day the default file name is cs032499 eq0 2 Thedefault allocation file storage location is C Program Files SchwabLink Desktop Securities Allocation D ata You can change the file name default drive and directory If you choose You cannot change the file extension 3 Click the Save button The file is saved to the location specified and is placed in the Worksheet Q ueue SchwabLink User M anual
235. owing types cash Cash account margin Margin account Dollar Amount Total Deposits Total Withdrawals The dollar amount of the transaction Total of all deposits listed in the viewer Total of all withdrawals listed in the viewer Summary totals change to reflect query results as well as additions or deletions to the viewer list Using the Query command you can display summary totals for a client or group of accounts for a specific period of time or for one or more securities SchwabLink User M anual Adjusting the Deposit Withdrawal Viewer Display You can change how information in the viewer is displayed To change column order and width or to sort data see Changing Column Order Adjusting Column Width and Sorting Data on page 5 83 NAVIGATING IN THE DEPOSIT WITHDRAWAL VIEWER Use any of the following methods to find records in the D eposit W ithdrawal List viewer e Record navigation buttons e Record navigation functions in the Window menu e Find function see Using the Find Command on page 5 81 e Scroll bars e Query function to find groups of records with common criteria see Using the Query Command for Transactions on page 5 60 5 65 Chapter5 Account Viewer PRINTING THE DEPOSIT WITHDRAWAL OR QUERY RESULTS LIST You can print the D eposit W ithdrawal List or a Deposit Withdrawal Query Results List The lists print continuously on multiple pages if necessary To print a Depos
236. permitting my fees to be paid directly from the accounts they hold at Charles Schwab Please call your Institutional Service Group ISG Team with your Master Account number number of client records sent and dollar amount totals Figure 9 9 Acknowledgement Dialog Box 3 Click Yes to accept the terms A dialog box appears showing the last Web user ID that was entered 4 If your user ID is different from the user ID displayed enter your user ID You must use your user ID and password every time you use the M anagement Fees module to send files to Schwab 5 Enter your password 6 Click OK The file is sent to Schwab If transmission is successful a confirmation message appears showing the file name The sent files disappear from the queue SchwabLink User M anual Requeuing Deleted Files Files that are deleted from the Worksheet Q ueue are still present on the drive in which they were originally saved To requeue a M anagement F ees file 1 Do one of the following e Open the file select Save As from the File menu and rename the file with the same name if desired e Open the file edit it if necessary and save it 2 Click E or select Send to Schwab from the File menu The Worksheet Q ueue appears with the file requeued SETTING PREFERENCES To begin setting preferences select Preferences from the O ptions menu to display the M anagement Fees Preferences dialog box Figure 9 10 For informati
237. ppendix C Fund Rebalancer 8 Repeat steps 3 7 for each account that needs exclusions 9 Click the close box x in the upper right corner to close the M odel Assignment program The program updates the account exclusions and refreshes the information on the Actual Portfolio tab within Fund R ebalancer The exclusion items appear with an X in the first column Step 4 Moving Accounts to the Select List Aya To rebalance an account with an assigned model you must first add it to the Selected Accounts list To move accounts to the Selected Accounts list 1 Click the Account List tab at the bottom of the Account pane 2 OntheAccount pane hold down the CTRL key and then click each account you want to move SchwabLink User M anual Sample Data Figure C 11 Selecting Accounts to Move to Selected Accounts List 3 Click the M ove Accounts From To Selected List toolbar button s The Selected Accounts tab displays with the selected accounts Note The securities displayed are fictional and used for illustration purposes C 190 Appendix C Fund Rebalancer Sample Data Figure C 12 Selected Accounts List Note The securities displayed are fictional and used for illustration purposes SchwabLink User M anual Step 5 Inputting Cash Management Options Aya The Cash M anagement features allow you to further adjust portfolio rebalancing for anticipated cash movements These transactions represent p
238. program is used to assign accounts to models Each model contains of a set of mutual funds and cash in specific allocation percentages This program also defines account exclusions such as mutual funds or cash you want with held from the rebalancing process You may access the program within Fund Rebalancer using the M odel menu or M odel Assignment toolbar button The Fund Rebalancer program is the core program It shows actual and projected portfolios and account statuses similar to a before and after snapshot This program creates the orders necessary for rebalancing C 180 Appendix C Fund Rebalancer Fund Rebalancer Program Structure aT mT Mali Saeed Pa ee a aed Ei ee ee a E l E Sample Data Fund Rebalancer Program Pe es a FAN iA Taian iiki Model Configuration Program SchwabLink User M anual Fund Rebalancer Program e Defines account cash management options e Defines Minimum Order Thresholds Sets rebalancing method e Generates orders e Displays portfolios Exports trade file Model Configuration Program e Creates and maintains models Model Assignment Program e Assigns accounts to models e Defines account exclusions Model Assignment Program Note The securities displayed are fictional and used for C 181 illustration purposes Appendix C Fund Rebalancer Although Fund Rebalancer is the core program it is automatically disabled when
239. r Display a client account by selecting it from the lower half of the viewer To find a record in the viewer do one of the following e Use the record navigation keys and the record navigation functions in the Window menu to move through the client accounts in the list e Scroll or page through the list until you locate the record you want e Use the Find command to locate the record See Using the Find Command on page 5 81 Double click on any record in the account list to display the details for that account in the Client Account Positions viewer SchwabLink User M anual Printing from the Client Information Viewer You can print details from the grid in the lower half of the screen and from the individual account information in the upper part of the viewer To print from the Client Information viewer 1 Select an account in the grid in the lower portion of the viewer 2 Click the Print button on the toolbar or select Print from the File menu The Client Information Print Selection dialog box Figure 5 4 appears You can select from one or both portions of the dialog box If you select from both you will receive two separate printouts Chent Information Print Selection New accounts only Restricted accounts only All accounts Figure 5 4 Client Information Print Selection Dialog Box 5 44 Chapter5 Account Viewer CLIENT ACCOUNT POSITIONS VIEWER The Client Account Positions viewe
240. r Figure 5 5 displays a com plete list of security positions held by the client account displayed in the Account Number and Account N ame fields Summary securities and cash values are displayed in the upper part of the viewer for the account The grid in the lower part of the viewer lists the name of and information about each security held in the account The selected M aster Account is shown in the title bar Client Account Positions 08000000 Client Account Positions 08000000 Updated 03 01 1999 Account Number 23456789 Account Name DORIS CORVETTE amp CHRISTY CORVETTE JT TEN Total Account Balances Net Market Value 792 147 29 PortfolioValue 195 090 24 Market Value Short r Invested Cash og Idle Cash 2 892 99 Total Cash ga np2gg 892 99 Cash Account Balances Account Statistics Net Credit or Debit S00 oo Equity Percentage C mig n Net Market Value F mi Option Requirements 0 00 an on Money Market Funds o m Margin Account Balances Credit or Debit 2 88299 Equity Incl Options 195 030 24 Margin Buying Power L 284 448 00 Market Value Long 192 147 25 Margin Cash Available 742 224 00 MTD Margin Interest SE Market Value Short 0 00 Equity Excl Options 195 030 24 Security TypeySecurity Teena Cash Marain Number of SharesfLong ShortfPrice Market Value Percentage 3 2827E 24 tn US TREAS NOTE xn 2 97 DUE O2 15 M L i 15 412 5000 75 912827UF tn IIS TREAS N
241. r Advent transaction file format are the same as those for the generic format See the Security Type entry on page A 158 of the Generic Transaction File Format section e Security symbol Schwab downloads security symbols from the following sources and in the following format e Primary NYSE AMEX NASD ticker symbols Schwab uses the standard industry accepted ticker symbols frequently used by major financial newspapers and by quotation services such as Quotron or ADP Secondary CUSIP number M ost bond transactions are downloaded with a CUSIP number that contains nine digits Advent software only uses eight The ninth digit is used as a check digit Tertiary Schwab security number If no ticker symbol or CUSIP number is available the Schwab security See your portfolio management system user manual for details on the Security Information File Commission amount The dollar amount of the commis sion charge as displayed on an individual confirmation number is transmitted When a transaction is completed on a principal basis no This security number is internal to Schwab and serves commission is shown no other purpose When a Schwab security number appears in a downloaded transaction contact the Schwab Trading Desk and give them the security num ber They will give you the security description that matches the number Comments Schwab downloads specific comments where applicable to assist in editing the tran
242. r Edit Trade area of the window 4 Make the appropriate changes Click Add Update Trade and the amended information appears in the grid Editing a Linked Trade Order To edit a linked trade order 1 To edit a linked trade order in the Linked Trades window select the linked trade that you want to edit The trade infor mation appears in the Enter Edit Trade fields Go to step 2 To edit a linked trade order that is displayed in the M utual Fund Template window select the trade that you want to edit In the Edit Linked Trades dialog box click Yes The Linked Trades window is displayed M ake sure that the trade order you want to edit is selected Go to step 2 2 Makethe necessary changes then click the Add Update Trade button The edited information appears in the appro priate grid in the lower part of the Linked Trades window SchwabLink User M anual Deleting a Single Linked Trade Order from the Linked Trades Window To delete a linked trade order from the Linked Trades window 1 Inthe grid select the trade order that you want to remove 2 Click the Delete button The trade order is removed Deleting All Linked Trade Orders from the Linked Trades Window To remove all the trade orders currently displayed in the Linked Trades window 1 Click the Delete All button The Delete All Confirmation box Figure 7 7 appears Delete All Confirmation Fr Do you want to delete all buy and sell trades Figure 7 7 De
243. r cable modem An Internet Service Provider ISP 2 13 Chapter 2 Getting Started Browser Microsoft Internet Explorer 5 0 or higher and Sun Microsystems Java Plug in 1 3 1 or higher with 128 bit encryption Monitor 17 inch SVGA 1024 x 768 resolution CD ROM drive 8x or higher CD ROM drive Network operating system Microsoft Windows 98 or Windows NT 4 0 for network installation only Additional Programs Adobe Acrobat Reader 4 0 with Search plug in INSTALLING SCHWABLINK ON YOUR COMPUTER N ote To install SchwabLink on a network refer to the Installing SchwabLink on a Network section that begins on page 2 25 To install SchwabLink on your computer 1 Close all open applications 2 Insert the SchwabLink 2 3 CD ROM The Setup Program menu appears on your screen Figure 2 1 SchwabLink User M anual N ote If the Setup Program menu does not appear e Click the Windows Start button e Select Run e In the Run dialog box type D setupapp exe where D is the letter address of your CD ROM drive e Click the OK button Te r pia ma Welcome to the SchwabLlink Setup Program fetal Schwablink Deakbop Z T View COUN nection and conlhemaiion mboin seme maniga fee ancl trade files to Schwab and rebalance mutual fund portfolios requires 30 ME diik tpace 4568 with Furmad Relsalane er Figure 2 1 SchwabLink Setup Program Menu Chapter 2 Getting Started 3 Clic
244. r your own trading system The TFF streamlines daily data processing by filtering out transaction data already imported into your portfolio management system Refer to Appendix B of this manual Transaction File Filter for more information 2 12 Chapter 2 Getting Started N ote Transaction File Filter is necessary only if you have more than one data feed and you require reconciliation conflict resolution Web Forms Database Install the Web Forms Database to create a database for completed and partially completed forms The database allows you to save forms that you complete on the Schwab Institutional Web site for future use Java Plug In 1 3 1 Access Web Forms and Web Trading on the Schwab Institutional Web site with the latest version of the J ava Plug In Adobe Acrobat Reader 4 0 Use Adobe Acrobat Reader to access Web Forms from the Schwab Institutional Web site Backup N etwork Scripts Access the Schwab Institutional Web site directly through the Schwab Backup Network with these required scripts The Backup Network is an optional service offered to Schwab Institutional Web site users for a nominal fee which is billed by and paid to UVUNET an MCI WorldCom company License Agreement This file contains the text of the license agreement for the products on this CD ROM Installing any of these products on your computer constitutes acceptance of the agreement SchwabLink 2 3 User M anual An electronic copy of t
245. rading module Some of these steps are prerequisites You may notice that during certain steps Some menu and toolbar functions are disabled For example you can t generate any orders Step 6 without moving accounts to the Selected Accounts list Step 4 The 10 basic steps include Step 1 Creating a M odel Step 2 Assigning Accounts to the M odel Step 3 Defining Account Exclusions Step 4 M oving Accounts to the Selected Accounts List Step 5 Inputting Cash M anagement O ptions Step 6 Generating the Order List Step 7 Reviewing Orders C 182 Appendix C Fund Rebalancer Step 8 Approving the Orders Step 9 Exporting the Orders Step 10 Importing the Order File Accessing SchwabLink Fund Rebalancer To access Fund Rebalancer 1 Doubleclick the SchwabLink icon on your desktop The SchwabLink Desktop window appears 2 Click the Trade tab reseed ink Cin chine Alm El Dis Drie Hele Je PF a i Schwah Figure C 1 Trade Folder 3 Click the Fund Rebalancer button A The Fund R ebalancer program opens SchwabLink User M anual Fund Rebalancer first opens with a blank account list Master Account Figure C 2 Fund Rebalancer Program 4 On the right side of the toolbar select the M aster Account you wish to work with C 183 Appendix C Fund Rebalancer Understanding the Fund Rebalancer Work Area The Fund Rebalancer work area consists of three connected parts Each part ma
246. ral categories Advent transaction file recipients and Generic transaction file recipients Each category of user has its own list of file filter profiles You can view the existing pro files through one of the following dialog boxes e Setup Filter for Advent Format dialog box e Setup Filter for Generic Format dialog box Viewing the Profiles List To view the profiles list 1 Inthe main window click the Setup Filter button The Setup Filter dialog box Figure B 4 appears SchwabLink User M anual Sate Filter fer Adweent Farr Fines Profil p Cim wap Ll aes Tr hule rank lepiej mie poprimi ianh heu m ola T DIC U sm mekk cash Dop H parna Ch en m a va Bel rey Li ega ehh pank Geel mie repre cah theokes ey aaa Edi Ge Caer Figure B 4 Setup Filter Advent Format Dialog Box 2 Specify the file format in the File Format portion of the U ser Preferences dialog box as described in Setting U ser Preferences on page B 166 Viewing the Selection Criteria To view the selection criteria 1 From the Setup Filter dialog box click on the box to the left of the name field 2 Part of the criteria may be hidden M ove the line to the left or right by clicking on the arrow keys on the bottom scrollbar You can get a better view of the profile by using the Filter Builder window B 169 Appendix B Transaction File Filter Accessing the Filter Builder Window To access the Filter Builder 1 Inthe main
247. rch from leading providers including Argus Credit Suisse Market Edge Morningstar Ned Davis Research Inc Thomson Reuters Standard amp Poor s Stanford Washington Research Group and the Schwab Center for Financial Research Some features are blocked for Third Party Administrators Note These features provide an overview of the site as of August 2001 We are committed to improving the site to meet your business needs and encourage you to share your feedback via the Suggestion Box on the Home page Watch for future announcements on the Web site as we introduce new products and services SchwabLink User Manual 1000 0821 Site Backup Network In the event that you are unable to use the Internet to access Schwab due to an outage or access problem with your Internet service provider ISP an alternate backup network is available through UUNET an MCI WorldCom Company This backup network service is completely separate from the Internet and will enable you to have a reliable non Internet connection to Schwab Institutional anytime There is a nominal fee for the backup network service Additional information and instructions on how to register are available in the Help section of the Schwab Institutional Web site Real time quotes may be subject to Internet traffic or other delays 3 29 Chapter 4 Download Utility OVERVIEW The Download Utility function of the Schwab Institutional Web site www schwabinstitu
248. re are no build files the Build U pdate process will find all consecutive update files from the last update date to the current day and process those files N ote If update files are missing for any of your M aster Accounts since the last Build U pdate was executed an error message appears when the Build Update process is run in manual mode If you receive this message contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time M onday through Friday TCS can generate build and update files appropriate to resolve your problem e For investment advisors call 1 800 647 LIN K 5465 or email techserv si schwab com e For Third Party Administrators call 1 800 231 2855 O ption 2 or email rps techserv schwab com Running Build Update N ote Before running Build Update make sure that you set appropriate preferences See Specifying Preferences for Build Update on page 5 89 You can run the Build Update function automatically as part of the completion task of your daily download process For more information see M odifying the Completion Task in Chapter 4 Download Utility To run Build Update in attended manual mode 1 Open Account Viewer 2 If you want to run Build Update for one M aster Account only select that M aster Account from the M aster Account List and go to the next step If you want to run Build Update for all M aster Accounts go directly to the next step SchwabLink User
249. re working with several viewers open and cascaded and then maximize the Account Viewer window the viewers stay the same size If you then reselect Cascade from the Window menu the viewers will re cascade in a size appropriate to the maximized Account Viewer window Similarly if the cascaded viewers become disordered due to switching between the views reselecting Cascade from the Window menu reorders them in the sequence they were opened N ote The Cascade Tile Vertical and Tile H orizontal selections only arrange those screens that are open and that are standard ized or maximized M inimized viewers will not be cascaded or tiled 5 85 Chapter5 Account Viewer Customizing Data in Account Viewer SchwabLink uses client account names account numbers and security descriptions that are recognized by Schwab H owever you may be more familiar with different numbers or names for client accounts and different security symbols SchwabLink offers a feature to customize your data so that you can view numbers and figures with which you are familiar yet Schwab will only receive data that Schwab recognizes If you want your customized data to appear automatically after you run Build Update you must set the preferences appropriately See Setting Preferences on page 5 88 N ote Although you can customize certain fields and columns such as Account N umber in some viewers the customized values for those same fields and col
250. rice Security List 08000000 Updated 03 01 1999 Security Description Price Date of Price fa x ate eh eal i a DEBT MTG ASN sse29 BOND DUE si Kiez r 1571995 inos e JUS TREA BOND seia DUE Tied 10a Aee 1S TREA NOTE 904 96 DUE Ceara TESTES US TREAS NOTE 11 97 DUE 11 159 US TREAS NOTE 07 97 DUE 0715 9 S128sGEWE oe _ SEPTRDG REGINTAPRINOFINT PMT DUE _ 98 5875 11 18 1895 _ Number of Secuies 4 Po Securities Figure 5 7 Security List Viewer To display the Composite Security Positions window double click on a record in the list 5 49 Chapter 5 Account Viewer Fields and Columns in the Security List Viewer An asterisk indicates a field or column that can be customized FIELD COLUMN Symbol Type Security Description Price Date of Price DESCRIPTION Symbol or CUSIP number used to identify and price the security For details see the Symbol field description on page 5 45 of the Fields and Columns in the Client Account Positions Viewer section Abbreviation for the type of security To view a list of the security types used in Account Viewer select Security Type Descriptions from the View menu Or see the Security Type field description on page 5 45 of the Fields and Columns in the Client Account Positions Viewer section The name of the security Market price per unit of the security as of the date in the Date of Price field The date on which Schwab recorded t
251. riction 070871992 DAVID B EDSEL C Do 5678901 ALFRED SIERRA o oaa 01271991 097 0371991 6789012 ANNE 5 JAVELIN 67290123 JAN JETTA Humber ot Accounts 10 5 Figure 5 3 Client Information Viewer To display the Client Account Positions window for an individual account double click on a record line in the list 5 42 Chapter 5 Account Viewer Fields and Columns in the Client Information Viewer An asterisk indicates a field or column that can be customized Account Name New Account FIELD COLUMN Client name and address Social Security Number Opened Home and Business Phone Branch ID DESCRIPTION Open Date Account Restriction Date the client account was opened Cash Instructions Margin Instructions Fund Selection Option Approval Level Securities Proceeds Dividends Account Number SchwabLink User M anual Cash account instructions for handling securities proceeds and dividends Margin account instructions for handling securities proceeds and dividends Indicates which Schwab money market fund the account is set up for Indicates level of approved option trading for the account Account name as registered with Schwab The letter Y indicates that the account was linked to the Master Account within the last seven days Otherwise the field is blank The date the account was opened at Schwab The account restriction code indicates a particular r
252. rmations in the Build Update process you can add them manually See Adding the Previous Day s Transactions and Adding the Previous Day s Confirmations on pages 5 59 and 5 69 respectively Include Master Account Information on Printouts Select this option to include master account information to all printouts from Account Viewer Include Column Headers in Export Files Select this option to include column headers in exported files using the Export feature Specifying the Transaction and Confirmation Record Retention Period When you add a confirmations or transactions file to the Trade Confirmations List or the Transactions List respectively SchwabLink combines the new confirmations or transactions with those already added Over time these lists may become too large Or may contain information that you no longer need SchwabLink provides a purge function that enables the old data records to be deleted automatically from the Trade Confirmations List and the Transactions List The files from which these records were added to the list remain in the M aster Account folder and can be added again SchwabLink User M anual 0901 03256 You can set the maximum amount of time to keep these records When you open the Transactions or Trade Confirmations List viewer on or after the scheduled purge date you receive a prompt asking whether you want to purge the records In the Account Viewer Preferences dialog box enter t
253. roval checkbox was located To continue working with other accounts you need to establish a new session O pening a N ew Session clears the Order List and Cash M anagement options All accounts are moved back to the Account List Reminder Note the Order Export File name The file name consists of your Master account number and a timestamp C 198 Appendix C Fund Rebalancer Step 10 Importing the Trade File 6 Select the trade file and click the O pen button The trades T A will display in the M utual Fund template From here you can add update or delete them as with any other trade file To import the Fund Rebalancer trade file 1 On the SchwabLink Desktop click the Trade tab 2 Click the M utual Fund Trading button 3 Select the appropriate master account from the M aster Account N umber drop down menu 4 From the File menu select Import External File LL EEFE Pe et IN TP TY HLL CFI HAL RC HA ie LC HA LR HA ie PL PH H TEF HA HA MELLA pr H a Figure C 22 Trades from Fund Rebalancer 7 To upload the file to Schwab select Send Trade List from the File menu Enter your user ID and password and click OK N ote In cases where proceeds exceed purchases in sets of linked trades the import process will generate messages on the Import File Format Errors page stating Buys total xx Excess proceeds will Figure C 21 Importing External Trade File go to cash This is an informational edit and not a fil
254. rt File Format Example 11111111 00500 00 Test account 1 22222222 10000 00 Test account 2 33333333 00250 00 Test account 3 9 137 Chapter9 Management Fees Opening Previously Created Files If you are sending similar M anagement Fees files on a regular basis you may want to open a previously created file and edit it TO Open a previously saved M anagement Fees file 1 Select the M aster Account that contains the file you want to open 2 Click Ea or select O pen from the File menu The Open dialog box Figure 9 4 appears Figure 9 4 Open Dialog Box 3 From the Look in field select the file you want to open and click Open You are returned to the M anagement Fee Processing window and the grid is populated with the fee information from that file 4 Makethe necessary changes See the next main section Revising Information SchwabLink User M anual F Select Save As from the File menu and save the new file with another name REVISING INFORMATION After you enter or import data in the worksheet grid you can edit delete or sort it Editing Information To edit information in the worksheet 1 In the M anagement Fee Processing Worksheet grid click on the row that you want to change The details appear in the Enter Edit section of the M anagement Fee Processing window Place your cursor in the Fee Amount field and enter the new fee Click the Add Update Fee button The record is
255. s 4 30 Chapter 4 Download Utility DOWNLOADING ALL NEw FILES FROM THE SCHWAB INSTITUTIONAL WEB SITE With the Download Utility you can download all your new files with one operation The Download All N ew Files feature performs the following functions e Dials up your Internet service provider ISP to get on the Internet unless your ISP is America Online AOL AOL users must connect to AOL prior to starting the download process e Goes to the URL for the Schwab Institutional Web site www schwabinstitutional com e Logs into the Schwab Institutional Web site using your user ID and password e Downloads all new files N ew files are defined as files that have become available since the last time the specified user ID downloaded files N ote The next three sections Security Configuration and Operations contain pre requisite steps and other information you need to know in order to set up the Download All Files function effectively Read these sections before proceeding to Download All N ew Files Setup and Procedure Security Set up a user ID and password to be used by the Download All N ew Files function of the Download Utility This user ID must be set up with access to the Web file downloads function for some or all M aster Accounts as appropriate Contact your Firm Security Administrator to set up this user account Or contact Technical Client Services for assistance between 8 00
256. s that enable you to take full advantage of each module within SchwabLink Getting Help If you have questions or need assistance please contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time M onday through Friday e For investment advisors call 1 800 647 LIN K 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 Option 2 or e mail rps techserv schwab com 1 11 Chapter 2 Getting Started WELCOME TO SCHWABLINK 2 3 AND THE SCHWAB INSTITUTIONAL WEB SITE Welcome to SchwabLink 2 3 for Windows M ake the most of your time and resources by using SchwabLink to place trade orders receive up to date account and financial data and manage assets more efficiently The Schwab Institutional Web site www schwabinstitutional com is your source for downloading account information and transac tion data In addition to providing account information to SchwabLink the Web site is your Internet channel to Schwab Institutional Getting Immediate Assistance If you have questions or need assistance please contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time M onday through Friday e For investment advisors call 1 800 647 LIN K 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 O ption 2 or e mail rps techserv schwab com Other Resources As you use SchwabLink you will learn how to take advant
257. s are formatted so that they will post to individual portfolios with their transactions Total Dollar Amount Cash total of all transactions listed in the viewer Total Commissions Total of all amounts listed in the Commission column of the list Summary totals change to reflect query results as well as addi tions or deletions to the viewer list Using the Q uery command you can display summary totals for a client or group of accounts for a specific period of time or for one or more securities SchwabLink User M anual This aggregate data can provide fast reporting on your Schwab activity For example if you complete a query to display only the previous day s transactions the aggregate summary data amounts to a report of your Schwab transactions for that day When you complete a query to display the transactions for one client account for a specific period of time the aggregate data shows Schwab activity totals for that account for that period Adjusting the Transactions List Viewer Display You can change how information in the viewer is displayed To change column order and width or to sort data see Changing Column Order Adjusting Column Width and Sorting Data on page 5 83 Navigating in the Transactions List Viewer Use any of the following methods to find records in the Transactions List viewer e Record navigation buttons e Record navigation functions in the Window menu e Find function see
258. sactions before post ing The comments are formatted to post to individual portfolios Dollar amount of transaction The net dollar amount of the transaction This amount is the net cost or net pro ceeds as displayed on an individual trade confirmation e Source destination code This field should always contain a ca security type or the word client or none See Source and Destination Codes on page A 163 e Quantity The number of shares or the face value of an asset if denominated in dollars All downloaded transactions Schwab Defined Security Types Schwab has created the following seven security type codes T hese are used in downloads Please note that these are addition al security type codes You must add these codes to your Security Type file when needed cd Certificate of Deposit ip Index Participation Contracts SchwabLink User M anual A 162 Appendix A Transaction File Formats mn tn un ut wt M utual Funds N on taxable Treasury N ote UIT N on taxable UIT Taxable Warrants Source and Destination Codes Schwab downloads seven ca security types to the SOURCE DESTINATION field The seven symbols and their definitions are as follows cash Cash account margin Margin account dvwash Provides wash treatment dvlong Records all mutual fund long term capital gain reinvestments dvshrt Records all mutual fund short term capital gain reinvestments calong Records all mutual fund lon
259. screen If you display a clock at the lower right corner of the screen you can confirm the date and time on your PC quickly M ove the cursor to the Time indicator in the lower right hand corner of your screen and double click the time The Date Time properties dialog box appears M ake necessary changes and close the dialog box Client Server Network Installation Use Windows Explorer to create a network directory on the server This directory must be available to all workstations accessing SchwabLink The network user login IDs must have read write and create rights for the network data directory For example each workstation could have access to an R SchwabLink Data directory This directory will contain the downloaded data files and the Account Viewer database files to be shared by the work stations When defining preferences on each client machine this data path should be used for the specific M aster Account This will configure the network location as the data path and cause all applications in the SchwabLink software to use that directory 2 26 Chapter 2 Getting Started Peer to Peer Network Installation To Install SchwabLink on a peer to peer network 1 Install SchwabLink on one PC as described earlier in Installing SchwabLink on Your Computer on page 2 14 2 In a module Preferences dialog box set up a M aster Account and associate it with a directory as described earlier in Adding a M aster Account on p
260. ser M anual Value 67 355 39 975 39 690 24 816 14 480 3 560 189 876 Value 75 950 56 963 37 975 18 988 189 876 Asset 35 5 21 1 20 9 13 1 7 6 1 9 100 Asset 40 30 20 10 100 Using the Strict Rebalancing method 8 orders were generated Asset CON DD UW BP W N e FUNDC FUN DB FUN DE FUNDA FUNDD NEWF1 NEWF2 FUNDC Action Buy Sell shares Sell all Sell all Sell all Buy Buy Buy Amount 24 816 20 987 3 560 67 355 14 480 56 963 37 975 11 444 Since the Strict Rebalancing method forces your current portfolio to the model portfolio s assigned asset percentages the following orders were generated e 3 sell orders 3 4 5 were generated for funds not in the model portfolio e 3 buy orders 6 7 8 were generated for funds not in the current portfolio 1 Buy order 1 was generated for FUN DC to meet the higher allocation percentage in the model portfolio e 1 Sell shares order 2 was generated for FUN DB to reduce the position to the lower model portfolio allocation C 218 Appendix C Fund Rebalancer Using the High Low Rebalancing method just 3 orders were generated Asset Action Amount 1 FUNDA Sell all 67 355 2 NEWF1 Buy 56 963 3 NEWF2 Buy 10 392 Since the High Low method starts by identifying the furthest outlying positions the following orders were generated FUN DA This fund represented 35 5 of the current portfolio
261. set Allocation drop down arrow 5 Highlight the mutual fund symbol you wish to add to the model or type in a new fund symbol 6 Type the percentage value the fund represents for your model in the field 7 Click the Add button The model s asset table will include the new fund 8 Repeat steps 4 6 until the model s TOTAL ALLOCATION iS 100 9 Inthe M odel M aintenance section click Save M odel 10 Click the close box x in the upper right corner to close the M odel Configuration program Note It s only possible to save a model when the Total Allocation equals 100 SchwabLink User M anual Deleting a Model with Assignments Fund Rebalancer prevents deleting models that have account assignments Prior to deleting any model the assigned accounts must be de linked To delete a model with account assignments 1 Click the M odel Assignment Screen toolbar button a 2 Click the M odel Assignment tab 3 On the Accounts with M odels tab click on the M odel column header to sort the accounts by assigned model 4 On the Accounts with M odels tab select the first account assigned to the model being deleted 5 Shift click the last account assigned to the model to be deleted This should select all assigned accounts for that model Prior to deleting a model you may wish to print a Model by Name report and a Model Assignments by Model report for reference C 201 Appendix C Fund Rebal
262. short cut on the desktop select Run from the Windows Start menu and enter the full path of the filter application Figure B 17 Example c Program Files SchwabLink Desktop SL Filter exe u N ote If the U parameter is not used the program will run in manual mode SchwabLink User M anual Type the name of a program folder or document and Windows will open it for you IY Run in Separate Memory Space Cancel Browse Figure B 17 Run Dialog Box Canceling the Results of the Filter Process If you do not want to save the results of the filter process click Cancel or the X button in each results window You can still reverse the filtering process even if you clicked Save although the reversal process is more lengthy W hen SL Filter successfully filters a transaction file the follow ing actions take place e The SL Filter renames the original downloaded transaction file extension from trn to org and leaves it in the same directory in which it originally resided e The SL Filter creates a new trn file containing only those transaction records that were selected by the filtering process e The SL Filter creates an additional file with the extension out containing the transaction records that were not selected in the filtering process The files reside in the directories you specified in the User Preferences dialog box To rename the files back to the original state and reverse the filtering proce
263. ss follow these steps B 178 Appendix B Transaction File Filter 1 Delete the filenames created by SL filter those with exten sion trn and extension out T hese files have the format csmmddyy trn and csmmddyy out 2 Rename the files with the extension org to have the exten sion trn Example cs101297 org gt cs101297 trn This completes the reversal Log File SL Filter contains a log file for output of information generated during the filtering process Data from each filtering process is continually added to the log file SLFilter log in the SLFilter directory under Program Files SLFilter At each month end the log file can be deleted or renamed A new log file is created when the filtering process is run again The log file contains information about each SL Filter run including e Start and stop times e Filter profile used e Files processed and created e Statistics e Any error messages SchwabLink User M anual 1000 0781 H ere is a sample of the output of the log file K KKK OK K K OK OK K K OK K K OOK K K K K OK K K K K K OK K K K K K K K K OK KOK K K KOK K OK K K K K K K K M anual mode start 12 10 97 5 32 07 PM 2K 2K OK OK K K KK K K K K K K K K K OK OK K OK OK K K K K K K K K K OK OK K Kk OK K OK OK OK OK OK KK KKK KX Filter DTC user File processed c WIN DOW S DESKTOP Cs101497 trn Files generated c WIN DOWS DESKTOP Cs101497 0rg c WINDOWS DESKTO P Cs101497 trn c WINDOWS DESK
264. st list of directories specifies the directories from which the input trans action files are read In unattended mode the program looks in each of these directories for a file named csmmddyy trn where mmddyy is the prior business date For example cs101397 trn Use the Unattended M ode portion of the User Preferences dialog box to specify the input and output directories used by the SchwabLink Transaction File Filter Initially SL Filter displays default directories in this field These are the directories that you have selected during the setup of SchwabLink H owever you can delete any of these directories at any time To add directories follow this procedure 1 Click the Add button The Add Data Directory dialog box Figure B 3 appears Add Data Directory D bes bo ie Sahect Ame ana deeectop Jr bo ali te haaaclien like F dieectoy list the liala chat in we Pm et Figure B 3 Add Data Directory Dialog Box SchwabLink User M anual 2 Inthe Drive field select the drive you want wy In the Directory box use your mouse and scroll bar to find and highlight the directory from which the file will be read 4 Double click on the directory you have selected or click the Select button 5 Click OK The dialog box disappears and the name of the selected directory appears in the Default Directories List box of the User Preferences dialog box Repeat steps 1 5 for every directory you want to add When you fi
265. start work Schwab Brokerage System To use the Advent transaction file effectively with your portfolio management software program you need to understand how Schwab brokerage conventions will affect what posts to your portfolio accounting system The Schwab brokerage system clears all transactions through a cash account The Schwab system records the movement of funds to or from money market accounts as well as movement of funds between a cash and a margin account These movements can occur at any SchwabLink User M anual time but they occur most often on a settlement date when funds are needed to settle a security purchase when proceeds have set tled from a security sale or when a client makes a deposit into his or her account Because both the Schwab brokerage system and Advent s portfolio management system use a double entry accounting system to record transactions each single transaction produces an entry in two accounts an account that is the source of the funds or assets and one that is the destination of the funds or assets Although Advent software allows transactions to be cleared through the Schwab cash accounts you may choose to clear all transactions through one default cash account on Advent s system Instead of recording all inter fund movements you can establish one ca cash type per portfolio The main advantage of this method is that the number of transactions posted to your client portfolios is m
266. stent with the infor mation in your portfolio software The portfolio management software compares the values of the Schwab reconciliation file to the values in the port folio management software and creates an exception report Include MVS Cash in Reconcile If this option is activated two additional fields are added to the position reconciliation file for market value totals of short positions in the cash account Consult with your portfolio man agement software to determine whether these fields can be used Substitute Custom Account Information Values on Build Update Although account details can be customized in the SchwabLink Database SchwabLink communicates with Schwab using Schwab specific account details Your customized details are displayed but the Schwab specific account details run in the background You must activate this option in order to display your cus tomized account details after Build Update Is run In the Account Viewer Preferences dialog box check Substitute Custom Account Information Values on Build Update If the option is not activated SchwabLink reverts to displaying Schwab account details 5 89 Chapter5 Account Viewer Include Positions Balances Transactions and Confirmations To include positions and balances transactions and trade confir mations in Build Update check the appropriate boxes in the Account Viewer Preferences dialog box If you do not include transactions or confi
267. ster Account you may press and hold down the CTRL key and click individual items in the group Click Open Click the Add Update button or press ALT A The selected files will populate the SchwabLink Upload Utility grid 8 Repeat steps 2 7 for each file type or M aster you wish to transfer 10 149 Chapter 10 Upload Utility Editing the File Transfer List You may edit the file transfer list including the associated M aster Account or file type To edit the list of files 1 Click on the file you wish to edit on the transfer grid The file specifics will display in the top portion of the template 2 From the top portion of the template make any changes to the M aster Account number or file type You may also select a different file by using the Browse button 3 Click Add Update or press ALT A The new file attributes will appear on the grid Removing a File from the Transfer List To remove a file from the file transfer list 1 Select the file to delete by clicking on any of its fields within the transfer grid The file will be highlighted 2 Click the Delete button The Delete Confirmation dialog box appears Figure 10 11 Delete Confirmation 2 Do you want to delete the highlighted row Figure 10 11 Delete Confirmation Dialog Box SchwabLink User M anual 3 Click Yes The file is deleted from the grid N ote Only one file may be deleted from the grid at a time SENDING THE FILES TO S
268. stified All alphabetic fields are left justified e All data elements are separated by a comma e All characters appear in lower case Your portfolio management software s standard file structure Is in ASCII text format Each transaction record consists of up to 12 data elements which will appear directly on your trade blotter screen after the transaction program is run See your portfolio management system user manual for a detailed description of the trade blotter file format or its equivalent The generic transaction file format includes e Account number This is your client s 8 digit Schwab account number To translate this number to your designated portfolio code see the user manual for your portfolio management system SchwabLink User M anual Transaction code This will be one of the eight acceptable portfolio management operations transaction codes buy sel dep wd cdt dbt int div A generic uncoded transaction comes down as a credit or debit Transaction date This date is the actual activity date that the transaction occurred trade date or ex dividend date not the date that the transaction was posted in the client s Schwab account Example A dividend was paid by a mutual fund company on February 27 but was not posted to the client s Schwab account until M arch 5 Therefore the transaction date is 0227Y Y However please note that this transaction will be downloaded as part of the M arch 5 transact
269. t 3 Repeat steps 1 2 as necessary for each M aster Account Specifying Account Validation There can be a one day delay between the time you set up a client account and the time it appears in the SchwabLink database M anagement Fees can validate the data that you enter into the worksheet against the details held in the SchwabLink Database If you enter a client account number that is not in the database and have selected the Validate typed sub accounts option in the Preferences dialog box a warning message tells you that the account number is not yet in the database You will not be able to transmit the information to Schwab To select this option click the Validate typed sub accounts checkbox A check appears If you enter a client account number that is not in the database and have not selected the Validate typed sub accounts option an asterisk appears in the question mark column next to the unrecognized account in the M anagement Fee Processing Worksheet grid You will be able to transmit the information To deselect this option click in the Validate typed sub accounts checkbox and the check disappears 9 142 Chapter 10 Upload Utility OVERVIEW The Upload Utility allows you to create a list of multiple files and send it to Schwab all within one transmission This transfer list may contain files of different types as well as different M aster Accounts Once Schwab receives the files the sof
270. t Copping F ne liyan phra baias oap ie Sepha enough rirerabon bo slei copang ha pogam ika iP you asni In reer he e tl otic Nou ave coated eth Ph cating chck Hest ta bags comm Cuei i Figure 2 9 Start Copying Files Window 11 To accept the installation settings proposed by the Setup program click the N ext button To make changes to the settings click the Back button W hen you finish making changes return to this step and click N ext The setup program begins copying files from the CD ROM to the destination folder and displays the progress of the installation Figure 2 10 2 18 Chapter 2 Getting Started Toh ad ink erkin eh em Pt rk Deakin Te Setup Status natal imh Wired Complete 5 Baa miiie rii Seheaaiel ink iihi Scheel ink Dardiop Sebup m parkaramg ihe requested opesrastorns amp CEEP imid riiag t FE Deethiop on pou Seale oen Muara Chee Fassel We oe choragi ctr Eeki dang Copano Abe iar O nap va o a lhe esra ia Figure 2 10 Setup Program Copying Files from the CD ROM Figure 2 11 Setup Complete After all files are copied the Setup Complete window ACCESSING THE SCHWABLINK DESKTOP AND Figure 2 11 appears SERVICES 12 To read the Read M efile for SchwabLink which contains the most current information available select the check box then click the Finish button You access SchwabLink modules by clicking icons on the SchwabLink Launcher screen To access SchwabLink in Windows select
271. t is active If you are exporting query results run the query first and make sure that the Query Results List viewer is active 2 Select Export from the File menu 3 Choose a location and file name for the exported file A default file name is provided in X X mmddyy csv format where X X is the designation for the exported viewer and mmddyy represents the update date for the data You may override the default file name with one of your own All files are exported in comma delimited format 4 Click Save SchwabLink User M anual DESIGNATION VIEWER CL Client Information CP Client Positions SL Securities List CM Composite Security Positions SC Security Cross Reference TR Transactions List DW Deposit Withdrawal List CN Trade Confirmations List Customizing the Account Viewer Window You can customize the Account Viewer window as follows e Hide or show the M aster Account list e Hide or show the toolbar e Resize the open viewers e Rearrange the open viewers Hiding and Showing the Master Account List If you only have one M aster Account or you want to expand the screens fully within Account Viewer you may want to hide the M aster Account list on the left hand side of the Account Viewer window From the View menu select M aster Account List to show or hide the list 5 84 Chapter5 Account Viewer Hiding and Showing the Toolbar To hide or show the Account Viewer toolbar select Toolbar from the View menu
272. tabase the fund name appears in the Swap Fund N ame field The Fund Instruction field is enabled Select the appropriate fund instruction N ote To duplicate swap orders for multiple accounts click Selected Accounts before adding the trade to the grid Follow the procedures for Selecting Accounts to Duplicate a Trade Order on page 7 106 6 Click Add Update The sell and the buy are entered in the M utual Fund Template grid as two entries Editing or Deleting a Swap To edit or delete a swap 1 Inthe M utual Fund Template window select the swap The Edit Linked Trades dialog box appears 2 Click the Yes button The Linked Trades window Figure 7 4 appears 3 Follow the procedures for editing or deleting linked trade orders later in this chapter Creating a Linked Trade Order in the Linked Trades Window Use the Linked Trades window to create linked trade orders other than swaps After you create the linked trade order it will also be displayed in the M utual Fund Template window To open the Linked Trades window click the Linked Trades but ton in the M utual Fund Template window The Linked Trades window Figure 7 4 appears SchwabLink User M anual TRD bp Fi mi e He THE f f gfe j ne Figure 7 4 Linked Trades Window Creating a Linked Sell and Buy Order To review the requirements for linked trade orders see Linked Trade Requirements on page 7 108 To create a linked trade
273. tar Sete Co inc Figure 2 4 User Information Window 6 Type your user name and company name then click N ext The Choose Destination Location window Figure 2 5 appears At the bottom of the screen the Setup program displays the recommended folder in which your SchwabLink files will be installed C represents your hard disk drive The SchwabLink files will be installed on your hard disk in the SchwabLink Desktop folder which resides in the Program Files folder The Setup program will also create a shortcut icon on the Windows Start gt Programs menu SchwabLink U ser M anual Tehas ri Desking Te Dhen a Darimah orahin iakat hija mhas Seb aa rna he Cohan val raal chasini Dadig in ha fokra lokia Teros be Hho miia cih hed Tendal k a djaai joa ck Bee ered cadet arih bhd Figure 2 5 Choose Destination Location Window 7 To accept the destination folder displayed click the N ext button To change the destination folder click the Browse button and select the drive and folder you want to use When you finish click N ext The Setup Type window Figure 2 6 appears It provides two setup options Custom and Typical We recommend that you select Typical to install all SchwabLink modules Custom enables users to select and install specific SchwabLink modules including sample data To perform a Custom installation see Other SchwabLink Installation O ptions on page 2 23 2 16 Chapter 2 Ge
274. te this setting select the box next to Check for duplicates in the M utual Fund Trading Preferences dialog box A Y appears To deactivate the setting select the box again and the v disappears SchwabLink User M anual 0901 03255 Showing or Hiding Titles in the Grid W hen the Show titles in grid box in the M utual Fund Trading Preferences dialog box has a titles are displayed in the M utual Fund Template window To deactivate this feature select the check box The disap pears When you return to the M utual Fund Template window the column titles will not show Checking File Format on Import When the Check file format on import box in the M utual Fund Trading Preferences dialog box has aw imported files will be checked for format errors To deactivate this feature select the check box The disap pears A warning dialog box appears Figure 7 15 to confirm that you want to continue Click Yes Imported files will no longer be checked for format errors ve it bat a j Fia boral vakis ell ee io ate S chess daar not accept mopy bor aor sacri oe ncomect deta vou ray hares ordered Cig pmu mard i coria Figure 7 15 Warning Dialog Box 7 119 Chapter 8 Securities Allocation OVERVIEW Use the Securities Allocation module to allocate block traded shares electronically among multiple client accounts Securities Allocation supports both Prime Broker trades and Schwab trades Once the secur
275. ter Account you can do so by using the Add M aster Account function Only one M aster Account can be deleted at a time To remove a M aster Account from the Upload Utility module 1 Select Preferences from the Options menu The Upload Utility Preferences dialog box appears Figure 10 2 Click on the M aster Account that you wish to delete Click Delete A Confirm Delete dialog box appears Figure 10 7 Confirm Delete 2 Are you sure you want to delete this Master Account Figure 10 7 Delete Confirmation 4 Click Yes to delete the M aster Account The M aster Account is deleted from the grid You will no longer be able to select this M aster Account in the Upload Utility template 5 Click OK to return to the Upload Utility template N ote Any changes to the M aster Account details in the Preferences section of the Upload Utility will show in the Preferences for Account Viewer Securities Allocation M utual Fund Trading Status Reports and M anagement F ees 10 147 Chapter 10 Upload Utility TRANSFER LISTS Once you have set up your preferences you are now ready to transfer file lists to Schwab To create a file transfer list 1 Open the Upload Utility 2 Default M aster should automatically appear in the M aster Account Field Figure 10 8 N ote To select a different master account click the master account drop down and select the appropriate master account Refer to Default Settings on page 10 14
276. tes SchwabLink User M anual 7 103 7 103 7 103 7 103 7 103 7 104 7 104 7 107 7 108 7 112 7 115 7 116 7 116 7 117 7 117 7 117 7 118 7 119 7 119 Showing or Hiding Titles in the Grid Checking File Format on Import Chapter 8 Securities Allocation Overview Prerequisites M ain Steps Securities Allocation Window M aster Account Field Allocating Securities Entering Schwab Trades Entering Prime Broker Trades Completing the Allocation Worksheet Sending Securities Allocation Files to Schwab Saving Files Sending Files R equeuing Deleted Files O pening Existing Files Printing Securities Allocations Importing Trade Files Schwab Trade File Format Prime Broker Trade File Format Example Importing an Excel Spreadsheet 7 119 7 119 8 120 8 120 8 120 8 120 8 121 8 121 8 121 8 122 8 125 8 126 8 126 8 127 8 128 8 128 8 129 8 129 8 129 8 131 8 132 Table of Contents Chapter 9 Management Fees Overview Prerequisites M ain Steps M anagement Fee Processing Window Selecting M aster Accounts Entering Account and Fee Data M anually Entering Data Loading Data from the SchwabLink Database Importing Data O pening Previously Created Files Revising Information Editing Information Deleting Rows Deleting Zero Fees Sorting Information Printing the Worksheet Sending Files to Schwab Saving the Worksheet as a File Sending Files R equeuing Deleted Files SchwabLink User M anual 9 134 9 134 9 134 9 134
277. the Schwab Institutional Web site browser application N ote If no new files are available when you select Download All N ew Files function a message is displayed and no files are downloaded SchwabLink User M anual Modifying the Completion Task The Download Utility allows you to execute one task automati cally at the end of every download This feature can be used to automatically run the Build Update process that is required to update the SchwabLink for Windows Account Viewer and generate the reconciliation R PS file that is used by most portfolio management applications If you have SchwabLink for Windows on the workstation where you installed the Download Utility module you were given the option to run the Build Update process automatically during the initial installation of the Download Utility To enter disable or enable a completion task 1 Start up the Download Utility module as described in Launching Download Utility 2 From the View menu select Completion task The Completion Task window Figure 4 1 is displayed showing details of the task that has been set up If no tasks are set up the Completion Task window is empty Camplattenm Tack BA Command Line ee YO Paame s DO Waking Crecy Po ST Fun Ste froma T Tak Ended cron Figure 4 1 Completion Task window 4 32 Chapter 4 Download Utility Do one of the following A To enter a completion task Enter the Command Li
278. tination C DataFirst Data FolderD etault Figure 10 15 Add Default Directory Dialog Box 5 Click OK 6 Click OK on the Upload Utility Preferences dialog box 10 152 Chapter 10 Upload Utility Unattended PCRA Upload Setup To set or change the Unattended PCRA Upload Archive directory 1 Select Preferences from the Options menu 2 Highlight the M aster Account for which you would like to set or change the Unattended PCRA Upload Archive Directory The directory information will appear in the mid dle portion of the dialog box N ote If the Unattended PCRA Upload Upload amp Archive directories are going to be the same as the general directories you can simply press the copy button located at the top right corner of the Unattended PCRA Upload section 3 Click the Browse button to the right of the Archive Directory textbox if you wish to setup a unique directory for the Unattended PCRA Upload process SchwabLink User M anual Set Unattended Archive Directory Deshnatiors ec Data gt First Data Folder PCRA Archive E C LOCAL z Selected Destination C DatasFirst Data Folder PCR A Archive Figure 10 16 Unattended Archive Directory Dialog Box 10 153 Chapter 10 Upload Utility N avigate to the new directory from the Set Unattended Archive Directory dialog box Double click on the desired directory Click OK Click OK on the Upload Utility Preferences dialog box to save the set up or chan
279. ting in the Client Account Positions Viewer Printing from the Client Account Positions Viewer Security List Viewer Fields and Columns in the Security List Viewer Adjusting the Security List Viewer Display N avigating in the Security List Viewer Printing from the Security List Viewer Composite Security Positions Viewer Fields and Columns in the Composite Security Positions Viewer Adjusting the Composite Security Positions Viewer Display N avigating in the Composite Security 5 42 5 42 5 43 5 44 5 44 5 44 5 45 5 45 5 48 5 48 5 48 5 49 5 50 5 50 5 50 5 50 5 51 5 52 5 52 Table of Contents Positions Viewer 5 52 N avigating in the D eposit Withdrawal Viewer 5 65 Printing from the Composite Security Printing the D eposit Withdrawal or Query Results List 5 66 os OS Lew et o gt Trade C onfirmations List Viewer 5 66 Se ECO ace ene 23 Fields and Columns in Trade Confirmations Fields and Columns in the Security Cross List Viewer 5 67 R LEENE MIENS ae Adjusting the Trade Confirmations List Adjusting the Security Cross Reference Viewer Display 5 68 Viewer Display 5 54 N avigating in the Trade Confirmations List Viewer 5 69 N avigating in the Security Cross Reference Viewer 5 54 Adding the Previous Day s Confirmations 5 69 Printing from the Security Cross Reference Viewer 5 55 O pening an Individual Confirmations File 5 69 Transactions List Viewer 22 Using the Query Command for Confirmations 5 70 Fields and Col
280. tion in the Confirmation List of Account Viewer See Chapter 5 Account Viewer See the end of this chapter for a glossary of codes used in the TOA Status and TOA Complete reports This chapter shows you how to e Open and exit the Status Reports module e Select a M aster Account SchwabLink User M anual e Select a report to view e Customize the viewer display e Print a report e Copy the contents of a report e Save reports to another location e Set Status Reports preferences Downloading Data into Status Reports N ote In order for your data to show up in Status Reports you must e Set up the appropriate M aster Accounts See Chapter 2 Getting Started e Download data into folders associated with the M aster Account See Chapter 4 Download Utility Status Reports Window To open the SchwabLink Status Reports module 1 Select the Accounts tab on the SchwabLink Launcher screen 2 Click the Status Reports icon The SchwabLink Status Reports window Figure 6 1 appears 6 91 Chapter 6 Status Reports ia SchwabLink Status Reports File Edit Options Window Help ey MI 4 EEL El escriptian Sample Data ap Event Notifications ay Confirmation Summary iP TOA Complete d Deposits amp Withdrawals J LIVERMORE INVESTMENTS INC ATTN JESSE LIVERMORE 610 W SCHWABLIWNE RD STE 300 PHOENIX z agds MASTER ACCOUNT NUMBER 06123456 Dear Financial Advisor 0612 1998 f
281. tional com allows you to transfer files containing price balance portfolio activity and other data from Schwab s computers to your workstation or network server via the Internet This file transfer is called downloading Files can be downloaded to workstations at one location or multiple locations You can import files into spreadsheet software portfolio manage ment software record keeping software or custom applications You can also view them in SchwabLink for Windows The Download Function Using the Schwab Institutional Web site you can download e All new files which are defined as files that have become available since your last file download You can download all new files in one operation e Files for specific dates e Files for one or more M aster Accounts e Files of a specific type W hile you are using the Web file download function you can also view e A list of new files not yet downloaded e A list of all new and previously downloaded files that are still available for download e The download history for one or more specific groups of files You can set up your Web file download to run the SchwabLink Build Update process automatically or you can run it manually using existing SchwabLink for Windows procedures This process also creates the RPS reconciliation file that you may SchwabLink User M anual use to perform automated reconciliation with your portfolio management software The Download
282. tomized software program thus eliminating time consuming manual data entry and costly errors SchwabLink also enables you to send trade and management fee files to Schwab securely and efficiently What s New N ew features of SchwabLink 2 3 include Fund Rebalancer Fund Rebalancer is an automated tool allowing you to manage model portfolios as well as perform mutual fund allocation and rebalancing functions It also includes the ability to perform what if analyses and generate trades via the SchwabLink M utual Fund Trading template SchwabLink User M anual 0901 03181 Installing SchwabLink Before you begin installation review the Recommended System Configuration section in Chapter 2 or in Getting Started SchwabLink 2 3 with Fund Rebalancer SchwabLink 2 3 is easy to install When you insert the SchwabLink CD ROM into your CD ROM drive installation begins automatically The first installation screen is displayed and guides you step by step through the installation process After you install SchwabLink you can reinsert the CD ROM to add additional modules as needed Steps for installing SchwabLink are provided in Chapter 2 of this manual and in Getting Started SchwabLink 2 3 with Fund Rebalancer Using This Manual Each chapter begins with an overview that provides a general description of and activities associated with the module Following the overview are detailed step by step procedure
283. ts from the selected M aster Account 1 Click the button or select Load from Database from the File menu All the accounts from the selected M aster Account appear in the Worksheet grid with a fee amount of 0 00 3 Click on a client account in the grid The account details appear in the Enter Edit Fee section of the window 3 Inthe Fee Amount field enter the management fee to be charged to this account 4 Click Add Update The fee amount is added to the listing in the Worksheet grid 5 Repeat this procedure for all accounts to which you are charging a fee 6 If there are accounts that you do not want to charge follow the procedure in Deleting Zero Fees on page 9 139 Importing Data To import data from another application 1 Make sure the file follows the format described in the next section Import File Format The extension for an external file is either csv comma delimited or txt tab delimited 2 Make sure that the correct M aster Account is selected in the M anagement Fee Processing window a From the File menu select Import External File The Open dialog box Figure 9 3 appears 9 136 Chapter9 Management Fees Look jn C ea i Figure 9 3 Open Dialog Box 4 From the drop down list in the Files of type field select the type of file that you want to import txt or csv 5 From the Look in field select the file that you want to import
284. tting Started ooh ad ink Deskin eh Setup Typa Dhene the pup koe that beh pir your reese Carb the type of Sebop wes praim Figure 2 6 Setup Type Window 8 Click the N ext button The Select Program Folder window Figure 2 7 appears displaying the SchwabLink Desktop folder that will be added to the Program Files folder on your hard disk You can rename the folder or select a folder from the list of existing folders to add to the Program Files folder SchwabLink User M anual Toh ad ink Deskiogn eh Salact Propam F nbin Piese pari a ppan biia Cohan val acd pogan cong Go hel Fade bled beds Yo mm hga area lokia narea or rabec one fean thee aing frideer bat ich Boel bp cordon b Acrobat a0 Java 2 Aunties Emi Figure 2 7 Select Program Folder Window 9 Click the N ext button The Create Desktop Shortcuts window Figure 2 8 appears You can have the installation create desktop shortcuts for SchwabLink Windows and or Download All N ew Files 2 1 Chapter 2 Getting Started Teha r Deskion hep Comate Gackiog Sneu FF Create anion kee SchestLink Windows RF Cregeen anon boo Dyed A Mea Fikes eo cea Figure 2 8 Create Desktop Shortcuts Window 10 Click the N ext button The Start Copying Files window Figure 2 9 appears Setup displays the proposed setting for your computer environment setup type and target folder SchwabLink U ser M anual Tehas i Deakin Tei Sea
285. tware archives the transmitted files to a directory of your choice N ote The Upload Utility is used primarily by clients of Retirement Plan Services RPS These clients typically send multiple files of varying types to Schwab The upload utility allows you to transfer the following file types e CSTC Disbursements e CSTC Trades e M anagement Fees e M utual Fund Trades e PCRA Account O pen Cashiering e Securities Allocation Prime Broker e Securities Allocation Schwab e Universal Trades e U S Trust M anagement Fees To access the Upload Utility select the Utilities tab for the Utilities folder and click on the Upload Utility icon The Upload Utility M ain M enu appears Figure 10 1 SchwabLink User M anual Doge tu chem it phis Lp Ci lt j Hira Se Fir ppt paon Lie l D Pir is Uinie Figure 10 1 Upload Utility Main Menu SETTING PREFERENCES Before transferring files to Schwab you should set the prefer ences for the SchwabLink Upload Utility The Upload Utility has several settings that can be adjusted from Preferences on the O ptions menu Within the Upload Utility Preferences dialog box you may edit the following e Archive directories e Default directories e Default M aster Account e Default File Type 10 143 Chapter 10 Upload Utility e Unattended Personal Choice Retirement Account PCRA Upload Archive directories e Unattended PCRA Upload directories e Unattended PCRA Upload
286. ual needs The custom program must be able to import an ASCII text file To create a successful interface with the Schwab file structure consider two points e Should you keep the current method of identifying trans actions or switch to the Schwab system format H ow will you restructure the file format if data elements need to be rearranged Example You need to translate the Schwab account number to match the value you currently use Additionally you want the new number to appear in column five rather than col umn one the location to which Schwab sends It You will need to write a translation program to convert the location SchwabLink User M anual 1000 0765 ADDITIONAL INFORMATION To get additional information about file format specifications and using SchwabLink transaction file formats with your portfolio management system e Refer to your portfolio management system user manual e Contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time M onday through Friday e For investment advisors call 1 800 647 LINK 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 O ption 2 or e mail rps techserv schwab com N ote For questions regarding record keeping file format specifications contact Technical Client Services at 1 800 231 2855 Option 2 A 164 Appendix B Transaction File Filter OVERVIEW Use the SchwabLink SL Transaction File
287. ude a Kammer eal com Bods shee om ad P T nh nla rg E OE Sample Data Figure C 34 Specific Dollar Exclusion Example If the defined cash exclusion is greater than the account s Total Cash Fund Rebalancer will exclude the Total Cash amount The order list will not result in a higher cash balance in the account by selling funds and retaining cash to bring the cash balance up to the exclusion amount Note The securities displayed are fictional and used for illustration purposes SchwabLink User M anual Exclusion indicator and EX entry Excluding Specific Funds The M odel Assignment program automatically determines which funds are eligible for exclusion by comparing the account s current portfolio to the model portfolio Any mutual fund presently held but not allocated in the model portfolio appears in the Asset Exclusion table These funds will be sold unless excluded It is not possible to exclude specific share quantities or dollar values for a fund To exclude specific funds from rebalancing i 1 Click the M odel Assignment Screen toolbar button 2 Click the Accounts with M odels tab 3 Click the account for which you wish to set exclusions 4 On the Account Exclusions tab click the checkbox in the X column for each fund you d like to exclude C 211 Appendix C Fund Rebalancer i rien rh Para ebda rr sirable A N rra A El Eeri fpqepeest feme kae Hele a J ae 9 ees
288. ulations in your state regarding storage and backup of mutual fund trades Mutual Fund Trade List A mutual fund trade list is a list of trade orders for one M aster Account that you send to Schwab The list can include orders for numerous clients within that M aster Account You can send only one mutual fund trade list at a time Mutual Fund Template Window To open the M utual Fund Trading module 1 On the SchwabLink Launcher screen select the Trade tab 2 Click the M utual Fund Trading icon The M utual Fund Template window Figure 7 1 appears 7 103 Chapter 7 Mutual Fund Trading If this is the first time that you have opened the template the Archive dialog box appears instructing you to select a location for archived files Click OK to accept the default archive drive typically C To select another default archive drive see Archiving Files on page 7 117 To exit the M utual Fund Trading module 1 From the File menu select Exit If you added or edited trades and did not save them prior to selecting Exit the File N ew Information dialog box Figure 7 2 appears 2 Click Yes to save the trade order list and exit the M utual Fund Trading module H gre ermar bh rej PAPA blipa krmari Hee Te Ci i akill Cp dainai Fh miza a H eee mati T Dc apie Jakas ii 5 petal Firid Oa Hb lel Tii Figure 7 1 Mutual Fund Template Window SchwabLink User M anual File New Information Would you
289. ults SL Filter displays all results for the files that could be processed Check the filter log file SLFilter log in the same directory where the SL Filter application is installed in a word processing program to Identify any files that were unable to be processed 8 To save the results of the filtering process click Save in each results window B 17 Appendix B Transaction File Filter Running the Filter in Unattended Mode In unattended mode SL Filter filters transaction files from the directories you specified in the User Preferences dialog box SL Filter only chooses those files with names that contain the prior business day s date Running the filter in unattended mode gives you the ability to e Filter transaction files for multiple M aster Accounts at one time e Append multiple transaction files into one file e Run the filter automatically after your daily download There are two ways to run SL Transaction File Filter in unattended mode e Launch the filter from an icon on your desktop To get help setting this up contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time M onday through Friday e For investment advisors call at 1 800 647 LINK 5465 or email techserv si schwab com e For Third Party Administrators call 1 800 231 2855 O ption 2 or email rps techserv schwab com e Run the filter from a command line To run the application from the command line or from a
290. umns do not show up in the Transactions List Deposit W ithdrawal List Trade Confirmations List or Trade Confirmation Detail viewers The fields in these viewers revert to Schwab assigned values Customizing Account Data To customize client account data 1 From the M aster Account list in the Account Viewer win dow select the M aster Account that contains the client account information that you want to customize 2 From the Tools menu select Account Customization The Account Customization List window Figure 5 39 appears SchwabLink User M anual Uroa Luror lel THAR rT COAVETTE JT TEH DHIE HAE ORETTE amp HATER MoD i Disi TEA WILLE ew ace ESN ALFRED HERRA UTA CHARLES SCHWAB b EO PMC SET Rein 2 BHHE ASEH SS MAZDA HLE ETEN AM JETTA 123 FOVER RD PER al GAMUEL GATUAH SALLY ANJRAH JT TEM Figure 5 39 Account Customization List Window The first account in the grid in the upper part of the window is the M aster Account 3 Select an account in the grid in the upper part of the window The details of that account appear under Schwab Account Information on the left side of the window 4 If you want to customize only one or two lines of the informa tion click on the arrow button next to the Schwab Account Information line The information is duplicated on the right side of the window under Custom Account Information Edit the data that you want to change by deleting the infor mation in the rig
291. umns in the Transactions LIEN ewer 5 56 Printing the Confirmations List or Q uery Results List 5 72 Adjusting the Transactions List Viewer Display 5 58 Using the Purge Function 5 73 N avigating in the Transactions List Viewer 5 58 Storing Your Trade Confirmations 5 74 Adding the Previous Day s Transactions 5 59 Trade Confirmation Detail Viewer 5 74 O PEMO san U yG anaE EON Sa E oa Fields in the Trade Confirmation Detail Viewer 5 75 Using the Query Command for Transactions 5 60 Account Viewer Feauires 5 76 Printing the Transactions or Query Results List 5 62 Build U pdate 5 76 Using the Purge Function 5 63 Running Build Update 5 77 D eposit Withdrawal List Viewer 5 64 Using the Find Command 5 81 Fields and Columns in the Deposit Withdrawal Viewer 5 64 Using the Find Command in the Positions and Adjusting the Deposit W ithdrawal Viewer Display 5 65 Security Cross Reference Viewers 5 82 SchwabLink User M anual Table of Contents Changing Column Order 5 83 Opening a Report by Report Type 6 93 Adjusting Column Width 5 83 Saving a Report 6 94 Sorting Data 5 83 Closing a Report Viewer 6 95 Exporting Data 5 84 Customizing the Status R eports D isplay 6 95 Customizing the Account Viewer Window 5 84 H iding or Showing the Toolbar 6 95 Customizing Data in Account Viewer 5 86 Adjusting the Width of the M aster Account List 6 95 Setting Preferences 5 88 Tiling Report Viewers 6 95 Selecting the File Data Type 5 89 Cascading Open Report Viewers 6 9
292. updated in the grid Deleting Rows To delete rows of information l To select a single row for deletion click anywhere in the row The line is highlighted To select contiguous rows for deletion highlight the first row you want to delete hold down the Shift key and click on the last row you want to select Or hold down the mouse button and drag the cursor until all the rows you want to select are highlighted Click the Delete Fee s button The Delete Fees dialog box Figure 9 5 appears 9 138 Chapter 9 Management Fees Delete Fees Fu Are you sure you want to delete the highlighted fees Figure 9 5 Delete Fees Dialog Box 3 Click Yes All the highlighted rows are deleted Deleting Zero Fees You may not want to charge a fee to some accounts After you complete the procedure in Loading Data from the SchwabL ink Database on page 9 136 for all accounts that you want to charge follow these steps to avoid charging the remainder 1 In the M anagement Fee Processing Worksheet click the D elete Zero Fees button The Verify Deletion dialog box Figure 9 6 appears Yernty Deletion Are you sure you want to delete all rows with fees of zero dollars Figure 9 6 Verify Deletion Dialog Box 2 Click Yes You are returned to the M anagement Fee Processing Worksheet Only the rows with fees allocated appear in the grid SchwabLink User M anual Sorting Information To sort information in the M ana
293. vated with trading authorization For fur ther information visit the online help section of the Schwab Institutional Web site To send a mutual fund trade order list to Schwab 1 Verify that the trade list you want to send Is displayed in the M utual Fund Template window If it is not select O pen from the File menu then select the trade file ry 2 Click the button or select Send Trade List from the File menu A dialog box appears showing the last user ID that was entered 3 If your user ID is different from the displayed user ID enter your user ID You must enter your user ID and password every time you use the M utual Fund Trading module to send a trade order list to Schwab Enter your password Click OK The file is sent to Schwab If transmission is successful a confirmation message appears showing the file name 6 Click OK You are returned to the M utual Fund Template window You can review the status of the uploaded mutual fund trade file by visiting the Schwab Institutional Web site www schwabinstitutional com Go to the Upload Activity Log located in the Trade section Sent files are automatically archived with a TM extension SchwabLink User M anual For information on the archive functions of the M utual Fund Trading module see Archiving Files on this page If file transmission is unsuccessful try to resend the file to Schwab If the transmission is still unsuccessful please conta
294. ve not entered a Disbursement Account you should store the Disbursement Account number for your records in the M anagement Fees module Follow the procedure in Setting Up Disbursement Accounts on page 9 142 SchwabLink User M anual To exit the M anagement Fee Processing module select Exit from the File menu Selecting Master Accounts Before entering any data make sure that the correct M aster Account is selected If it is not select the account from the drop down list in the M aster Account field You cannot enter a M aster Account number manually If you do not see the M aster Account number you need and attempt to type it in the M aster Account Changes dialog box Figure 9 2 appears Sot belaic Haiba Account chape Fisso mre the fle bef changing the msie souri OE Figure 9 2 Master Account Change Dialog Box To set up or modify a M aster Account see Chapter 2 Getting Started ENTERING ACCOUNT AND FEE DATA There are several ways to enter data into the M anagement Fee Processing Worksheet e M anually enter data e Load account information from the SchwabLink database and enter fee information into the worksheet e Import information from an external file e Open and edit a previously created M anagement Fees file 9 135 Chapter9 Management Fees Manually Entering Data To enter data manually 1 Make sure that the correct M aster Account is selected 2 Select or enter the client a
295. wer Cash ACCOUNT BALANCES Market Value Short Total market value of all short positions in the margin account Net Credit or Debit Amount of money on deposit in the cash account If the EE figure is negative the client owes Schwab this amount Equity Including Options Total equity and value of any option positions in the margin account This is the liquidation value of the margin account Net Market Value Market value of security positions held long in the cash if it has option positions account Margin Cash Available Amount of money that can be withdrawn from the margin Money Market Funds Amount currently invested in Schwab money market funds account Includes credit balance in margin account plus maximum amount that can be borrowed against marginable securities ACCOUNT STATISTICS Equity Excluding Options Dollar value of securities in the margin account less any ee amount owed to Schwab plus any cash in margin account Equity Percentage Equity in a margin account divided by the market value of the This is the liquidation value of the margin account if it does positions held The balance reflects the percentage of the not have any options current margin account value that the client would receive if positions were liquidated and any margin debt paid off Margin Buying Power Maximum value of additional marginable securities in a which the client can invest without depositing equity in the Option Requirements Total equity required to maintain curre
296. when you click L or select M inimize All from the Window menu e Print Recent Reports on Startup All current Status Reports automatically print the next time you open the Status Reports module M ake sure your printer is on To activate these options simply click in the check box next to the appropriate option Setting Default Text Options You can change the type font size and style for the text that appears in the Status Reports In the Text Options area of the Preferences dialog box click the Font button In the Font dialog box Figure 6 9 that appears select a font font style and type size 6 100 Chapter 6 Status Reports Copes UseD IN TOA Status AND TOA Cope DESCRIPTION COMPLETE REPORTS HOLD Hold The transfer request has been received and reviewed During CODE DESCRIPTION review a problem was detected requiring resolution before processing may continue ACAT The Automated Customer Account Transfer ACAT system electronically NOTE Mutual Fund transfers have a temporary HOLD status as the transfers between member firms more quickly than non ACAT systems proper re registration paperwork is prepared and forwarded along with do For a transfer of account to qualify for the ACAT system it must be a the transfer form to the delivering firm full account transfer Mutual fund bank and insurance accounts may not qualify tor ACAT transfers INIT Initiated For Non ACAT transfers only the transfer papers received by
297. window click the Setup Filter button 2 Inthe Setup Filter dialog box highlight the profile you want to work with 3 Doubleclick the selection or click the Edit button The Filter Builder Window Figure B 5 appears Pitter Builder Tn echo ode Scag ed se ee ol de T wyl fare leo leeds Souuiy por re ee mys leeds kpr ml Far Figure B 5 Filter Builder Window DTC User In the Filter Builder each selection criterion is listed on a sepa rate line Scroll up and down the list with the scrollbar at the right to view the complete list The logic is read from the top down and each line is a separate statement in a complex logical expression Groups of field selec tions are enclosed in parentheses Each line is connected to form one stream of logic for which the rules of Boolean logic apply SchwabLink User M anual Example The logic for the DTC user profile means that the following transactions will be included in the trn file e Cash deposits and withdrawals e Interest on cash security types e Expenses e Cash dividends e M utual funds transactions e Receipts of securities e Other assets e Return of capital transactions e Adjusted capital transactions After you review any set of criteria you may decide to customize a filter based on one of the existing profiles To do this follow the instructions as needed in the next section M odifying an Existing Profile and in Filtering on Comment
298. xcess digits is consistent with the Schwab system Commission amount The dollar amount of the commission charges as displayed on an individual trade confirmation When a transaction is completed on a principal basis no commission is shown A 159 Appendix A Transaction File Formats e Unit cost Where applicable this is the unit cost of the security e Accrued interest W here applicable this is the dollar amount of accrued interest paid mostly used in determin ing the cost basis of a bond When you purchase a new bond the accrued interest shows as 0 00 When you pur chase any noninterest bearing security this field is blank Broker code Where applicable the broker code Is trans mitted as schwab If the trade was done with another broker Prime Broker trade that broker s code will be shown Advent Transaction File Format Working with Advent software Schwab has developed a transac tion file formatted for use with Advent s popular portfolio man agement software programs that enables fast easy daily updating of your client portfolios The data you receive in your download includes Schwab account price and transaction information that mirrors the format used by the Schwab brokerage system Asa user of Advent software programs you receive the data in a for mat that is immediately readable by your portfolio management software You do not need to spend time typing transactions or reformatting the data before you
299. y Date Use the arrows to change the date to the desired file date N ote Only one day s worth of files can be downloaded at a time If additional files are needed the dates must be adjusted accordingly and another download must be executed Click OK to execute the download process 4 37 Chapter5 Account Viewer OVERVIEW Use the Account Viewer module to update the SchwabLink Account database with the latest client account and securities information You can display or print the information in nine different views and view information from different M aster Accounts at the same time with no limit to the number of viewers that can be open at once N ote In order for your data to show up in Account Viewer you must set up at least one M aster Account See Chapter 2 Getting Started This chapter shows you how to e View navigate and print from nine viewers that show client account securities transactions and trade confirmation information Use the Query command to search for display and work with selected transactions and confirmations Purge transactions and confirmations automatically or manually Run Build Update to update the database manually Add transactions and confirmations manually Speed searches by setting up and editing your own cus tomized values for account and security information Set other Account Viewer preferences N ote Build Update now simultaneously updates all M aster Accounts i
300. y be resized bb fel i Lal ha 2 Portfolio pane 1 Account Sample Data Figure C 3 Fund Rebalancer with View Charts option 1 Account pane T his pane contains two tabs listing accounts with model assignments e Account List accounts with model assignments highlighted in Figure C 3 e Selected Accounts List accounts with model assignments in preparation for order generation Note The securities displayed are fictional and used for illustration purposes SchwabLink User M anual Actual Portfolio tab Account List tab When you select an account from the Account pane Fund Rebalancer displays the corresponding asset information on the Portfolio pane and Graph area 2 Portfolio pane T he Portfolio pane consists of three tabs that represent the before and after account picture if all generated orders executed These tabs include e Actual Portfolio highlighted in Figure C 3 e Order List e Projected Portfolio These last two tabs are only enabled after you ve moved accounts to the Selected Accounts List and generated orders 3 Graph area T his is an optional area located below the Portfolio pane This area displays either bar charts or pie charts from the selected tab in the Portfolio pane The feature is available either from the O ptions menu or View Chart toolbar button C 184 Appendix C Fund Rebalancer Step 1 Creating Models 2 Inthe M odel Maintenance section click the
301. y downloaded your daily files You must complete the following activities Today 1 Set up the Download Utility for ongoing daily downloads and Account Viewer updates that will begin tomorrow See Chapter 4 Download Utility 2 Use Account Viewer to view account and position data for each or all of your portfolios See Chapter 5 Account Viewer 3 Use Account Viewer to view and verify your most recent file of all transactions you made through Schwab 4 UseAccount Viewer to view and verify confirmation data Tomorrow 1 Perform the daily download See Chapter 4 Download Utility 2 Use Account Viewer to view and verify your most recent file of all transactions you made through Schwab 3 Use Account Viewer to view and verify confirmation data See Chapter 5 Account Viewer SchwabLink User M anual INSTALLING SCHWABLINK ON A NETWORK Sharing data on a network allows several workstations to access SchwabLink s Paradox data tables and other data simultaneously N ote The SchwabLink software must be installed on each work station Although the data files can be shared the SchwabLink software is not a true network application The program executable files cannot be loaded onto a network drive and shared among several workstations Each workstation should have the SchwabLink software installed on the C drive as in a stand alone installation You then set the path to the data d
302. you time and effort because you e No longer receive hundreds of pieces of mail e Save valuable storage space e Can sort and organize electronic confirmations with SchwabLink for Windows 5 14 Chapter5 Account Viewer The selected M aster Account N umber is shown in the title bar Fields in the Trade Confirmation Detail Viewer Trade Confirmations Detail 08000000 DATA TYPE FIELD NAME DESCRIPTION si Edd ok dead Wipe I Cerda Feld N S eo eee Pe El too reer re non Account Data Account Number Number of the account in which the trade Farn ea Companies Sec Ceca e Clem sich Cordimn Se eT Variables was placed S imrit ree aai Lae Prussia EE ERE ne ap Account Name Registered name and address of the RAPD AVM E tee some account for which the trade was placed cpr e a ENE on uk es Arra ini nm Account Type Type of account in which the trade was Hae Ths um processed for example cash or margin Bam ca mc GbE Fe Pit i Ha MC Cui i WEHI Biat Aki ir g Trade Related Action Action taken for the trade usually bought Ga Eg his tern PrE Variables or sold Te wT H pes LMA Fema BaF pe a a Gn Meco Quantity Security units traded r Ses i 1 1 1 Aree inta meals Item Description Description of the security _ iniii z Executed Date on which the trade was executed Figure 5 26 Trade Confirmation Detail Viewer Symbol Ticker symbol for the security Price Unit price of the trade The following table describes fi
303. you to provide efficient high quality client service Security and System Requirements Before you access the Schwab Institutional Web site review the Recommended System Configuration section in Chapter 2 or in Getting Started SchwabLink 2 3 With Fund Rebalancer All users of the Web site within your firm must have a valid user ID and password which are available from your Firm Security Administrator FSA If your firm does not have access to the Web site or you do not have an initial user ID and password your Firm Security Administrator should contact Technical Client Services between 8 00 a m and 6 00 p m Eastern Time M onday through Friday e For investment advisors call 1 800 647 LIN K 5465 or e mail techserv si schwab com e For Third Party Administrators call 1 800 231 2855 O ption 2 or email rps techserv schwab com For additional information on the role of the Firm Security Administrator please refer to the H elp section of the Web site SchwabLink User M anual Schwab Institutional Web Site Key Features Some key features of the Web site include Alerts R eceive real time notifications from Schwab Institutional regarding new account and account transfer status Only available to investment advisors e Customization Customize your home page by selecting what kind of information you want to view Elect to receive e mail notification of relevant news available on the Web site e S

SchwabLink® 2.3 User Manual v

Contents

Download Pdf Manuals

Related Search

Related Contents

SchwabLink&reg; 2.3 User Manual v

Contents

Download Pdf Manuals

Related Search

Related Contents

SchwabLink® 2.3 User Manual v