Share Gallery 1/share_gal_1.zip/share_gal_1/BF/BF017.ZIP/PFROISW.EXE/PFROISW.HLP

Text File | 1992-02-28 | 26KB | 538 lines

*
0 PFROI ("PortFolio Return On Investment") is an investment portfolio
0 management program designed to allow the user to maintain continuous
0 and contiguous records of all portfolio transactions, keep track of
0 investment cost bases for tax purposes, and to calculate portfolio
0 performance using the internal rate of return method of return on
0 investment ("ROI") calculation.  Built-in communications facilitate
0 price quote downloading from a number of services. Prices may also
0 be manually entered or imported. PFROI additionally generates numerous
0 user-configurable reports, including graphics displays designed to
0 operate on CGA, EGA, VGA, and Hercules-type display systems.
0
0 PFROI uses two types of menu systems to enable the user to manuever
0 through the program.  The first is a standard full-screen menu from
0 which a selection is made by keying a character at the ">" prompt.
0 The second type of menu system is an "Alt-Command" menu system.  In this
0 system the available commands are displayed on a single line in mnemonic
0 form.  The user executes the command by depressing the "Alt" key in
0 combination with the letter key corresponding to the selected command.
0
0 PFROI additionally uses the "Esc", "Arrow", "Page", "Ins", "Del", "Home"
0 and "End" keys plus some "Control-Key" combinations to perform editing
0 and screen manuevering functions.
*
0 The following commands function much the same throughout the program:
0
0  Esc   - Returns to the previous screen or aborts an operation
0  Arws  - "Arrow" keys on number keypad move the cursor
0  PgUp  - Pages upward (backward) a page of data at a time
0  PgDn  - Pages downward (forward) a page of data at a time
0  ^PgUp - ("Ctrl" + "PgUp") Moves to start of data
0  ^PgDn - Moves to end of data
0  Ins   - Inserts new record (Ctl+F5 duplicates record)
0  Del   - Deletes current record (Ctl+F10 bypasses prompt message)
0  Home  - Moves cursor to beginning of field, initiates field edit
0  End   - Moves cursor to end of field, initiates field edit
0  ^Y    - ("Ctrl"+"Y") Clears field
0  ^G    - ("Ctrl"+"G") Deletes next word in field
0  Alt+F - File save, load and directory function sub-menu.
0  Alt+H - Displays help screen (or "F1" key)
0  Alt+P - Prints out data, "LPT1" is the default output device.  If a
0          filename is used, a disk text file is created.
0          Output to "SCRN" enables output to be viewed on screen.
0
0  Other "Alt" commands vary functions depending upon the active screen.
*
0  PFROI MENU
0
0  Load Portfolio - Loads file specified, and then returns to main menu
0    with filename displayed in header.  If specified file contains
0    non-portfolio records, file will be renamed to "XXXXXXXX.ZZZ"
0    to protect agains inadvertant corruption of non-portfolio files.
0
0  Transactions - Enters transaction module.  This module is where "Buy",
0    "Sell", "Dividend", etc., activity is entered into your portfolio.
0
0  Valuations - Enters valuation module.  The valuation module screen
0    indicates the dates for which portfolio position records have been
0    computed.  Existing positions can be reviewed using the "Review"
0    (Alt+R) command.  New positions may be added or existing positions
0    recomputed by using the "Create" (Alt+C) command.
0
0  Performance - Enters Return On Investment (ROI) computation module.
0    ROI "Start" and "End" dates should be existing valuation dates.
0
0  Reports - Enters report module.  Many reports require a "Close Date"
0    which must be the date of an existing valuation.
*
0  PFROI MENU (Cont'd)
0
0  Client Group - Enters module for maintaining a list of portfolios being
0    managed.  "Batch" valuations must be initiated from this module
0    and operate only on portfolios files listed in the currently
0    loaded client group file.
0
0  Auxiliaries - Access point for supporting records:
0    Portfolio Configuration
0    Tax Rate Records
0    Target Prices
0    Master Security List
0    Price History Records
0    Distribution Records  (Regis PFROI/CAPTOOL)
0    Currency Exchange Rate Records (CAPTOOL Only)
0
0  Configure - Configuration menu for CAPTOOL/PFROI operating parameters.
0
0  Utilities - Accesses sub-programs which perform "merge", "archive",
0    "symbol change" and other functions.
*
1 Transaction "Alt" Menu
1
1 Alt+S - "Sorts" transactions by date.
1 Alt+A - accesses "Auxiliary" records menu.
1 Alt+M - toggles "Mask".  Isolates transactions by "TAC", "Symbol" and "L#"
1         depending on which field in which cursor resides. Clear the mask
1         by toggling Alt+M a second time while the cursor is in the field.
1 Alt+D - toggles Display formats ("Est. Tax", "Cost/Unit", "Com/Fees")
1 Alt+C - various functions depending on field in which executed:
1          Descrip: Imports discription from master list
1          Amount : Calcs accrued interest for AMT, ACR & PIN transactions
1          Est tax: Calcs estimated taxes from current year forward
1 Alt+K - "seeK" record with next occurance of Symbol specified
1 Alt+T - "subTotals" a group of transactions. (toggle/move/toggle)
1 Alt+3 - "subtotals" quantity only transactions (signs adjusted)
1 Alt+4 - "subtotals" cash only transactions (signs adjusted)
1 Alt+I - Import transactions from text file (see manual for details)
1       (See IMPORT.TXT for details on importing from other portfolio mgrs.)
1 Alt+B - displays cash Balance at current transaction
1 Alt+G - toggle auto-siGn (careful! should be "On" excepting rare cases)
1
*
1 Transaction Codes (TAC's)
1 DPF  DePosit Funds        CGD  Capital Gains Distrib. (long)
1 WDF  WithDraw Funds       CGR  Cap. Gains Dist. Reinvested
1 BUY  BUY security         CGW  Cap. Gains Withdrawn
1 SLL  SeLL security        ROC  Return Of Capital (credit cash)
1 SLS  SelL Short           RCR  Return of Capital Reinvested
1 BYC  BuY to cover         RCW  Return of Capital Withdrawn
1 IN+  INterest earned      BRW  BoRroW funds
1 IN-  INterest paid        RPY  RePaY funds
1 DV+  DiVidend earned      RNT  ReNT earned
1 DV-  DiVidend paid        EXP  cash EXPenses
1 SP+  Split credited       DPR  DePReciation
1 SP-  Split debited        RCV  ReCieVe (e.g. from other portfolio)
1 INW  Interest Withdrawn   DLV  DeLiVer (e.g. to other portfolio)
1 DVW  Dividend Withdrawn   FEE  acct. mgmt. FEE ("FUI" for Fee UnInvest)
1 DRI  Dividend ReInvested  SCO/LCO Short/Long loss CarryOver
1 IRI  Interest ReInvested  SGD  Short term cap. Gains Distrib.
1 BYD  BuY + Deposit        SGR  Short term Gains distr. Reinvested
1 SLW  SelL + Withdraw      SGW  Short term Gains distr. withdrawn
1 DST  partnership DiSTrib  PIN  Phantom INterest
1 CBA  Cost Base Ajustment  AMT  AMorTization of premium
1 IOB  Interest On cash Bal ACR  ACcRetion of discount (same as PIN)
1 TXW  Taxes Withheld (on foreign dividends)
*
1 Transaction Fields
1
1 Mo/Dy/Yr - Transaction Date
1 TAC      - Transaction Code
1 Symbol   - Security trade symbol
1 Lot      - Lot number (1..999, FFO, LFO, AVG, AV2)
1 Descrip. - Security Description
1 Quantity - # Shares (decimal shrs ok)
1 Amount   - net transaction value (include commis. & fees)
1 Est. Tax - Estimated Taxes (for ROI calcs)
1 Cost/Unit- Computed cost/unit (non-input field)
1 Com.Fees - Commissions or fees
1
1 Descrip. field may contain note of :
1  div/int rate      : "@$2.65"
1  receive date/amt  : "&&3/15/85 $2435.25" (RCV only)
1  maturity date     : "##1/15/92"
1  turn off cost cum : "=C-"
1  force "Long" posit: "=L+"
*
2 Position "Alt" Menu
2
2 Alt+T - computes "sub-Totals" (Normally, S/T's are automatically computed
2         upon price entry. "T-" in Misc. Specs. supresses automatic S/T's)
2 Alt+A - accesses "Auxiliary" records menu.
2 Alt+D - Toggles to alternate "Displays".
2 Alt+R - Retrieves prices from price records.
2 Alt+S - Send prices to price records.
2 Alt+L - access data-Link to download price quotes into current screen.
2 Alt+M - Mask sub/totals.
2 Alt+G - display pie-chart Graphics. ("F-" in Misc. specs. suppresses "fill")
2 Alt+C - Currency exchange rate import (CT-Global, Display #5 only).
2 Alt+X - eXport to Master list from current position records.
2 Alt+I - Income forecast re-calculation. (Display #2 only, see manual)
2 Alt+U - (CAPTOOL Batch Only) Updates individual portfolio positions for
2         close date and values using prices from current batch position.
2 Alt+Y - Yield % & F/C Income recompute using master list specifications
2 Alt+! - Toggles price retrieval "Disable" flag. When set ("!" next to
2         symbol) DataLink skip record during price retrieval operations.
2
*
2 Position Fields
2
2 T         - Security type
2 Symbol    - Ticker symbol
2 Descript. - Security Description, "@$" for div/int rate, e.g. "@$1.25"
2 Position  - Number of units held
2 Mkt Price - Market price on date of valuation
2 $ Value   - Valuation at market price
2 $ Cost    - Taxable Cost Basis of security
2 Gains     - (Dspl #0) Unrealized gain or loss (in parentheses)
2 Val %     - (Dspl #0) Percent of total portfolio
2 Gain %    - (Dspl #1) Percent gain over taxable cost basis
2 $/Yr      - (Dspl #2) Forecast income/yr (Qty * @$ in Master List Aux Descr.)
2 Yld %     - (Dspl #2) Annual dividend or interest percent yield
2 $/U       - (Dspl #3) Taxable cost basis per share or unit
2 Beta      - (Dspl #3) Security static beta (from Master List record)
2 Accrued   - (Dspl #4) Accrued interest (int. rate/dates spec'd in Mstr. List)
2
*
3 Portfolio/Batch Valuation "Alt" Menu
3
3 Alt+A - Accesses Auxiliary record menu.
3 Alt+C - Create valuation or re-compute valuation after transactions modi-
3          fied. Overwrites any valuation of same date but preserves prices.
3 Alt+R - Review existing valuation.  Positions are NOT RECALCULATED
3 Alt+D - Delete existing valuation.
3 Alt+B - Set valuation "Base" date.  Positions are computed starting with
3          the valuation on the base date and including all subsequent
3          transactions.  Default base is day before first transaction.
3 Alt+G - Valuation Graphics (see manual for setting up printer)
3 Alt+M - Multiple valuation recalculation.
3 Alt+T - toggles Tax status.  If Tax=On then Est. Tax computed on batch val.
3 Alt+I - Import (See IMPORT.TXT for details)
3 Note 1: When prompted for Create, Review, Delete or Base date, Gray "+" &
3          "-" keys may be used to select dates from table.
3 Note 2: The valuation screen displays up to 64 valuation dates, however
3          more than 64 dates may be created.  Use "PgUp", "PgDn" to view
3          these additional records.
3 Note 3: "*" indicates that price data is missing for the indicated date.
3         "." indicates requires "re-Creation" due to transaction edits.
*
4
*
5 ROI Computation
5
5  To compute ROI, set the "Mask" record, then execute the "Alt+R" command
5  to initiate the ROI calculation:
5
5   Start Date - ROI initiation date (should be a valuation date).
5   End Date   - ROI termination date (should be a valuation date).
5   Symb Mask  - Specifies symbol of security to be computed.  Setting
5                of "*ALL*****" computes ROI of entire portfolio.
5   T          - Specifies security type.  If blank then all types used.
5   SIC        - Specifies industry code as specified in master list.
5                If blank then all types used.
5   Twt        - "Time Weighted". If "On" a time-weighted ROI is computed.
5   Pf Mask    - Specifies portfolio to be used (CAPTOOL only). Default is
5                current portfolio.  DOS "wildcard" symbols "*" & "?" for
5                multiple portfolios, e.g. "*.*" computes all portfolios.
5   Csh        - Currency symbol mask. (CAPTOOL-Global only)
5
5 "Beta" output is of portfolio or security relative to the market index.
5  No beta is displayed if Twt=Off or ROI covers fewer than 12 valuations.
5  "Alt+C" clears the ROI "mask" record, setting Symb. Mask back to "ALL"
*
6 Tax Rate Fields
6
6 Mo/Dy/Yr - Date new rates become effective.
6 Hld Prd  - Hold period (months) req'd for long term cap. gains.
6             (Use 999 or greater for no long term treatment.)
6 CGRate   - Long term capital gains rate (0 .. 1.0 allowed)
6             (Use 1.0 for no long term C.G.)
6 Max Loss - Maximum capital loss deductible from ord. income
6 Tax Rate - Portfolio marginal tax rate (0 .. 1.0)
6 Lng/Sht  - Long to Short term weighting ratio
6 Loc Rate - Local tax rate (City & State)
6 Index    - Annual price index used to adjust cost bases up for inflation.
6            This is only used if portfolio C.G. Indexing="On"
6 Idx Hld  - Min. Period a security must be held to be eligible for
6            cap. gains cost base indexing.
*
7 Accounts Fields (Use "Home"/"End" keys to initiate edit) :
7
7  Account Name   - Name & Address (\= separator, < > = salutation)
7  Phone Number   - For auto dial, requires modem
7  Portfolio File - File specification (must be legal DOS filename, i.e. max.
7                   8 char. prefix and max. 3 char. extension).
7  Acct. Number   - For reports
7  Tax ID Number  - For reports
7  Note Field     - Hidden field (Use Alt+N to access)
7
7 Client Group "Alt" Menu
7
7  Alt+P - "Prints" records, labels & mail merge (see manual for details)
7  Alt+S - "Sort" by Zip, Acct. #, or Portfolio Filename
7  Alt+D - (or F9 key) Auto dial current client
7  Alt+K - "seeK" record containing key word or key word combination
7  Alt+N - Display Note field for editing
7  Alt+G - "Get" (Load) portfolio indicated in current screen
7  Alt+B - enter "Batch" Valuations module (Captool only)
7
*
8 Master Security List ("Master List")
8
8  The Master Security List is used to store information about a security
8  so it can be automatically or optionally drawn upon by PFROI when it
8  performs computations or generates reports.  Fields are used as follows:
8
8   SYMBOL - Used to uniquely identify security.
8
8   Aux. Description - Extended description, may be used to indicate interest
8    & dividend rates and dates and bond maturity dates and redemption prices
8    as in the following examples:
8
8     "@@2/15*4@$5.32"  - indicates that a $5.32 annual dividend or interest
8        is paid in 4 quarterly installments (the "*4" indicates this), with
8        the first payment of the calendar year on 2/15.
8
8     "##10/15/94#$100" - indicates that a bond matures on 10/15/94 at a par
8         price of $100/unit.  If the price is omitted, 100 is the default.
8
8     "/F-" in Aux. Descrip. --> income is federal tax free.
8     "/L-" in Aux. Descrip. --> income is local tax free.
*
8 Master Sec. List (cont'd)
8
8   Cusip - Security "Cusip" number which may be used in lieu of "Symbol"
8    for price retrieval.
8
8   T   - Security type.  This value will be automatically imported onto
8         position screens when the "Create" valuation command is executed.
8
8   SIC - Industry code.  Use first two chararcters of federal "SIC" code.
8
8   "$" - "Cash symbol".  Uses to indicate the base denomination of security
8         in multiple currency portfolio.
8
8   Beta- This value will be automatically imported onto position screens
8         when the "Create" valuation command is executed.
*
8 Master Sec. List "Alt" Menu
8
8  Alt+S - Sort by symbol, cusip and/or type.
8  Alt+K - seeK record with specified symbol.
8  Alt+D - accesses Distribution records
8  Alt+T - accesses group Type specification records.
8  Alt+! - toggles quote retrieval suppression (! next to symbol indicates
8          quote retrieval suppression is active.
8  Alt+# - toggles quote retrieval by CUSIP # in lieu of symbol. (# next to
8          symbol indicates CUSIP quote retrieval is active.
8  Alt+* - toggles suppression of import to price record on Ctrl+F6 cmd
8          (* next to symbol indicates import to price record is suppressed)
*
A Price Limit Records
A
A  Price Limit records specify both low and high target prices for a
A  security.  If the valuation price falls below the low price or exceeds
A  the high price an asterisk "*" will appear on the position screen
A  adjacent to the price field for the security.
A
A  Price Limit Records are local to each portfolio.
A
*
B  Portfolio Configurations
B
B  The Portfolio Configuration Record allow each portfolio file to be
B  individually configured for the following parameters:
B
B   Fiscal Year   - Date of fiscal year end
B   Tax Adj       - Forces generation of year-end tax adjustment entry.
B   Loss Carryover- Forces generation of year-end loss carryover entry.
B   C.G. Indexing - Enables capital gains inflation indexing.
B   Client Rpts   - Specifies reports to be included in client report,
B                   e.g. "ABEMJK[".  Note: Including "[" in spec.
B                   shifts account title to right.
B   Val. Base     - "Last"=Last previous valuation date.
B                   "First"=One day prior to first transaction date.
B   Distribution  - Enables automatic insertion of distribution transactions.
B   Twtd ROI/Beta - Enables time weighted ROI and beta computation.
B   Beta Index    - Specifies Index to be used for beta calculation.
B   Index         - Specifies symbol & description for indices
B
*
C CAPTOOL Configurations
C
C  Global configurations apply across all portfolios unless overridden
C  by local configuration specifications.
C
C   Work File Path - Specifies disk drive/directory to be used for temporary
C                    storage/retrieval of records when DOS base RAM memory is
C                    full.  Fastest operation is achieved with RAM disk.
C   System Mhz     - No longer used.
C   System Sound   - Enables/Disables prompt "beep".
C   Mono HiVideo   - Sets "Hi" & "Reverse" video for monochrome displays.
C   Block Cursor   - Enables Block cursor for LCD displays.
C   File Backup    - Enables/Disables creation of "$" backup files.
C   Decimal Type   - Either "." or "," decimal notation.
C   Amt Dcmls      - Decimal places (0..4) displayed for "Amount" values.
C   Currency Symb  - Symbol of base currency used in portfolio.
C   Date Format    - Date display format (Mo/Dy/Yr, Dy-Mo-Yr, Yr.Mo.Dy)
C                    The configurable default input period is 1951-2050;
C                    Warning: See manual before altering Century base year.
*
C PFROI Configurations
C
C  The PFROI Configurations contain the default configuration to which a
C  portfolio file is set when it is created as a new file.
C
C   Fiscal Year   - Date of fiscal year end
C   Tax Adj       - Forces generation of year-end tax adjustment entry.
C   Loss Carryover- Forces generation of year-end loss carryover entry.
C   C.G. Indexing - Enables capital gains inflation indexing.
C   Client Rpts   - Specifies reports to be included in client report.
C   Val. Base     - "Last"=Last previous valuation date.
C                   "First"=One day prior to first transaction date.
C   Distribution  - Enables automatic insertion of distribution transactions.
C   Twtd ROI/Beta - Enables time weighted ROI and beta computation.
C   Beta Index    - Specifies Index to be used for beta calculation.
C   Misc. Specs   - Misc. "Switches" (see manual)
C   Index         - Specifies symbol & description for indices
C
*
C  PFROI Misc. Specs
C
C  Operative Miscellaneous specs on the PFROI "Configure" menu are:
C
C   F-  : Suppress "fill" of allocation plot (CGA & Herc never fill)
C   T-  : Disables automatic Sub-Totaling on position screen
C   C-  : Disables automatic override of portfolio configurations by PFROI
C         configurations
C   C+  : (in Portfolio Config record) protects indiv. portfolio config.
C         from override by PFROI confg.
C   S+  : "Send price" command on position screen overrides existing prices
C         in price records.
C   A+  : Causes bond "accrued" interest to be added to bond valuation.
C   G-  : Forces graphics to be printed from screen (faster) rather than
C         from memory buffer (higher resolution).
C   M+  : Automatic update of Master List from Position Records.
C   P+  : Adds the Current Path to data filenames
C   X-  : disables printer port chkg
C   C!  : forces cost base recomputation
C   R+  : Sets automatic retrieval of prices from PRICES.STD
C
*
D
D PFROI Reports
D
D  Upon selection of a report from this menu the user is prompted for set-up
D  specifications required for the selected report.  Default values will
D  generally be provided.  "Base" & "End" dates should correspond to existing
D  valuations.  Vertical arrow keys may be used to select alternate dates.
D
D    End/Close Date  - Last date of the reporting period desired.
D    Base/Start Date - Last date of preceding report period.
D    Fiscal Year End - Used for tax and capital gains reports.
D    Output Device   - "LPT1" for printer port #1, "SCRN" for screen display,
D                      and any unused file name for disk text file output.
D                      If ".WKS" file extension is used, a Lotus-readable
D                      ".WKS" file is created. (Regis PFROI/CAPTOOL only)
D
D  Note: Some reports are user customizable with respect to the fields which
D        are printed.  Depressing the "Ctrl" key plus report selection key
D        will bring up the customization screen for a report.
D
*
E Auxiliary Records
E
E  Auxiliary records contain portfolio supporting data other than
E  transaction and position records.
E
E  The following Aux. records are local to each portfolio and thus may
E  be uniquely configured for each portfolio:
E
E    Portfolio Configurations
E    Tax Rate Table
E    Limit Prices/Reinvestment specs.
E
E  The remaining Aux. records apply to all portfolios.
E
*
F
F Report Customization
F
F  The report customization screen displays fields available to the user with
F  each field labeled with a letter "A"-"Z".  Some fields may be similar to
F  others but be of longer length, e.g. "   Description   " vs. "Descrip".
F
F  The letter sequence in the "Cur. Spec." determines which fields and in
F  what order they will appear in the report.  The "Cur. Spec." may be
F  modified by making an entry in the "New Spec.".
F
F  Report output is truncated to the maximum output columns specified in the
F  printer set-up specifications.
F
*
G Group Specifications
G
G  Group Specification records are used to assign a descriptive label
G  to each group type. This descriptive label is used on the sub-total
G  records on portfolio "Position" screens.
G
*
H Market Indices
H
H  Up to seven market indices may be specified.  Indexes with non-blank
H  symbol fields will be displayed on "Position" screens and if priced
H  will have ROI computed/displayed on the ROI report.
H
H  The "Beta" index is the index against which portfolio beta is computed.
H
*
I PFROI Utilities
I
I Merge - Combines multiple portfolio files into a single portfolio file.
I
I Change Symbol - Changes specified ticker symbol in specified portfolio
I  to new ticker symbol.  (Useful for corporate name changes).
I
I Archive - Removes records of closed out securities to a storage file
I  so as to reduce the size of the current portfolio. Avoid using this
I  function unless you have run out of computer memory.
I
I Create Demo - Creates a non-full-function version of CAPTOOL/PFROI labeled
I  "Demo" which may be copied and passed on to others for trial use.
I
I Backup Data - Copies ".STD" files and portfolio files listed in CLIENTS.STD
I  to specified floppy drive.
I
I Non-English Report Labels (CAPTOOL Global) - Enables user translation of
I  report headers & labels to non-English formats.
*
M Price History Records
M
M  Price history records are a historical database of prices which may be
M  drawn on by PFROI to price portfolios or used to plot price/volume trends
M  and compute moving averages.  Data may be manually entered, imported from
M  an ASCII text file, or updated by downloading prices from a price data
M  service using the DLINK module.  Alt commands are as follows:
M
M   Alt+S - Sort by date (and by symbol for same date)
M   Alt+M - Mask by symbol, to isolate a particular security
M   Alt+G - plot Graphics of price, volume & moving averages
M   Alt+D - toggles "Description" field display on/off (off=faster scroll)
M   Alt+L - accesses dLink communications for data download.
M   Alt+I - Import data from ASCII comma delimited text file of format:
M             mm/dd/yy, Symbol, Type, Volume, Open, High, Low, Close
M   Alt+A - accesses Master Security List (Aux)
M   Alt+R - aRchives records from currently loaded price file.
M   Alt+! - Toggles price retrieval "Disable" flag. When set ("!" next to
M           symbol) DataLink skip record during price retrieval operations.
M
M  The "Ctrl+F6" key will create a full set of new records dated the same
M  date of the current record and with symbols drawn from the master list.
*
M  To permit splits to graph properly, two price records should be entered
M  on the date the split takes effect, with the first record containing
M  the pre-split price in the "Close" field and the second entry containing
M  the post-split price.  For example, security "XYZ" splits on 4/15/90
M  and closes the day at 40.  You would make two "4/15" entries, the first
M  closing at 80 and the second at 40.
*