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
=============