TUTORIAL GUIDE PART 2: FILE MAINTENANCE                     PAGE 1 OF 14

This tutorial assumes you have already installed the Personal Portfolio
Analyzer on your hard disk, or have made working copy diskettes to use.
It also assumes you are familiar with Part 1, which takes you through a
step-by-step procedure to acquaint you with the program.

In Part 2, we will perform "file maintenance" - the process of adding,
deleting and changing data in a file.  A "file" is a contiguous set of
homogeneous data, such as the catalog (which contains the list of
securities) or a portfolio (which contains a list of transactions).
It is also a named unit of data storage on disk, for example the cata-
log file which has the name CATALOG.POR.

Whenever the program asks you to enter information such as the name of a
security or a current price, the data is typed into a solid video block
near the bottom of the screen.  It is not necessary to fill that block.
Lowercase letters are automatically changed to uppercase (CAPITAL) let-
ters.  The backspace key (not the smaller left-arrow key) can be used to
make corrections.  



TUTORIAL GUIDE PART 2: FILE MAINTENANCE                     PAGE 2 OF 14

1.  Let's start by adding a new security to the list.  From the Master
    Menu, type A to go to the Securities Register.  You should see a
    list of securities with another menu at the bottom of the screen.

2.  Type A again to ADD a new security to the list.  You will see a list
    of security types at the bottom of the screen.  Use the left-arrow
    or right-arrow key to move the selector bar over the type of secur-
    ity you want.  For a description of the available security types,
    press H for HELP or see Chapter 12.  Press the Enter key to register
    your selection to the program.

3.  Enter the ticker symbol.  If there is no official ticker symbol,
    you must make one up, for example FRANKM for Franklin Money Fund.
    If you plan to "import" current price quotes from an external file,
    you must use the same ticker symbols as the source of your quotes.
    You can find ticker symbols in Barron's, The Wall Street Journal,
    Standard & Poor's Stock Guide or Value Line Investment Survey.
    Or, ask your broker.



TUTORIAL GUIDE PART 2: FILE MAINTENANCE                     PAGE 3 OF 14

4.  Next, enter the security name.  If you plan to enter current quotes
    from a newspaper, use a spelling similar to what is in the paper,
    including any blank spaces.  For example, use S C E CORP instead of
    SCECORP.  Blank spaces sort lower than any other characters; there-
    fore S C E CORP will come before SAN DIEGO GAS in the Current Quote
    screen.  You may have to re-arrange certain names, for example BLOCK
    H R instead of H&R BLOCK, or LILLY, ELI instead of ELI LILLY.  The
    security name can always be changed at a later time.

    In the Current Quote screen (discussed later in this chapter),
    securities are arranged by type, exchange and name (to facilitate
    entry of quotes from a newspaper).  In the Securities Register,
    securities are always arranged in order by type and symbol.

Only the security type, ticker symbol and security name are required by
the program; all other data items are optional.  You can press Enter by
itself to bypass entry of an individual data item, or Esc to terminate
data entry at any time.  We will be entering more data now.



TUTORIAL GUIDE PART 2: FILE MAINTENANCE                     PAGE 4 OF 14

5.  Enter a two-letter code to identify the exchange, such as NY for New
    York or OC for over-the-counter.  If you are entering a mutual fund
    or municipal bond, the program will not ask for the exchange.

6.  If you are entering a stock or mutual fund, enter an industry categ-
    ory such as COMPUTERS or a fund category such as TOTALRET.  Then
    enter the S & P (or other) ranking (if applicable and you know it).
    If you know it, enter the Beta, or just press Enter to leave a de-
    fault value.

7.  Enter the annual income per share (or other unit).

    Note that any data item can be entered or corrected later.








TUTORIAL GUIDE PART 2: FILE MAINTENANCE                     PAGE 5 OF 14

