Current Shareware 1994 January

home *** CD-ROM | disk | FTP | other *** search

/ Current Shareware 1994 January / SHAR194.ISO / finance / w_tbl60.zip / WALLST.DOC < prev next >

Wrap

Text File | 1993-08-18 | 62KB | 1,233 lines

Wall $treet - The Bottom Line General Investment Database Tracking & Analysis Software for MS-DOS Version 6.0 September 1,1993 Color / Monochrome / LCD EGA / VGA / CGA Copyright 1989-93 by: Dan M. Schell IMAGE PLUS SOFTWARE 2522 Quail Glen Carrollton, Texas 75006 (214) 416-3387 All Rights Reserved Program File Listing -------------------- WALLST.EXE MAIN LOADER PROGRAM WSMAIN.OVL MAIN OVERLAY MODULE PNTWST.OVL PRINT MODULE WSUTIL.OVL UTILITY MODULE WSGRAPH.OVL GRAPH MODULE WSTRACK.OVL CURRENT PRICING MODULE SAMPLE.DAT SAMPLE DATA FILE - Can be deleted HOTSTOCK.DAT You might want to consider some of these stocks! WALLST.DTA SAMPLE CURRENT PRICING DATA FILE WALLSTD.CTL SYSTEM CONFIGURATION FILE - DO NOT DELETE PRINTERS.CTL PRINTER CONFIGURATION FILE - Can be deleted BRUN45.EXE RUN TIME MODULE WALLST.DOC DOCUMENTATION - Printed docs mailed with Registration INSTALL.EXE INSTALLATION PROGRAM README.TXT May be included with the latest notes and revisions WALLST.ICO A Windows Color Icon for use with Microsoft Windows QUOTES.TXT A sample Prodigy current pricing file for HOT STOCKS Program Overview ----------------- This program was written to help you keep track of and analyze your investments. It was originally written to handle stocks and bonds, but has been expanded to handle most types of investments including coins, collectibles and any item you buy and then sell at a later date, hopefully to make a profit. Each time you buy & sell an investment, you will be able to quickly & easily store the details of the transaction. This will provide a permanent record of the details of each transaction for future use. You will be able to edit & delete individual records, allowing you to keep your data file or files current. You can easily sell part of an investment, update a current investment as a result of a stock split, or create a new record each time a dividend is paid as additional shares of your investment. Using the current pricing module, you will be able to evaluate your current investments based on their current pricing or value, & obtain a year to date performance evaluation, based on current pricing and trades completed in the current year. You will be able to use as many different data files as desired, as specified from the Utility menu. The data file last used, will be automatically loaded from the menu the next time you start the program. You are able to password protect any or all of your data files to restrict access to your investment history. When you start the program, it will remind you of the last date the program was executed, the active data file, and the number of records in that data file. It will also keep track of how long you have been in the program & provide that information to you when you exit. The program will accommodate "Short Sells" as well as traditional investments. It will calculate & display various factors based on buy/sell prices, fees/commissions paid, date bought/sold, & number of shares including: Total cost to purchase an investment Total received from sale of an investment Day of the week that a transaction occurred Number of days held to date, while still in your portfolio Number of days investment held when a trade is complete Profit or loss percentage, based on the investment & on the time held Allow you to assign a record type to each of your investments Calculate the present value of each investment based on the current pricing for that investment The Analysis portion of the program will display various summaries for all trades occurring in the year you choose. One option will summarize a listing of all trades reportable to the IRS in the chosen year. This is very useful at tax time. The Graph portion of the program will display several graphs displayed by record number to aid in visualizing your trading performance over time. Menu Interface: The selections from the menu are made by pressing the indicated key. You can use upper or lower case. For example: "Press Your Choice (A,L,D,C, or M)" Make your selection by pressing "A". No return is needed, as the selection is automatic. The Menu will indicate the appropriate choice by parentheses. For example "Cum-(S)ummary Graph" would be selected by pressing "S". In addition to the direct selection from the menus, The "ESC" key will return you to the parent menu. When at the Main menu, the "ESC" key will exit the program. If your system does not have color capability, or if you prefer to display all text in white, you will want to select the LCD / Monochrome selection from the Utility menu, Graphic mode select option. This will modify the highlight used in the pop-up windows, so that you will be able to determine which item is being highlighted. To Get Started Quickly ---------------------- 1: Run the Install program, or simply use DOS to create a directory and copy all files to that directory. NOTE: If your registered disk is delivered on a 5 1/4" 360K format, you must run the INSTALL program from this disk. Once the INSTALL program is complete, you will need to re-run the INSTALL.EXE file from your target disk. This will uncompress the necessary program files. Run WALLST.EXE to begin Wall $treet The Bottom Line. 2: Change directories to the directory created in step 1 above and type in "WALLST". 3: If you wish to explore the capabilities, use the SAMPLE.DAT Data file or HOTSTOCKS.DAT and experiment with as many menu choices as desired. When you are ready to enter your own investment data, proceed to item #4. 4: From the Main menu, select "U" to activate the Utility menu. 5: From the Utility Menu, select "F" and then "A" to select a new data file. 6: Enter up to 8 characters to name your data file, and press "E", then "Y", and then any key to activate your new data file. 7: Press "M" and then "M" again to return to the main menu. 8: Press "A" and begin adding Records to your file. These records contain the details of each of your investments! Good Luck ! Menu Descriptions ----------------- MAIN MENU --------- DISPLAY & ANALYZE / DATA ON FILE: Branch to the Investment Display Menu. ADD NEW DATA TO ACTIVE FILE (BUY): Used primarily to add a new investment to the active file. The input fields are as listed and described below: An "I" indicates an input, "W" Pop up window, "Q" Question, & "R", a system Response. I Item Description: The name of the investment (up to 20 characters). You may want to use your own naming system for use as a quick search as described in the Video Print Menu. For example, noting all investments in your IRA with these letters somewhere in the name will later allow you to display all IRA investments by simply searching on IRA as described below. W Record Type: Select from the choices listed in the pop-up window by using the Up - Down arrows or the Home / End Key. The record type will be stored along with the name of the investment. This will be useful to later display a selected group of your investments. The last selection in the list will allow you to enter your own investment type. I Number of Shares: The number of shares purchased. For investment types such as coins, or real estate, the number of shares will be 1. Maximum of 500,000 shares in integer format. Optional format maximums are 999999.9; 99999.99; 9999.999 if shares entered require a non integer format. Q Short Sell (Y/N): A short sell occurs when an investment is sold first, & then later bought back at, hopefully, a lower price. Answer "N" or simply press Return to enter traditional "Buy now - Sell Later" investments. If you enter "Y", you will be asked to enter the appropriate Sell data next. I Year of Purchase: The year the investment was purchased. Enter the last two digits of the year. If you press Return, this value will default to the current year. I Month of Purchase: The Month the investment was purchased. If you enter an incorrect value or press return, this value will default to the current month. I Day of Purchase: The Day the investment was purchased. If you enter an incorrect value or press Return, this value will default to the current day. R Day of the Week: The system will reply with the Day of the Week that this purchase took place. I Price Per Share: The price paid per share. You may enter this value directly as a fraction and the system will calculate the decimal equivalent. For example, entering 3 1/4 or 3.25 will have the same result. I Commission to Buy: The total commission paid when the investment was Purchased. Simply press Return to enter "0" for this value. I Other Fees & Taxes: Any other fees or taxes paid when the investment was purchased. The commission entered above, will be added to this value and will be stored as the total purchase commissions and fees. R Total Cost to Buy: The system will then reply with the total cost of purchase based on Number of Shares; Price paid per share; & Commission/Fees paid. Q Has this been Sold: If you press "Y", indicating a completed investment, you will be able to input the sell data, as noted below. This would be the case if you are entering past investment history. If you press "N", you will not be asked for sell information. IF YOU ANSWER N to the "Has this Investment been Sold?" question: I Enter Optional Investment Comment: You can enter a comment or personal reminder message regarding this investment. If you do not wish to enter a comment, simply press Return. I Income From This Investment: You can use this field to keep track of cash dividends or other income that you have received from this investment. Simply press Return to enter zero. You will then be asked "Is this information Correct?" If you press: Y The data will be stored and you will be returned to the main menu. N The data will be stored and the edit routine will be displayed to allow you to correct the incorrect data. A The addition of the data will be aborted and you will be returned to the main menu. IF YOU ANSWER Y to the "Has this Investment been Sold?" question, the program will then prompt you to enter the sell data as described below: I Year of Sale: The year the investment was sold. If you press Return, this will default to current year. I Month of Sale: The month the investment was sold. If you press Return or enter an incorrect value, this will default to the current month. I Day of Sale: The day the investment was sold. If you press Return or enter an incorrect value, this will default to current day. R Day of the Week: The system will reply with the Day of the Week that this sale took place. I Price Per Share: The price received per share when the investment was sold. You may enter this value directly or as a fraction as described above. I Commission to Sell: The total commission paid when the investment sold. Simply press Return to enter "0" for this value. I Other Fees & Taxes: Any other fees or taxes paid when the investment was sold. The commission entered above will be added to this value and will be stored as the sales commissions and fees. R Total Received: The system will then reply with the total amount received when sold, based on Number of Shares; Price per Share received when sold; & Commission/Fees paid. R Total Loss or Gain: The system will then calculate the total amount of profit or loss based on the above data. I Enter Optional Investment Comment: You can enter a comment or personal reminder message regarding this investment. If you do not wish to enter a comment, simply press Return. I Income From This Investment: You can use this field to keep track of cash dividends or other income that you have received from this investment. Simply press Return to enter zero. You will then be asked "Is this information Correct?". If you press: Y The data will be stored and you will be returned to the main menu. N The data will be stored and the edit routine will be displayed to allow you to correct the incorrect data. A The addition of the data will be aborted and you will be returned to the main menu. EDIT/UPDATE EXISTING FILE (SELL): This is usually used to enter the corresponding sell data of an investment that had been previously purchased, however from this selection, you will be able to edit any information contained in an investment record. After pressing "E" to select the edit routine, you will be asked to select the investment record you wish to edit. You may do this by selecting the investment record by number; or by pressing Return, you will be able to select from a summary listing, temporally displayed in a pop-up window. Once the window is displayed, you simply highlight the record of choice, using the Up or Down arrow keys, Page Up, Page Down, HOME, or END keys, & then press Return to select the record of your choice. Once a record is selected, the investment record will be displayed to allow you to confirm that this is the record you wish to edit. You may: Press "E" to edit the displayed record. Press "O" to enter the other edit option menu. This will provide the options to; Press "C" - Place an identical copy of the displayed record at the end of the file, ready to edit. Press "S" - Edit the record to record a split. You will then be asked to enter the investment split ratio. You can enter '0' to abort. Once a valid split ratio has been entered, you will be prompted with the new effective price and number of shares. If this is not correct press "ESC", otherwise press any key to record the split. Press "P" - Execute a Partial Sale. This will create a new record for the amount still held and allow you to easily record the partial sale. This will divide the commissions and fees proportionally based on the volume of shares sold and still held. Press "V" - Create a new record for a dividend reinvestment. This creates a new record at the end of the file and places you in the edit mode ready to record the reinvestment. You then record the quantity of Shares. The buy price is set to zero since the dividend cost was zero. Press "D" to delete this record. If you select "D", you will be asked to confirm the deletion of this record by entering a "Y". Press "ESC" to return to the main menu. Press the Up - Down arrow keys to search through the file, one record at a time. As you scroll through the file, you will note the record number is displayed is as noted at the top of the screen. Press the Page Up / Page Down keys to quickly scan through the file. Once you get close to the record of interest, you can switch to the Up / Down arrow keys. During the edit process a small arrow will appear at the left of the item currently available for editing. This will begin with the record type as previously described. In each case, pressing Y (Yes) this item is correct, the next item available for editing will be displayed. If you press N (No) this item is not correct, you will be able to modify the item selected. If at any time you select A (Abort), any modifications will be erased and you will able to select a different record to edit, or by pressing "ESC", you can return to the main menu. If you wish to modify or confirm that the buy or sell status is "Not Bought" or "Not Sold", simply enter "-1" when asked if the year is correct. Once you confirm this selection, the record status will be modified accordingly. When editing the "Income From This Investment:" field, as noted, you may add to the existing value by simply adding a "+" prefix to the value you wish to add. GENERATE GRAPHS FROM DATA ON FILE: Branch to the Graph Display Menu. PRINT INVESTMENTS & REPORTS MENU: Branch to the Main Print Menu. CURRENT PRICE & SYMBOL ASSIGNMENT: Branch to the Current Pricing Menu. UTILITIES/DATA FILE/SETUP OPTIONS: Branch to the Utility Menu. QUIT & EXIT - Wall $treet TBL: When ready to exit Wall $treet TBL, simply enter "Q" from the main menu. You will be able to Print a registration form to your printer, begin again or Exit. You may also exit W$TBL at any time by pressing "ESC" several times. INVESTMENT DISPLAY MENU ----------------------- INDEX - INVESTMENTS ON FILE: Display a summary of the investment records in index format to your screen. You will be able to simply press Return or enter "A" to display all records, Press "ESC" to return to the menu, or search by Name, Record Type, Current pricing Symbol or Buy & Sell Year. The search string must be 2 to 10 characters in length. For example entering "TEX" would return all records with the characters "TEX" in the Investment name, Current Pricing Symbol or Record Type. Entering "1980" or "80", will return all records bought or sold in 1980 or with those characters in the Investment name, Current pricing Symbol, or Record Type. You can also enter "COMPLETE" to view only those records that have been both bought and sold. This is useful for displaying summary information for all completed investments. The listing will be displayed to your screen in summary format. The fields displayed will be as noted below: Record Type (4 character abbreviation) Record Number Investment Name Number of Shares Buy Date (Purchase Date or "Not Bght" If not Bought, as in a short sale) Sell Dte (Date Sold or "Not Sold"; if not Sold) Buy Pr (The Purchase Price or blank if not Bought, as in a short sale) Sell P (The Selling Price or blank if not yet sold) Pft/Loss (The profit or loss, unless the investment is still in your portfolio. In this case, the amount invested will be displayed along with an "*") If there are more investments than will fit on one screen, a message will display near the bottom of the screen: "Press Key To Continue = Up/Down Arrow for Details = Press 'P' to Print Screen" If you press the Up or Down Arrow keys, the display will overlay a window of Record Details. You can browse through the file by continuing to press the UP or DOWN arrow keys. If you press "P", the currently displayed screen will print to your printer. This will have a similar effect of pressing the "SHIFT PRINT" keys. This is not intended to replace the primary print routines described later. If you press any other key, the next screen of records will display. This process will continue until the last record is displayed, at which time, a summary of all records selected will be displayed at the bottom of the screen (Keep in mind this refers to the items selected and not the entire file, unless the entire file was selected). This summary will include: The Total Amount Invested: This includes the investments that have already been sold. The Total Amount Received: Total amount received from the investments that have been sold. Number Current Investments: The number of investments still being held (Those where the buy or sell year has not yet been entered). Amount Still Invested: The Amount invested from all current investments still held. You will also be able to display, in a pop up window, various averages, and other summary information by pressing "A", once the index display function has completed. This summary will include: The total Amount invested: This includes the investments that have already been sold. The average number of days the investments have been held. The total number of shares invested. The average number of shares invested per investment. The average purchase price per share. The total commission paid to buy. The average commission paid at purchase per investment. The average sales price per share. The total commission paid to sell. The average commission paid at sale per investment. SINGLE DISPLAY OF INVESTMENTS: To view the details of a specific record, simply enter the corresponding record number, or select from the pop-up window as described above. Once an investment is displayed, the UP/DOWN arrow keys will allow you to browse, displaying each investment in your file if you wish. DISPLAY GROUP OF INVESTMENTS: This works much the same as the Index option, except each record is displayed in detail format. The up/down arrow keys can be used to select the next, & prior records accordingly. Only those matching the select criteria will be displayed. If you choose to display all records, by simply pressing Return, you will be asked to enter a starting record number. This capability was added for large data files. If you press Return when asked for the starting record number, the display will begin at the first investment. If you enter a number larger than the number of records on file, the display will begin at the last record number. The number of days held to date will be displayed if the record is still in your portfolio. This is based on your Computer System Date as displayed. The record number is displayed at the top of the screen during this search. Press "ESC" at any time to abort the data display. ANALYZE - PROFIT/YEAR/CURRENT: Branch to the Analysis Print Menu. MAIN MENU WALL $TREET TBL: Branch to the Main Menu. INVESTMENT ANALYSIS MENU ------------------------ INVESTMENTS FOR SINGLE YEAR: Display in index format, all trading activity for the selected year. Once the last two digits of the year have been entered, do not press Return, as the display will begin after a brief pause. This display will include all investments bought or sold in the selected year. A summary analysis, as described above, will be displayed at the bottom of the screen. PROFIT ANALYSIS SINGLE YEAR: Display in index format, all records that were sold, (or bought, in the case of a short sell) during the selected year. A summary analysis will be displayed at the bottom of the screen. The summary analysis will also include the average number of days each item was held, and the percent profit or loss in the selected year. This is a useful summary report at tax time. This report is also available in printed format from the print menu. CURRENT INVESTMENTS NOW HELD: Display in index format, a listing of all investments currently held, along with a simple summary analysis. The current prices are not displayed here, but rather the investment data. For a similar display, but including the current prices and potential profit or loss, select the summary listing from the current investment menu. DISPLAY INVESTMENT MAIN MENU: Branch to the Investment Display Menu. MAIN MENU WALL $TREET TBL: Branch to the Main Menu. W$TBL GRAPH CHOICE MENU ----------------------- PROFIT OR LOSS GRAPH: Display a graph of Profit or Loss by record number. Similar to the video print option, you will be able to select: "A" or Return for all investment records on file. "C" for all Currently held investments based on current prices as stored in the current pricing module. Search by Current Pricing Symbol, Investment Name, Record Type, or Buy or Sell year. The search string will function as described earlier. "ESC" to return to the menu. When entering a "C" for currently held investments, all records currently being held are displayed. The Profit & Loss on these items is calculated based on the prices set in the current pricing module. If you have an EGA/VGA color system, potential losses will be displayed below the line in red, & profit will be displayed above the line in green. % PROFIT OR LOSS GRAPH: Display percent profit or loss by record number. The available options are the same as described above, with a similar graph layout. The percent profit is based on the amount invested and amount received when sold. CURRENT INVESTMENTS: Display graphically the amount invested of the currently held investments, by record number. If your current holdings include any "short sells", these will be displayed in magenta on a color display (EGA/VGA). Use the "C" option from the Profit / Loss Graph selection to examine the current P/L status of the currently held investments. All Current Investments will be displayed. FEES - PERCENT PAID: This will display the percentage of the total investment that was paid as commission & fees, by record number. All records matching the search criteria, will be displayed, including those currently being held. The percent paid at investment purchase will be above the line. The percent paid at the sale of each investment will be below the line. Each record will generate two bars, except for those records currently being held. This is useful to gain a graphical representation of the % commission and fees, being paid over multiple records, or an extended period of time. CUM - SUMMARY GRAPH: Display a CUM-SUM chart for profit or loss by record number. From left to right, each bar is the sum of the prior displayed bar. This could be used to determine the total amount of profit or loss over numerous records, or over an extended period of time. As noted previously, you can select all or a subset of your investments. GRAPH MODE SELECT: Branch to the Graphic Mode Select Menu. MAIN MENU WALL $TREET TBL: Branch to the Main Menu. General Graph Notes: 1: Although the limit to the number of records that can be maintained on W$TBL is 500, the maximum number of records that can be graphed at a single time is 300. If you attempt to exceed this limit, a warning will be printed & the first 300 items selected will be displayed. In the case of the Fees Paid graph, 300 bars can be generated for 150 records. 2: The vertical scale is set automatically to simplify the graphing process. A multiplying factor is displayed at the top of the graph. For example, if the top of the vertical axis displayed 125 x 10^2, this would mean that a full scale vertical bar would represent $12,500. 3: The horizontal axis will be labeled with the record number & space permitting, with the name of the investment. The name will be truncated to include the first several characters as space permits. When more than 8 records are displayed, only the record number will be displayed. When more than 17 records are displayed, a skip sequence will be used to label the records at regular intervals. When large number of records are printed, the number of records included in the graph will be displayed at the upper left corner of the graph screen GRAPH MODE SELECT MENU ---------------------- AUTOMATIC MODE DETECTION: An attempt will be made to determine the graphic capability of your system. Once you select this option the detected Graphic capability will be selected and displayed at the bottom of the screen for a short period of time. In each case, a warning will be presented if you attempt to select a graphic mode that appears not to be supported by your hardware. You will be given opportunity to override this selection. If a lockup should occur, you can reset the graphic mode by restoring the WALLSTD.CTL file from your registration disk. VGA COLOR (640 x 480): Set the Graphic Mode to VGA Color. Graphs will be displayed in color in a 640x480 pixel resolution mode. EGA COLOR (640 x 350): Set the Graphic Mode to EGA Color. Graphs will be displayed in color in a 640x350 pixel resolution mode. CGA MONOCHROME (640 x 200): Set the Graphic Mode to CGA Monochrome. Graphs will be displayed in Monochrome in a 640x200 pixel resolution mode. MCGA MONOCHROME (640 x 200): Set the Graphic Mode to MCGA Monochrome. Graphs will be displayed in Monochrome in a 640x200 pixel resolution mode. NONE - RETURN TO MAIN MENU: Branch to the Main Graph Menu. MAIN PRINT MENU --------------- PRINT: INDEX - DATA ON FILE: Send a hard copy of your Investment data file in Index format to your printer. The printout will be double spaced & printed in compressed print. A summary will be printed at the bottom based on the records printed. You can choose to print all records by entering "A" or select a portion of your data records by: Entering a Bxx where xx is the beginning record number. A listing of all records, beginning with the selected record number will be sent to your printer. This is useful to provide an update of recent investments without printing the entire file. Entering a search data string of between 2 & 10 characters. This functions in a similar manner as described previously in this documentation. You may also press "ESC" to return to the prior menu without sending any data to your printer. PRINT: SELECTED DATA RECORD: Print a hard copy of a single data record in detail format. You will be asked the record number you want to print. As described earlier, you can select from a summary listing by just pressing Return and then using the UP/DOWN, PAGE UP/PAGE DOWN, HOME/END keys. This printout will resemble the detail record view option from the main menu. PRINT: GROUP - DATA RECORDS: Print a hard copy of a group of data records in detail format. The printout of each record will closely resemble the detail record view option from the main menu. The search option will function as described above. ANALYSIS MENU YEAR/CURRENT: Branch to the Analysis Print Menu. MAIN MENU WALL $TREET TBL: Branch to the Main Menu. Print Menu Note: You must have a printer connected to use these options. If the printer is not "on-line" you will be prompted to place the printer on line before the menu selections may be made. If you do not correct this after a reasonable length of time, the program will automatically re-load the main menu. CAUTION: In some cases, we are not be able to tell if your printer is on. If the program locks up after selecting a print selection, turn on the printer & place the printer on line. If this does not correct the problem, you may be forced to reboot, or re-start your system. ANALYSIS PRINT MENU ------------------- PRINT: INVESTMENT HISTORY BY YEAR: Print a hard copy in index format, of all data records either bought or sold in the selected year. PRINT: PROFIT ANALYSIS BY YEAR: Print a hard copy in index format, of all records that were sold in the selected year. In the case of short sells, the records will be selected based on the year purchased. PRINT: CURRENT INVESTMENTS HELD: Print a hard copy in index format, of all records that are currently still in your portfolio. This is quite useful to obtain a listing of the investments you are currently holding. (See the Current Pricing Menu, for a similar printout but including the current prices and the potential profit or loss.) RETURN TO MAIN PRINT MENU:Branch to the Main Print Menu. MAIN MENU WALL $TREET TBL: Branch to the Main Menu. CURRENT INVESTMENT DATA MENU ---------------------------- The General procedure is to first assign existing symbols to each current investment. If the desired symbol does not exist, it must first be added using the Define/Assign Investment Symbol option described below. Once the symbols are assigned, the next step is to update the prices for each symbol using the Update Current Investment Data option, thereby assigning them to each current investment that is tied to that particular investment. UPDATE CURRENT INVESTMENT DATA: The three options available to you to update the prices of your current symbols are described below. Remember, you must first add the necessary symbols and assign them to the corresponding current investments ( See Define Symbol Option described below). To update the current prices manually, you have two options: ALL - SCAN THROUGH ALL SYMBOLS & UPDATE: Each symbol will be displayed, ready for you to update it's set of current pricing information. SELECT AN INDIVIDUAL SYMBOL AND UPDATE: A pop up window will appear allowing you to select a particular symbol, ready for you to update as described below. Once the symbol of choice is displayed, the fields available are described below: The date of the last update is displayed at the bottom of the screen. The symbol is noted at the top with a reference note on the number of symbols on file. The number of current investments, in your presently active file, that are assigned to this symbol is noted. Note: You may choose to maintain symbols that currently have no current investments assigned to them. This may be on previous investments or investments that you would like to keep track of for possible future investment. Current Price: The last stored current price is displayed. If you wish to change this price, you simply press "N", (No this is not correct) and make the necessary modifications. Simply press "Y" if the price is correct. Reference High Price: This is updated automatically as new current prices are entered. If you wish to override this value, you may do so. Once this value is entered, the percent of the current price is noted: Reference Low Price: Functions as described above Earnings Per Share: Entering earnings per share if desired. The program will automatically calculate the PE ratio as noted below: PE = Current Price / Earnings per Share. Dividends Per Share: Entering the dividends paid annually per share. The program will automatically calculate the % dividend as noted below: % Dividend = Dividend per Share / Current Price * 100. The current pricing information can be used to evaluate your current investments. If you simply want to keep track of the current prices, you may choose not to update the Earnings & Dividend fields. Press "A" to abort the current pricing update routine at any time. If a current symbol is no longer desired in the symbol database, pressing "D" will delete this symbol. IMPORT CURRENT PRICES FROM EXTERNAL FILE: If you choose to import current prices from a data file, press "I" and you will be presented with the following options: AUTOMATICALLY IMPORT FROM PREDEFINED FILE: This allows you to import current pricing information from the previously defined data file, as noted below. You will be able to view the progress of the update of the current pricing file, as this progresses. Each time a matching symbol, from your file and the current pricing file is located, the pricing information will be displayed and the current pricing file will be updated. FAST IMPORT WITHOUT IMPORT STATUS REPORTS: Once you have the configuration correctly set, and the correct symbols defined to both data files, this provides the same functionality as the prior option, but without the slow screen updates. DEFINE FILE FOR CURRENT PRICE IMPORT: This allows you to define a valid DOS path and file name, that contains valid pricing information. The file requested will be verified to exist. Currently only PRODIGY data files, and those with similar data formats, are supported. VIEW THE ACTIVE PRICE FILE ON THE SCREEN: This serves as a quick check of the current pricing file that is selected above. The file will be displayed to the screen, one screen at a time. DEFINE/ASSIGN INVESTMENT SYMBOLS: Define the symbols you will use to identify each of your current investments. You will have to do this prior to assigning prices as described above. Each time a new investment is added to your current holdings in your portfolio, you will need to assign a current tracking symbol to that item. Two options will be presented: SCAN FILE FOR ANY MISSING SYMBOL ASSIGNMENTS: The first will allow you to quickly scan your active data file and search for any current investments that do not have a symbol assigned to it. This is helpful after entering a new investment. The symbol assigned to each of your current investments will be displayed briefly, allowing you to visually verify the accuracy of the symbol assignments. If a current investment is found without a symbol assignment, you will be prompted to assign one. The detail instructions for completing the assignment of symbols, is summarized below. VERIFY ALL YOUR CURRENT SYMBOL ASSIGNMENTS: The other option will allow you to review and edit each of the symbol assignments in your active file. The symbol can be selected from an existing list, which can be displayed in a pop-up window, or added if necessary. This feature prevents you from having to remember the symbol or abbreviation used previously. Once the pop-up window is displayed, you can select from an existing symbol, by using the up & down arrow keys as described earlier. If the currently assigned symbol is correct, you simply press "Y" to display the next current investment with the symbol assigned to it. It there is no symbol assigned or is not correct, press "N". A list of all the current symbols in your symbol file, will be displayed that you may choose from. If the desired symbol is not contained in the list, simply press "ESC", and you will able to add the new symbol. Once the new symbol has been added, it will be stored in the file, and included in the symbol list, in alphabetical order. SUMMARY SYMBOL AND PRICE LISTING: You have the option of viewing only your current investments, or including any Year-To-Date trading activity to obtain a more complete Year-To-Date P/L, and overall activity for the Year, with potential profit, based on your current investments and their current value. This will display to the screen, a summary of the symbol, initial investment price, current price, & associated data currently assigned to each of your current investments. The potential profit or loss is displayed based on the current price, & initial investment. A summary of the number of your current investments, number of symbols, & total amount currently invested is summarized at the bottom of the screen. If you chose to include Year-To-Date trading activity, the trades completed in the current year will also be included in this display to provide a summary for the current year. One should note that any commission or fees that may be required to sell the investment are not included in this calculation. Once the display is complete, you can press "B" to obtain a similar display, but with the Profit/Loss column replaced by the total Investment Cost. You can also press "S" to display the potential value of each currently held investment, based on the current prices displayed. Press any other key to restore the default Profit/Loss display, or press "ESC" to exit. You will notice the titles will change appropriately to remind you of which values are currently being shown. PRINT CURRENT PRICING DATA MENU: Branch to the Current Pricing Report Menu. INITIALIZE -- INVESTMENT SYMBOLS: This will initialize the symbol database. All current pricing information will be lost from the symbol file, however, the last price & active symbol will still be stored in the each data file. You can easily recreate the active symbol list for investments currently held by the simple process outlined below: Initialize the Symbol Data Base Select Define/Assign Investment Symbol, then Verify all your Current Symbol Assignments, menu selections & press "Y" to quickly scan through the file and accept the current investment to symbol assignments still stored in the currently active investment file. Select the Update Current Investment Data, and one of the update options, and enter or import the current prices, and associated data for each symbol as appropriate. NOTE: This module was written to be able to track numerous portfolios, possibly with some of the same investments, as well as numerous investments of the same company in the same portfolio. For this reason, the first time you use this module, & for any new investments not currently in your symbol database, you are required to establish a symbol or abbreviation, for each investment. It is intended that the standard "Ticker Symbol" be used, but any symbol (1 to 6 characters ) will work, as long as you are consistent. MAIN MENU WALL $TREET TBL: Branch to the Main Menu. PRINT REPORTS & ANALYSIS MENU (CURRENT PRICING MODULE) ----------------------------- PRINT: INDEX - AT CURRENT PRICES: Print an index listing of your current investments with the current pricing information incorporated in the analysis. You are also allowed to select a subset of your current investments. Year to date completed trades are also included. PRINT: CURRENT DATA - INDEX LIST: Print an index listing of your current investments with the current pricing, PE, & % Dividend information. PRINT: SELECTED INVESTMENT ITEM: Print in Detail format any single investment by record number. If this investment is currently being held, the potential P/L calculations are included based on current pricing. PRINT: GROUP - INVESTMENT ITEMS: Print in detail format a group of investments by specifying a search string. The search string will function as described earlier. If any of the investments selected are currently being held, the potential P/L calculations are included based on current pricing. MAIN CURRENT PRICING MENU: Branch to the Main Current Pricing Menu. UTILITY MENU ------------ FILE MANAGEMENT MENU: Branch to the File Management Menu. SYSTEM STATUS/ANALYSIS: Display several aspects of your current system configuration. This is useful for your information, but also as a debug / problem solving tool in the unlikely event that you should experience a system problem while using W$TBL. The display will include: System environment variables currently set on your system. The display will include the active "PATH" & DOS environment variables. Current DOS Operation System Version, & DOS Memory up to 640K. Please note that although your system may contain additional memory above 640K, memory that is configured as either extended or expanded is not reported here. Current Active Disk Drive & Available Space on Active Drive. Number of Records that can be stored on the current drive, based on the Available Space, and the W$TBL Record Length. The Active Data File, and number of records in that file. Current Graphics Capability, active number of columns, & Bios Mode. Number of detected Parallel, Serial, & Game ports. Current System Time & Date. Your Computer Processor and Clock Speed. GRAPHIC MODE SELECTION: Branch to the Graphic / Color Menu. CALENDAR DISPLAY: This option will generate a calendar for any month & year from 1899 to the year 2099. Once the desired month is displayed, you can display the next or prior month, by pressing "N" or "P" accordingly. You can also select a new month by pressing "C" to change the active date. This is useful in determining the exact date a trade took place & also as a utility for other applications. You can quickly select the current year & month, by simply pressing "E", in response to the year & month inquires. Press "ESC" to return to the Main Utility Menu. PRINTER CONTROL CODES: This option will allow you to choose appropriate printer control codes for Dot Matrix Printers, HP Laser Jet II, or IBM Proprinter type printers. You will also be able to modify these default printer control codes. One of these three sets of printer control codes should work for your printer, with the exception of POSTSCRIPT. Currently W$TBL does not support postscript- only printers. You can choose a different set of control codes by pressing the "S" key. This will scroll through the list of printers that are supported directly by W$TBL. You can choose to modify any or all of these control code configurations by selecting the item to modify and the choosing "A" for an ASC control code, or "E" to precede your control codes by the universal escape control character "ESC" (ASC 27). You may press "Q" if you choose not to modify the control code. Once you have made the desired control code changes, you will be able to test this configuration on your printer by selecting "T" as instructed. Item "P" from the printer control menu now allows the user to select single or double space and control the number of lines per page. This setting is used for all "index" type reports. The detail reports will default to standard spacing. CAUTION: Consult your printer control manual before attempting to modify any of these control codes. You can reset these codes to the default values listed above by pressing "R" from this menu, as noted in the on-screen instructions. You can also reset these codes by deleting PRINTERS.CTL, and allow W$TBL to re- create it. UPDATE SYSTEM DATE: The Current system date is displayed. and can easily be changed from this selection. This value is used throughout W$TBL. FINANCIAL CALCULATIONS: Branch to the Financial Calculations Menu. MAIN MENU WALL $TREET TBL: Branch to the Main Menu. FILE MANAGEMENT MENU -------------------- SORT ACTIVE DATA FILE: You have the option of sorting your active data file by Investment Date, Investment Name and Type, or Investment Type and Name. After selecting the sort order of your choice, W$TBL will sort your active data file as requested. This may take anywhere from a few seconds to hours depending on the number of records, the degree of disorder and your computer speed. It will obviously take considerably longer if running W$TBL from a floppy disk. The sort routine will keep you informed of its actions as it proceeds to sort your data file. We recommend that you sort your file by date, since this will correspond to the natural order as time progresses and additional investment data is entered. It may be helpful for analysis purposes to view graphs, such as the CUM-SUM graph bases on another sort criteria. The date sort will allow you to enter your investments in random order and allow W$TBL to sort them after your initial load is complete. Normally you will only need to do this after you store your initial investments. You can check the order of your investments at any time from this menu. If your investments are in the proper order, this will only take a few seconds. ACTIVE W$TBL DATA FILE: Modify the data file that is currently active, or create a new data file. You may find it useful to keep separate data files for different investment types, or perhaps a new file each year. The data file is limited to 500 investment records. Currently the W$TBL data file must exist on the same drive as the W$TBL Software. You can enter the file name or select from the existing files by simply pressing Return to invoke the pop-up window with all available .DAT files in the current drive/directory. Valid characters are limited to A-Z & 0-9, and 8 characters in length. The DOS suffix of ".Dat" will be added to the end of the file name. Once you select an active data file and confirm your choice, W$TBL will verify the data file, inform you of the last date this file was accessed and inform you of the number of active records in the selected file. The program will automatically convert to the current file format if your data file was created with version 5.2 or later. The screen will notify you of this conversion when it occurs. You will not be able to use data files created with a version prior to 5.2, or a data file created with the Windows version of W$TBL. LIST ALL W$TBL FILES: This option will display a listing of all files in your current directory. If you maintain your W$TBL software in a directory of it's own, all files should fit on one screen. If you have a large number of data files, the display will pause at the end of each screen. DELETE W$TBL DATA FILE: This option will allow you to delete a ".DAT" (Data) file. A similar input screen will be available as described above. You will be notified if the deletion was successful. COPY W$TBL DATA FILE: This option will allow you to copy an existing ".DAT" (Data) file. This feature is useful if you decide to divide an existing file into smaller separate files. This can be done by copying the data file & then deleting the desired, records from the files using the main menu, edit option. PASSWORD PROTECT FILE: This option will allow you to password protect any single data file with a password of up to ten characters in length. Make sure you make a note of the password. If it is lost, you will not be able to view or edit the data on that data file. If you need to gain access to a data file that the password has been lost, contact Image Plus Software, and this can be done for the registered user, at a nominal fee. NOTE: This password only protects the active file, and not all data files in the Wall $treet Directory. This feature will allow two users to share the same computer and restrict access to their individual data files accordingly. If a password for the active data file has been set, you will be required to enter this password before the program will allow you access to the main menu, each time the program is started. MAIN UTILITY MENU: Branch to the Main Utility Menu. GRAPHIC / COLOR MENU ---------------------- COLOR WITHOUT GRAPHIC BORDERS: EGA Graphic Borders will be ignored, menu items will be displayed in full color, with Blue ASCII Borders. EGA COLOR WITH GRAPHIC BORDERS: EGA screen graphics will be displayed in full color with EGA Graphic Borders displayed during the menu displays. If your system does not support EGA or VGA, do not select this option. NOTE: The Borders will only display in the menu selections. You may choose to select COLOR WITHOUT GRAPHIC BORDERS, even if you have EGA/VGA capability, since these borders will slow the program slightly. LCD OR MONOCHROME - NO BORDERS: EGA Graphic Borders will be ignored, & all colors will be set to high intensity white. ASCII borders will be displayed. The color scheme will be modified to allow the highlight selection to be displayed on an LCD screen. ALTER DEFAULT COLOR CHOICES: The colors can only be changed if you have selected "C" or "E", as described above. The current color choices are displayed, along with the valid 15 system colors. These are displayed for your choice, & are numbered 1 through 15. The standard color assignments are as noted below: Red will be used to indicate a loss Green to indicate a profit Magenta to indicate a short Sell White to indicate an investment still held NOTE: The default setup will be color, no graphics. This does not effect the generation of Graphs. The graphic choices for the Graph Menu are available separately. MAIN UTILITY MENU: Branch to the Main Utility Menu. FINANCIAL CALCULATIONS ---------------------- FUTURE VALUE OF INVESTMENT: After entering present value, annual interest rate, number of years invested, and the number of compounding periods per year, the future value will be calculated for you. PRESENT VALUE OF INVESTMENT: After entering the desired future value, annual interest rate, number of years invested, and the number of compounding periods per year, the initial investment required will be calculated for you. EFFECTIVE INTEREST RATE: After entering the present value, future value, number of years invested, and the number of compounding periods per year, the effective annual rate of return required to meet the outlined goals will be calculated for you. TIME REQUIRED TO ACHIEVE GOAL: After entering the present value, the future value, the effective annual interest rate, and the number of compounding periods per year, the number of years (or months) will be calculated for you. LOAN - AMORTIZATION SCHEDULE: After entering the loan amount, the annual interest rate, and the number of length of the loan in months, the payment (Principal and interest) will be calculated for you necessary to repay the loan in the prescribed amount of time. After the necessary input values have been entered, you will have an option of generating an amortization schedule. To begin the process of generating a schedule, simply press "S". You will be prompted to enter the effective date of the loan. You can simply press Return for todays date. You can then choose to display the schedule to your screen or to your printer. Once the entire schedule has been displayed or printed, a summary will be included at the bottom of the screen or page. This summary will contain the total interest, total principle, the total amount paid and the payment ratio. The payment ratio is simply the total amount paid divided by the loan amount, expressed as a factor. ANNUITY FV/PV CALCULATION: After entering the desired monthly annuity, the annual interest rate, and the number of months you wish the annuity to last, the present investment amount will be calculated for you. Registration Agreement ----------------------- If you wish to obtain a personalized copy of Wall $treet - The Bottom Line, with all limitations removed, please fill out the registration form. This form is available by pressing "P" as indicated when you begin or end the program. If you do not have a printer, registration form information can be viewed on your screen by using the "V" option. Registered users will receive the latest version customized with their name on the system menus, & with all limitations removed. You will also be added to our mailing list & will be made aware of all future releases. Drop us a line if you have any questions or recommendations on Wall $treet - The Bottom Line. We want to hear from you! Bugs Or Problems ---------------- Reasonable care was taken to ensure that you will not encounter any problems while using Wall $treet - The Bottom Line. These include range checking on the input fields & testing prior to release. If you should encounter any problems while using this product please report these to: IMAGE PLUS SOFTWARE Wall $treet - The Bottom Line 2522 Quail Glen Carrollton, Texas 75006 (214) 416-3387 Please include as much information as possible. In the case of a system error, please include: the error number, the conditions that produced the error, & a hardware description of your system. Where possible, we will identify & correct the problem & provide a corrected copy to you at no charge. Operating Notes & Hints ----------------------- #1: If you have entered a record as being sold & later determine that it is not sold, you may correct this by entering "-1" in the year field, to change the sold status. For example, if you entered a record as being sold, & wish to modify it to be unsold; when asked if the year data is correct, just enter "N" for not correct & "-1" for the year. #2: If you make an error & wish to abort the current screen, press the "ESC" key and the system will return you to the parent menu. When viewing a menu, the "ESC" key will return you to the parent menu, or to the exit screen if currently at the parent menu. #3: If you specify a graphic mode & your system locks up, you can reset to the standard color settings, with no graphics by restoring the file "WALLSTD.CTL" from your registration disk. #4: If you modify the printer control codes, & do not achieve the desired results, you can reset these codes from the utility menu. You can also delete the PRINTERS.CTL file before starting W$TBL, which will also reset these codes. #5: The "WALLSTD.CTL" file now contains your registration information. If this file is deleted, you will need to restore it from your registration disk, in order to restore full program functionality. #6: The Data file structure has changed from earlier versions of the program. File structures created with W$TBL prior to version 5.0 are not supported. The program will automatically convert 5.1 to 5.7 version data files to the current format. #7: Although W$TBL can be successfully run from a floppy disk drive, a hard drive is recommended. This will greatly increase the speed of the program & increase the number of records that can be displayed. If you choose to run W$TBL from a floppy drive, & you find that you need more storage space, you can delete the .DAT files, WALLST.DOC & REA.ME.TXT files. This will increase the number of records that can be stored on the disk. The number of records that will fit on the disk at any time, can be read directly from the utility menu - System display option. #8: The Letter "K" is used to indicate values in thousands, and "M" used to indicate millions. For example 456,000 may be shown as 456K. #9: Although W$TBL is not a Microsoft windows application, you can run W$TBL from within Microsoft windows. If you're using windows 3.0, or later, in the enhanced mode, you can choose to run W$TBL, full screen or in a window. The WSTBL.ICO file is a full color ICON (Windows 3.0, and 3.1 compatible) which can be selected by selecting File Properties; Change ICON; and entering the Path and desired Icon File. For example "C:\WALLST\WSTBL.ICO". Restrictions ------------ You may not alter, modify, or adapt the software, including, but not limited to, translating, decompiling, disassembling, or creating derivative works. Image Software Plus makes no warranty or representation either expressed or implied, with respect to this software or documentation, including their quality, performance, or fitness for a specific purpose. Because software is inherently complex & may not be completely free of errors, you are advised to verify your work. In no event will Image Software Plus be liable for direct, indirect, special, incidental, or consequential damages arising out of the use or inability to use the software or documentation, even if advised of the possibility of such damages. Wall $treet The Bottom Line For Windows is now available ! WALL$T TBL is available in a windows version. Contact Image Plus Software if you are interested. As a registered user, you will be able to upgrade for a reduced fee. The windows version requires a 386 or above and MS Windows 3.1 or later. Thank You for Choosing Wall $treet - The Bottom Line & Good Luck with all your Investments ! Dan M. Schell =============