Porfolio

Porfolio v.1.2 ============== Shareware proposed by Guillaume Dupont e-mail:100740.1033@compuserve.com Key words: FINANCE,PORTFOLIO,STOCK,SHARE,S3A,S3C Introduction. ============= Porfolio is an application for the management of a portfolio of shares on a Psion S3a. Its main features are: - several share accounts can be created and managed - details of each account can be displayed in text mode or in graphical mode (quick toggle between 3 different display modes) - one single data base, where each share has its last quote, currency of quotation and date of last quote - several currencies with exchange rates and date of last update (a home currency is defined) - the average purchase price of each share in each account is updated after each purchase - capital gains/losses are recorded by account after each sale - dividend/expenses can be recorded, by share and by account - a "Cash" option can be switched On/Off for each account - last quotes can be imported from a text file (like quotes.cis, generated by ReadCIS), and automatically recorded in the data base and in the history files - a quote history graph can be created for each share and updated automatically - a summary graphical display of all accounts is available - several synthetic reports are available (capital gains by account, transactions between two dates,...) Porfolio is a Shareware. The demonstration version allows to handle three shares and two currencies only in the data base and in the different accounts. Content. ======== The porfolio.zip file contains the following files: - readme.txt is this documentation - porfolio.opa is the application file (part 1) - porfolio.ovl is the application file (part 2) - porfolio.rsc is a help file - plotuw8.zip is a graphic application, used to store and display history of quotes. Installation. ============= To install Porfolio: - copy porfolio.opa to an \app\ directory on any disk - copy porfolio.rsc and porfolio.ovl to the \opd\ directory on the INTERNAL disk - install the application like any other Psion application: press <Psion-I> in the system screen, etc... - start Porfolio - when asked, name your home currency (dialog window). You can use up to 3 letters (USD, DEM, CHF,...) - select the disk, on which you want the data files and working files to be installed (dialog window). This must NOT be a Flash SSD. The program will automatically do the following: - create an \app\porfolio\ directory on the same disk, where you have installed the application file porfolio.opa - move porfolio.rsc and porfolio.ovl to this \app\porfolio\ - create an \opd\porfolio\ directory on the disk, which you have selected for the data and working files - create a first data base with two "dummy" shares (Psion PLC and Big Sister Corp). These can be deleted later (see Housekeeping) - create a first empty account, named Porfolio. To install version 1.2 if you had already installed a previous version: - replace the file porfolio.opa (in an \app\ directory) with the new file - replace the files porfolio.rsc and porfolio.ovl (in an\app\porfolio\ directory) with the new files - do not move any file to or from the \opd\porfolio\ directory See the file changes.txt for a summary information on changes from previous versions. If you later wish to move the data files to another disk (in no case a Flash SSD): - create an \opd\porfolio\ directory on this new disk - move all the files from the original \opd\porfolio\ to the new one - delete the original \opd\porfolio\ directory. If you wish to move the application files to another disk (which can be a Flash SSD): - move porfolio.opa to the \app\ directory on this new disk - create an \app\porfolio\ directory on this new disk - move porfolio.rsc and porfolio.ovl to the new \app\porfolio\ - delete the old \app\porfolio\ - remove the porfolio application in the system screen, and re-install it. Plotuw8 has to be installed separately: unzip the plotuw8.zip file in a separate temporary directory and see instructions in the included readme.txt documentation file. Operation. ========== Press <Enter> on the Porfolio icon. Once Porfolio is started, press <Help> for instructions. I strongly recommend, that you go through all the screens of the help menu, to get all the benefits of Porfolio. The content of all the Help screens is reproduced at the end of this documentation. The menu options themselves, which are displayed when the <Menu> key is pressed, are self explanatory. Limitations. ============ The way Porfolio displays information in fast moving windows imposes limitations on some numbers: - the maximum total number of shares and currencies in the base is approximately 120 - the maximum number of shares in one account is 40 - the maximum number of transactions which can be displayed at once for one account is 90. This means that, if you have recorded more, you will have to set date limits for the display. - 20 accounts can be managed simultaneously One thing Porfolio does NOT do is print. Registration. ============= Porfolio v.1.2 is Shareware. You can use it freely during 14 days. After this period, if you find it useful, please register. Otherwise remove it from your computer. The registration fee is US$30. This fee includes a "free" registration to Plotuw8, the graphic application which is included in the package. Note that special conditions apply to users, who are already registered users of Plotuw8 (contact me). You can register online on CompuServe via SWREG (GO SWREG. Registration ID=14005). Alternatively you can send US$30, GBP20, DM50, CHF40, or FF150 in cash by mail. Send bank notes, no checks. Do not forget to send your e-mail address with payment. Note that sending cash by mail is at sender's risk. My address is: Guillaume Dupont 25, rue Pauline Borghese 92200 Neuilly sur Seine France Registered users will receive via e-mail a registration code, which unlocks the programme (number of shares) and removes nagging screens. They will also receive a registration code for Plotuw8. Disclaimer of responsibility. ============================= Users of Porfolio must accept this disclaimer of warranty: "Porfolio is supplied as is. The author disclaims all warranties, expressed or implied, including, without limitation, warranties of fitness for any purpose. The author assumes no liability for damages, direct or consequential, which may result from the use of Porfolio or any of its accompanying files". The following instructions are available on line ================================================ from the help menu of Porfolio. =============================== General ------- Porfolio can manage several share accounts, record information on transactions in each account, on last quotes and exchange rates, and produce synthetic information: - on the day to day value of each account, line by line, with indication of potential capital gains/losses, in text or graphic mode - on the whole set of accounts - on the transactions recorded between two dates, by account, with cumulated gains/losses. Information on the shares is stored in one single common data base, where each share has: - a name - a ticker (see "Import from text file") - a currency of quotation - a last quote, expressed in this currency - a date of last quote A share must be created in the data base (Psion-N), before it can be purchased (Psion-B), in one or several accounts. Share quotes can be updated manually (Psion-Q or Psion-U) or automatically by import from a text file (Psion-I). Account display --------------- The name of the account is displayed in the upper left corner of the screen. There are three different modes for the display of details in the central window. Press the Diamond key to toggle display modes. The display mode at startup can be set in "Preferences". In the "bar graph" mode, the central window shows for each share: - name of the share - potential capital gain/loss on this line, as a percentage of the amount invested - total investment in this share (purchase costs) = the thin line on the graph - present value of the line (at last quote) = the thick line on the graph - present value of the line, as a percentage of the total value of the account. In the "detail of quotes" mode the central window shows: - name of the share - number or shares in the account - average purchasing cost, in home currency (updated after each purchase) - last quote, and currency of quotation - total value of the line, in home currency In the "capital gain/loss" mode, the central window shows: - name of the share - amount invested in the share - potential capital gain/loss on this line, in total value and as a percentage of the amount invested - present value of the line (at last quote) Use the arrows (or PgUp/PgDn, or Ctrl-PgUp/Ctrl-PgDn) to move up and down in the central window. The bottom of the screen shows the total amount invested, the total potential capital gain/loss, and the total net value of the account (at last quotes). Share purchase -------------- Press <Psion-B> to record a purchase in the currently displayed account. The following information is required: - name of the share (selection window) - date of transaction - quantity purchased - total cost of purchase (with currency). The programme converts the cost of purchase into home currency, and calculates: - the number of shares in the account after the purchase - the new average purchase cost of the share in the account. If the "Cash" option is ON, a cash line is debited of the amount of the purchase (in the currency of transaction). Share sale ---------- Press <Psion-S> to record a sale of the highlighted share in the currently displayed account. Complementary information: - date of transaction - quantity sold - net revenue from the sale (and currency). The programme converts the amount into the home currency, and calculates: - the number of shares in the account after the sale - the capital gain/loss from the sale. If the "Cash" option is ON, a cash line is credited of the amount of the purchase (in the currency of transaction). Dividends & expenses -------------------- Press Psion-D to record a dividend, or another income or expense, related the share highlighted or to the account itself. The amount is converted and recorded in home currency for reporting purposes (see "History of transactions"). If the "Cash" option is ON, a cash line is credited (debited) of the amount of the income (expense), in the currency of transaction. Share quotes ------------ Press <Psion-Q> to load a table of all the last quotes with dates. Move up and down with arrows (or PgUp/PgDn, or Ctrl-PgUp/ PgDn). Enter a number or press <Enter> to open a little quote update window. Confirm or modify the date of last update. Press the initial letter of a share name to reach it quicker. See "Import from text file" for automatic update. Currencies ---------- A "home" currency is defined at the first run of the programme. Several other currencies can be created <Psion-C>. All currencies are shown as "_Cash xxx" lines in the share table called by <Psion-Q>. Exchange rates can be updated in the same way as share quotes. Cash & cash transfers --------------------- A "Cash" option can be switched ON and OFF separately for each account (Shift-Psion-F). When it is ON, an account can have one cash line for every currency. This line is created automatically the first time a currency is used in the account, and then credited/debited each time a sale/purchase, a dividend/expense or a cash transfer is recorded. "Cash" is ON at startup for every new account created. Use <Shift-Psion-C> to transfer/withdraw cash to/from the account (command available only when "Cash" is ON). Note that cash transfers are not recorded in history files, and not reported by <Psion-Y>. Quote history graphs -------------------- The history of each quote can be recorded and displayed in a graphical form, using the Plotuw8 application. The procedure is as follows: - the plotuw8 application must be installed - each share, for which a history file is wanted, must have a "ticker" (see corresp. help page) - press <Tab> to create/display a graph, when a share name is highlighted, in the account display mode (main screen) or in the quote display/update window <Psion-Q> - history files can be updated automatically each time new quotes are entered (see "Preferences") Import from text file --------------------- Last quotes can be updated, or "imported", from a text file: the programme looks for one label, or "ticker", and one quote, at specified positions (columns) in each line of the designated text file. Press <Psion-I> to open a file selection window, then <Tab> to navigate to the import file, and <Enter> to confirm the selection. The first few lines of the import file are displayed. If needed, press the <Down> arrow to see more. Then confirm: - date for this update - number of the column for the ticker - number of the column for the last quote - type of column separators (spaces/tabulations or commas) Tickers ------- Press <Psion-T> in the account display screen, and a "Tickers" window will open: a ticker is a character string, or label, which the programme uses to identify a share in a text file for import. Tickers are also used to link the name of the shares in Porfolio to the name of their history graphs in Plotuw8: - name in Porfolio >> ticker in Porfolio - ticker in Porfolio = ticker in Plotuw8 - ticker in Plotuw8 >> graph in Plotuw8 Tickers are displayed in the right side of the Tickers window. Use arrows (or PgUp / PgDn) to move up and down in the window, then press <Enter> to enter or update the ticker of a share, when the name of this share is highlighted. To reach more quickly a share, one can also press its initial letter. Calculator ---------- Press any numerical key to open a calculator window in the upper left corner of the screen. Press <Esc> to close it. Summaries --------- Press <Psion-L> for a summary on the present value of all accounts. The central window gives on one line for each account: - name of the account - potential capital gain/loss, as percentage of the investment value - investment value (purchasing costs) = the thin line of the graph - net value (at last quotes) = the thick line of the graph - value of the account as percentage of the total of all accounts. Press <Shift-Psion-Y> for access to a menu on history of the total net value (graph). Note that entry of new records is not automatic. It has to be done from this menu (single record or all accounts at once). History of transactions ----------------------- Press <Psion-Y> for a detailed report of all transactions in the account between two dates. The central window will display for each transaction: - date - name of the share - number of shares traded - net amount of the transaction (purchase or sale) - capital gain/loss (sale) or income/expense (dividend) Note that simple cash transfers are not reported. While in this screen, press <Enter> to display only the transactions corresponding to the highlighted share. From there press <Esc> to return to the display of all transactions. At each stage it is possible to change the range of limit dates for display: press <D>. Press <Shift-Psion-L> from any account display screen to produce a synthetic report on all the transactions recorded between two dates in all accounts, showing total purchases, total sales, and total income (capital gains/losses, dividends, expenses) by account. In this screen, press <Enter> for a detailed report on the highlighted account (same result as Psion-Y in account display screen). Password protection ------------------- Press <Psion-W> to enter a password and turn the password protection on or off. This module works in the same way as the password protection of the Psion itself. However it does not provide the same level of security: only a first level protection against undesired intrusion. Plotuw8 ------- Potuw8 is a simple and easy to use multipurpose plotting application. When installed on any disk of the Psion, it can be called directly from Porfolio to record and display the history of the quotes of all or part of the shares in a portfolio. The full application, with its documentation and help file, is included in the plotuw8.zip file. To call Plotuw8 from an account display screen: - highlight a share, which has a ticker - press <Tab> - if the share does not have a history file yet, press <C> to create one, and give a file name. Press <Psion-X> to return to Porfolio from Plotuw8. Preferences ----------- Press <Psion-F> to open a dialog window, where one can specify: - the default disk, path and name for the text file for import of quotes. This file name will be proposed each time file import function <Psion-I> is invoked - whether new quotes must be automatically recorded in the history files of the shares, each time quotes are updated. Note that this is only a yes/no switch. If answer is yes, a ticker and a history file must still be created (once) for each share. - the account display mode at startup (3 options). - the starting date for reports on transactions, proposed in dialog windows (2 options) Deleting shares, accounts,... ----------------------------- Call the Housekeeping module <Psion-K>. Some checks are performed: a share cannot be deleted, if it exists in one account,... The user is warned if a share exists in the transaction history of an account. Last update 1 Feb 1997.