8.  Now the selector bar should be on the security you just added.
    Let's change one of the data items.

    Use the left- or right-arrow key to select the name of the security.
    Press C to change it; then try a slightly different spelling.  Using
    this method, you can change or correct any data item.  Be careful
    about changing the security type or ticker symbol - they have to be
    changed separately in each portfolio in which they appear.

    Press H (for HELP) or see Chapter 11 for further explanation of each
    individual data item.  Press Esc to see the Master Menu again.










TUTORIAL GUIDE PART 2: FILE MAINTENANCE                     PAGE 6 OF 14

9.  Now let's invest some money.  From the Master Menu type B to see the
    Portfolio Select screen for buying and selling.

    You may remember from Part 1 that a portfolio can be any grouping
    of security purchases (tax lots).  A portfolio should have a mean-
    ful name such as PERSONAL or 401K or HUSBIRA.  The portfolio name is
    also used with the extension .POR as a DOS filename on the disk.

    Use the up- or down-arrow key to select DEMOFILE.  Then press the
    Enter key once more to invoke the BUY function.  You should see
    a list of transactions on the screen.










TUTORIAL GUIDE PART 2: FILE MAINTENANCE                     PAGE 7 OF 14

10. Type B (for BUY) to enter a new transaction.  Near the bottom of the
    screen, the program will be asking you to enter the ticker symbol
    for the security you want to buy.  That symbol must exactly match
    one already existing in the Securities Register.

    Let's say you forgot the exact spelling of that symbol.  Press Esc
    once to get the menu back on the bottom of the screen.  Then type A.
    This will take you to the Securities Register.  Select the security
    you want to BUY, then type B to return to the Transaction Register.

    The program will ask if you want to BUY that particular security and
    you can reply (Y)es to buy it, or (N)o or Esc to buy a different
    security.  We will buy that security, so type Y.

    Note you can either invoke the BUY function from the Master Menu
    (and select any portfolio), or invoke it directly from the Securi-
    ties Register.  Also note you can switch at will between the Securi-
    ties Register and the Transaction Register without going through the
    Master Menu.


TUTORIAL GUIDE PART 2: FILE MAINTENANCE                     PAGE 8 OF 14

11. After the ticker symbol has been entered, the program will ask for
    the date of purchase.  Type 6 digits, in the required format with no
    punctuation, for example 040693 for April 6, 1993.  Once the date
    has been entered, the transaction will appear on the screen.

    Note: You can change the format in which dates are entered and dis-
    played.  From the Master Menu press F to invoke the FORMAT DATE
    function.

12. Enter the number of shares (or other units) and the purchase cost,
    including any commission and other fees.  This information comes
    from your brokerage firm or mutual fund statement, or from your bro-
    ker's confirmation slip.

    Note:  For a cash, margin or commercial paper account, you enter the
    account BALANCE as of a particular date.  You can have any number of
    balance entries for the same account on different dates.  Typically,
    you would make entries at the end of each month or on other dates
    for which you want to run reports.  The program will automatically
    select the correct entry for reports.

TUTORIAL GUIDE PART 2: FILE MAINTENANCE                     PAGE 9 OF 14

    The program does not keep track of individual interest payments that
    are actually received.  However, these would be reflected in the ac-
    count balances.

13. If the current price per share (or other unit) is not already avail-
    able in the program, you will be prompted to enter it.  Normally,
    current price quotes for all securities at one time are entered in
    the Current Quote screen (described later in this chapter).  In the
    Transaction Register the ability to enter the current price is main-
    ly for making an initial entry if the current price is not avail-
    able, or for making a correction.  Entry of a current price quote
    automatically makes it available to all transactions in this same
    security in all portfolios.

    This completes transaction entry.  For more information see Chapter
    16 or press H to view that chapter on the screen.  Press Esc to
    return to the Master Menu.




TUTORIAL GUIDE PART 2: FILE MAINTENANCE                    PAGE 10 OF 14

14. One more basic file maintenance step remains: updating the current
    security prices.  From the Master Menu press E.  This will take you
    to the Current Quote screen and another list of securities.

    In this screen, securities are arranged in order by security type,
    exchange and name to permit easy updating of current price quotes
    from a newspaper.  You as the user can control the arrangement by
    varying the spelling of security names and exchanges.  For example
    if you obtain current quotes from Barron's, you can use NY for the
    New York exchange and OC for over-the-counter.  However if you want
    American exchange stocks to come in between, you may want to use
    something like OA for those.









