Position Dialogs

There are three dialogs in BondManager that deal with positions, the Positions Dialog, the Portfolio Navigator, and the Positions Transcripts dialog.  The Positions Dialog offers the opportunity to view or create the positions linked to a specific stock or option issue.

 

The Portfolio Navigator provides a top-down view of your bond portfolio, optionally expanding or collapsing branches in the hierarchy down to individual positions at the leaf level.

 

The Positions Transcripts dialog provides a text transcript equivalent to the leaf level in the Portfolio Navigator.  The intent is to export these journal entries for review, tax records, and other documentary purposes.

The Positions Dialog

The Positions Dialog is where all positions in your portfolio are created.  BondManager tries to anticipate which bond you want to edit positions for based on the last issue you defined, analyzed, or created/edited positions for.

 

 In the screen shot at right, we’ve selected ‘Ford Mtr Co Del’ (a long term bond on Ford’s Delco subsidiary) from the list of bond identifiers and filled in values for # Bonds.  Changing the focus from the # Bonds control causes the dialog to compute the Total Cost based on the current market value of the bond (in the bond definition) and the quantity specified here.  The calculation is unaware of fee structures, so if you want to add purchasing costs as part of your cost basis, you would add that amount into the Total Cost now.  We’ve increased the Total Cost by $500.00 so we can show a capital loss and set the purchase date to 07-Feb-2005.  You might also take this opportunity to create a note for yourself regarding the source of funds or whatever you feel is appropriate for the Note field.  We classified the source of funds as ‘Lottery winnings’.

Symbol (Identifier)

Note that it’s not necessary to select a bond identifier from those already defined in the database.  If you enter a new identifier, a placeholder bond definition will be created for you, though BondManager will not make any assumptions about the issue’s current market price, coupon rate, maturity date, etc.  The market price in a placeholder definition is set to 0.00 to serve as a reminder that its value has never been properly defined.  With so much information missing, you’ll find that Income and Yield columns (discussed below) contain meaningless placeholder values as well.

Purchase Date

The current date is used as the default value for the Purchased date.  Future dates are disabled, so you can’t accidentally create pro forma positions.

# Bonds

The number of bonds in a position is stored as a double precision floating point number.  Although fractions of a bond don’t find much practical application, reinvestment plans often produce fractional shares of stock, so we’ve allowed for fractional bonds here to accommodate the possibility.  For short sales, you’d specify the number of units as a negative number.

Total Cost

Total Cost[1] is also stored as a double precision floating point value.  The presumption is that it represents the cost of the position including any transaction fees.  As an example, if you defined ‘Ford Mtr Co Del’ previously in the Bond Definition dialog, you could choose ‘Ford Mtr Co Del’ from a list of sbond identifiers in the Bond ID control.  If you then enter 100 for the number of bonds, it calculates and enters the cost of the position based on the market price you entered for ‘Ford Mtr Co Del’ in the bond definition.  No fees are added at this point (that’s left for you to do manually).  We’ll set the date back a year and add $500 to the total cost to create a capital loss.

 

Note that the Total Cost associated with a short sale is negative, thus representing an inflow of capital after expenses.  Fees would reduce the magnitude of a short sale’s (negative) proceeds.

Note

 The Note field is provided to document almost anything associated with the position – typically, the position’s source of the funds.  We’ll adopt the source of funds convention and call the source ‘Lottery winnings’.

 

 

Enter Button

Once a symbol has been entered and there are values for the number of shares and the total cost, the Enter button will be enabled.[2]  Tapping the Enter button inserts a position representing the fields above into the database.

Active Positions list

Any position that appears in the Active Positions control has persistent status.  This dialog is the one place where you can modify or remove positions from the database.  All stored positions for the currently selected bond identifier are displayed in the Active Positions list.

 

If, in the year before we won the lottery, we sold our classic Vette and bought 200 bonds of the very same ‘Ford Mtr Co Del’ bond issue. we’d see two positions in the database. 

Note that the most recently created position appears first in the list, not last.  This is done so you will have visual confirmation even when the list contents exceed the size of the control.

 

A Total row, highlighted in powder blue, has been added to depict the sums for each of the columns.  The one exception is the % Yield column which displays the cost weighted average yield of the contributing positions (which depict annualized yields in this column).  This entry gives you immediate feedback on how well cost averaging is working for you.  The total row is only visible when more than one position exists for the issue you’ve selected.

 Active Positions list columns

Column headings are generally self explanatory, so we’ll focus on a few things that may not be as readily apparent.    The Net Gain column displays the sum of the Capital Gain and Income columns.  The Note column displays the Note you made to yourself before Entering the position in the list.

Managing Display of the Positions List

Clearly, you can’t see the contents of all columns without scrolling the Positions List horizontally, but you can disable the display of any of the columns in the Positions List Options dialog, thus reducing the need to scroll horizontally.  The list control also supports column resizing, reordering, and sorting (toggles between ascending and descending) by tapping on the column header.  If a total row is present, it is not included in the sort.

 Managing the Contents of the Positions List

The three buttons below the Positions List allow you to manage the list of positions displayed above.  If you select one of the positions in the list, you’ll see the row highlight and the three buttons at the bottom of the screen become enabled.  You may notice that you can’t select the total row – it’s not a real position, just a summary entry in the list control.

 

Here’s what happens when you select one of the three buttons at the bottom of the dialog.

Delete

The Delete button is the simplest of the three.  Selecting it causes the message box below right to post over the dialog. [3]  If you click ‘Yes’, it the position will disappear from the database forever.  The Delete button is the only one of the three bottom buttons that supports multiple selections.

 Modify

The Modify button is very much like the Delete button, in that it warns you that you are about to delete the selected position, and once you select ‘Yes’, the position will be permanently deleted from the database, just as it promised.[4]  The difference is that Modify overwrites, without asking permission, all of the fields in the dialog with values taken from the position you are ‘modifying’.  Clearly, you shouldn’t use the Modify button if you have typed information into the fields above the Enter button that you care about.

 

After you complete your modifications, you must re-Enter the position in the database.  Until it appears in the Active Positions list below the Enter button, it’s not saved in the database – that’s why the warning message says “you are about to permanently delete the selected position” when you just selected Modify.  It’s really been permanently deleted until you re-Enter it.

Close

 The Close button also has irreversible consequences, but it does not have an associated preference in the Confirmation Options Dialog because it needs to capture additional information along with your approval to proceed.  The Close Position Dialog completely overlays the Positions Dialog and collects three things from you which enable converting it into a closed position.  The date the position was closed, the net proceeds from the sale, and a closing note.  The closing date can be no later than the current date.  Upon selecting the ‘OK’ button, a ‘closed position’ is created in the database with all of the information previously associated with the active (open) position.  The active (open) position is then deleted.

 

There is no mechanism for modifying a closed position – it can’t be deleted, modified, or converted back into an active (open) position, but you can get transcripts of all closed positions according to the year in which they were closed (refer to the Positions Transcripts Dialog on the Tools menu).



[1] Only ‘Cost’ appears in the column header in the Positions Dialogs in this section because the column was resized to a smaller width.

[2] The initial results of clicking the Enter button are shown above right, with scroll-right addenda below it.

[3] You can bypass warning messages posted by the Delete button by disabling the preference ‘Positions Dialog – Delete position’ in the Confirmation Options Dialog.

[4] You can bypass warning messages posted by the Modify button by disabling the preference ‘Positions Dialog – Modify position’ in the Confirmation Options Dialog.  .