TUTORIAL GUIDE PART 2: FILE MAINTENANCE                    PAGE 11 OF 14

15. Let's update current price quotes manually.  Use the up-arrow and
    down-arrow keys to select the security at which you want to start
    entering quotes.  Remember this only selects securities of the SAME
    type.  You must use Ctrl-PgUp or Ctrl-PgDn to see DIFFERENT security
    types.

    Then press E.  The computer will ask for that price quote.  Each
    time you press the Enter key, the selector bar will automatically
    move down to the next security, and so on until the end is reached
    or you press the Esc key.  Note the program calculates the percent-
    age change from the previously entered quotes.

    Entry of fractional values such as 2 11/16 is permitted; leave a
    space between the whole number and fraction so the computer knows,
    for example, you don't mean it to be 21 1/16 instead.  To leave an
    existing value intact, press Enter by itself.  To stop the process,
    press the Esc key.




TUTORIAL GUIDE PART 2: FILE MAINTENANCE                    PAGE 12 OF 14

16. When you have finished entering price quotes, the computer will ask
    you for the date for which they are current.  This date is important
    because it is used to control the selection of data to appear in the
    reports.  You do not necessarily have to use today's date.

    The program can store two sets of price quotes, each with its own
    corresponding "as of" date.  One of these sets is for the ending
    (or only) report date.  The other is for the beginning report date.

    IMPORTANT!  The beginning report date will be ONE DAY AFTER the "as
    of" date for the beginning prices.  This is because the program
    assumes you are the using CLOSING price quotes.

    For example: if you want to see gains and losses for the month of
    May, you will need the closing prices as of APRIL 30 and the clos-
    ing prices as of MAY 31.  The program automatically adds 1 day to
    April 30 to obtain the beginning report date.

    Go ahead and enter today's date, or press the Enter key by itself
    to accept the DOS system date (which should be today's date).

TUTORIAL GUIDE PART 2: FILE MAINTENANCE                    PAGE 13 OF 14

    The date you have just entered can be used as EITHER the beginning
    or the ending "as of" date.  It is your responsibility to insure the
    prices and dates you enter are corresponding.

    Any price value will remain intact until specifically changed, even
    if its corresponding date is changed. When you EXIT from the Current
    Quote screen, the program will ask which set of prices to update
    (beginning or ending).

    Another perspective: Assume you want to know the value of your port-
    folio as of May 31, 1993.  If you use that ending date, any pur-
    chases made after that date, and any tax lots sold on or before that
    date, will not appear in reports which use only the ending report
    date (such as the Market Value and Total Return report).

    If the beginning date is May 1, 1993 any purchase lots sold between
    May 1 and May 31, inclusively, WILL be reflected in reports which
    use both beginning and ending report dates.  This allows flexibility
    to monitor portfolio performance between any two dates.


TUTORIAL GUIDE PART 2: FILE MAINTENANCE                    PAGE 14 OF 14

17. Press Esc to return to the Master Menu.  Before returning, the pro-
    gram will ask if you want to update the current (ending) quotes, or
    the beginning (historical) quotes, as appropriate.  Press E to up-
    date current quotes.  After a short pause you will see the Master
    Menu again.

The process of "importing" current quotes from an external ASCII file is
an advanced technique which will not be covered in this tutorial.  You
will need to know how to use an external communications program, how to
save downloaded data on disk as an ASCII file, how that data is format-
ted, and how to manage files and sub-directories in DOS.

Examples of external communications programs are ProComm Plus by Data-
storm Technologies, Inc. and Prodigy from Prodigy Services Company.
These software products should be available at a local computer store.

For more information read Chapters 13, 14 and 15 about CURRENT PRICE
QUOTES.  This completes Tutorial Part 2.  Continue on to Part 3 to ex-
plore the different kinds of reports that are available.
